If your data are in four columns of the worksheet, and each column contains data for only one period of a sequence, complete the following steps.
Click in Response to see the columns that are available for your analysis.
C1 | C2 | C3 | C4 |
---|---|---|---|
Group 1 Generic Drug | Group 1 Brand Drug | Group 2 Brand Drug | Group 2 Generic Drug |
3.92 | 4.01 | 3.76 | 3.51 |
4.22 | 4.66 | 4.69 | 3.73 |
5.55 | 3.76 | 4.53 | 3.91 |
3.66 | 3.51 | 3.32 | 3.21 |
If your data for the two sequences are stacked, with one column for the period 1 responses, one column for the period 2 responses, and another column to identify the sequence, complete the following steps.
C1 | C2 | C3 |
---|---|---|
Period 1 | Period 2 | Sequence |
5.03 | 4.97 | 1 |
4.95 | 5.01 | 1 |
4.92 | 5.00 | 2 |
4.98 | 5.05 | 2 |
From the drop-down list, indicate how you want to express your equivalence criteria.
Define equivalence in terms of a difference between the mean of the test population and the mean of the reference population.
Define equivalence in terms of the ratio of the mean of the test population to the mean of the reference population.
Define equivalence in terms of the ratio of the mean of the test population to the mean of the reference population, as modeled with a log transformation of the original data. For this option, all observations must be greater than 0.
From the drop-down list, select the hypothesis that you want to prove or demonstrate.
To test the difference between the test mean and the reference mean, select one of the following options.
Test whether the difference between the population means is within the limits that you specify.
For example, an analyst wants to determine whether the mean gastric pH induced by a new antacid is within 10% of the mean gastric pH induced by a brand-name antacid.
Test whether the mean of the test population is greater than the mean of the reference population.
For example, an analyst wants to determine whether an improved formulation of a nutritional supplement results in higher blood levels of an essential mineral than the current formulation.
Test whether the mean of the test population is less than the mean of the reference population.
For example, an analyst wants to demonstrate that a new medication results in a mean diastolic blood pressure that is lower than that of the current medication.
Test whether the difference between the population means is greater than a lower limit.
For example, a researcher wants to determine whether the mean reduction in diastolic blood pressure induced by an experimental drug is more than 3 mm Hg greater than the mean reduction induced by the current medication.
Test whether the difference between the population means is less than an upper limit.
For example, researchers develop a new formulation of a popular medication. The new formulation is less expensive, but requires more time to achieve maximum effect. Researchers want to ensure that the mean difference in time to maximum effect does not exceed that of the current medication by more than 2 minutes.
To test the ratio of the test mean to the reference mean, select one of the following options.
Test whether the ratio of the population means is within the limits that you specify. Both limits must be greater than 0. A ratio of 1 indicates that the two means are equal.
For example, an analyst wants to determine whether the mean bioavailability of a test drug is between 0.8 and 1.2 times that of a reference drug.
Test whether the ratio of the population means is greater than a lower limit.
For example, a researcher wants to determine whether the mean reduction in diastolic blood pressure induced by an experimental drug is more than 1.5 times greater than the mean reduction induced by the current medication.
Test whether the ratio of the population means is less than an upper limit.
For example, an analyst wants to prove that the mean response time for a new therapy does not exceed the response time for an established therapy by 5% or more. The analyst tests whether the ratio of the mean response times is less than 1.05.
To test the ratio of the test mean to the reference mean using a log transformation of the original data, select one of the following options.
Test whether the ratio of the population means is within the limits that you specify. Both limits must be greater than 0. A ratio of 1 indicates that the two means are equal.
For example, an analyst needs to demonstrate that the mean bioavailability of a test formulation is within 80% (0.8) and 125% (1.25) that of the reference formulation, using log transformed data.
Test whether the ratio of the population means is greater than a lower limit.
For example, an analyst needs to demonstrate that the mean bioavailability of a test formulation is greater than 80% (0.8) that of the reference formulation, using log transformed data.
Test whether the ratio of the population means is less than an upper limit.
For example, an analyst needs to demonstrate that the mean bioavailability of a test formulation is less than 125% (1.25) that of the reference formulation, using log transformed data.
Enter a value for each equivalence limit that is included in the alternative hypothesis.
Enter the lowest acceptable value for the difference or ratio. You want to demonstrate that the difference (or ratio) between the mean of the test population and the mean of the reference population is not lower than this value.
Enter the highest acceptable value for the difference or ratio. You want to demonstrate that the difference (or ratio) between the mean of the test population and the mean of the reference population does not exceed this value.
Select this option to specify that the limit represents a proportion of the reference mean. Use to test whether the mean of the test population is within a certain percentage of the mean of the reference population. For example, select this option to change the limit from a fixed value of 0.1 to a value that equals 10% of the reference mean.
This option is displayed only when you express equivalence in terms of a difference between the test mean and the reference mean.