AFNovice -

See the Regression section of this article:

http://support.microsoft.com/default...b;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

- Mike
www.mikemiddleton.com

"AFNovice" wrote in message
...
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?