How to calculate p-value in Excel t-test

Excel's primary function is running calculations for you and analyzing data sets in many different ways. One of the most useful tools is calculating a p-value, or a probability value.

Probability is a key concept in statistical hypothesis testing and may help you in many projects. Finances, physics, economics, and other fields all benefit from calculating p-values, and Microsoft's software makes it easy to do just that. Forget complex calculations and let Excel handle the math.

In this article, you can learn how to calculate probability values or p-values in different versions of Excel.

How to find the p-value in Excel

There are currently 2 ways of finding the probability value in Excel: the T-Test function and the Data Analysis tool. Weve set up an example below for both approaches. We recommend you try the one more suitable for your project and skill level.

Disclaimer: For this article, well be using the most recent Microsoft Excel 2019. Some steps may be different in earlier or later versions of the software.

Lets get right into it.

Method 1. Find the p-value using T-Test

The guide below gives step-by-step instructions for using the T-Test function in order to calculate the p-value.

1. Open the Excel document you want to work with or create a new one. Make sure theres already data in the workbook before you proceed.
2. Select any cell outside of your data set. Input the following formula: =T.Test(
   
   
   
   
3. Type in the first argument. In our example, this would be the entire Before (kg) column. The formula should change accordingly, automatically inputting the cells.
   
   
   
   
4. Next, type a comma (,) and select the second argument. In the example we set up, this would be the After (kg) column, further completing the function.
   
   
   
   
5. Type another comma (,) after the second argument. Here, double-click on the One-tailed distribution from the options.
   
   
   
   
6. Type another comma (,) and double-click on Paired.
   
   
   
   
7. Now, all elements the function needs have been selected. Use the ) symbol to close the bracket, and then press Enter.
   
   
   
   
8. The selected cell will display the p-value immediately.

So, what does this mean? In this example, the p-value is low. This means that the research can safely conclude that the test didnt result in significant weight-loss. This doesnt mean the null hypothesis is correct, only that it hasnt been disproven.

Method 2. Find the p-value using Data Analysis

The Data Analysis tool allows you to play with your data in a number of different ways. This includes finding the p-value of your data set. Follow the instructions below to learn how.

To keep things simple, well be using the same data set as in the previous method.

1. Open the Excel document you want to work with or create a new one. Make sure theres already data in the workbook before you proceed.
2. Switch to the Data tab in the ribbon header interface, and then click on Data Analysis from the Analysis group.
   
   
   
   
3. If you dont have this option, navigate to File Options Add-ins and click on the Go button. Select Analysis ToolPak and click OK. The option should appear on your ribbon now.
   
   
   
   
4. In the pop-up window, scroll down and select t-Test: Paired Two Sample for Means, and then click OK.
   
   
   
   
5. Enter your arguments. Make sure to place a $ symbol before each digit, excluding the : symbol between two cells. Your setup should look similar to this example:
   
   
   
   
6. You should leave the Alpha text box on the default value. If you changed it, change it back to 0.05.
7. Select the Output Range option and type the cell you want to use in the field. For example, if you want to use the A9 cell to display the p-value, type in $A$9.
   
   
   
   
8. The final table will contain a number of calculations, and the p-value result. You can use this table to get interesting facts about your data.
   
   
   
   

Things you may want to know about the p-value

Calculating and finding p-values is a complex process. Probability is one of the hardest fields to tackle, even for experienced and educated individuals. Here are some things to note when working with p-values in Excel:

• The data in your table is important if the p-value is 0.05 (5 percent). However, the data you have is more relevant if it is less than 0.05 (5%).
• If the p-value is more than 0.1 (10%), the data in your table is insignificant.
• You may change the alpha value to a different number, however, most people tend to fluctuate between 0.05 (5%) and 0.10 (10%).
• Choose two-tailed testing instead of one-tailed testing if its better for your hypothesis.
• P-values cant identify data variables. If a correlation is identified, the p-value calculation isnt able to detect the cause(s) behind it.

Final thoughts

If you need any further help with Excel, dont hesitate to reach out to our customer service team, available 24/7 to assist you. Return to us for more informative articles all related to productivity and modern-day technology!

Would you like to receive promotions, deals, and discounts to get our products for the best price? Dont forget to subscribe to our newsletter by entering your email address below! Receive the latest technology news in your inbox and be the first to read our tips to become more productive.

You may also like

» What is Flash Fill in Excel? How do I use it?
» How to Freeze a Row in Excel for Mac
» How to Calculate Break-Even Analysis in Excel