Forecast Accuracy in Excel

Forecast Accuracy in Excel

[@igitankgames4706]

Thank you so much you dont know how helpful you were in showing me how to use the abs formula

[@samrich197667]

Nice Thanks for Sharing

[@LalitKumar-nj7xc]

Thanks Dr Dami. You made it so simple to understand.

[@bikassingh7469]

Good one

[@kneebrain9298]

THANK YOU TEACHER NOW I CAN DO MY ASSIGNMENT 😢❤

[@RodrigueTigwaMeli]

Thank you for this tutorial. I was helpful to me👍

[@bigworknoscales]

great video!

[@2krajan]

Thanks for this helpful video. P

[@dr.damikabiawu4976]

Glad it was helpful!

[@kinglos2807]

Thank you doctor! Helped me out with some work stuff :)

[@dr.damikabiawu4976]

Happy to help!

[@shiningxtarq7628]

This is what I needed. Thank you.

[@dr.damikabiawu4976]

You're so welcome!

[@holio1009]

I love it 🥰 ,But how we can display it on a chart?

[@dr.damikabiawu4976]

What exactly are you trying to display on a chart? What type of chart?

[@navketan1965]

Madame, If I am doing double exponential smoothing 5 period moving average with a software program-after 5 period exponential moving average is calculated say (X) does computer do second calculation with data X and (X-t1) (X-t2) (X-t3) (X-t4) - - - forgive me,I went to college 50 years ago..(X-t1) is exponential moving average one period prior & so on.Thank you.

[@dr.damikabiawu4976]

The answer to this is not as straightforward as you would like. It depends on the software and the code you write with it.

[@jalalbcit]

Thank you so much, now I wonder how can we use these data, calculation to improve the forecast ?

[@dr.damikabiawu4976]

The error calculations can be used as a feedback mechanism. It tells when your actual starts to depart from your forecasts.

[@Opkopen]

Thanks mam

[@scm.digital]

Hello Dami, very good explanation. Why you use n-1 instead of n when you calculate MSE? is it MSE formula = (1/n) * Σ(actual - forecast)^2 ?