I know that there is a LINEST function to return the coefficient of best

linear curve fit

However I would like to know if there is anyway to return the coefficients

of, say , a quadratic curve fit? Or if there is anyway to manual type in

algorithm that excel use in polynomial curve fit? Oh and I would like to have

a 0 y-intercept

Thanks

Did you check HELP for LINEST?

Is this not what you are looking for?

=======================

.... you can use LINEST to calculate a range of other regression types by

entering functions of the x and y variables as the x and y series for LINEST.

For example, the following formula:

=LINEST(yvalues, xvalues^COLUMN($A:$C))

works when you have a single column of y-values and a single column of x-values

to calculate the cubic (polynomial of order 3) approximation of the form:

y = m1*x + m2*x^2 + m3*x^3 + b

==============================

--ron