Calculate polynomial curve

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to calculate the polynomial curve of a dataset (y values, x
values). This is essentially what an XY scatter chart does, thought I'd like
to see the exact coefficients. Are there statistical functions that
accomplish this?

Thanks!

Ron
 
Ron -

(1) Use the array-entered LINEST worksheet function (see Help for
assistance), e.g.,

=LINEST(y-range, x-range^{1,2,3})

(2) Enter the x, x^2, x^3, ... data in adjacent columns on a worksheet, and
use the Regression tool of the Analysis ToolPak. You'll get the LINEST
results (and more) in formatted output.

- Mike
www.mikemiddleton.com
 
Thanks!

Mike Middleton said:
Ron -

(1) Use the array-entered LINEST worksheet function (see Help for
assistance), e.g.,

=LINEST(y-range, x-range^{1,2,3})

(2) Enter the x, x^2, x^3, ... data in adjacent columns on a worksheet, and
use the Regression tool of the Analysis ToolPak. You'll get the LINEST
results (and more) in formatted output.

- Mike
www.mikemiddleton.com
Click to expand...
 
Back
Top