Math/Physic/Economic/Statistic Problems
Question 41
Calculate the final entry in the Moving Average column entering your answer in the cell on the spreadsheet above.
Question 42
Using your answer to Question 41, and with further calculation (but no entry required), find the Seasonal Variation
for Year 3 Quarter 2 entering your answer in the cell on the spreadsheet above.
Questions 43 and 44
Work out the missing entries for Year 1 Quarter 3 (no entry required) to find:Question 38
Calculate the mean error (ME).
Calculate the mean absolute deviation (MAD).
Calculate the mean square error (MSE).
The following information is required for Questions 41, 42, 43 and 44.
This incomplete Excel spreadsheet shows quarterly sales over three years.
Copy and paste the table elsewhere to work on it.
