FORECAST()

Syntax. FORECAST(x,known_y’s,known_x’s)

Definition. This function returns the estimated value for a linear trend. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using a linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends.

Arguments

  • x (required). The data point for which you want to predict a value

  • known_y’s (required). The dependent array or range of data

  • known_x’s (required). The independent array or range of data

Note

If x isn’t a numeric expression, the FORECAST() function returns the #VALUE! error.

If known_y’s and known_x’s are empty or contain a different number of data points, the ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.