Excel Forecast Function Explained!
Vložit
- čas přidán 20. 06. 2018
- This excel video tutorial provides a basic introduction into the forecast function which can be used to predict a y value given an x value. It could be used to predict the population at a certain year, the value of a car at a given time, or the estimated sales forecast in the future.
Excel Tutorial For Beginners:
• Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
Excel - Statistics - Mean, Median, Mode:
• Statistics - Excel
Excel Scatter Charts:
• How To Make a X Y Scat...
Excel - Finding Slope & Y-Intercept:
• Excel Basics - Linear ...
Solving Polynomial Equations - Goal Seek:
• Solving Polynomial Equ...
__________________________________________
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
_________________________________________
CZcams Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections
Final Exams and Video Playlists: www.video-tutor.net/
thank you, before I did not understand after seeing your question I understood the forecast function in excel
Thank you for doing this.
well the forecast for 2020 was sooo incredible :-)
Thank you for this explanation.
Thank you, that was helpful
Very helpful! Thanks!
Thank you!!! You saved my skin
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!
Awesome! Thank you!
very nice and simple!!
thank you. so helpful.
Brilliant. God Bless you
Very clear explanation subscribing
Thank you , Now I know a new function
nice lecture. thanks
what about if there are variations up and down, instead of just linear moving up?
Thank you so much
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
Thank you helpful
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?
This is GOLD, thanks a LOT!
Hi. Can I make a forecast using just one known x and y value?
Hello. I am from the future in 2020. And you are correct! The population of cats is 3,805. ;)
thank you
Whatif there is a dip in sales in some year . can we use forecast formula there?
what if there were multiple y values and I had to choose 1 row from the y values?
i don't get why he spent so much time inputting the values and like zero time explaining the functions
i want to see the forecast for every year until target date!
Love a maths lesson involving cats :)
how can i use this when recruiting number of employees?
helpful... though cant work in my microsoft excell 2007 VERSION. any help?
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?
What do we do to cope with wrong negative output values?
What about other forecasting models like ETS or ARIMA?
How can I use this for betting?? Please help!!
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
Could we predict or estimate 10years value by knowing year1 year 2 and our goal at year 10?
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.
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😁
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.
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!
This is just basic interpolation and extrapolation.
My excel doesnt have the forecast.est
Is this an auto regressive forecast function?
You show graphical in this forecasting plz
I watched at 1.75 playback speed.
This function was correct about the 2020 forecast of cats 😂
Math Damon
We win BIIiIIG!🏆🏆✝️✝️
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
We win BIIiIiIG!🏆🏆✝️✝️
I keep getting #Div/0! everytime I do it
watch the video again
Świr
+1
lies, doesnt exist, nobody can predict futur
Thank you so much