FORECAST.LINEAR Function

The FORECAST.LINEAR function is one of the statistical functions. It is used to calculate, or predict, a future value by using existing values; 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 linear regression.

Syntax

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

The FORECAST.LINEAR function has the following arguments:

Argument	Description
x	An x-value used to predict the y-value.
known_y's	An array of known y-values.
known_x's	An array of known x-values.

Notes

How to apply the FORECAST.LINEAR function.

Examples

The figure below displays the result returned by the FORECAST.LINEAR function.