| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate polynomial curve
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate polynomial curve
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" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trend for polynomial curve fitting by regressing | Excel Worksheet Functions | |||
| How do I calculate the area under a curve in an Excel graph? | New Users to Excel | |||
| How do I calculate the area under the curve using Excel? | Excel Worksheet Functions | |||
| Calculate the intersection of supply and demand curve | Excel Worksheet Functions | |||
| how do i calculate the area under a curve? | Charts and Charting in Excel | |||
Linear Mode
