When you have only one independent x-variable, you can obtain y-intercept (b) values directly by using the following formula: Like LINEST, LOGEST returns an array of values that describes a relationship among the values, but LINEST fits a straight line to your data LOGEST fits an exponential curve. The more a plot of your data resembles an exponential curve, the better the calculated line will fit your data. If stats is FALSE or omitted, LOGEST returns only the m-coefficients and the constant b.įor more information about additional regression statistics, see the LINEST function. If known_x's is omitted, it is assumed to be the array. If more than one variable is used, known_y's must be a range of cells with a height of one row or a width of one column (which is also known as a vector). If only one variable is used, known_y's and known_x's can be ranges of any shape, as long as they have equal dimensions. The array known_x's can include one or more sets of variables. An optional set of x-values that you may already know in the relationship y = b*m^x. If the array known_y's is in a single row, then each row of known_x's is interpreted as a separate variable. If the array known_y's is in a single column, then each column of known_x's is interpreted as a separate variable. The set of y-values you already know in the relationship y = b*m^x. The LOGEST function syntax has the following arguments:

On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.LOGEST(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.

Excel exponential trendline equation