If the least-squares regression algorithm does not
"REQUIRE THE NUMBER OF OBSERVATIONS TO EXCEED
THE NUMBER OF PREDICTORS, THEN THE REGRESSION
ALGORITHM COULD BE USED TO SOLVE A SYSTEM OF
SIMULTANEOUS EQUATIONS THAT WOULD HAVE
NO ERRORS."
Another "interesting" characteristic of Excel Regression is that it
"requires
the number of observations to exceed the number of predictors".
Fortunately, Colin Bell is working with the Excel folks at Microsoft to
improve the numerous "interesting" characteristics of Statistics in Excel.
-- Joe
********************************
*** Joe H. Ward, Jr.
*** 167 East Arrowhead Dr.
*** San Antonio, TX 78228-2402
*** Phone: 210-433-6575
*** Fax: 210-433-2828
*** Email: [EMAIL PROTECTED]
*** http://www.ijoa.org/resumes/ward.html
*** -----------
*** Health Careers High School
*** 4646 Hamilton-Wolfe
*** San Antonio, TX 78229
*********************************
----- Original Message -----
From: "Graeme Byrne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 4:42 AM
Subject: Re: adjusted r-square
> In short, you don't. If the number of terms in the model equals the number
> of observations you have much bigger problems than not being able to
compute
> adjusted R^2. It should always be the case that the number of observations
> exceed the number of terms in the model otherwise you cannot calculate any
> of the standard regression diagnostics (F-stats, t-stats etc). My advice
is
> get more data or remove terms from the model. If neither of these is an
> option you are stuck.
>
>
> "Atul" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I have a doubt regarding adjusted r-square
> >
> > How do we calculate the adjusted r-square when the error degrees of
> > freedom are zero ?
> > (or in other words, number of samples is equal to the number of
> > regression terms including the constant)
> >
> > Such a situation leads to a zero in the denominator in the expression
> > for calculating adjusted r-square.
> >
> > Your help is highly appreciated.
> >
> > Thanks
> > Atul
>
>
>
>
> =================================================================
> Instructions for joining and leaving this list and remarks about
> the problem of INAPPROPRIATE MESSAGES are available at
> http://jse.stat.ncsu.edu/
> =================================================================
>
=================================================================
Instructions for joining and leaving this list and remarks about
the problem of INAPPROPRIATE MESSAGES are available at
http://jse.stat.ncsu.edu/
=================================================================
