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.
Please see the attached file.
To calculate the seasonality index do ...
Tutorial is in excel to assist you.