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
>
>
>