baliuf.blogg.se

To change format of values (use less significant digits or scientific notation), select the equation in the chart, right-click to open the context menu, and choose Format Trend Line Equation - Numbers.ĭefault equation uses x for abscissa variable, and f(x) for ordinate variable. To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose Insert Trend Line Equation. When the chart is in edit mode, LibreOffice gives you the equation of the trend line and the coefficient of determination R 2, even if they are not shown: click on the trend line to see the information in the status bar. Trend Line Equation and Coefficient of Determination Its name can be defined in options of the trend line. On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.A trend line is shown in the legend automatically.Double-click the trendline equation or R-squared text.Method 2: Microsoft Office Excel 2003 and earlier versions of Excel In the Category list, click Number, and then change the Decimal places setting to 30 or less.Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.Open the worksheet that contains the chart.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.