Forecasting Techniques : Moving Average, MAD, MSE,MAPE
HTML-код
- Опубликовано: 11 окт 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
Your teaching methodology is very inspirational & clear headed. Thanks
Glad to hear that :-)
This is so simply explained. Thank you
You made it so easy to understand. Thank you!
Honestly ur method is perfect thanks
Hello Mam your videos really helps to recollect everything thanks a lot you teach very nice keep posting more videos...
Thank you so much this is so much easier !!
fantastic video mam..thankyou so much
love it thanks for making it so easy
Excellent teaching ..
Excellent explanation Madam. Very easy to understand.
Thanks a lot sir
I wish to ask that what is the difference between Dt and Ft in the formula? As Demand and Forecast are same.
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
Thank u Madam for your explanation.
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!
great work !
Very Well Explained!!
My question is simple: how come the forecast is lower than the trend? I would have thought that with a growing amount for each period, that the 7th value would have been higher than 465, irrespective of the method used. 443 means that I am forecasting a lower value, i.e. the trend will move down from period 6.
Maam, your explanation is perfect. please add double exponential smoothing video as well.
Sure Indira maam, will upload the video shortly.
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 ....
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
Can you explain linear regression method of forecasting ?
Thank you ❤️
why do we need to calculate for the error?
very helpful
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
What happens if mean average is negative
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.
mam can solve the same sum through exponential smoothing method please........i have exam on Monday please ......for mse mape mad - exponential smoothing
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
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.
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
best
Mam!
please interpret the results
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
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?
Kindly please answer soon. I am waiting.
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 📧