How to perform Holt Winter's Method on Monthly Data (in Excel)

[@lilcheezit9338]

literally thank you so much its 5 am have spent 3 hours trying to decipher my professor just for this one part and you fixed my issues in less than 10 minutes

[@HarryWessex]

So much more understandable for me, than my professors explanation away from Excell.

[@DeronHuskey]

Love the way you step thru this and break out the formula. Thank you.

[@brendanthorne8353]

I'm so thrilled to have found this video. Thank you!

[@tejasvis8806]

Wow! could you please share a downloadable excel file link for that one. that would help a lot

[@trentsawyer5201]

thank you so much Leslie. You cooked, I love you

[@murators4732]

Well explained. Breaking it down step by step helps. Thx

[@annak.1307]

You are the best teacher! It's so clear! Thank you!

[@iliankostadinov8209]

Thank you sooo much! After an entire semester in quarantine i felt like I was going to 100% fail Forecasting. But after watching a couple of your videos I finally understand the fundamentals!

[@learn_with_rungmang]

Hey can you please tell me which course are you taking, where you study things like forecasting? is it data analytics? I ll be joining university soon and wanted to know.

[@iliankostadinov8209]

@@learn_with_rungmangHi, i'm studying Value Chain Management which includes everything from Marketing and Supply Chain to Forecasting, Inventory Management, Planning and many others.

[@learn_with_rungmang]

@@iliankostadinov8209 Thankyou so much! Really appreciate it! :)

[@AtlasEfendi]

What if you had to forecast for more than one season? Which seasonal factors would you use?

[@felixjonathantjuatja898]

Thankyou for helping my exam

[@mdshahriarislam6933]

Dear Leslie , shouldn't the forecast for February consider the level and trend values of January ? The formula says so.

[@hajrawaheed9636]

Thankyou for this!...can we get this excel sheet? it would immensely help.

[@rafiwirawan9102]

this is really helpful, thank you! can we have this excel file?

[@diogocosta9289]

This was very helpful, thank you!!

[@BastiaanQuast]

This is great, thank you. Is the spreadsheet available?

[@vengadanathanmanogaran106]

Thank you for the great tutorial

[@mariateresairustadalenz133]

Thank you! You explained it so well !

[@lugia8888]

Aww

[@learn_with_rungmang]

If a company only has past data for 1 year, how should it go about forecasting for future months mitigating the seasonal effects?

[@rawiyahalraddadi7064]

Thank you for your help!

[@bmh349]

Great explanation Thank You..!!

[@rumeysa7186]

great explanation, thank u so much!

[@emilytran84]

Thank you for great video ! Do you think this model still work perfectly with 12 months data and some month with 0 value. Then is there any way to apply for multi sku products... in the same sheet?

[@valeriorobert]

Great video, thanks!

[@tantipornanan]

Can data be weekly instead of Month in quarter? the Model is still be effective?

[@pelintezcan8405]

great work!!! thank you

[@lesliemajor6676]

Thank you!

[@lesliemajor6676]

You're welcome!

[@ilkeuyankerstudent5347]

I need to forecast 48 months but in this example we only need 9 months to forecast. I don't know how to take seasonalities can you please help?

[@austinbright-j3o]

How can I build forecast.ets Excel function essentially by hand so I have more control over inputs? This is for seasonality as well. I ran forecast.ets.stat so I have the smoothing parameters. Do you have videos on the equations so I can reproduce the results of the exponential triple smoothing by hand?

[@billgillaspey9036]

Is there a way to get your data file?...so I can practice and follow along.?

[@metropropertiesgroup4363]

Bill, To download the data used by Leslie in this example: 1) visit this page at Redfin: www.redfin.com/news/data-center/ 2) scroll down to "Home Prices, Sales & Inventory" 3) select "All" for States 4) select the "Download" Tab 5) select the "Download" Icon at the bottom of the Table (right side of gray Tableau bar) 6) choose "Crosstab" from the list 7) choose "Excel" from the next list and click "Download" 8) download complete Good luck!

[@JimKernix]

@@metropropertiesgroup4363 Home Prices, Sales & Inventory is not on that page

[@JimKernix]

Found it - the new link is www.redfin.com/news/data-center/ then follow all the steps she mentions

[@JimKernix]

However, the numbers don't match. Homes sold in her spreadsheet for January 2015 is 131646 but the file has 310785.

[@metropropertiesgroup4363]

@@JimKernix I see the discrepancy. You can reduce the Home Sales number by filtering by Property Type to "Single Family Residential". However, this doesn't reduce the number to the example value though. My guess is Redfin has expanded their sales database and the downloaded table will still work, but the results will vary from the example. *I have counties around me that still are not tracked by Redfin and not part of their current sales database. FYI...I have used @Leslie Major layout and formulas on a private sales database and it performs the same as in the example. Speaking of that, you can filter the Redfin sales data to your specific area and use her layout for your specific market. Good luck!

[@1309Adrian]

Hey thanks a lot for the explanation, I just have a question, what if you´re forecasting sales for 2021 and want to make some adjustment due to the pandemic economic shut down in 2020, do you have any advice regarding this situation?

[@marcellusnoel1259]

I guess Im asking randomly but does anybody know of a way to log back into an Instagram account?? I stupidly lost my password. I would love any tips you can offer me.

[@poetriii]

hi thank you so much, this really helps me! where can I find the source of the formula to find the initial value? it's for citation purpose!

[@zohalalfinas2777]

can this holt winter method be used in forecasting weekly data?

[@jikosarkar3962]

best video

[@noobgamer-ne3xy]

Hey Leslie, I have an assignment cool, I wanted to know when we are using this method, do we need to find the initial seasonal factors, or we use the first year current values ?

[@ajayiae]

thanks leslie.. quick question.. I followed the steps however final solver step did not work... alpha, beta, gamma and RMSE remained unchanged even after i used the solver to optimize the constants.... any guidance?

[@gabebrown9714]

When we complete the forecast shouldn't the month be off by 1 month due to the plus one. I.e., for your example when you used February should you take the seasonal factor of march?

[@alvarostatistics01]

Sorry. Please answer Mrs, It's aditive or multiplicatice?

[@joodd1468]

This the Holt winter’s additive or multiplicative method?

[@joyrao4537]

what to do if one of the initial month's sales are 0, as later when I drag the formula I get division by 0 error

[@lesliemajor6676]

@joyrao4537 that's such a good question. The initial value can be treated different ways. Some people even use solver to solve for the optimal initial values. Do you have a data set with this initial value of 0 to share? I could have a look

[@jdlopez131]

do you have this excel file?

[@lembayungsenjavibe2120]

Thank you for tutorial, my question, when i have 10 data jun until maret, how i calculate level? Because find level must have y/average(y1,..y12). Please give me answer thank you

[@fordraneokumu1432]

for this there are various formula you can use but let me help in answering your question first...the time series variables or observations , for example stock are the y1,y2,y3...yn , for this particular example, sold are the y1,y2,y3...yn..e.g the first observation is the y1 etc ....for levels you also use [(Y3 - Y1)/2] or [(Y2 - Y1) + (Y3 - Y2)/2] ... so to answer your question, let the first observation take the value y1, then use any formula. If I got your question right

[@espectrum9609]

what if i wanna model another year? I use "k" as 13,14...24?? I think that overestimates the demand

[@nithin1674]

hey sorry for bothering you after one year but I got the same question, do you mind sharing answer if you got one?

[@zeeshanrafi6511]

Good one, just checking have you done holts winter method for daily data using excel. Like I need to calculate my next month day wise, thanks

[@danieladeniyi1558]

Can we utilise Holt Winters method for weekly forecasting? Anyone? and if yes what formulas would one use?

[@exerblank]

Yes, you would have to use 52 periods instead of using 12 periods, since 52 weeks in a year vs 12 months in a year.. And instead of months match week with equivalent week of previous year. Split seasonality into weeks. It will become a lot more tedious though.

[@3003164491]

Awesome!! :)

[@תומרשוורץ-י1מ]

Hello Leslie. I love your channel. I am interested to talk to you. I would like to talk to you about integrating excel skills in industrial engineering studies. How can i reach you? thanks

[@lolbich9420]

sorry, I don't understand why the trend forecasting has some negative number, is ít acceptable?

[@lesliemajor6676]

Yes if the trend is negative, the data is trending down. Sometimes the trend for a particular timestep doesn't reflect what the actual data is doing. That can happen particularly if there is lots of random fluctuations in the data

[@lolbich9420]

@@lesliemajor6676 oh, so does it go the same with the level and season?

[@lesliemajor6676]

@@lolbich9420 yes although the seasonal shouldn't be negative if the data is well suited for holt winters

[@lolbich9420]

@@lesliemajor6676 thanks, now i have understood, thank you so much for answering my question

[@lesliemajor6676]

@@lolbich9420 You're very welcome!

[@patriciapaculanang5193]

Hi! Is this the additive or multiplicative Holt Winter's Model?

[@shakirullah5840]

I think it's multiplicative one.

[@ledyafrischamargolang8387]

I think so

[@nithin1674]

its pseudo additive

[@anandpatel8820]

please share your data

[@lesliemajor6676]

Will do! I'll post the file tomorrow:)

[@albertacorvi4625]

@@lesliemajor6676 where did you post the excel file please?

[@edgarabgar4633]

So, if I understand it correctly, up until period = 63 (March) we have the Actuals. And the forecast column tries to replicate (backtest) the Actuals. But I miss the real Forecasts into the future. In my excel I have tried to drag the formula down to forecast 36 months in the future, but it didn't work. How should I procede from here?