O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required