btabunny.blogg.se - Display trendline equation excel

If is FALSE the constant b is set to 0 and the straight line equation becomes y = mx. If is TRUE (or if this argument is omitted) the constant b is treated normally Īn optional logical argument that specifes whether the constant 'b', in the straight-line equation y = mx + b, should be forced to be equal to zero. If the argument is omitted, it is set to be equal to the. Īn optional argument, providing one or more arrays of numeric values representing a set of new x-values, for which you want to calculate the corresponding new y-values.Įach array of should correspond to an array of. If omitted, the set of takes on the value. This is an optional argument which, if provided, should have the same length as the set of known_y's.

Where the function arguments are as follows: known_y's

On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.TREND( known_y's,, , ).

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.