As Donald has already pointed out, what I think you want is the p-value, not the
significance level. Given that, Excel has a F-distribution so you don't need to resort
to tables:
FDIST(f,degrees_freedom1,degrees_freedom2)
gives the probability that F > f.
degrees_freedom1 is the numerator degrees of freedom.
degrees_freedom2 is the denominator degrees of freedom.
The 2Num workbook in the freeware version of XLStatistics downloadable from
http://www.man.deakin.edu.au/rodneyc/XLStats.htm
automatically gives out the p-value, too. It just uses the built in Excel functions.
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Rodney Carr
School of Management Information Systems
Deakin University
PO Box 423
Warrnambool VIC 3280
Australia
email: [EMAIL PROTECTED] phone: + 61 3 5563 3458
mobile: 0417 307 692 fax: + 61 3 5563 3320
www: http://www.man.deakin.edu.au/rodneyc
-----Original Message-----
From: Ailc1 [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, January 30, 2000 12:50 AM
To: [EMAIL PROTECTED]
Subject: Shareware for Computing Significance Level?
I am using Excel to perform a linear regression analysis. Excel does not
compute significance level. At best, I have to use computations it makes of F,
etc. and then go to hard copies of F and Student's t distribution tables.
Anyone know of shareware that computes significance level given degrees of
freedom v1 and v2?
===========================================================================
This list is open to everyone. Occasionally, people lacking respect
for other members of the list send messages that are inappropriate
or unrelated to the list's discussion topics. Please just delete the
offensive email.
For information concerning the list, please see the following web page:
http://jse.stat.ncsu.edu/
===========================================================================
===========================================================================
This list is open to everyone. Occasionally, people lacking respect
for other members of the list send messages that are inappropriate
or unrelated to the list's discussion topics. Please just delete the
offensive email.
For information concerning the list, please see the following web page:
http://jse.stat.ncsu.edu/
===========================================================================
