Locked lesson.
About this lesson
T-Tests compare the mean of two data samples to each other.
Exercise files
Download this lesson’s related exercise files.
T Tests Exercise.xlsx10.6 KB T Tests Exercise Solution.docx
238.4 KB
Quick reference
T-Tests
T Tests compare the mean of two data samples to each other.
When to use
T Tests are used to show differences between data sets. When the means are statistically different it can indicate cause-and-effect relationships. Also, the tests are often used in a before/after analysis to demonstrate the effectiveness of an improvement.
Instructions
T Tests are among the easiest hypothesis tests to perform. The test determines the mean of the sample and compares it to the mean of another sample. The hypothesis statements for T Tests are:
H0: x̄1 = x̄2
Ha: x̄1≠ x̄2
There are two types of T Tests that compare means between data samples:
- Two-sample T Tests compare the means between two data samples. Before that test is done, a test for equal variances should be done using the F Test and the correct variant of the Two-sample T Test used.
- Excel:
- Data Analysis > T Test: Two Sample Assuming Equal Variance (or unequal based upon the result of the F Test)
- Enter the data range for each sample
- Minitab:
- Stat > Basic Stats > 2-sample T
- Indicate the format of the data
- Select the data column(s)
- Select the Option button to indicate equal variances (default is unequal variances) and to change the relationship to greater than or less than
- Excel:
- Paired T Tests compare the means of two data sets. In this case, these data sets have identical numbers of data points and the points are linked or paired between the data sets. This pairing is based on the order of the data items in each set.
- Excel:
- Data Analysis > T Test: Paired Two Samples for Means
- Enter the data range for each sample.
- Minitab:
- Stat > Basic Stats > Paired T
- Select the data columns
- Select the Option button to change the relationship to greater than or less than
- Excel:
There are several reasons for pairing the data. One reason is to do before/after testing with process resources to show levels of improvement. Another reason is to conduct a controlled test where paired items are exposed to the same conditions. The items are identical except for the feature being investigated. The third reason is when two different items are linked or paired together and then both are simultaneously exposed to identical conditions to determine the different types of reactions.
Hints & tips
- When using a greater than or less than Alternative Hypothesis, be sure to enter the data ranges in the correct order for the P Value to be correctly stated.
- Use the F Test to determine if there are equal variances in order to do the correct T Test.
Lesson notes are only available for subscribers.
PMI, PMP, CAPM and PMBOK are registered marks of the Project Management Institute, Inc.