Explore BrainMass

Explore BrainMass

    Solve: Time Series and Forecasting

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

    Question: Victor Anderson, the owner of Anderson Belts, Inc., is studying absenteeism among his employees. His workforce is small, consisting of only five employees. For the last three years he recorded the following number of employee absences, in days, for each quarter.

    Year I II III IV
    2001 4 10 7 3
    2002 5 12 9 4
    2003 6 16 12 4

    Determine a typical seasonal index for each of the four quarters.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:07 pm ad1c9bdddf

    Solution Preview

    Data (Rearranged)
    Quarter 2001 2002 2003
    I 4 5 6
    II 10 12 16
    III 7 9 12
    IV 3 4 4

    Step 1: Compute overall ...

    Solution Summary

    This solution provides a 3-step response demonstrating how to solve for a typical seasonal index. There is also an Excel spreadsheet which accompanies the solution, presenting the response in proper format. By clicking directly onto the cells of the spreadsheet, it shows which functions are needed in order to compute the corresponding values.