On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.Double-click the trendline equation or R-squared text.

y -0.518x + 0.596 The Pearson correlation coefficient is -0.566. The equation of the line is the following. Question: In Excel, a linear trendline was added to a scatter plot. Method 2: Microsoft Office Excel 2003 and earlier versions of Excel This problem has been solved Youll get a detailed solution from a subject matter expert that helps you learn core concepts. In the Category list, click Number, and then change the Decimal places setting to 30 or less.This function has only two arguments (arguments are pieces of data the formula needs to run). By using a function in a formula: Round a number to the number of digits you want by using the ROUND function. Right-click the trendline equation or the R-squared text, and then click Format Trendline Label. In the Decimal places box, enter the number of decimal places that you want to display.Note: if you round a number, you lose precision. Open the worksheet that contains the chart. The ROUND function below rounds a number to two decimal places.

To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 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. Sometimes the trendline equation displayed on a graph will not be shown the number of decimal places or significant figures desired.

Excel trendline equation decimal places