Determine a typical seasonal index for each of the four quar

Determine a typical seasonal index for each of the four quarters

I need to know how to do this in excel as well

			Absent
			4
			10
5. 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 3 years, 2011 - 2013, he recorded the following number of employee absences, in days for each quarter.			7
	Year	Quarter	3
	2011	1	5
		2	12
		3	9
		4	4
	2012	1	6
		2	16
		3	12
		4	4
	2013	1
		2
		3
		4

Determine a typical seasonal index for each of the four quarters I need to know how to do this in excel as well

Grand mean = 7.666667

Seasonal Index = Quarter mean/Grand mean