A restaurant has tracked the number of meals served at lunch over the last four weeks. The data shows little in terms of trends, but does display substantial variation by day of the week. Use the following information to determine the seasonal (daily) index for this restaurant. Week Day 1 2 3 4 Sunday 40 35 39 43 Monday 54 55 51 59 Tuesday 61 60 65 64 Wednesday 72 77 78 69 Thursday 89 80 81 79 Friday 91 90 99 95 Saturday 80 82 81 83 Week Day 1 2 3 4 Sunday 40 35 39 43 Monday 54 55 51 59 Tuesday 61 60 65 64 Wednesday 72 77 78 69 Thursday 89 80 81 79 Friday 91 90 99 95 Saturday 80 82 81 83 Solution Week 55 51 59 Day 1 2 3 4 Sunday 40 35 39 43 Tuesday 61 60 65 64 Thursday 89 80 81 79 82 81 83 total 487 479 494 492 ((40+35+39+43)/4) /69.71 0.563 0.785396643 Wednesday 72 77 78 69 Friday 91 9 0 99 95 (487+479+494+492)/28 69.71 Monday 54 Saturday 80 average daily Seasonal index Sunday Seasonal index Monday seasonal index Tuesday 0.896571511 seasonal index Wednesday 1.061540668 seasonal index Thursday 1.183474394 1.344857266 seasonal index Friday seasonal index Saturday 1.16912925 Name: Description: ...
Purchase document to see full attachment