The following table shows the RevPAR of a hotel from Day 1 to 30 : An excel file of the above is also attached Exercise 8.xlsx From the above data, find out the following: - 7 day moving average on Day 12 - 7 day moving average on Day 18 - 7 day moving average on Day 24 From the above data, find out the following: - 7 day moving average on Day 12 - 7 day moving average on Day 18 - 7 day moving average on Day 24 Use the data (Day 1 to 30 ) above to prepare an Excel forecast sheet with the following criteria: - Forecast End - 44 - Forecast Start - 30 - Confidence Interval - 95\% - Seasonality - Detect Automatically - Fill Missing Points Using - Interpolation - Aggregate Duplicates Using - Average The following table shows the RevPAR of a hotel from Day 1 to 30 : An excel file of the above is also attached Exercise 8.xlsx From the above data, find out the following: - 7 day moving average on Day 12 - 7 day moving average on Day 18 - 7 day moving average on Day 24 From the above data, find out the following: - 7 day moving average on Day 12 - 7 day moving average on Day 18 - 7 day moving average on Day 24 Use the data (Day 1 to 30 ) above to prepare an Excel forecast sheet with the following criteria: - Forecast End - 44 - Forecast Start - 30 - Confidence Interval - 95\% - Seasonality - Detect Automatically - Fill Missing Points Using - Interpolation - Aggregate Duplicates Using - Average