+ Reply to Thread
Results 1 to 3 of 3

Resolved >>> Excel does not compute t-test with unequal sample sizes?

  1. #1
    Registered User
    Join Date
    10-18-2007
    Posts
    11

    Resolved >>> Excel does not compute t-test with unequal sample sizes?

    am I right?
    using the ttest formula function

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444
    Yes it does, but you have to specify the t test as either homoscedastic or hetroscedastic. This is done in the final arguement in the function:

    =TTEST(range1,range2,tails,type)

    type=1 Paired
    type=2 homoscedastic
    type=3 hetroscedastic
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    10-18-2007
    Posts
    11
    omg
    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1