Formula for regression

[Kaspa]

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

 

[Tom Ogilvy]

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/ExcelTips/Polynomial.htm

 

[The Chess Addict]

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/ExcelTips/Polynomial.htm

Tom,

Thanks for your timely help.

Kaspa