Excel Forecast Function Explained!

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:

Top 30 Excel Tips & Shortcuts:

_________________________________________
Excel - Statistics - Mean, Median, Mode:

Excel Scatter Charts:

Excel - Finding Slope & Y-Intercept:

Solving Polynomial Equations - Goal Seek:

__________________________________________
How To Calculate Loan Payments In Excel:

How To Create an Amortization Table:

How To Look Up Customer Data In Excel:

How To Create a Data Entry Form In Excel:

_________________________________________
YouTube Channel Growth Accelerator:

Algebra For Beginners:

Final Exams and Video Playlists:

Full-Length Math & Science Videos:

[triheru]

thank you, before I did not understand after seeing your question I understood the forecast function in excel

[sam]

well the forecast for 2020 was sooo incredible :-)

[fbarbie]

Hello. I am from the future in 2020. And you are correct! The population of cats is 3, 805. ;)

[philippemizizi]

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!

[giselalopes]

Very clear. Thanks a lot. Waiting for more videos about excel functions.

[renatosilva]

what about if there are variations up and down, instead of just linear moving up?

[CaribouDataScience]

What about other forecasting models like ETS or ARIMA?

[bymdm]

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?

[nodebeinechi]

Hi. Can I make a forecast using just one known x and y value?

[marcarnaldo]

This is just basic interpolation and extrapolation.

[nishanthpillai]

What do we do to cope with wrong negative output values?

[etukurijoshua]

How can I use this for betting?? Please help!!

[georgeodhyambo]

helpful... though cant work in my microsoft excell 2007 VERSION. any help?

[annachan]

i don't get why he spent so much time inputting the values and like zero time explaining the functions

[crafttymum]

When forecast and when forecast.ets to be used

[amazingvdo]

Could we predict or estimate 10years value by knowing year1 year 2 and our goal at year 10?

[crafttymum]

Whatif there is a dip in sales in some year . can we use forecast formula there?

[greencable]

i want to see the forecast for every year until target date!