Seasonal Indices

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