## About this lesson

T Tests compare the mean of two data sample to each other.

## Exercise files

Download this lesson’s related exercise files.

T Tests.xlsx10.4 KB T Tests - Solution.docx

381.9 KB

## Quick reference

### T Tests

T Tests compare the mean of two data sample to each other.

### When to use

T Tests are used to show differences between data sets. When the means are 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. There are two types of T Tests that compare means between data samples:

- Two sample T Test compares 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 Test compares the means of two data sets, but these data sets have an identical number of data points and the points are linked or paired between the data sets. This pairing is based upon 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 and PMBOK are registered marks of the Project Management Institute, Inc.