For more information about this change, read this blog post. Summary 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.
Trendline equation is a formula that finds a line that best fits the data points. R-squared value measures the trendline reliability - the nearer R2 is to 1, the better the trendline fits the data. Note The trendline formula is used for an XY Scatter chart.
For some purposes, this may not be a sufficient number of significant figures. This article explains how to display more digits in the coefficients.
- What news is better to trade binary options
- Trading options reviews
- Excel trendline equation is wrong - reasons and fixes Excel trendline types When adding a trendline in Excel, you have 6 different options to choose from.
- Where can I register to make money
Display more digits The trendline equation and R-squared value are initially displayed as rounded to five digits. To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel Open the worksheet that contains the chart.
Right-click the trendline equation or the R-squared text, and then click Format Trendline Label. Click Number.
In the Category list, click Number, and then change the Decimal places setting to 30 or less. Click Close.
Method 2: Microsoft Office Excel and earlier versions of Excel Open the worksheet that contains the chart. Double-click the trendline equation or R-squared text.
On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less. Click OK.
Note Even though you can like the trendline equation the number of decimal places to 30 for the Number category, Excel only displays values to a maximum of 15 digits of precision.
Additional digits are displayed as zero. Is this page helpful?