Seasonal Indices

Week Monday Tuesday Wednesday Thursday Friday Saturday Sunday 1 334 499 262 2 170 249 203 232 435 351 223 268 329 168 293 3 110 179 240 114 266 99 90 4 155 234 81 253 314 93 278 5 95 164 225 99 264 107 283 6 270 183 308 125 194 255 129 7 223 132 239 268 143 323 332 8 212 369 390 369 218 495 320 9 479 540 414 590 390 460 663 10 549 739 734 684 642 866 832 Q 4 The marketing manager of a transportation network company offering taxi services ina metro city wishes to improve customer service and taxi scheduling based on the daily levels of customers in the past I'D weeks. The numbers of customers during that period are given below: i} Determine the seasonal indices for the given data using a Tday moving averages. ii) Obtain the deseasonalised values. iii) Fit the appropriate trend for the deseasonalised data using the leastsquares method by matrix approach that best describes the data. iv) Project the number of customers on Wednesday of the 52111 week. v} Plot the original data, the deseasonalised data, and the trend values. REQUEST TO KINDLY PROVIDE SCREENSHOT OF EXGEEWPUT AND INTERMEDIATE STEPS ALSO