# Solve: Time Series and Forecasting

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.

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 ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/solve-time-series-and-forecasting-124272

#### Solution Preview

Data (Rearranged)

Year

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.