Forecasting Techniques : Moving Average, MAD, MSE,MAPE

[@waqarazeem349]

Your teaching methodology is very inspirational & clear headed. Thanks

[@karpagamqtcorner8764]

Glad to hear that :-)

[@Kianshliton]

This is so simply explained. Thank you

[@socialactivist7296]

Honestly ur method is perfect thanks

[@gopicondur]

Excellent explanation Madam. Very easy to understand.

[@karpagamqtcorner8764]

Thanks a lot sir

[@raavn0007]

fantastic video mam..thankyou so much

[@mallelaindira]

Maam, your explanation is perfect. please add double exponential smoothing video as well.

[@karpagamqtcorner8764]

Sure Indira maam, will upload the video shortly.

[@pallavipandavula6724]

Very Helpful.Thank you mam 🙂

[@gabriel-no4uh]

You made it so easy to understand. Thank you!

[@pratheekshakt]

Thank you so much this is so much easier !!

[@ashwaghoshsonkamble8507]

Very Well Explained!!

[@princess3284291]

Thank you. The best.

[@andreweric9790]

great work !

[@prabhatkumar7847]

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

[@zayedsaleh9430]

Thank u Madam for your explanation.

[@MM_lifestylechec742]

Hello Mam your videos really helps to recollect everything thanks a lot you teach very nice keep posting more videos...

[@avunas1430]

love it thanks for making it so easy

[@sudha1611]

Excellent teaching ..

[@humchatt]

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!

[@vishwaschander6274]

Can you explain linear regression method of forecasting ?

[@Hcooper14]

What about the Root mean square error and display it on a chart?

[@sarankumar3499]

Thank you ❤️

[@jmugo_cii5627]

very helpful

[@anjann-e7x]

To calculate MAPE, can we consider only years or is it applicable on a monthly basis as well?

[@dieterstalmann5717]

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.

[@canbhanu]

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

[@zairimtiaz434]

I wish to ask that what is the difference between Dt and Ft in the formula? As Demand and Forecast are same.

[@bft157basavarajan6]

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.

[@xiaojienan7891]

I want to know too

[@canbhanu]

for 7th year it is ok , how we can calculate 8th year forecast madam

[@VASILYOMARBARRIGA]

why do we need to calculate for the error?

[@meyyappanlakshmanan5169]

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 ....

[@amitjain5432]

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

[@karpagamqtcorner8764]

Hi Amit, for trend analysis use excel data analysis option, whereas for forecasting the next period, use the method that i have shown.

[@mohitpal8475]

Mam where is the starting forcast demand

[@priyanktyagi5725]

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??

[@seharlicious010]

What happens if mean average is negative

[@JenyfarYasmin-b3m]

best

[@meyyappanlakshmanan5169]

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

[@DwightWalker]

They give spread of error to see how accurate the predictions are. They are all variations on measuring spread of error.

[@mageshwaranmeena1724]

​@@DwightWalker MSE.. i couldn't find the need of it

[@priyanktyagi5725]

MAD, MSE, MAPE what does tell us..? How to calculate the accuracy of provided material agst the foreacst and what sold agsnt the forecats

[@jafarmohamad9753]

What if the forcasted demand was bigger than the actual demand, the error will be in minus

[@srushtishetty16]

Yes, but due to absolute error, it will be considered positive in the next column.

[@rahulpawar417]

mam can solve the same sum through exponential smoothing method please........i have exam on Monday please ......for mse mape mad - exponential smoothing

[@abdul5806]

Mam! please interpret the results

[@rahulpawar417]

mam can you solve the same sum through exponential smoothing method please........i have exam on Monday please ...... upload.

[@karpagamqtcorner8764]

Sure Rahul, I will upload the video on or before Sunday afternoon

[@rahulpawar417]

@@karpagamqtcorner8764 thankyou madam

[@ahmedmokhtar113]

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

[@mageshwaranmeena1724]

Why is that 2 instead of 3, any reason?

[@zairimtiaz434]

Kindly please answer soon. I am waiting.

[@prabhatkumar7847]

ok so why anyone would like to do this Simple Moving Average method if we have other option, because this is very lengthy

[@areeshaayaz502]

Hey you did a mistake. You have to subtract 1 from denominator in MSE

[@زهراءالكناني-س6ه]

Can you explain the mistake more I didn’t understand what do you mean is it a big mistake?

[@93two2five9OO6SIX]

Really?

[@kwesiamofa9796]

Please can I’ve ur email 📧