Syntax: @TREND(NX, KX, KY)
NX = range for new x values for which TREND will return
corresponding y values
KX = known x values
KY = known y values
@TREND fits a straight line to KX (known x's) and KY (known y's) using least square method, and then returns the y values along the line for NX (new x's).
Example:
B | C | |
10 | X values | Y values |
11 | 1 | 242 |
12 | 2 | 256 |
13 | 3 | 263 |
14 | 4 | 274 |
15 | 5 | 279 |
16 | 6 | 285 |
17 | 7 | 290 |
@TREND(A1..A2, B11..B17, C11..C17) =
301 |
308.7857 |
316.5714 |