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/ >=========================================================================== > =========================================================================== 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/ ===========================================================================
