Ahead of discussing how to calculate p value in excel, lets define it. In statistics, the p-value is the probability of obtaining results at least as extreme as the observed results of a statistical hypothesis test, assuming that the null hypothesis is correct.
A P-value less than 0.05 indicates strong evidence against the null hypothesis while a P-value greater than 0.05 indicates weak evidence against the null hypothesis.
Formula to Calculate P Value in Excel.
- In excel, click on data and choose data analysis.
- Select t-test:Paired Two Sample for Means.
- Add in the arguments, click OK and get your answer.
Example:
Calculate the P value of the gym program
| Name | Before (Weight in Kg) | After (Weight in Kg) |
| Mike | 54 | 53 |
| Alex | 60 | 64 |
| Esther | 92 | 70 |
| Ann | 52 | 47 |
| Cristiano | 70 | 64 |
We begin by transferring the data to an excel spreadsheet.
Click on Data and choose data analysis,choose t-test:paired Two Sample for Means, input your arguments in the table that appears.
A new sheet like the one below will be formed with your results.
Therefore, on the results, we can see that the p-value with the one-tail test is 0.12 and the p-value with the two-tail test is 0.24.
