Prev: Desparate For Help - Pivot Table Field List
Next: .csv Re-Format Question
From: Kipi on 12 Apr 2010 08:58
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
From: Ron Rosenfeld on 12 Apr 2010 09:41
On Mon, 12 Apr 2010 05:58:02 -0700, Kipi <Kipi(a)discussions.microsoft.com>
wrote:

>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
 | 
Pages: 1
Prev: Desparate For Help - Pivot Table Field List
Next: .csv Re-Format Question