Syntax: POLYCOEF(X, Y, N)
X = a range representing a row or column vector of
independent variable values
Y = a range representing a row or column vector of dependent variable values
N = polynomial degree in the range 1 to 10
POLYCOEF generates the least squares coefficients for the polynomial fit.
The output of this function is a vector of length N+1
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.
Matrix B1..B5 =
Matrix C1..C5 =
POLYCOEF(B1..B5, C1..C5, 2) =
Excel function: N/A