Syntax: LINCOEF(X, Y)
X = a range representing a column vector of independent
variables values
Y = a range representing a column vector of dependent
variables values
LINCOEF generates the straight line least squares fit. The output is the values for and and is a row vector if X and Y are row vectors, and a column vector if X and Y are column vectors. This function is equivalent to POLYCOEF(X, Y, 1).
Example:
Matrix B1..B5 =
B | |
1 | 1 |
---|---|
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
Matrix C1..C5 =
C | |
1 | 3 |
---|---|
2 | 5 |
3 | 11 |
4 | 18 |
5 | 31 |
LINCOEF(B1..B5, C1..C5) =
6.9 7.1 |
This is the solution for:
Excel function: N/A