Power & Sample Size: 2 Sample t-Test Calculator

Calculate Power and Sample Size for a 2 Sample t-Test in SigmaXL

To calculate power and sample size for a 2 Sample t-Test in SigmaXL, use the Power & Sample Size Calculator or the Power & Sample Size with Worksheet tool.

1. Click SigmaXL > Statistical Tools > Power & Sample Size Calculators > 2 Sample t-Test Calculator.


2. Select Solve For Power (1 – Beta). Enter Sample Size and Difference as shown:
   
   
   
   Note that we are calculating the power or likelihood of detection given that Mean1 – Mean2 = 1, with sample size for each group = 30, standard deviation = 1, significance level = .05, and Ha: Not Equal To (two-sided test).


3. Click OK. The resulting report is displayed:
   
   
   
   A power value of 0.97 is good, hence we have the basis for the “minimum sample size n=30” rule of thumb used for continuous data.


4. To determine Power & Sample Size using a Worksheet, click SigmaXL > Statistical Tools > Power & Sample Size with Worksheet > 2 Sample t-Test.


5. A graph showing the relationship between Power, Sample Size and Difference can then be created using SigmaXL > Statistical Tools > Power & Sample Size Chart. See 1 Sample t-Test power and sample size example.