Determine a typical seasonal index for each of the four quarters I need to know

Question

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

Explanation / Answer

Grand mean = 7.666667

Seasonal Index = Quarter mean/Grand mean

Year/Quarter Q1 Q2 Q3 Q4 2011 4 3 9 16 2012 10 5 4 12 2013 7 12 6 4 Quarter Sum 21 20 19 32 Quarter mean 7 6.6667 6.3333 10.6667

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.