View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DigitalDuck
 
Posts: n/a
Default Multiple Regression R^2 Issue

Whenever I run a multiple regression it always tells me that my R^2 is 1
Now I know these numbers aren't that good.
Maybe someone can help me figure this out.
Here is what it outputs in the summary field:
Regression Statistics:
Multiple R: 1
R Squa 1
Adj. R Squa -1.2E-09
Standard Error: 1.15E-10
Observations 3

I have 7 input variables each with 3 observations.
Anyone know what is going on or if I am just screwing it up and reading it
wrong?
I haven't been in stat for a while, and when I was I used SPSS which was way
more user friendly.
Thanks.

I know there are very ef