Click SigmaXL > Templates & Calculators > Basic Statistical Templates > 2 Sample Equivalence Test (Compare 2 Means) to access the 2 Sample Equivalence Test (Two One-Sided t-Tests TOST)
calculator. The template gives the following default example.
Notes
Enter summarized Sample Data, Upper & Lower Equivalence Limits and Confidence Level in cells with yellow highlight. Do not modify any other part of this worksheet.
Select "Assume Equal Variances" using drop-down.
Null hypothesis for P1: Difference >= UEL; Null hypothesis for P2: Difference <= LEL. Both null hypotheses must be rejected to conclude that equivalence is true.
LEL and UEL establish the zone or region of equivalence and are determined by what size difference is considered practically significant.
This calculator will automatically detect the version of Excel and use the appropriate statistical
functions.
Define, Measure, Analyze, Improve, Control
Simulate, Optimize, Realize
Web Demos
Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim Click here to view some now!