Have more digits of curve fitting coefficients shown

[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

 

[Jerry W. Lewis]

1. If you are referring to a chart trendline, you can format the
displayed equation to show more figures (Right click on the equation and
format as scientific with 14 decimal places). Also, chart trendlines
can be calculated using LINEST (search Google archives for details).

2. It is not clear what you are saying. Excel (all versions) accepts 15
digits on input into a cell. Formatted display may show fewer figures,
but formatting does not impact the underlying value.

The characterization of this group as "Excel Application Errors" in
Microsoft's Office Discussion Groups Home is easily misinterpreted. The
standard name of the group is microsoft.public.excel.crashesgpfs, and
your post has nothing to do with Excel crashing. You would have gotten
an almost immediate response had you posted the question in Worksheet
Functions, Charts, or General Questions, where it would have been more
on topic.

Jerry