How to do Holt's Method in Excel

[@chiaradb852]

Hi, it is very clear and useful. However, could you show it for the monthly data set?

[@chiangchong1880]

How to determine the alpha and beta values in the beginning? Can we choose any value?

[@backpacker4342]

Find using solver

[@ferencgerocs8190]

How to calculate the confidence interval for the F(t+k.th) periods?

[@jahedhossain815]

Can you please share the excel data?

[@annasherikjian7934]

Dear Mrs.Leslie Major, I am Anna from the Netherlands, I study applied mathematics and at the moment I am busy with making a website regarding a course. My question is if I could get your permission to use this KZbin video fot my website? I am looking forward to hearing from you. Beste wishes, Anna

[@mrs3443]

you made it so complex that only you can do it, its not for us after 4 minutes

[@onurerdogan7910]

Thank you so much.

[@akshitbhalla874]

Excellent. Thank you!

[@Slimbowe]

مشكورة برابر

[@mrs3443]

you had flu?

[@marcoalcovendas4476]

Hi Leslie, really interesting but could you help to present in monthly data sets, let say 24 months. Thanks a lot

[@sevvalkalay2455]

How to calculate the alpha and beta values?

[@businessman1060]

couldn't you provide us with the solution spreadsheet please

[@nidhitambe844]

If RMSE is already low do we need to smoothen it still??

[@andylachman3000]

this helped

[@gbitencourt]

Fantastic!

[@oleersoy6547]

You Rock!!

[@gildardorojasmartinez7433]

Very nice, I believe the reason that you are getting a very high error is because Holts method is appropriate when demand is assumed to have a level and a trend in the systematic component, but no seasonality. In the graph that you demonstrate 6:30, it's clear that the data being used has a seasonality. End result better off using Static Method

[@JRAnalyzes]

Shes teaching the Holt's method, not trying to find the best method with the data. Its a continous lecture following up with a better method on her next video using the same dataset...

[@chiangchong1880]

hi do you know where i can find holts forecasting method excel

[@gildardorojasmartinez7433]

@@chiangchong1880 My suggestion to you is just to create your own template. It’s quite simple and you will learn a thing or two during the process.

[@enchanted_swiftie]

Just one sentence: Thank you. No, I need another sentence as well: Thank you very very much! Third one (can't stop): You have really, really done a great job! So clear... and like solved many doubts within just the first minute!