Question

Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows

Quarter	Guests (in thousands)	Quarter	Guests (in thousands)
Winter Year 1	63	Summer Year 2	125
Spring Year 1	89	Fall Year 2	51
Summer Year 1	155	Winter Year 3	94
Fall Year 1	77	Spring Year 3	161
Winter Year 2	65	Summer Year 3	210
Spring Year 2	84	Fall Year 3	97

 

Based on the given attendance, the seasonal indices for each of the seasons are (round your responses to three decimal places)

Season Index

Winter

Spring

Summer

Fall

Answer 1

Formula:

E3 =AVERAGE(B3:D3) copy to E3:E6

F3 =E3/$E$7   copy to F3:F6

E7 =AVERAGE(E3:E6)

Season	Index
Winter	0.699
Spring	1.051
Summer	1.542
Fall	0.708