FORECAST
Formulas / FORECASTPredicts values based on a linear trend
FORECAST(x, known_y's, known_x's)
- x - the data point
- known_y's - the dependent array or data range
- known_x's - the independent array or data range
Examples
=FORECAST(B13,sales,periods)The FORECAST function is used to predict a future value, such as sales values over different periods.This takes the values from the named range sales (located in cells C5:C12) and the named range periods (located in cells B5:B12) and uses them to calculate the predicted value for cell D13.
Summary
The FORECAST function calculates a future value based on existing values using linear regression. It produces a y-value for a given x-value, allowing for accurate predictions of future values.
- Starting with Excel 2016, FORECAST has been replaced with FORECAST.LINEAR, which will eventually be deprecated.
- FORECAST returns a #VALUE! error if the given x value is not numeric.
- FORECAST returns an #NA error if the sizes of the known_ys and known_xs are not the same.
- FORECAST returns a #DIV/0! error if the variance of the known_x values equals zero.
Need help with Formulas?
Frequently Asked Questions
What is the FORECAST function?
The FORECAST function is an old function that has been replaced with FORECAST.LINEAR in Excel 2016. It returns a predicted value based on existing values, using the equation A+Bx.
How is the syntax of FORECAST different from FORECAST.LINEAR?
The syntax of FORECAST.LINEAR is the same as FORECAST.
What errors are returned by FORECAST and FORECAST.LINEAR?
- FORECAST returns a #VALUE! error if x is non-numeric.
- For Excel 2016, FORECAST.LINEAR returns a #N/A error if known_y's or known_x's is empty. It also returns a #N/A error if known_y's has more data points than known_x's, or vice versa.
- FORECAST and FORECAST.LINEAR return the #DIV/0! error if the variance of known_x's is zero.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV