Forecasting Techniques : Moving Average, MAD, MSE,MAPE
Vložit
- čas přidán 11. 10. 2021
- This video talks about calculation of moving average and the error calculation.
1. 3 Year Moving average is used
2. Calculation of Error : Mean Absolute Deviation, Mean Square Error, Mean Absolute Percent Error.
#Movingaverage #MAD #MSE #MAPE .
Keep Watching, Keep Learning
This is so simply explained. Thank you
Your teaching methodology is very inspirational & clear headed. Thanks
Glad to hear that :-)
You made it so easy to understand. Thank you!
Honestly ur method is perfect thanks
Thank you so much this is so much easier !!
Hello Mam your videos really helps to recollect everything thanks a lot you teach very nice keep posting more videos...
I wish to ask that what is the difference between Dt and Ft in the formula? As Demand and Forecast are same.
Excellent teaching ..
love it thanks for making it so easy
fantastic video mam..thankyou so much
What does the mse, mape % denote? As in case of coeff we say lesser the coeff more consistent & vice versa similarly is there anything with error!
Thank u Madam for your explanation.
Karpagam - I have Incidents for month 1 to month 10. I need to estimate incidents for month 11, 12 and 13. Is it possible to moving average ....
great work !
plz make video on another topics of Finance as well. Budgeting decision, leverage etc. The way of you are explaining is great. please make videos
Excellent explanation Madam. Very easy to understand.
Thanks a lot sir
Very Well Explained!!
Maam, your explanation is perfect. please add double exponential smoothing video as well.
Sure Indira maam, will upload the video shortly.
very helpful
why do we need to calculate for the error?
Thank you ❤️
mam can solve the same sum through exponential smoothing method please........i have exam on Monday please ......for mse mape mad - exponential smoothing
Can you explain linear regression method of forecasting ?
Madam- i made an attempt to forecast (by following 3 yrs moving avg) for 2023 is 214, but 2024 is 148 (it is doubt) - by following your teaching guidelines
What happens if mean average is negative
hlloo mam,
Your explanation method is very good. I have a doubt, how to get the correct forecasted value by using MAD, MSE and MAPE values. Please give easy solution, it is important for me.
I want to know too
Mam where is the starting forcast demand
Man I am simple want
What provide material agenst the forecast and what sales team sold the material agst the forecast
I want calculate both the accuracy
Pls suggest how to do that??
for 7th year it is ok , how we can calculate 8th year forecast
madam
Hello mam, i have a query for moving average, when i calculated using "Data Analysis" option in excel to calculate Moving average for 3 years it gives values starting from 3rd year itself which should be starting from 4th year so got confused shall we consider 3rd year data for 3rd year moving average to see the trend or not, can you help please
Hi Amit, for trend analysis use excel data analysis option, whereas for forecasting the next period, use the method that i have shown.
best
What if the forcasted demand was bigger than the actual demand, the error will be in minus
Yes, but due to absolute error, it will be considered positive in the next column.
Mam!
please interpret the results
Kindly please answer soon. I am waiting.
Karpagam - One more question. I totally understand the logistics of calculating MAD, MSE and MAPE but I am missing a point - Why are calculating this MAD, MSE and MAPE ? What does it tell us ? Please help me understand. I will be glad to call you or even set up a google call. I learning statistics on own .... any help of great value to me
They give spread of error to see how accurate the predictions are. They are all variations on measuring spread of error.
@@DwightWalker MSE.. i couldn't find the need of it
MAD, MSE, MAPE what does tell us..? How to calculate the accuracy of provided material agst the foreacst and what sold agsnt the forecats
thanks madam for your video but i have comment i think you mistake in calculation of MSE where should divided into 2 instead of 3 please check and feedback
Why is that 2 instead of 3, any reason?
mam can you solve the same sum through exponential smoothing method please........i have exam on Monday please ...... upload.
Sure Rahul, I will upload the video on or before Sunday afternoon
@@karpagamqtcorner8764 thankyou madam
ok so why anyone would like to do this Simple Moving Average method if we have other option, because this is very lengthy
Hey you did a mistake. You have to subtract 1 from denominator in MSE
Can you explain the mistake more I didn’t understand what do you mean is it a big mistake?
Really?
Please can I’ve ur email 📧