Curve fit coefficient

[Kipi]

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

 

[Ron Rosenfeld]

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