Calculate polynomial curve

[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

[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

"ronbrosh111" <ronbrosh111@discussions.microsoft.com> wrote in message
news:0C856489-4D0A-4B8E-A545-D8FBA9539079@microsoft.com...
> 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

[ronbrosh111]

Thanks!

"Mike Middleton" wrote:

> 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
>
> "ronbrosh111" <ronbrosh111@discussions.microsoft.com> wrote in message
> news:0C856489-4D0A-4B8E-A545-D8FBA9539079@microsoft.com...
> > 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
>
>
>