View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default Calculate polynomial curve

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" wrote in message
...
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