• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

P-Value in Excel

April 9, 2021 by Andrew Childress
How to find Excel P value

Probability value (P-Value) is a common statistical measurement. Let’s learn how to find P-Value in Microsoft Excel with these easy steps.

Probability value (P-Value) is a common statistical measurement. It helps you test the validity of your null hypothesis. Let’s learn how to find P-Value in Microsoft Excel.

How to Find the P-Value in Excel

Imagine you have a dataset, and you want to test the hypothesis that the two columns are correlated. We’ll use a real-world example. This table lists hours spent studying for an exam, along with exam results. The hypothesis is a correlation between the two: that more study time is linked to higher scores.

Excel P value intro

To find the P-Value, get started by going to the Data tab on Excel’s ribbon. On the far right side, find the Data Analysis button. You’ll see the Data Analysis menu with a list of Analysis Tools. Scroll down until you find the t-Test: Paired Two Sample for Means option. Click on it, then choose OK.

How to find Excel P value

The t-Test menu appears, and asks for several inputs. Variable 1 is your data from column B. Click into the Variable 1 box, then click and drag to select your range of data in cells B2:B6. Repeat this with Variable 2, this time, selecting column C data in C2:C6.

Check the box for Labels. Alpha defaults to 0.05, which is commonly used in statistics. If your P-Value is less than 0.05, your hypothesis is found to be statistically significant.

How to find P value in Excel

Click OK. Excel will run the t-Test analysis and place it on a new sheet in your workbook. Your P-Value appears in row 11 for a one-tail test, and row 13 for a two-tail test.

P values in Microsoft Excel

As you can see, both values are tiny, certainly well below 0.05. This demonstrates that, yes, your hypothesis regarding the correlation is statistically significant.

This is a great example of how Excel automates advanced statistics and makes analysis a breeze. You can quickly analyze even the largest data sets, enabling fast and accurate decision-making.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Excel confidence intervalsConfidence Intervals in Excel
Next Post:Scientific Notation in ExcelScientific notation in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top