How Do I Perform a Two Sample t-Test in Excel Using SigmaXL?
Two Sample t-Test with Assumptions test
- Open Customer Data.xlsx, 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
- Click SigmaXL > Statistical Tools > 2 Sample t-test. If necessary, check Use Entire Data Table, click Next.
- 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:
- 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.

Each sample is tested for Normality using the Anderson Darling test. If not normal, the minimum sample size for robustness of the 2 sample t-Test is determined utilizing Monte Carlo regression equations (see Basic Statistical Templates – Minimum Sample Size for Robust t-Tests and ANOVA). If the sample size is inadequate, a warning is given and the Nonparametric Mann-Whitney Test is recommended.
See Appendix Hypothesis Test Assumptions Report for further details.
Click here to download a Free 30-Day Trial.
Web Demos
Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!
Contact Us
Ph: 1.888.SigmaXL (744.6295)
Support: Support@SigmaXL.com
Sales: Sales@SigmaXL.com
Information: Information@SigmaXL.com