Purchase Solution

Seasonal Indicies

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

Seasonal indices are examined.

Purchase this Solution


Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce