Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The Linest Function has severe errors when curve fitting my data as follows:
X Y 2499.89 -0.240420 4499.83 -0.432740 6499.77 -0.625070 8999.69 -0.865580 11499.83 -1.106090 13499.91 -1.298610 15999.74 -1.539220 18499.93 -1.779800 20500.05 -1.972495 21999.93 -2.116850 2499.89 -0.240400 4499.83 -0.432740 6499.77 -0.625070 8999.69 -0.865535 11499.83 -1.106125 13499.91 -1.298610 15999.74 -1.539235 18499.93 -1.779850 20500.05 -1.972410 21999.93 -2.116830 2499.89 -0.240430 4499.83 -0.432770 6499.77 -0.625150 8999.69 -0.865625 11499.83 -1.106175 13499.91 -1.298680 15999.74 -1.539240 18499.93 -1.779895 20500.05 -1.972440 21999.93 -2.116840 D C B A 4.384643E-17 -4.849642E-12 -9.613158E-05 -7.173873E-05 If you change the first 'Y' value to -0.240419 (the real value), the Linest Equation blows up and is wrong, (Value of 'D' is zero). The results are below: D C B A 0 -4.83784E-12 -9.61317E-05 8.03804E-05 Is there any fix by Microsoft in the works or is there something I can do to ensure data sent to the customer is correct? -- Jim National Research Council of Canada |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003??? | Excel Worksheet Functions | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) |