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 calculate the moving average for the period March to May, we take the percentage of rooms occupied for each month:
March: 30%
April: 45%
May: 70%
The total is:
30+45+70=145
The moving average is then:
3145=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 for June to August:
June: 70%
July: 90%
August: 90%
The total is:
70+90+90=250
The moving average is:
3250=83.33%
Step 3
State the difference between the two 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
Now we find the difference between the two moving averages:
