T-test

2011-08-04
2012-12-09
  • I'm just curious, is t-test planed to be implemented in this great add-in?

     
  • Daniel Kraus
    Daniel Kraus
    2011-08-05

    Hi,

    Excel has built-in support for Student's t test: simply type =ttest(data1, data2, param1, param2) in a cell (where data1 and data2 designate the cell ranges with the data in it; for information on the parameters, please see the Excel help text).

    If you are using Excel 2010, you can also use the new function =t.test (note the period after the first t); however, for backwards compatibility, the old ttest function is available in Excel 2010 also.

     
  • Daniel Kraus
    Daniel Kraus
    2011-08-07

    By the way, you can also use the ANOVA to analyze just two groups - it will produce the very same p value as the t test.

     


Anonymous


Cancel   Add attachments