Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can somebody please help me with the questions below. I need step-by-step instructions as to how to do the moving averages using the data analysis
Can somebody please help me with the questions below. I need step-by-step instructions as to how to do the moving averages using the data analysis tool in Excel.
Q1 | 10 Marks | Sales | |||||||||||||
Month | Sales | ||||||||||||||
a) Develop the 2-months and 3-months moving averages for the supermarket sales. | 1 | 125 | |||||||||||||
Note: use data analysis tool pack. | 5 Marks | 2 | 141 | ||||||||||||
3 | 125 | ||||||||||||||
b) Which moving average appears to provide more accurate forecasts based on MAD? Explain. | 4 | 123 | |||||||||||||
Note: show your MAD calculations. | 5 Marks | 5 | 126 | ||||||||||||
6 | 145 | ||||||||||||||
7 | 147 | ||||||||||||||
8 | 162 | ||||||||||||||
9 | 155 | ||||||||||||||
10 | 158 | ||||||||||||||
11 | 147 | ||||||||||||||
12 | 159 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started