     Next: LLS Up: A. Function Reference Previous: LINCOEF   Contents   Index

# LINFIT

Syntax: LINFIT(X, Y)

X = a range representing a column vector of independent variables values
Y = a range representing a column vector of dependent variables values

LINFIT generates the values for a straight line least squares fit.

The output of this function is the vector of estimated y values on the left hand side of the above equation. The input vector X and Y must both be row vectors or both column vectors. The output vector will be a row vector if X and Y are row vectors, and a column vector if X and Y are column vectors. The length of the output vector is equal the the length of the input vectors. This function is equivalent to POLYFIT(X, Y, 1).

Example:

Matrix B1..B5 =

1 2 B 1 2 3 4 5

Matrix C1..C5 =

1 2 C 3 5 11 18 31

LINFIT(B1..B5, C1..C5) =
 -0.2 6.7 13.6 20.5 27.4

Excel function: N/A     Next: LLS Up: A. Function Reference Previous: LINCOEF   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003