Syntax: @FORECAST(X', X, Y)
X'= New x value
X = Old x value
Y = Old y value
@FORECAST returns Y', the predicted value for y for X', given original x and y values X and Y.
Example:
A | B | |
1 | 20 | 6 |
2 | 28 | 7 |
3 | 31 | 9 |
4 | 38 | 15 |
5 | 40 | 21 |
@FORECAST(30, A1..A5, B1..B5) = 10.60725