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


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

Excel function: N/A


next up previous contents index
Next: TRIM Up: A. Function Reference Previous: TRANSPOSE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003