Formula for regression
 

Is there an Excel formula that can do the regression to find the best
quadratic fit for a set of x-y data.

The equation would be
y = a0 + a1 * x + a2 * x^2

I know that index(linest(...),..) can give me individual coefficients
for a simpler linear equation y = a0 + a1 * x.
Is there a similar formula for the equation above? I don't want to
go through multiple menus or create extra 'dummy' columns.
Any simpler way? Thanks.

Kaspa

Formula for regression
 

Linest will work here as well:

You can see how Bernard Liengme solves for the coefficients of a polynomial
curve using LINEST.
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

--
Regards,
Tom Ogilvy


"Kaspa" wrote in message
...
Is there an Excel formula that can do the regression to find the best
quadratic fit for a set of x-y data.

The equation would be
y = a0 + a1 * x + a2 * x^2

I know that index(linest(...),..) can give me individual coefficients
for a simpler linear equation y = a0 + a1 * x.
Is there a similar formula for the equation above? I don't want to
go through multiple menus or create extra 'dummy' columns.
Any simpler way? Thanks.

Kaspa

Formula for regression
 

"Tom Ogilvy" wrote in message ...
Linest will work here as well:

You can see how Bernard Liengme solves for the coefficients of a polynomial
curve using LINEST.
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

--
Regards,
Tom Ogilvy

Tom,

Thanks for your timely help.

Kaspa