Question: 1. Open historical Microsofts stock price data using MS Excel 2. Build one moving average and one exponential smoothing forecast (choose any coefficients). You can
1. Open historical Microsofts 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 all three accuracy measures (MAE, MSE, and MAPE) to compare your models and suggest the best one 4. Build and appropriate chart that displays the actual data and both of your forecasts.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
