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
Excel function: N/A