Calculate MSE on Excel to diagnose forecast accuracy

preview_player
Показать описание
Calculate MSE (mean squared error) on Excel. Use two different methods to forecast.
Рекомендации по теме
Комментарии
Автор

Thank you for the informative video!

I am working on 30 days data that has outliers (i.e. 10 perfume sold). The other values ranges from 300 - 400 perfumes sold. In your opinion, will you be remove the outliers?

Thank you again!

pengypang
Автор

Can you please help me in taking out the average of the data as forecast of 25, 14, 20, 12, 19, 24, 36

rachitkhetan