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?
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~
thanks for the vid. background noise - sounds like overloaded PC, probably due to heavy formulas in excel :)
This is helping me out with my current case study. Thank you so much!
What a wonderful way to find a better alpha changing some parameters using goal cell.
Thanks for the goal seek, helped me a lot today 🙏
That was so simple and helpful, it is help me a lot in my current class.
Thanks for sharing
good stuff
Your presentations are extremely helpful. Thanks
Nice video, please include the forecast since that's the point.
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
Thank you Professor Leudi. I should try the go seek tool
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?
Thank you.. using it at my work and spreading the word..
Hi, Nice way to round numbers. You can do it in different ways, but I like your solution. Thank you.
Thanks you so much
we can also use the solver and set the MSE value to minimum to find best value for alpha
Nice video. Thanks
there is a problem that the alpha value may be bigger than 1or smaller than 0, how can i tackle?
WOW
How do I prevent alpha value from going below zero ?
By typing it??
Thanks. This is extremely helpful!!
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
all your videos are extremely helpful. how do you calculate the beta & gamma though?
I have a question, The forecasts that you make are demand for periods 25 to 48?
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~
For a more accurate result, you should give input 0.000001 into the value cell instead of zero while using goal seek.
can alpha be a negative number?
no, from 0 to 1
Nice
you said that this is to show solver but instead showed goal seek.
bad screen/video resolution
you talked so fast, I can't catch up with.