 Formula Engine Reference Guide |
|
Back to Class Index
FORECAST(X', X, Y)
This function returns Y', the predicted value for y for X', given original x and y values X and Y.
Parameters
X'
New x value
X
Old x value
Y
Old y value
Example
A B
20 6
28 7
31 9
38 15
40 21
FORECAST(30, A1..A5, B1..B5) = 10.60725