Solve with EXCEL

Question 2 (15 pts): 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. Then calculate the deseasonal data and only explain which forecasting technique can be applied by drawing graph? 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