What a wonderful way to find a better alpha changing some parameters using goal cell.
@duke02198 жыл бұрын
This is helping me out with my current case study. Thank you so much!
@mohammedal-ahmadi80458 жыл бұрын
That was so simple and helpful, it is help me a lot in my current class. Thanks for sharing
@arzamas18265 жыл бұрын
thanks for the vid. background noise - sounds like overloaded PC, probably due to heavy formulas in excel :)
@chukwunonsoamaikwu962110 ай бұрын
Thanks for the goal seek, helped me a lot today 🙏
@kenji23422 жыл бұрын
Thank you Professor Leudi. I should try the go seek tool
@abasi.242 ай бұрын
Thanks for the goal seek, helped me a lot
@hittman122212 жыл бұрын
Your presentations are extremely helpful. Thanks
@88spaces4 жыл бұрын
Hi, Nice way to round numbers. You can do it in different ways, but I like your solution. Thank you.
@IndraneelBapat4 жыл бұрын
we can also use the solver and set the MSE value to minimum to find best value for alpha
@kris24n12 жыл бұрын
Thank you.. using it at my work and spreading the word..
@skillsandresearch24853 жыл бұрын
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
@christallaperatikou47589 жыл бұрын
all your videos are extremely helpful. how do you calculate the beta & gamma though?
@usmankaimkhani37192 жыл бұрын
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?
@wh1p8810 жыл бұрын
Nice video, please include the forecast since that's the point.
@shubhamgupta-xy6tz4 жыл бұрын
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
@RsAsksWhy8 жыл бұрын
How do I prevent alpha value from going below zero ?
@tusharshivan95594 жыл бұрын
By typing it??
@hoaiannguyenle602 Жыл бұрын
there is a problem that the alpha value may be bigger than 1or smaller than 0, how can i tackle?
@nikoskritsilis12 жыл бұрын
I have a question, The forecasts that you make are demand for periods 25 to 48?
@최원근-t7c11 жыл бұрын
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~
@GaryHutsonVBA10 жыл бұрын
Nice video. Thanks
@jennychen48817 жыл бұрын
can alpha be a negative number?
@javiervatcky7 жыл бұрын
no, from 0 to 1
@gateng157312 жыл бұрын
Thanks. This is extremely helpful!!
@shivachiotieno46668 ай бұрын
good stuff
@deepkotak80873 жыл бұрын
For a more accurate result, you should give input 0.000001 into the value cell instead of zero while using goal seek.
@vishalsejpal6018 Жыл бұрын
Thanks you so much
@sinisasavic41527 жыл бұрын
Nice
@mendellauron1614 Жыл бұрын
WOW
@cray03084 жыл бұрын
you said that this is to show solver but instead showed goal seek.