Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can somebody please clearly explain step-by-step how to use Excel Data Analysis to answer the below questions. Thank you. Q2 20 Marks Sales Month Sales
Can somebody please clearly explain step-by-step how to use Excel Data Analysis to answer the below questions. Thank you.
Q2 | 20 Marks | Sales | ||||||||||||||
Month | Sales | |||||||||||||||
1 | 125 | |||||||||||||||
a) Use = .2 to compute the exponential smoothing forecast for the supermarket sales. | 5 Marks | 2 | 141 | |||||||||||||
3 | 125 | |||||||||||||||
b) Use = .3 to compute the exponential smoothing forecast for the supermarket sales. | 5 Marks | 4 | 123 | |||||||||||||
5 | 126 | |||||||||||||||
c) Use = .4 to compute the exponential smoothing forecast for the supermarket sales. | 5 Marks | 6 | 145 | |||||||||||||
7 | 147 | |||||||||||||||
d) Does a smoothing constant of .2, .3 or .4 appear to provide more accurate forecasts based on MSE? Explain. | 5 Marks | 8 | 162 | |||||||||||||
Note: show your MSE calculations. | 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