Basic Statistical Templates 2 Sample
Equivalence Test (Compare 2 Means)
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.
