Dr. O'Loughlin, Thank you so much for these videos. I am currently trying to obtain my 2nd Bachelor's Degree online while working 65 hours a week and I could not have passed this most recent course without your helpful instruction! Thank you for everything you're doing it is so appreciated.
Hi Maian, Keep calculating the next month as shown until you reach five months - you can actually keep going as long as you want. BUT.... remember that the further into the future you predict, the less accurate your predictions will be. This is because you will soon start using forecasted values in your calculations. Dr E.
A better comparison can be visualized by plotting on the same chart. Just add the 3-month moving average column as series data source in the existing chart.
Thanks a lot Dr. Eugene....very useful tutorial..but how can I forecast more (e.g . 5 mos). coz in your example, you only have 1 month (January 2012)...can you help me?
Greetings Mr Eugene,I would like to ask, in order to calculate the WMA, we must use exclusively the closing price of the instrument ? Thanks in advance
Can you show us any method that can be used for longer periods this method has the smoothing effect and after a while the numbers become absolutely the same ?
Thanks for this. Btw is there any formula for calculating this in excel. Actually I wanted to calculate it for 50 weights, so is there any shortcut method to do? The given formula is going to exhaust me by giving weights to 50 different values
Thanks for the tutorial, may I know what's the difference between 3-months forecast and 5-months forecast? I'm doing a retrospective analysis of the learning curve of a new surgical method, and my chart's finally smoothened by using a moving 10-subjects average (which're bizarre spikes with 3- and 5-subjects averages).
Hi Anchal, The figure if 6 is the sum of the weightings. In my example the weightings are: 3, 2, and 1. Remember to change this if you use different weightings, eg: if you have weightings of 5, 4, and 3, then divide by 12 (5 + 4 + 3 = 12). Hope this helps, Dr E.
Hi Upd, Check the formula at 17 secs into the video. You can see that it is used to determine the Forecast (F) for time (t). To do this for a three point average you can see in the formula that the actual (A) values used are for t-1, t-2, and t-3. So if Ft is April, At-1 is March, At-2 is February, and At-3 is January. I hope this helps clarify how you use this method. Dr E.
Dr. O'Loughlin,
Thank you so much for these videos. I am currently trying to obtain my 2nd Bachelor's Degree online while working 65 hours a week and I could not have passed this most recent course without your helpful instruction! Thank you for everything you're doing it is so appreciated.
Mr. Eugene, Excellent Explanation. My doubts are clarified by your responses for questions asked by others. Thanks!
I really like your videos Eugene...you have this nice and simple way of explaining things. Thanks
thank you so much! sir! I really confused cause my lecturer didn't explain it so well. and you make it so simple! thank you so much
Thank you so much for these videos! You're saving my ass in a supply chain management class I'm in with a professor who doesn't teach! =(
Thanks so very much for this Dr O'Laughlin. Very well explained.
very clear explanation and easy to understand
Thank you very much for your videos. They're all very useful! subscribed.
Hi Maian,
Keep calculating the next month as shown until you reach five months - you can actually keep going as long as you want.
BUT.... remember that the further into the future you predict, the less accurate your predictions will be. This is because you will soon start using forecasted values in your calculations.
Dr E.
You the man, +1 from Canada!
Thank you so much for this video! Excellent
U R A HERO MY FRIEND U SAVED ME LIKE 2H WORK :*
Thanks a lot Dr. Eugene.. very useful..
Thank You so much Mr O'Loughlin
A better comparison can be visualized by plotting on the same chart. Just add the 3-month moving average column as series data source in the existing chart.
Thanku for explaining WMA, Pls can u make a video of calculating HMA and post it....it ll be very useful
Many thanks, very helpful!
Thank you for this informative video!
Excellent audio quality
Thanks! Great job, this helped me!
You rock!
Thanks a lot Dr. Eugene....very useful tutorial..but how can I forecast more (e.g . 5 mos). coz in your example, you only have 1 month (January 2012)...can you help me?
Greetings Mr Eugene,I would like to ask, in order to calculate the WMA, we must use exclusively the closing price of the instrument ?
Thanks in advance
Can you show us any method that can be used for longer periods this method has the smoothing effect and after a while the numbers become absolutely the same ?
Thanks for this. Btw is there any formula for calculating this in excel. Actually I wanted to calculate it for 50 weights, so is there any shortcut method to do? The given formula is going to exhaust me by giving weights to 50 different values
Hi Karan,
Try my video about how to do this:
ruclips.net/video/-ZsrkI0OsEw/видео.htmlsi=pCsVZT9-fC-ByAJV
Hope this helps,
Dr E.
Thanks for the tutorial, may I know what's the difference between 3-months forecast and 5-months forecast? I'm doing a retrospective analysis of the learning curve of a new surgical method, and my chart's finally smoothened by using a moving 10-subjects average (which're bizarre spikes with 3- and 5-subjects averages).
Hi what if we are calculating only 3 month moving average from april to november then how solve ?
Thank you so much for this Video!! Helped me a lot in analyzing my data in research.
Does Weighted mean and Weighted Average the same? thanks.. :)
Thank you!!
very helpful
May I know the formula to get the January, 2012 sales figure?? Thank you
U CAN ALSO USE =AVERAGE(..+..+..)
i'm using quarterly data. means every three months. can i easily change it to 3 periods weighted moving average
Hi ailurophobia03,
It's up to you to decide analysis to do on your data, but yes - you can use 3 periods as I show in the video.
Dr E.
why don't use "= sumproduct"?
sumproduct can be used only when number of arrays are equal, in this explanation, it's about moving averages, when arrays are changing,
why in formula divided by 6??
Hi Anchal,
The figure if 6 is the sum of the weightings. In my example the weightings are: 3, 2, and 1.
Remember to change this if you use different weightings, eg: if you have weightings of 5, 4, and 3, then divide by 12 (5 + 4 + 3 = 12).
Hope this helps,
Dr E.
I don't understand why you are dividing by 6
Hi Kush,
6 is the sum of the weights (3+2+1) that I used in this example (as explained at 2:47 in the video).
Dr E.
why is it divided by 6
Same Question!!!
This is wrong, for april you need to start with april * 3, for a specific month you allways start with the close of that time.
Hi Upd,
Check the formula at 17 secs into the video. You can see that it is used to determine the Forecast (F) for time (t). To do this for a three point average you can see in the formula that the actual (A) values used are for t-1, t-2, and t-3.
So if Ft is April, At-1 is March, At-2 is February, and At-3 is January.
I hope this helps clarify how you use this method.
Dr E.