Curve fit coefficient


K

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
 
Ad

Advertisements

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top