Calculate polynomial curve

R

ronbrosh111

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
 
M

Mike Middleton

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
 
R

ronbrosh111

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
 

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