![]() (This can still be helpful sometimes, but you do need to be careful when using the fit, as it will be off by a factor of 1000.) In older versions of Excel, it was necessary to play with the scale of your x and y axes in order to fix this type of a problem.įor example, if your x-axis was in kilovolts, you might need to plot your data by dividing your x-series by 1000, so that 4000 would be plotted as 4.000. If you’ve been doing your experiment correctly, chances are that more than one digit in your fit should be significant. In particular, for large numbers displayed with powers of ten, like 5E-34, it may only show one digit. When Excel plots your trend line and displays its equation, it is almost hit-or-miss on how many digits it will display. Significant Digits in a Trendline Equation Changing the digits in the trendline equation to the correct number of significant digits can help improve your lab reports and scientific papers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |