G
Guest
1. The coefficients of the curve fitting are not shown with enough digits. I
calulated the y's with the euqation and they don't match the original data as
well as shown by the fitted curve. The worset point from the fitting curve
is 10 times lower than the original data.
2. When I tried to type the curve fitting equation obtained from Tecplot
into the excel sheet, Excel did not take all the digits (2 out of 13 digits
were not shown) of the coefficients. As a result, the curve fitting did not
show good macth.
However, when I typed in the coefficients with all the digits into seperate
cells and reference the cells in the equation, the data from the equation
matched the original data very well.
Please email to me so I can email you the xls file to show you the above
problems.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...4d1f31a&dg=microsoft.public.excel.crashesgpfs
calulated the y's with the euqation and they don't match the original data as
well as shown by the fitted curve. The worset point from the fitting curve
is 10 times lower than the original data.
2. When I tried to type the curve fitting equation obtained from Tecplot
into the excel sheet, Excel did not take all the digits (2 out of 13 digits
were not shown) of the coefficients. As a result, the curve fitting did not
show good macth.
However, when I typed in the coefficients with all the digits into seperate
cells and reference the cells in the equation, the data from the equation
matched the original data very well.
Please email to me so I can email you the xls file to show you the above
problems.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...4d1f31a&dg=microsoft.public.excel.crashesgpfs