Trying to do a Paired Two-Sample t-Test in Excel?

QI Macros can do it for you!

Create Paired Two-Sample t-Test using QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Statistical Tools > F & t Tests > Paired Two-Sample
  3. QI Macros will do the math and analysis for you.

Go Deeper: When to Use the Paired t-Test

In the constant quest to reduce variation and improve products, companies need to evaluate different alternatives. A t-Test using two paired samples compares two dependent sets of test data. It helps determine if the means (i.e., averages) are different from each other.


Weight Loss Paired t-Test Example

If a diet claims to cause more than a 10 lb weight loss over a six month period, you could design a test using several individuals before and after weights. The samples are "paired" by each individual. You might want to know if the diet truly delivers greater than a 10 lb weight loss.


To conduct a Paired t-Test Using QI Macros for Excel, follow these steps:

  1. Input your data into Excel, then click and drag over it to select it:
  2. paired t test data sample

  3. Next click on QI Macros >Statistical Tools > F & t Tests, then "t-Test: Paired two-sample for means":
  4. paired t test on QI Macros for Excel

  5. QI Macros will prompt for a significance level (default = 0.05):
  6. significance level

  7. And a hypothesized mean difference (in this case 10 lbs):
  8. Hypothesized difference in means

QI Macros paired t-Test macro will perform the calculations and interpret the results for you:

Paired t-Test results

In the July 2022 version of QI Macros, the Box & Whisker Plot output was removed and replaced with a Values Plot output, as Values Plots provide simpler visual representations of your data.:

t-test-paired-two-sample-values-plot


To change the order of your Two-Sample t-Test results between the first and last columns:

  1. Create your Two-Sample t-Test.
  2. Then, in row 1 you have the option to update the "Column Order" by inputting value "1" (Column 1/Column 2) or "2" (Column 2/Column 1):
  3. t test column order

    NOTE: Changing the order of your t-Test results will not change the order of the Box and Whisker output.

What's Cool about QI Macros Paired t-Test? 

Interprets the results for you: QI Macros will compare the p-value (0.429) to the significance level (0.05) and indicate that you "Cannot Reject the Null Hypothesis/Accept the Null Hypothesis, because p>0.05" and that the "Means are not Different/Means are the same."

Draws a chart to help you visualize the results: QI Macros paired t-Test results include a box plot which helps you see the difference in means (color change line in the box) and the variation (height of the box and length of the whiskers).

Interactive Results: QI Macros lets you change the significance level and Hypothesized Difference in Means to see what impact those changes have on your results. See red arrows in the image above.


Stop Struggling with Paired t-Tests!
Start creating your Paired t-Tests in just minutes.

Download a free 30-day trial. Get Paired t-Tests now!


Learn More...


Why Choose QI Macros Statistical Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support