How Do I Perform a Two Sample t-Test in Excel Using SigmaXL?

Two Sample t-Test

1. Open Customer Data.xls, click Sheet 1 tab (or press F4 to activate last worksheet). We will look at comparing means of Customer Satisfaction by Customer Type ( 2 vs. 3), using the Two Sample t-test. H0: μ2=μ3, Ha: μ2≠μ3
2. Click SigmaXL > Statistical Tools > 2 Sample t-test. If necessary, check Use Entire Data Table, click Next.
3. With stacked column format checked, select Overall Satisfaction, click Numeric Data Variable Y >>; select Customer Type, click Group Category X >>; H0: Mean Diff = 0; Ha: Not Equal To; Confidence Level: 95%; ensure that Assume Equal Variances is checked:



4. Click OK. Select Customer Type 2 and 3.




5. Click OK. Resulting output:



Given the p-value of .0007 we reject H0 and conclude that Mean Customer Satisfaction is significantly different between Customer type 2 and 3. This confirms previous findings.

Click here to download a Free 30-Day Trial.