next up previous contents index
Next: TRIM Up: A Function Reference Previous: TRANSPOSE

TREND

 

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


next up previous contents index
Next: TRIM Up: A Function Reference Previous: TRANSPOSE

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999