Hi, please help me with this question and I will give you a thumbs up. It has an Excel spreadsheet, but unfortunately it won't let me upload (I'm not sure why) so I've included a link in the comments that has all the Excel data that you must refer to, please scroll down to find the data link.

Here are the questions, please help me answer them thank you very much!

The spreadsheet contains data on the number of visits to the Emergency Department (ED) of a hospital in our region for the last three weeks. The data excludes arrivals by ambulance and provides breakdown of the total number of patient visits by day of the week and 6-hours shifts.Based on this last three weeks of data, the ED manager is seeking help to forecast ED demand in terms of the number of patient visits for each day of the week and shifts over the next week. To help the ED manager achieve his goal, perform the following analyses, and assume the effect of seasonality to be a multiplicative effect.

a)Explore the data, creat e graphs and comment on the seasonality patterns you observe in the data. Explore the seasonality patterns by "day of the week" as well as by "day of the week and shifts." (2 marks)

b)Use the "seasonality forecasting technique with no trend" to forecast the volume of ED visits by "day of the week" only. (Use the actual number of ED visits as the initial value for exponential smoothing. Use smoothing constant 0.25) (8 marks)

c)Calculate MAD and MAPE measures of error on training data for the forecasting model in part (b). (3 marks)

d)Plot the actual volume of ED visits versus forecasted volume from part (b) and comment on how they compare. (1 mark)

e)Use the "seasonality forecasting technique with no trend" to forecast the volume of ED visits by "day of the week AND shift". (Use the actual number of ED visits as the initial value for exponential smoothing. Use smoothing constant 0.25) (10 marks)

f)Calculate MAD and MAPE measures of error on training data for the forecasting model in part (e). (3 marks)

g)Plot the actual volume of ED visits versus forecasted volume from part (e) and comment on how they compare. (1 mark)

h)Compare MAD and MAPE measures of error for the two forecasting models used in part (b) and (e). Do these measures suggest that one method performs better on the training data? (2 marks)