How to do Holt's Method in Excel

preview_player
Показать описание
How to do Holt's Method in Excel and use solver to find the best alpha & beta by minimizing the RMSE (root mean squared error)
  1. Leslie Major
  2. excel
  3. holt
  4. solver
  5. rmse
  6. stats
Рекомендации по теме
How to do 0:09:15

How to do Holt's Method in Excel

Forecasting - Holt's 0:06:33

Forecasting - Holt's Method

Forecasting (13): Holt's 0:15:50

Forecasting (13): Holt's trend method forecast (double exponential smoothing)

How to perform 0:13:21

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

Holt's Linear Method 0:12:04

Holt's Linear Method

3 Holt's 0:15:37

3 Holt's Method

What is Holt 0:10:24

What is Holt Winters Method? - Time Series Forecasting

How to Holts 0:11:32

How to Holts Winters Method in Excel & optimize Alpha, Beta & Gamma

LIVE! With Christy: 2:43:14

LIVE! With Christy: Lori Holt

Holts Method 0:12:24

Holts Method

How to do 0:06:29

How to do Holt Winter's method in StatPro for Excel 2010/2016/64 bit

TIME SERIES FORECASTING 0:01:23

TIME SERIES FORECASTING - HOLTS LINEAR TREND METHOD

4 HOLTS METHOD 0:07:02

4 HOLTS METHOD FOR TRENDING DATA

Smoothing 5: Holt's 0:11:58

Smoothing 5: Holt's exponential smoothing

Holt winters method 0:12:20

Holt winters method

Holt-Winter's Double Exponential 0:12:10

Holt-Winter's Double Exponential Smoothing Method - Data Driven Forecasting | Data Science | Ex...

Forecasting (14): Holt 0:21:58

Forecasting (14): Holt Winters' method

Holt Winters Method 0:08:38

Holt Winters Method

TIME SERIES FORECASTING 0:03:05

TIME SERIES FORECASTING - HOLT'S LINEAR TREND METHOD PART 2

Exponential Smoothing Method 0:07:02

Exponential Smoothing Method in Forecasting | Forecasting Techniques - Exponential smoothing method

7.5: Holt’s linear 0:03:23

7.5: Holt’s linear trend method

Forecasting: Exponential Smoothing, 0:04:59

Forecasting: Exponential Smoothing, MSE

Smoothing 6: Winter's 0:09:17

Smoothing 6: Winter's exponential smoothing

Forecasting with Holt 0:10:53

Forecasting with Holt and Winters in R

Комментарии
Автор

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

chiaradb
Автор

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!

enchanted_swiftie
Автор

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 Youtube video fot my website?



I am looking forward to hearing from you.



Beste wishes,
Anna

annasherikjian
Автор

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

chiangchong
Автор

How to calculate the alpha and beta values?

sevvalkalay
Автор

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

marcoalcovendas
Автор

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

nidhitambe
Автор

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

gildardorojasmartinez
Автор

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

ferencgerocs
Автор

couldn't you provide us with the solution spreadsheet please

businessman
Автор

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

mrs