Trendline values
 

I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to get
the R-square, which is 0.9442. Then I made a chart based on the same series
of numbers and add trendline to the curve. I selected "Exponential" under
"Type" and checked "Display equation on chart" and "Display R-Squared value
on chart". The value shown on the chart is "y=3928.8e^0.0592x" and
"R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^2=0.9442". Why are
the values on the chart different from those produced by the functions?

Trendline values
 

All this and more is explained at
http://people.stfx.ca/bliengme/Excel...&%20LOGEST.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Scott" wrote in message
...
I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to
get
the R-square, which is 0.9442. Then I made a chart based on the same
series
of numbers and add trendline to the curve. I selected "Exponential" under
"Type" and checked "Display equation on chart" and "Display R-Squared
value
on chart". The value shown on the chart is "y=3928.8e^0.0592x" and
"R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^2=0.9442". Why
are
the values on the chart different from those produced by the functions?

Trendline values
 

Thanks a lot. That solved my problem.

"Bernard Liengme" wrote:

All this and more is explained at
http://people.stfx.ca/bliengme/Excel...&%20LOGEST.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Scott" wrote in message
...
I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to
get
the R-square, which is 0.9442. Then I made a chart based on the same
series
of numbers and add trendline to the curve. I selected "Exponential" under
"Type" and checked "Display equation on chart" and "Display R-Squared
value
on chart". The value shown on the chart is "y=3928.8e^0.0592x" and
"R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^2=0.9442". Why
are
the values on the chart different from those produced by the functions?