Question: 1. Open historical McDonalds stock price data using MS Excel 2. Build one moving average and one exponential smoothing forecast (choose any coefficients). You can

1. Open historical McDonalds stock price data using MS Excel 2. Build one moving average and one exponential smoothing forecast (choose any coefficients). You can use either Data Analysis toolpak or Forecast Sheet 3. Calculate one accuracy measure (MAD, MSE, or MAPE) to compare your models and suggest the best model 4. Build and appropriate chart that displays the actual data and both of your forecasts. McDonalds stock.xlsx
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
