1. Attendance at Los Angeles’s newest Disneylike attraction, Vacation World, has been as follows:

Quarter Guest in Thousands Quarter Guest in Thousands
Winter 05 73 Summer 06 124
Spring 05 104 Fall 06 52
Summer 05 168 Winter 07 89
Fall 05 74 Spring 07 146
Winter 06 65 Summer 07 205
Spring 06 82 Fall 07 98

In excel compute seasonal indicies using all of the data. Cells must include the associated cell computations.

2. The following gives the number of accidents that occured on Florida State Highway 101 during the last 4 months:

Month Number of Accidents
January 30
February 40
March 60
April 90

Forecast the number of accidents that will occur in May, using least-squares regression to derive a trend equation.

3. The number of transistors (in millions) made at a plant in Japan during the past 5 years follow:

Year Transistors
1 140
2 160
3 190
4 200
5 210

a. Forecast the number of transistors to be made next year, using linear regression.

b. Compute the mean square error (MSE) when using linear regression

c. Compute the maean absolute percent error (MAPE)

All work must be done in excel inclding the cell computations.