Using the information in Extract F, calculate the three period moving averages for the percentage of rooms occupied for the periods March to May and June to August to two decimal places, stating the difference between these moving averages - Edexcel - A-Level Business - Question 2 - 2022 - Paper 2
Question 2
Using the information in Extract F, calculate the three period moving averages for the percentage of rooms occupied for the periods March to May and June to August t... show full transcript
Worked Solution & Example Answer:Using the information in Extract F, calculate the three period moving averages for the percentage of rooms occupied for the periods March to May and June to August to two decimal places, stating the difference between these moving averages - Edexcel - A-Level Business - Question 2 - 2022 - Paper 2
Step 1
Calculate Moving Average for March to May
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
To find the moving average for March to May, we sum the occupancy rates for these three months and divide by 3:
Moving Average (March to May)=330+45+70=3145=48.33%
Step 2
Calculate Moving Average for June to August
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Next, we calculate the moving average for June to August:
Moving Average (June to August)=370+90+90=3250=83.33%
Step 3
Calculate the Difference Between the Moving Averages
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Finally, we find the difference between the two moving averages calculated: