LINEST(,,,TRUE) and LOGEST(,,,TRUE) provide the R^2 (3rd row, first column of
output) for the specified model.
Jerry
"David" wrote:
Hi Mike,
Should I be using a different function than RSQ to come up with the answer?
If RSQ is for a linear function, what might I use for an exponential growth?
I would be interested in your book, could you provide the ISBN.
Thank you for your help.
--
David
"Mike Middleton" wrote:
David -
The chart uses an exponential function for the fit, and the chart
trendline's R^2 value is based on that fit (which involves a log
transformation of the Y data).
The RSQ worksheet function is equivalent to using a linear function for the
fit (involving no transformation).
If you want more details about the differences, let me know, and I can send
you some excerpts from my book "Data Analysis Using Microsoft Excel: Updated
for Office XP."
- Mike
http://www.MikeMiddleton.com
"David" wrote in message
...
Hi Group,
I am in "Microsoft Excel Data Analysis and Business Modeling." Chapter 42,
pg 342-343 and put the R squared value on a chart, which equals .9828.
Then i
went to the functions and did RSQ, thinking this would give me the same
answer, but it did not. Maybe I am using the wrong function, although it
indicates that is give the R squared value, but the anser I get is .8386
The data:
Year Sales
1 70
2 183
3 340
4 649
5 1243
6 1979
7 4096
8 6440
9 8459
10 12154
The graph gives one answer, (Format options on the trend line, "display R
squared value on chart") = .9828, but the RSQ function gives .8386.
--
David