LINCOEF

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 $a_1$ and $a_0$ 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