For this, we need another tail we have to get the expected runs to be scored by each batsman.As per the image below, you can see that we have collected data of cricketers and the runs they have made in a particular series.The formula to calculate the P-Value is TDIST(x, deg_freedom, tails).Finding P-Value for correlation in excel is a relatively straightforward process, but there is no single function for the task we will see the example for the same.A smaller Pvalue leads to the rejection of the null hypothesis. A P-Value is a number between 0 and 1, but it’s simpler to think of it in terms of percentages, such as 5% for a P-Value of 0.05.P-Value is therefore an investigator rather than a judge. In short, it enables us to determine if the obtained results are the result of chance or show that the two things we are testing are unrelated. If the P-Value indicates that the null hypothesis is unlikely, then this makes us believe that the alternative hypothesis might be true. P-Value is used to test whether the Null Hypothesis is valid.P-Value, also known as probability value, is used to understand the statistical significance of a finding.TEXT and String Functions in Excel (26+).Lookup Reference Functions in Excel (34+).

Histogram in graphpad prism 5