Explore BrainMass

Explore BrainMass

    Seasonal Indicies

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 11:52 pm ad1c9bdddf
    https://brainmass.com/business/business-management/seasonal-indicies-305203

    Solution Summary

    Seasonal indices are examined.

    $2.19

    ADVERTISEMENT