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 the 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 three-month moving average from March to May, we use the formula:
3March+April+May=330+45+70=3145=48.33%
Therefore, the moving average for this period is 48.33%.
Step 2
Calculate the 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 from June to August:
3June+July+August=370+90+90=3250=83.33%
Thus, the moving average for this period is 83.33%.
Step 3
State 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
To find the difference between the two moving averages:
83.33%−48.33%=35%
Hence, the difference between the moving averages is 35%.