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

* This function was added in Excel 2016.
* This function can return multiple values.
* This function replaces the FORECAST function.
* You can use the FORECAST.ETS function to return the future value based on historical values.
* You can use the FORECAST.ETS.CONFINT function to return the confidence interval for a future value.
* You can use the FORECAST.ETS.SEASONALITY function to return the length of the repetitive seasonality pattern.
* You can use the FORECAST.ETS.STAT function to return the statistical value for a future value.
* For the Microsoft documentation refer to

1=FORECAST.LINEAR(30, {6, 7, 9, 15, 21}, {20, 28, 31, 38, 40}) = 10.607
2=FORECAST.LINEAR(3.2, 2, 3) = #DIV/0!

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