How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate P value in Excel.
statistics

How to Calculate P value in Excel.

Rosemary Njeri

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.

P-value helps you determine the significance of your results in relation to 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

NameBefore (Weight in Kg) After (Weight in Kg)
Mike5453
Alex6064
Esther9270
Ann5247
Cristiano7064

We begin by transferring the data to an excel spreadsheet.

 P value in Excel.

Click on Data and choose data analysis,choose t-test:paired Two Sample for Means, input your arguments in the table that appears.

P value in Excel.

A new sheet like the one below will be formed with your results.

P value in Excel.

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.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Cumulative Frequency.
In this article we will learn how to calculate cumulative …

How to Calculate Cumulative Frequency.

How to Calculate P Value from T.
P-value is the probability that a random chance generated the …

How to Calculate P Value from T.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2023 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh