Negative r-squared?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When performing regression analysis, Excel returns an r-squared of -3....how
can the square be negative, and how can it be greater than 1 if r ranges from
-1.0 to 1.0?
 
You have stated a truth; the correlation coefficient must exist betwee
-1.o and 1.0, OTHERWISE, there is something wrong with either the dat
or the calculation. I would look at the data to be sue it was properl
displayed. I know this doesn't give you an exact answer to your math
but it does reinforce your initial belief. George F
 
Mike Middleton wrote...
AFNovice -

See the Regression section of this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;829208

Description of the effects of the improved statistical functions for the
Analysis ToolPak in Excel 2003 and in Excel 2004 for Mac
Click to expand...
....

Also see

http://groups-beta.google.com/group...tions/msg/d6a03470e7a1c650?dmode=source&hl=en

(or http://makeashorterlink.com/?H3592148B ).

While Excel 2003 is a big improvement, it's still not perfect. The
linear regression worksheet functions still don't do as good a job
managing limited precision as the chart trendline code. And Excel 2003
handles missing and nonnumeric values in regression X and Y ranges
differently than earlier versions. See the thread

http://groups-beta.google.com/group...31fff22c235/c58cdd63033f6a2f#c58cdd63033f6a2f

(or http://makeashorterlink.com/?Q3E52236A ).
 
Back
Top