Problem doing t-tests in Excel

Discussion in 'Mac Apps and Mac App Store' started by PeteKD, May 4, 2010.

  1. PeteKD macrumors newbie

    May 4, 2010
    Hi all

    I am wanting to do a t-test in Excel (for a class I am teaching). So as a practice, I did this (in columns A and B):

    34 13
    35 23
    23 29
    13 200000
    14 200000
    56 12

    These are my two groups, with means:

    31.14285714 66679.5

    Certainly the means seem different!

    However, the ttest procedure gave me this p-value:

    The formula was this:

    What on earth is going on? Can anyone explain? Can anyone suggest the correct approach?

  2. bluskale macrumors regular

    Mar 29, 2010
    the variance is so high that you don't get a really strong p value for rejection?

Share This Page