Statistical - FORECAST.LINEAR Function
Advertisements
Description
The 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.
Syntax
FORECAST.LINEAR(x, known_y's, known_x's)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
X | The data point for which you want to predict a value. | Required |
Known_y's | The dependent array or range of data. | Required |
Known_x's | The independent array or range of data. | Required |
Notes
FORECAST.LINEAR Function is added in Excel 2016 and replaces the FORECAST Function of the earlier Excel Versions.
Applicability
Excel 2016
advanced_excel_statistical_functions.htm
Advertisements