Forecasting with Exponential Smoothing in Excel

  Рет қаралды 75,345

scmprofrutgers

scmprofrutgers

Күн бұрын

Пікірлер: 34
@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!
@mohammedal-ahmadi8045
@mohammedal-ahmadi8045 8 жыл бұрын
That was so simple and helpful, it is help me a lot in my current class. Thanks for sharing
@arzamas1826
@arzamas1826 5 жыл бұрын
thanks for the vid. background noise - sounds like overloaded PC, probably due to heavy formulas in excel :)
@chukwunonsoamaikwu9621
@chukwunonsoamaikwu9621 10 ай бұрын
Thanks for the goal seek, helped me a lot today 🙏
@kenji2342
@kenji2342 2 жыл бұрын
Thank you Professor Leudi. I should try the go seek tool
@abasi.24
@abasi.24 2 ай бұрын
Thanks for the goal seek, helped me a lot
@hittman1222
@hittman1222 12 жыл бұрын
Your presentations are extremely helpful. Thanks
@88spaces
@88spaces 4 жыл бұрын
Hi, Nice way to round numbers. You can do it in different ways, but I like your solution. Thank you.
@IndraneelBapat
@IndraneelBapat 4 жыл бұрын
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..
@skillsandresearch2485
@skillsandresearch2485 3 жыл бұрын
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
@christallaperatikou4758
@christallaperatikou4758 9 жыл бұрын
all your videos are extremely helpful. how do you calculate the beta & gamma though?
@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?
@wh1p88
@wh1p88 10 жыл бұрын
Nice video, please include the forecast since that's the point.
@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
@RsAsksWhy
@RsAsksWhy 8 жыл бұрын
How do I prevent alpha value from going below zero ?
@tusharshivan9559
@tusharshivan9559 4 жыл бұрын
By typing it??
@hoaiannguyenle602
@hoaiannguyenle602 Жыл бұрын
there is a problem that the alpha value may be bigger than 1or smaller than 0, how can i tackle?
@nikoskritsilis
@nikoskritsilis 12 жыл бұрын
I have a question, The forecasts that you make are demand for periods 25 to 48?
@최원근-t7c
@최원근-t7c 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~
@GaryHutsonVBA
@GaryHutsonVBA 10 жыл бұрын
Nice video. Thanks
@jennychen4881
@jennychen4881 7 жыл бұрын
can alpha be a negative number?
@javiervatcky
@javiervatcky 7 жыл бұрын
no, from 0 to 1
@gateng1573
@gateng1573 12 жыл бұрын
Thanks. This is extremely helpful!!
@shivachiotieno4666
@shivachiotieno4666 8 ай бұрын
good stuff
@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.
@vishalsejpal6018
@vishalsejpal6018 Жыл бұрын
Thanks you so much
@sinisasavic4152
@sinisasavic4152 7 жыл бұрын
Nice
@mendellauron1614
@mendellauron1614 Жыл бұрын
WOW
@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.
Excel - Time Series Forecasting - Part 3 of 3
17:03
Jalayer Academy
Рет қаралды 522 М.
Exponential Smoothing Using Excel
9:41
The Business Doctor
Рет қаралды 2 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
1% vs 100% #beatbox #tiktok
01:10
BeatboxJCOP
Рет қаралды 67 МЛН
Chain Game Strong ⛓️
00:21
Anwar Jibawi
Рет қаралды 41 МЛН
Forecasting Techniques: Trend and Seasonality-Corrected (Winter's Method)
18:26
Supply Chain Tutorials
Рет қаралды 110 М.
Time Series Talk : Autocorrelation and Partial Autocorrelation
13:16
Using Excel 2016 Solver to Find the Optimum Value of Alpha for an Exponential Smoothing Forecast
7:42
Forecasting (12): Simple exponential smoothing forecast
9:12
RESEARCH HUB
Рет қаралды 26 М.
Learn Regression Analysis in Excel in Just 12 Minutes
12:34
Kenji Explains
Рет қаралды 35 М.
Forecasting in Excel using the Holt-Winter technique
12:09
scmprofrutgers
Рет қаралды 161 М.
Exponential Smoothing Forecast Excel 2016 Data Analysis Toolpak
5:42
The Stats Files - Dawn Wright Ph.D.
Рет қаралды 58 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН