Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

Degrees of Freedom in TTest

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David B - 11 Sep 2007 00:16 GMT
According to http://office.microsoft.com/en-us/excel/HP052038731033.aspx 
degrees of freedom in t-test for two unequal variances (regardless of using
TTEST or t-test from toolpak) uses a formula where
(S1^2+S2^2)^2(((S1^2/m)^2/m-1))+((S2^2/n)^2/(n-1))) = DF (call this formula
"Formula 1").

Normally, DF is simply equal to count of sample1 + count of sample2 - 2
("Formula 2"). Is there any reason why Excel uses Formula 1? I have searched
for Formula 1 in a number of statistics manuals and have been unable to find
an example of it.

Best,
David
Bernard Liengme - 11 Sep 2007 13:34 GMT
David,
Most books use the simple df= n1+n2-2
However, look at these for references to the more complex formula
http://www.biostat.wustl.edu/archives/html/s-news/2005-08/msg00008.html
http://projectile.is.cs.cmu.edu/research/public/talks/t-test.htm
http://www2.hawaii.edu/~donaldp/Biostatitics/lecture10.htm

You will need to find a professional statistician to ask why there are two
methods.
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> According to http://office.microsoft.com/en-us/excel/HP052038731033.aspx
> degrees of freedom in t-test for two unequal variances (regardless of
[quoted text clipped - 13 lines]
> Best,
> David
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.