Thanks, Richard --
Yes, there IS A PROBLEM!
I called the IJOA folks about the situation.
http://www.ijoa.org/joeward/wardindex.html
IJOA is in the process of changing computer systems, so their URL will
be down until sometime next week. Of course, those system changes are
unpredictable.
Thanks for your interest.
By the way, we checked the EXCEL2000 Regression program yesterday and
it still has the WRONG TOTAL and REGRESSION SUM OF SQUARES WHEN
THE "CONSTANT IS ZERO" IS CHECKED. Of course, that makes the F statistic
wrong, too.
Fortunately, the RESIDUAL SUM OF SQUARES IS CORRECT.
I'm sure that previous users must have mentioned this to the EXCEL
REGRESSION folks.
Perhaps no one cares.
-- Joe
************************************************
* Joe Ward
* 167 East Arrowhead Dr.
* San Antonio, TX 78228-2402
* Phone: 210-433-6575
* Fax: 210-433-2828
* Email: [EMAIL PROTECTED]
* http://www.ijoa.org/joeward/wardindex.html
* --------------------------------
* Health Careers High School
* 4646 Hamilton Wolfe
* San Antonio, TX 78229
* Phone: 210-617-5400
* Fax: 210-617-5423
******************************************
-----Original Message-----
From: R.C. <[EMAIL PROTECTED]>
To: Joe Ward <[EMAIL PROTECTED]>
Date: Friday, June 16, 2000 10:08 AM
Subject: Re: Beginner requests for help on ANOVA and T-tests (n
SYSTAT97 --CAUTION)
>IS THERE A PROBLEM WITH THE LINK PROVIDED HERE? OR IS
>IT ME?
>
>THANKS,
>RICHARD
======================================
>--- Joe Ward <[EMAIL PROTECTED]> wrote:
>> Edmond--
>>
>> You may want to use the REGRESSION program in Excel
>> (WITH CAUTION).
>> That way you can create your own models to do what
>> YOU WANT TO DO.
>> You might want to contact a statistician to help you
>> use REGRESSION
>> models. You don't need to use some of the
>> Pre-Computer algorithms if
>> you know who to create your models to answere YOUR
>> QUESTIONS.
>>
>> The URL below has a few articles related to this
>> message:
>> http://www.ijoa.org/joeward/wardindex.html
>>
>> If the "packaged" algorithms answer the questions of
>> interest,
>> then you can use them.
>>
>> I am using Excel 97 with three high school students
>> this summer.
>> 2 Sophomores and 1 Senior in preparation for their
>> Science Fair
>> Research Projects. I usually use SYSTAT. However,
>> these students
>> already have Excel, so we are "testing" the use of
>> REGRESSION in Excel.
>>
>> Incidentally, when you use REGRESSION models that
>> need to:
>>
>> NOT HAVE THE Y-INTERCEPT TO PASS THROUGH ZERO,
>>
>> THE REGRESSION SUM OF SQUARES ARE NOT CORRECT.
>>
>> So be careful when you use REGRESSION in Excel 97.
>>
>> The Excel97 Error is due to the fact that the
>> REGRESSION SUM OF SQUARES
>> IS CALCULATED FROM THE "TOTAL SUM OF SQUARES" MINUS
>> THE "RESIDUAL
>> SUM OF SQUARES". THE "TOTAL SUM OF SQUARES" IS NOT
>> CORRECT
>> WHEN YOU INDICATED THAT YOU DO NOT WANT THE
>> INTERCEPT TO PASS THROUGH
>> THE ORIGIN.
>>
>> THE EXCEL PROGRAM USES THE "ADJUSTED SUM OF
>> SQUARES"
>> (REMOVING the REGRESSION SUM OF SQUARES ACCOUNTED
>> FOR BY THE
>> UNIT VECTOR (the "MEAN"). The REAL TOTAL SUM OF
>> SQUARES IN THIS
>> CASE SHOULD BE THE SUM OF SQUARES FOR THE DEPENDENT
>> VARIABLE.
>>
>> Apparently the programmer of the REGRESSION
>> procedure did not know how to
>> compute the REAL TOTAL SUM OF SQUARES.
>>
>> As some of the users and creators of Statistical
>> Software Packages
>> frequently mention:
>>
>> "Using the statistical routines in Excel can be
>> risky."
>>
>> Of course, ALL statistical packages should be used
>> with caution.
>>
>> We have not had time to check on the Excel2000 to
>> find out if it is still
>> has the
>> same problem.
>>
>> Keep in touch.
>>
>> -- JHW
>> ************************************************
>> * Joe Ward
>> * 167 East Arrowhead Dr.
>> * San Antonio, TX 78228-2402
>> * Phone: 210-433-6575
>> * Fax: 210-433-2828
>> * Email: [EMAIL PROTECTED]
>> * http://www.ijoa.org/joeward/wardindex.html
>> * --------------------------------
>> * Health Careers High School
>> * 4646 Hamilton Wolfe
>> * San Antonio, TX 78229
>> * Phone: 210-617-5400
>> * Fax: 210-617-5423
>> ******************************************
>>
>> -----Original Message-----
>> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED]
>> <[EMAIL PROTECTED]>
>> Date: Thursday, June 15, 2000 9:37 AM
>> Subject: Beginner requests for help on ANOVA and
>> T-tests
>>
>>
>> >Hello, I am a 16 year old student and a beginner to
>> statistics.
>> >I'm lost.
>> >Currently I only have Microsoft Excel 97. And I
>> would like to know the
>> >differences between the following ANOVA tests (in
>> Excel):
>> >
>> >ANOVA Single Factor
>> >ANOVA Two-Factors with replication
>> >ANOVA Two-Factors without replication
>> >
>> >What do all these mean? Where and when should they
>> be applied? And can
>> >anyone please use simple english terms to explain?
>> I am only a beginner.
>> >What is one-way or two-way ANOVA?
>> >
>> >How about for T-Test?
>> >T-Test: Paired two samples for means
>> >T-Test: Two-sample assuming equal variances
>> >T-Test: Two-sample assuming unequal variances
>> >
>> >Also, can I use ANOVA instead of T-test when
>> testing null hypothesis?
>> >Between 2 groups?
>> >
>> >Thanks for your help,
>> >Edmund
>> >
>> >
>> >Sent via Deja.com http://www.deja.com/
>> >Before you buy.
>> >
>> >
>>
>>==========================================================================
=
>> >This list is open to everyone. Occasionally, less
>> thoughtful
>> >people send inappropriate messages. Please DO NOT
>> COMPLAIN TO
>> >THE POSTMASTER about these messages because the
>> postmaster has no
>> >way of controlling them, and excessive complaints
>> will result in
>> >termination of the list.
>> >
>> >For information about this list, including
>> information about the
>> >problem of inappropriate messages and information
>> about how to
>> >unsubscribe, please see the web page at
>> >http://jse.stat.ncsu.edu/
>>
>>==========================================================================
=
>> >
>>
>>
>>
>>
>=======================================================================
>> The Advanced Placement Statistics List
>> To UNSUBSCRIBE send a message to [EMAIL PROTECTED]
>> containing:
>> unsubscribe apstat-l <email address used to
>> subscribe>
>> Discussion archives are at
>> http://forum.swarthmore.edu/epigone/apstat-l
>> Problems with the list or your subscription?
>> mailto:[EMAIL PROTECTED]
>>
>=======================================================================
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages with Yahoo! Messenger.
>http://im.yahoo.com/
>
===========================================================================
This list is open to everyone. Occasionally, less thoughtful
people send inappropriate messages. Please DO NOT COMPLAIN TO
THE POSTMASTER about these messages because the postmaster has no
way of controlling them, and excessive complaints will result in
termination of the list.
For information about this list, including information about the
problem of inappropriate messages and information about how to
unsubscribe, please see the web page at
http://jse.stat.ncsu.edu/
===========================================================================
