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
Personal Tutor For Serways Essentials Of College Physics,
Authors: Raymond A Serway, Chris Vuille
1st Edition
0495171646, 9780495171645
