it's easy to understand at the beginning, but starting from 11'15" I got lost. Why just simply put 1 to 6 to calculate future forecast, any explanation or theory behind that?
Thanks very much for the great example. The only one I had found alread. Just one point. I do not get it, why you input the value for the forecast yt+1 for period march 1996 into cell I7 instead of I6. By including the time parameter t+1 it is already clear, that the forecast is for the next period. Any you also want to make sure, that the forecast for march 1996 is made in february 1996. By putting it into a cell below, you waste one forecast at the end. Also I did use the software xlstat and it also did it one cell above.
Sir, If I am doing double exponential smoothing 5 period moving average with a software program--after 5 period exponential moving average is calculated say (X) does computer do second calculation with data X and (X-t1) (X-t2) (X-t3) (X-t4)- - - - forgive me,I went to college 50 years ago..(X-t1) is exponential moving average one period prior & so on.
thankyou but what if the last Tt's value is negative? I tried to forecast using holt but because of negative Tt's value my forecast value is decreasing.
it's easy to understand at the beginning, but starting from 11'15" I got lost. Why just simply put 1 to 6 to calculate future forecast, any explanation or theory behind that?
Amazing video! Thank you
very helpful again, cheers!
Glad to hear it!
Can I ask, how to determine the value of alpha and gamma at the 1G and 2H
Thanks very much for the great example. The only one I had found alread. Just one point. I do not get it, why you input the value for the forecast yt+1 for period march 1996 into cell I7 instead of I6. By including the time parameter t+1 it is already clear, that the forecast is for the next period. Any you also want to make sure, that the forecast for march 1996 is made in february 1996. By putting it into a cell below, you waste one forecast at the end. Also I did use the software xlstat and it also did it one cell above.
If the demand trend is initially decreasing and later increasing, should we take the first trend value (Tt) as a negative number?
thank you so much
Sir, If I am doing double exponential smoothing 5 period moving average with a software program--after 5 period exponential moving average is calculated say (X) does computer do second calculation with data X and (X-t1) (X-t2) (X-t3) (X-t4)- - - - forgive me,I went to college 50 years ago..(X-t1) is exponential moving average one period prior & so on.
Thanks for a great lecture!
Glad you enjoyed it!
thankyou but what if the last Tt's value is negative?
I tried to forecast using holt but because of negative Tt's value my forecast value is decreasing.
have you tried any other method for example HW or regression? maybe HT is not the most appropriate method for your data?
can i get ppt used and excel sheet computation done
Thankyou for the explanation, what if forecasts comes negative and how could we verify whether this model for our data is correct or not?
What kind of data are you forecasting?
What is out sample forecast? Why July didn't use June values?
Please see th-cam.com/video/16IKsLlZClY/w-d-xo.html
Great videos and very helpful! Which forecast methods do we use when we have seasonality??
holt-winters, see th-cam.com/video/uLHOfewK9wc/w-d-xo.html
so, how to forecast for the next period? example Jan 2000
Can you increase the Volume please.
Acadamic grade!
The problem with that is the Forecast Horizon calculation where to get Forecast for future you are just multiplying with forecast horizon number
This is not a problem at all. There are different approaches to forecasting, and this is one of them.
@@RESEARCHHUB I have a question: In double exponential smoothing, the sum of alpha and beta must= one, or not necessary?
This is confusing, more background knowledge please and use a typing instead of writing pen, can't read.
0:20 TT hahahahaa