How to calculate P-value in excel (Step-by-Step)

August 9, 2022
17.2K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

While working on regression or correlation analysis, it is required to calculate P-value to test the significance of results. Calculations for P-value can be very lengthy and time consuming with high possibility of error. But you don’t need to worry as you can use excel for easily and learn How to calculate P-Value excel WPS OFFICE(2016/2019/mac/online).

Once you go through this article you will be able to easily calculate P-value in excel. Let’s cover the simple methodologies of How to calculate P-value excel WPS OFFICE(2016/2019/mac/online). Excel has a built-in formula

I.e. “Tdist” which we will be using to calculate P-value by entering the T-value.


Three different ways of How to calculate p-value in excel.

Using Insert function button in excel to calculate P- value

You can calculate P- value in excel by using insert function button by following simple below mentioned steps and picture illustrations.

Steps:

1.Open WPS Excel /Spreadsheet file where you want to calculate P- value in excel.

2.Click on the cell where you want to calculate P- value.

3.Go to Formulas Tab.There will be an Insert formula button in it.

4.Click on this button.A new dialogue window shall appear.In the search for a formula bar write “Tdist”.Tdist shall appear in the below list.

5.Click on tdist and press OK.A new function argument window shall appear. 

  • To calculate P- value, three different parameters are required. 

  • i.e.Value X (The value at which P is to be calculated, in our case it will be T value) 

  • Degrees of freedom (value always greater than 1)

  • Tails (One tailed or two tailed distribution)

You can either enter the values of these three parameters or you can use excel value links as used in picture illustrations in this article.

6.After entering all five parameters, press enter.P- value is calculated.

Using Statistical formula section in excel to calculate P- value in excel

You can calculate P- value by using statistical formula section by following simple below mentioned steps and picture illustrations.

Steps:

1.Open WPS Excel /Spreadsheet file where you want to calculate P- value in excel.

2.Click on the cell where you want to calculate P- value.

3.Go to Formulas Tab.There will be a more functions button in it.

4.Click on this button.A drop down list shall appear.

5.From the drop down menu click on statistical section.Another drop down list shall appear.

6.In the list, find tdist and click on it. A new function argument window shall appear. 

  • To calculate P- value, three different parameters are required. 

  • i.e.Value X (The value at which P is to be calculated, in our case it will be T value) 

  • Degrees of freedom (value always greater than 1)

  • Tails (One tailed or two tailed distribution)

You can either enter the values of these three parameters or you can use excel value links as used in picture illustrations in this article.

After entering all five parameters, press enter.P- value is calculated.

1.3 Manually entering P- value Formula in excel to calculate P- value

You can calculate P- value by manually entering P- value formula by following simple below mentioned steps and picture illustrations.

Steps:

1.Open WPS Excel /Spreadsheet file where you want to calculate P- value in excel.

2.Click on the cell where you want to calculate P- value.

3.Write “=tdist”, the press Tab.

4.P- value formula is initiated.

  • To calculate P- value, three different parameters are required.

  • i.e.Value X (The value at which P is to be calculated, in our case it will be T value) 

  • Degrees of freedom (value always greater than 1)

  • Tails (One tailed or two tailed distribution)

You can either enter the values of these three parameters or you can use excel value links as used in picture illustrations in this article.

After entering all five parameters, press enter.

P- value is calculated.

In this way you can easily calculate P- value in excel in the WPS excel/spreadsheet.

This article has covered the simplest ways on calculating P- value in WPS Excel/Spreadsheet. You can use these simple steps as explained above and easily calculate P- value in excel WPS Excel/Spreadsheet whenever required.

Hopefully you have learned How to calculate P- value excel? in WPS Excel/Spreadsheet. If you want to know more about Excel features, you can follow WPS Academy to learn.
You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.