Forecasting with Exponential Smoothing in Excel

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

[@arzamas1826]

thanks for the vid. background noise - sounds like overloaded PC, probably due to heavy formulas in excel :)

[@duke0219]

This is helping me out with my current case study. Thank you so much!

[@cristiancamiloramirezlopez8811]

What a wonderful way to find a better alpha changing some parameters using goal cell.

[@chukwunonsoamaikwu9621]

Thanks for the goal seek, helped me a lot today 🙏

[@mohammedal-ahmadi8045]

That was so simple and helpful, it is help me a lot in my current class.
Thanks for sharing

[@shivachiotieno4666]

good stuff

[@hittman1222]

Your presentations are extremely helpful. Thanks

[@wh1p88]

Nice video, please include the forecast since that's the point.

[@shubhamgupta-xy6tz]

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

[@kenji2342]

Thank you Professor Leudi. I should try the go seek tool

[@usmankaimkhani3719]

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?

[@kris24n]

Thank you.. using it at my work and spreading the word..

[@88spaces]

Hi, Nice way to round numbers. You can do it in different ways, but I like your solution. Thank you.

[@vishalsejpal6018]

Thanks you so much

[@IndraneelBapat]

we can also use the solver and set the MSE value to minimum to find best value for alpha

[@GaryHutsonVBA]

Nice video. Thanks

[@hoaiannguyenle602]

there is a problem that the alpha value may be bigger than 1or smaller than 0, how can i tackle?

[@mendellauron1614]

WOW

[@RsAsksWhy]

How do I prevent alpha value from going below zero ?

[@tusharshivan9559]

By typing it??

[@gateng1573]

Thanks. This is extremely helpful!!

[@skillsandresearch2485]

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]

all your videos are extremely helpful. how do you calculate the beta & gamma though?

[@nikoskritsilis]

I have a question, The forecasts that you make are demand for periods 25 to 48?

[@user-eh3fw2ch2x]

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~

[@deepkotak8087]

For a more accurate result, you should give input 0.000001 into the value cell instead of zero while using goal seek.

[@jennychen4881]

can alpha be a negative number?

[@javiervatcky]

no, from 0 to 1

[@sinisasavic4152]

Nice

[@cray0308]

you said that this is to show solver but instead showed goal seek.

[@MichaelTarnowskiPIB]

bad screen/video resolution

[@wendywen24]

you talked so fast, I can't catch up with.