Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# Paired Samples T-Test In Excel

by | 7:00 pm EST | January 20, 2023 | Excel, Power BI

In this tutorial, you’ll learn how to execute and interpret the paired samples t-test using Excel. You can watch the full video of this tutorial at the bottom of this blog.

The paired sample t-test is going to check for a difference in the means of observations. So, we’re dealing with quantitative data between one time period and another. Also, we are dealing with a time series data.

This is going to be a hypothesis test with all of the fittings that go along with that. If you want to learn more about how to do a hypothesis test in Excel, you can check out my book Advancing Into Analytics.

We won’t go too much into the theory, but we will be using the Analysis Tool Pack in Excel, where we will be testing at the 95% significance level and using a peer-reviewed data set from Plos One.

Basically, what we want to find is whether there’s a difference in the means for Group 1 between Time 1 and Time 2. We are going to try to reproduce a research study.

## Executing & Interpreting Paired Samples T-test

Let’s go ahead and dive into Excel. We can run this per sample test and then we’ll regroup and go from there.

In this data, these are individual patients. They were measured in a period called Volume 1 and then given another measurement in Volume 2.

We need to know the measurements at both periods else we cannot use these patients or these observations. That’s one thing to know about the paired samples t-test.

Let us take the average of Volume 1 & Volume 2 data and then get the difference between the two. It looks like Volume 2 is a bit higher by 14.07.

The nice thing about using hypothesis testing is that we can really dig into this and decide whether what we are seeing is just a fluke or not.

The next thing to do is go to the Data section and then select Data Analysis Tools. If you’re not familiar with the tool pack, you can check out the book to learn how to install it or do a web search.

From the options, select t-Test: Paired Two Sample for Means then click the OK button.

For this window, we need to enter two ranges.

For Variable 1 Range, select the entire range of Volume 1 data by pressing CTRL + Shift + arrow down. Let’s also select the entire range of Volume 2 for the Variable 2 Range field.

We got the same number of observations in each group, which makes sense because we need those observations for each patient.

Since we have labels in the first row, let’s check the Labels checkbox then for Hypothesized Mean Difference, leave it blank. It’s going to assume that the mean difference is significantly different than zero. We can also check if it’s different than 5 or -10, but 0 is the most common.

For the Output Range, we can put this in the same worksheet then click OK.

Noticeably, this is a very menu-driven approach in finding the difference on this test. We can see the same numbers that we did earlier.

Next, I want you to focus your attention on the P(T<=t) two-tail value, which is 0.751. It means that it’s probably not a significant difference even though this number is a little bit higher statistically speaking. We cannot say that it’s likely different than 0.

Again, the objective is to take your analysis to the next level by applying hypothesis testing to it.

Finally, let’s check out the data for Group 1.

Based on the table, we can see from the Plos One Journal that the p-value is 0.751. This means that we were able to reproduce the research results of this report, which is awesome!

Kudos to the researchers as well for having their data published and made available to the public so that anybody can access this.

Most often, the paired samples t-test is used when there’s an intervention, whether that’s in medicine, marketing, or education. Hence, this is often a social science test to use and know whether there’s been some change given in intervention.

However, the difficult side of it is that we need to have the observations for both pre- and post-intervention, which is hard to do often in business settings.

## Conclusion

A paired samples t-test is a statistical procedure used to compare the means of two related groups or samples. It is commonly used in situations where you have two related samples that you want to compare.

This makes it an accessible and convenient tool for researchers and analysts who need to quickly and accurately compare the means of two related groups.

Overall, this is an essential tool for anyone working with data and seeking to draw meaningful conclusions from it.

All the best,

George Mount

## How to Center Across Selection in Excel

Centering data in Excel is a simple yet powerful function that can make your spreadsheets more readable...

## How to Ignore All Errors in Excel & Remove The Green Triangles

Errors in Excel are a pain and seeing those green triangles representing errors is downright annoying,...

## How to Apply the Calculation Style in Excel

A game-changing feature of Microsoft Excel is the ability to quickly and accurately apply the...

## How to Shift Cells Down in Excel: Step-by-Step User Guide

Looking to shift cells down in your Excel spreadsheet, but unsure how? You're in the right place. To...

## How to Collapse Columns in Excel: 4 Top Methods Explained

To collapse are column in Excel is simple, straightforward, and something you will need in your Excel...

## How to Convert Notepad to Excel: 4 Quick Methods Explained

Need to convert data from Notepad to Excel? Well, youâ€™re in luck! This process is a simple one that can...

## How to Merge Two Columns in Excel: A Step-By-Step Guide

New to Excel or just forgotten how to merge two columns? In Microsoft Excel, merging columns is a...

## Fix Filter in Excel: 5 Ways to Quickly Fix Common Issues

You're filter isn't working and you need to fix it ASAP? Well, you're in the right place to sort this...

## How to Use an IF Function With 3 Conditions in Excel

An Excel if function with three conditions engages the program to perform a logical test against...

## How to Calculate Range in Excel: 4 Quick Ways Explained

Ready to calculate range in Excel? Great, you're in the right place. We've got 4 quick and efficient...

## How to Get a Standard Deviation in Excel: User Guide

A standard deviation is used to understand and compare the variability within a dataset or to assess...

## How to Separate First and Last Names in Excel: 5 Quick Ways

Want to separate first and last names in Excel quickly and easily? Well, you're in the right place. To...