I have a question, weighted 3 Period Moving Average, with what do I need to divide, my textbook said 3 but my teacher said 6 - I dont understand why this could be, can you maybe help me to understand? He just used the same formula as you, however he divided by 6.
You just need the previous months data. So you would need Oct, Nov, Dec of the previous year to do a 3month weighted avg for Jan. Without the previous months data you cant really do a 3-month weighted average.
ur so much better at teaching than my teacher
Hahaha appreciate that!
you saved my life man😭😭 i was up for hours tryna figure this out
Ooof Happy to help! Glad this was useful for you.
It was really usefull. Thank you so much.
Glad you found this useful! Appreciate the support!
I have a question, weighted 3 Period Moving Average, with what do I need to divide, my textbook said 3 but my teacher said 6 - I dont understand why this could be, can you maybe help me to understand? He just used the same formula as you, however he divided by 6.
How to use this method in finding 12 months forecast? Like you have Jan-Dec. 2023, and you want to forecast Jan-Dec. 2024?
What is the basis of choosing this weight combination ? I meant why choose 3,7,10 ? Why not 4,6,10? Or 5,7,8?
No particular reason, I just used those numbers in the example. You can weigh your criteria however you think is best.
Could the same results have been achieved using the function SUMPRODUCT?
I’ve never tried using a sumproduct for this but it would make sense that it could work to a certain degree
Is there a way to get a forecast for the empty months? Jan, Feb, March?
You just need the previous months data. So you would need Oct, Nov, Dec of the previous year to do a 3month weighted avg for Jan. Without the previous months data you cant really do a 3-month weighted average.
@@CalonHeindel Thank you for taking the time in replying. Cheers mate.
@@Sirquattro2010 Happy to help