FORECAST.LINEAR function

Calculates, or predicts, 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. You can use this function to predict future sales, inventory requirements, or consumer trends.

Syntax

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

The FORECAST.LINEAR function syntax has the following 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.

See Also

Forecasting functions (reference)