On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.

In my case I am using a polynomial of degree 6 which, to maintain accuracy, I am displaying to 9 decimal places. Is there any way of accessing the coefficients of the equation directly from Excel, other than by re-typing them. Click Close.

Double-click the trendline equation or R-squared text. When you specify a trendline on a chart, you are able to display the trendline equation on the chart. Exponential Function in ExcelDouble-click the trendline equation or R-squared text.

Next, click the Options tab near the top of the Add Trendline menu. Method 2: Microsoft Office Excel 2003 and earlier versions of Excel Select Chart > Add trendline On the Add Trendline menu, select Linear for the Trend/Regression type (Fig.

In the Category list, click Number, and then change the Decimal places setting to 30 or less. Note In previous versions of Excel, you change the number of decimal places in a trendline equation by using the Increase Decimal or Decrease Decimal.

Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.

Open the worksheet that contains the chart.

Round your answer to two decimal places and do not include a dollar sign. To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 In the file, MajorSalary, data have been collected from 111 College of. The trendline equation and R-squared value are initially displayed as rounded to five digits. This article explains how to display more digits in the coefficients. For some purposes, this may not be a sufficient number of significant figures.

When you add a trendline to a chart, and then display the equation and R-squared value for the trendline, the equation shows only the first five digits of each coefficient.

Excel trendline equation decimal places