FORECAST.LINEAR(x, known_y's, known_x's)

Returns the future y-value along a linear trend using existing values.

xThe x-value you want the prediction for.
known_y'sThe set of y-values for the equation (y = mx + c).
known_x'sThe set of x-values for the equation (y = mx + c).

Remarks

* Added in Excel 2016.
* This function replaces the FORECAST function.
* You can use the FORECAST.ETS function to
* You can use the FORECAST.ETS.CONFINT function to
* You can use the FORECAST.ETS.SEASONALITY function to
* You can use the FORECAST.ETS.STAT function to
* For an illustrated example refer to the page under Advanced Functions.
* For the Microsoft documentation refer to support.office.com

 A
1xx


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top