The video describes using MS Excel to calculate seasonal indices for a very simple set of data that has seasonal fluctuations.

The video describes using MS Excel to calculate seasonal indices for a very simple set of data that has seasonal fluctuations.

Hi, Piyush Shah!Join AIR MCN:https://goo.gl/jYDSVzSir how do you model the croston method for intermittent demands?

what is solution? when Anova result is not significant .

Nice video, Sir please make videos using same example for weighted moving average and exponential smoothing.

A big H E L L O from COLOMBIA. I do something like you…..related to milking production, but using percentage….I know you are laughing now but, is my way…and it works with cow´s milk production. I will use your method. G R A C I A S M I L !!!!

Very helpful. Thank you so much

i'm wondering how you can forecast daily volumes for christmas, using trends from past 3 years, as christmas day varies per year

How would calculate seasonal indices using average percentage method?

Hello Mr. Piyush,

Very nice video! I just have one question, though..

How will I calculate my seasonal indices when I do not have a complete set of data points? For example, if I am using monthly sales data for forecasting, and I have only 30 months of previous sales data, how will I calculate the seasonal indices? My data starts in Feb,2014 and ends in July,2017.

Mr. Piyush can I ask what book or theory references you used for this method?

What if you're not given year 4 demand of 570? i was given a question like this. How do you do forecast for year 4 seasons using naive trend method?

Hi jus wanna say thank you!

thank you. this video is very helpful

Thank you for your video!

what if I donot have 4th year total data 570. How to forecast then?

Excellent !!!! Thank you so much

Thank you!!! You explain things so well and make it easy.

hello Mister Pitush .. where did you get the 570 demand for year 4?

thanks!

Thank you for your wonderful and clear explanation!

Thank you for your help! Was very informative.

Why not test the data from forecast eror ? How we know that forecast is well ?