Paired t Test with SigmaXL

What is a Paired t Test with SigmaXL

The third type of a Two Sample t-Test is the Paired t Test with SigmaXL. This test is used when the two populations are dependent of each other, so each data point from one distribution corresponds to a data point in the other distribution. When using a paired t test, the test statistic is calculated using the average difference between the data pairs, the standard deviation of the differences, and the sample size of either population.

Test Statistic

Paired t Test SXL_01

Where:

  • d is the difference between each pair of data
  • is the average of d
  • n is the sample size of either population of interest

Critical Value

  • tcrit is the t value in a Student’s t distribution with the predetermined significance level α and degrees of freedom (n – 1).
  • tcrit values for a two-sided and a one-sided t-test with the same significance level α and degrees of freedom (n – 1) are different.

The critical t is looked up using the significance level alpha and degrees of freedom (n – 1).

Run a Paired t Test with SigmaXL

Case study: We are interested to know whether the average salaries ($1000/yr.) of male and female professors at the same university are the same.
Data File: “Paired T-Test” tab in “Sample Data.xlsx”

The data were randomly collected from 22 universities. For each university, the salaries of male and female professors were randomly selected.

  • Null Hypothesis (H0): μmale – μfemale = 0
  • Alternative Hypothesis (Ha): μmale – μfemale ≠ 0

Step 1: Test whether the difference is normally distributed.

  • Null Hypothesis (H0): The difference between two data sets is normally distributed.
  • Alternative Hypothesis (Ha): The difference between two data sets is not normally distributed.
  1. Select the entire range of “Difference”
  2. Click SigmaXL -> Graphical Tools -> Histograms & Descriptive Statistics
  3. A new window named “Histogram & Descriptive” pops up with the selected range pre-populated in the box under “Please select your data”
  4. Click “Next>>”
  5. A new window named “Histograms & Descriptive Statistics” appears.
  6. Select “Difference” as the “Numeric Data Variables (Y)”
  7. Click “OK>>”
  8. The results of the Normality Test show in the tab “Hist Descript (1)”

The p-value of the normality test is 0.287, greater than the alpha level (0.05), so we fail to reject the null hypothesis and we claim that the difference is normally distributed. When the difference is not normally distributed, we need other hypothesis testing methods.

Step 2: Run the paired t-test to compare the means of two dependent data sets.

  1. Select the entire range of both MALES and FEMALES data
  2. Click SigmaXL -> Statistical Tools -> Paired t-Test
  3. A new window named “Paired t-Test” pops up with the selected range pre-populated in the box under “Please select your data”
  4. Click “Next >>”
  5. Another new window named “Paired t-Test” pops up
  6. Select “MALES” as “Numeric Data Variable 1”
    Select “FEMALES” as “Numeric Data Variable 2”
  7. Click “OK>>”
  8. The paired t-test results appear in the tab “Paired t-Test (1)”
    Paired t Test Using SigmaXL

Model summary: The p-value of the paired t-test is 0.213, greater than the alpha level (0.05), so we fail to reject the null hypothesis and we claim that there is no statistically significant difference between the salaries of male and those of female professors. Because the p-value is higher than 0.05, we again fail to reject the null hypothesis, meaning that there is no statistically significant difference between the salaries of male and female professors.

Join Our Community

Instant access to hundreds of "How to" articles, Tools, Templates, Roadmaps, Data-Files.. Everything Lean Six Sigma! Come on in! Welcome to our community of Lean Six Sigma certified professionals.

Join

Password*
My Interest in This Content is More Closely Related to*
This field is for validation purposes and should be left unchanged.
author avatar
Lean Sigma Corporation
Lean Sigma Corporation is a trusted leader in Lean Six Sigma training and certification, boasting a rich history of providing high-quality educational resources. With a mission to honor and maintain the traditional Lean Six Sigma curriculum and certification standards, Lean Sigma Corporation has empowered thousands of professionals and organizations worldwide with over 5,300 certifications, solidifying its position and reputation as a go-to source for excellence through Lean Six Sigma methodologies.

About Lean Sigma Corporation

Lean Sigma Corporation is a trusted leader in Lean Six Sigma training and certification, boasting a rich history of providing high-quality educational resources. With a mission to honor and maintain the traditional Lean Six Sigma curriculum and certification standards, Lean Sigma Corporation has empowered thousands of professionals and organizations worldwide with over 5,300 certifications, solidifying its position and reputation as a go-to source for excellence through Lean Six Sigma methodologies.