Thank you so much! Because I'd have thought Regression model analysis was the only method to forecast values! Though, I can guess the difference. But I wish if you can suggest the difference between this function and regression analysis!
Hello, what if the first value of Year 1 is not provided and there were no previous data available, is there a way in finding that Year 1 value of a certain subject?
Supply and demand, inflation and economic development or declination also taking in the factors of the U.S. labor statistics and economic reports to spot trends and make money, otherwise welcome to the 90% that lose in trading in the long run😁
If I want to know forecasted date instead of population figures. Is it possible? What I mean is say, I input a population value of 8000 in excel and want to know on which date it will occur? Thanks!
I don't know why the forecast.ets function doesn't exist in my Excel 2013. I've checked the add ins and customize ribbon settings and it have check list completed, but still it doesn't appear or exist. Can someone please help me to tell how to overcome this?
Hehe if it's a 2003 Audi you couldn't pay me enough to take it! It would be a negative value LOL. They're extremely complicated and hard to service. Great video though!
what if a car value is also based on mileage? so you have extra parameter mileage and dataset would be something like 2010 year, value 20k, mileage 0 (brand new car), in year 2011, same car is worth of 15k with 10k mileage, 2012, 8k with 120k miliage and so on and you want to predict the value of the car in 2030 when you decide to sell it with 100k mileage and obviously you know what the cars were selling each year and mileage? can this be done with forecast?
Final Exams and Video Playlists: www.video-tutor.net/
Thank you so much! Because I'd have thought Regression model analysis was the only method to forecast values! Though, I can guess the difference. But I wish if you can suggest the difference between this function and regression analysis!
Very clear explanation subscribing
Thank you so much
thank you, before I did not understand after seeing your question I understood the forecast function in excel
Thank you!!! You saved my skin
Thank you for this explanation.
well the forecast for 2020 was sooo incredible :-)
what about if there are variations up and down, instead of just linear moving up?
Brilliant. God Bless you
Hello. I am from the future in 2020. And you are correct! The population of cats is 3,805. ;)
What about other forecasting models like ETS or ARIMA?
very nice and simple!!
This is GOLD, thanks a LOT!
Thank you helpful
thank you
Very clear. Thanks a lot. Waiting for more videos about excel functions.
He just wants to see what functions can get more accurate values
Very helpful! Thanks!
thank you. so helpful.
Thank you for doing this.
Hello, what if the first value of Year 1 is not provided and there were no previous data available, is there a way in finding that Year 1 value of a certain subject?
We win BIIiIIG!🏆🏆✝️✝️
i don't get why he spent so much time inputting the values and like zero time explaining the functions
helpful... though cant work in my microsoft excell 2007 VERSION. any help?
nice lecture. thanks
Hi. Can I make a forecast using just one known x and y value?
THANK YOU
Could we predict or estimate 10years value by knowing year1 year 2 and our goal at year 10?
Awesome! Thank you!
Can you make an tutorial about how to calculate forex currency's pair trend?
Supply and demand, inflation and economic development or declination also taking in the factors of the U.S. labor statistics and economic reports to spot trends and make money, otherwise welcome to the 90% that lose in trading in the long run😁
Whatif there is a dip in sales in some year . can we use forecast formula there?
Thank you , Now I know a new function
What do we do to cope with wrong negative output values?
Love a maths lesson involving cats :)
How can I use this for betting?? Please help!!
We win BIIiIiIG!🏆🏆✝️✝️
This is just basic interpolation and extrapolation.
If I want to know forecasted date instead of population figures. Is it possible? What I mean is say, I input a population value of 8000 in excel and want to know on which date it will occur? Thanks!
Yes, it is just to invert the references.
When forecast and when forecast.ets to be used
I don't know why the forecast.ets function doesn't exist in my Excel 2013. I've checked the add ins and customize ribbon settings and it have check list completed, but still it doesn't appear or exist. Can someone please help me to tell how to overcome this?
It was released as part of Excel 2016 I think.
Thank you, that was helpful
i want to see the forecast for every year until target date!
Is this an auto regressive forecast function?
what if there were multiple y values and I had to choose 1 row from the y values?
Hehe if it's a 2003 Audi you couldn't pay me enough to take it! It would be a negative value LOL. They're extremely complicated and hard to service. Great video though!
what if a car value is also based on mileage? so you have extra parameter mileage and dataset would be something like 2010 year, value 20k, mileage 0 (brand new car), in year 2011, same car is worth of 15k with 10k mileage, 2012, 8k with 120k miliage and so on and you want to predict the value of the car in 2030 when you decide to sell it with 100k mileage and obviously you know what the cars were selling each year and mileage? can this be done with forecast?
You show graphical in this forecasting plz
Math Damon
how can i use this when recruiting number of employees?
My excel doesnt have the forecast.est
I watched at 1.75 playback speed.
This function was correct about the 2020 forecast of cats 😂
please tell me how to use forecast for cells having two x_ranges or discontinuous ranges.
im actually trying to figure this out myself for warehouse volumes for days and nights actuals.
lies, doesnt exist, nobody can predict futur
What is this alien language, I have no idea what just happened!
thank you for explaining this. but with the cat population forecasting cats do not live long lol
I keep getting #Div/0! everytime I do it
watch the video again
Świr
+1
Thank you so much