Тёмный
No video :(

Forecasting with Exponential Smoothing in Excel 

scmprofrutgers
Подписаться 2 тыс.
Просмотров 74 тыс.
50% 1

Get you Master of Science in Supply Chain Management online in as little as one year. Please visit: business.rutgers.edu/scmonline.

Опубликовано:

 

29 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 33   
@arzamas1826
@arzamas1826 5 лет назад
thanks for the vid. background noise - sounds like overloaded PC, probably due to heavy formulas in excel :)
@cristiancamiloramirezlopez8811
@cristiancamiloramirezlopez8811 3 года назад
What a wonderful way to find a better alpha changing some parameters using goal cell.
@duke0219
@duke0219 8 лет назад
This is helping me out with my current case study. Thank you so much!
@chukwunonsoamaikwu9621
@chukwunonsoamaikwu9621 5 месяцев назад
Thanks for the goal seek, helped me a lot today 🙏
@mohammedal-ahmadi8045
@mohammedal-ahmadi8045 7 лет назад
That was so simple and helpful, it is help me a lot in my current class. Thanks for sharing
@IndraneelBapat
@IndraneelBapat 3 года назад
we can also use the solver and set the MSE value to minimum to find best value for alpha
@kris24n
@kris24n 12 лет назад
Thank you.. using it at my work and spreading the word..
@hittman1222
@hittman1222 11 лет назад
Your presentations are extremely helpful. Thanks
@shivachiotieno4666
@shivachiotieno4666 4 месяца назад
good stuff
@vishalsejpal6018
@vishalsejpal6018 Год назад
Thanks you so much
@88spaces
@88spaces 4 года назад
Hi, Nice way to round numbers. You can do it in different ways, but I like your solution. Thank you.
@kenji2342
@kenji2342 2 года назад
Thank you Professor Leudi. I should try the go seek tool
@wh1p88
@wh1p88 10 лет назад
Nice video, please include the forecast since that's the point.
@mendellauron1614
@mendellauron1614 11 месяцев назад
WOW
@shubhamgupta-xy6tz
@shubhamgupta-xy6tz 4 года назад
AT -0.065, I am getting the lowest MSE. I know it's not practical but how do I prevent alpha from going below zero
@gateng1573
@gateng1573 11 лет назад
Thanks. This is extremely helpful!!
@GaryHutsonVBA
@GaryHutsonVBA 10 лет назад
Nice video. Thanks
@hoaiannguyenle602
@hoaiannguyenle602 Год назад
there is a problem that the alpha value may be bigger than 1or smaller than 0, how can i tackle?
@usmankaimkhani3719
@usmankaimkhani3719 2 года назад
i tried the goal seek method but it started using negative values of alpha after a while to calculate the lowest possible MSE value. How do i prevent that from happening?
@skillsandresearch2485
@skillsandresearch2485 2 года назад
Hello, really it's great videos. sir could you suggest to me any sophisticated and accurate method for forecasting.because I am new in this field
@RsAsksWhy
@RsAsksWhy 7 лет назад
How do I prevent alpha value from going below zero ?
@tusharshivan9559
@tusharshivan9559 3 года назад
By typing it??
@deepkotak8087
@deepkotak8087 3 года назад
For a more accurate result, you should give input 0.000001 into the value cell instead of zero while using goal seek.
@christallaperatikou4758
@christallaperatikou4758 8 лет назад
all your videos are extremely helpful. how do you calculate the beta & gamma though?
@nikoskritsilis
@nikoskritsilis 11 лет назад
I have a question, The forecasts that you make are demand for periods 25 to 48?
@user-eh3fw2ch2x
@user-eh3fw2ch2x 11 лет назад
I have a question. If I set the alpha value to 0.600. Goal Seek make an error. Could you explain what happened in the functionality in Goal Seek? I think they tried to find local minimum and get an error but I don't know exactly. Please answer~
@jennychen4881
@jennychen4881 7 лет назад
can alpha be a negative number?
@javiervatcky
@javiervatcky 6 лет назад
no, from 0 to 1
@sinisasavic4152
@sinisasavic4152 6 лет назад
Nice
@cray0308
@cray0308 4 года назад
you said that this is to show solver but instead showed goal seek.
@MichaelTarnowskiPIB
@MichaelTarnowskiPIB 11 лет назад
bad screen/video resolution
@wendywen24
@wendywen24 3 года назад
you talked so fast, I can't catch up with.
Далее
Forecasting in Excel Using Simple Linear Regression
7:59
Forecasting in Excel using the Holt-Winter technique
12:09
Forecasting (14): Holt Winters' method
21:58
Просмотров 43 тыс.