Trendline values

S

Scott

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's equation for R-Squared value given for chart trendlines? 4
R-squared from a trendline 4
Trendline Values 1
I want to use equations to generate the chart. Is it possible? 2
Trendline Textbox Not Updating 3
Correlation coefficient for log plot.. 2
Trendline Extract 5
Fitting a power or exponential trendline 3

Top