Calculates the expected y-value for a specified x based on a linear regression of a dataset.
Sample Usage
FORECAST(20,A2:A10,B2:B10)
FORECAST(A1,A2:A10,B2:B10)
Syntax
FORECAST(x, data_y, data_x)
- x - The value on x-axis to forecast.
- data_y - The array or range representing dependent data points.
- data_x - The array or range representing independent data points.
Examples
FORECAST(20,A2:A10,B2:B10) calculates the expected y-value for 20 based on the linear regression of the dataset in data_x and data_y.