FORECAST.LINEAR
Calculates a future value by using existing values, using linear regression
Syntax
FORECAST.LINEAR(x, known_y's, known_x's)
Parameters
- 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
Example
=FORECAST.LINEAR(30, A1:A10, B1:B10)