Completed
) Change Alpha to find smallest MSE
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Basic Excel Business Analytics - Basic Forecasting Methods & Measures of Forecast Error
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Naïve Method or Most Recent Method for Forecasting
- 2 ) Forecast Error and Mean Forecast Error MFE
- 3 ) Mean Absolute Forecast Error MAE. Measure of Forecast Accuracy/Error.
- 4 ) Mean Square Error for Forecasting MSE for Forecasting. Measure of Forecast Accuracy/Error.
- 5 ) What does Forecast Error or Accuracy measures mean?
- 6 ) Mean Absolute Percentage Error. Measure of Forecast Accuracy/Error.
- 7 ) SUMPRODUCT Array Formula for calculating Mean Square Error for Forecasting
- 8 ) Average Past Values for Forecasting
- 9 ) Moving Average Method for Forecasting
- 10 ) Exponential Smoothing Method for Forecasting using Smoothing Factor Alpha.
- 11 ) Change Alpha to find smallest MSE
- 12 ) Use Solver to find smallest MSE.
