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

Attendance at Los Angeles’s newest Disneylike attraction, Vacation World, has been as follows:
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.

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.