The original number could then have ranged from 2.51 to 3.49. In the image shown, if we only had one digit in our trendline, the first term would be displayed as 3x 2. In the extreme case where only one digit is displayed in our first term, our actual acceleration has a wide range of possibilities. In the example shown, we are using the fit to determine the acceleration of an object sliding down an incline. Often we use the fit of the trendline to determine a particular quantity. Why would you want to change the number of digits displayed? The Trendline Format Dialog, accessed by right-clicking on the trendline equation. Choose the appropriate precision based on your measurements. You will be given the option for how many decimal places to display. Under Number\Category select “Number” or “Scientific” from the drop down list.A new dialog panel will show up to the right. Click on “Format Trendline Label” from the options that appear.(Sometimes you might need to click twice.) Right click on the trend line equation.In the latest version of Excel, however, you can change the number of digits displayed in your fit by doing the following… (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 Trend Line Equation
0 kommentar(er)
