Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**P Value Formula (Table of Contents)**

## What is the P-Value Formula?

P is a statistical measure that helps researchers to determine whether their hypothesis is correct. It helps determine the significance of results. The null hypothesis is a default position that there is no relationship between two measured phenomena. It is denoted by H_{0. An alternative} hypothesis is the one you would believe if the null hypothesis is concluded to be untrue. Its symbol is H_{1} or H_{a. }

P value is a number between 0 and 1. There are tables, spreadsheet programs and statistical software to help calculate the p-value. Level of significance (α) is a pre-defined threshold set by the researcher. It is generally 0.05. A very small p-value, which is lesser than the level of significance indicates that you reject the null hypothesis. P value which is greater than the level of significance indicates that we fail to reject the null hypothesis.

### Explanation of the P-Value Formula

The formula for the calculation of the p-value can be derived by using the following steps:

#### Calculating P-Value from a Z Statistic

**Step 1:** We need to find out the test statistic z

Where

- is Sample Proportion
- p0 is Assumed Population Proportion in the Null Hypothesis
- n is the Sample Size

**Step 2: **We need to find the corresponding level of p from the z value obtained. For this purpose, we need to look at the z table.

**Source: **www.dummies.com

For instance, let us find the value of p corresponding to z ≥ 2.81. Since normal distribution is symmetric, negative values of z are equal to its positive values. 2.81 is a sum of 2.80 and 0.01. Look at 2.8 in z column and the corresponding value of 0.01. We get p = 0.0025.

### Examples of P-Value Formula (with Excel Template)

Let’s see some simple to advanced examples of P-Value equation to understand it better.

#### Example #1

**a) P-value is 0.3015. If the level of significance is 5%, find if we can reject the null hypothesis.**

**b) P-value is 0.0129. If the level of significance is 5%, find if we can reject the null hypothesis.**

**Solution:**

Use the following data for the calculation of P-Value.

P-Value will be –

a) Since the p-value of 0.3015 is greater than the level of significance of 0.05 (5%), we fail to reject the null hypothesis.

4.9 (927 ratings)

b) Since p-value of 0.0129 is less than the level of significance of 0.05, we reject the null hypothesis.

#### Example #2

**27% of people in India speak Hindi as per a research study. A researcher is curious if the figure is higher in his village. Hence, he frames the null and alternate hypothesis. He tests H _{0: }p = 0.27. H_{a: }p > 0.27. Here, p is the proportion of people in the village who speak Hindi. He commissions a survey in his village to find out the number of people who can speak Hindi. He finds that 80 out of 240 people sampled can speak Hindi. Find out the approximate p-value for the researcher’s test if we were to assume that the necessary conditions are met and the significance level is 5%.**

**Solution:**

Use the following data for the calculation of P-Value.

Here, the sample size n = 240,

p_{0 }is population proportion We will have to find the sample proportion

= 80 / 240

= 0.33

**Z Statistic**

Calculation of Z Statistic

=0.33 – 0.27 / √ 0.27 * (1 – 0.27 ) / 240

Z Statistic will be –

**Z** = **2.093696**

P Value will be –

P Value = P (z ≥ 2.09)

We have to look at the value of 2.09 is the z table. So, we have to look at -2.0 in z column and the value in 0.09 column. Since normal distribution is symmetrical, the area to the right of the curve is equal to that on the left. We get the p-value as 0.0183.

**P Value** = **0.0183**

Since the p-value is less than significant level of 0.05 (5%), we reject the null hypothesis.

**Note:** In Excel, the p-value is coming as 0.0181

#### Example #3

**Studies show that a higher number of flight tickets are bought by males as compared to females. They are bought by males and females in the ratio of 2:1. The research was carried out at a particular airport in India to find the distribution of air tickets among males and females. Out of 150 tickets, 88 tickets were bought by males and 62 by females. We need to find out if the experimental manipulation causes the change in the results, or we are observing a chance variation. Calculate the p-value assuming the degree of significance is 0.05.**

**Solution:**

Use the following data for the calculation of P-Value.

**Step 1:** The observed value is 88 for males and 62 for females.

- Expected Value for males = 2/3* 150 = 100 males
- Expected Value for females = 1/3* 150 = 50 females

**Step 2:** Find out chi-square

=((88-100)^{2})/100 + (62-50)^{ 2}/50

=1.44+2.88

**Chi-Square (X^2)**

Chi-Square(X^2) will be –

**Chi-Square(X^2)** = **4.32**

**Step 3:** Find the degrees of freedom

Since there are 2 variables – males and females, n=2

Degrees of freedom = n-1 = 2-1 = 1

**Step 4:** From the p-value table, we look at the first row in the table as the degree of freedom is 1.We can see that p-value is between 0.025 and 0.05. Since the p-value is less than the degree of significance of 0.05, we reject the null hypothesis.

P Value will be –

**P Value** = **0.037666922**

**Note:** Excel directly gives the p-value using the formula:

CHITEST (actual range, expected range)

#### Example #4

**It is known that 60% of the people who enter apparel stores in a city purchase something. An apparel shop owner wanted to find if the number is higher for the apparel shop owned by him. He already had the results of a study conducted for his shop. 128 out of 200 people who entered his shop purchased something. The shop owner denoted pas the proportion of people who entered his apparel shop and purchased something. The null hypothesis framed by him was p = 0.60 and the alternate hypothesis was p > 0.60. Find the p-value for the research at a significance level of 5%.**

**Solution:**

Use the following data for the calculation of P-Value.

Here, the sample size n = 200. We will have to find the sample proportion

= 128 / 200

= 0.64

**Z Statistic**

Calculation of Z Statistic

= 0.64 – 0.60 / √ 0.60 * (1 – 0.60) /200

Z Statistic will be –

**Z Statistic** =**1.1547**

P Value = P (z ≥ 1.1547)

NORMSDIST will be –

**NORMSDIST** = **0.875893461**

There is an inbuilt function to calculate a p-value from a z statistic in Excel. It is known as the NORMSDIST function. The Excel NORMSDIST function calculates the Standard Normal Cumulative Distribution Function from a supplied value. Its format is NORMSDIST(z). Since z statistic value is in cell B2, the function used is = NORMSDIST(B2).

P Value will be –

**P Value** = **0.12410654**

Since we have to find the area to the right of the curve,

p-value = 1 – 0.875893 = 0.124107

Since p-value of 0.124107 is more than significant level of 0.05, we fail to reject the null hypothesis.

### Relevance and Use

P Value has wide applications in statistical hypothesis testing, specifically in null hypothesis testing. For instance, a Fund Manager runs a mutual fund. He claims that the returns from a particular scheme of the mutual fund are equivalent to Nifty, which is the benchmark stock market index. He would frame the null hypothesis that the returns of the mutual fund scheme are equivalent to that of Nifty. The alternative hypothesis would be that the Scheme’s returns and Nifty returns are not equivalent. He would then calculate the p-value.

### Recommended Articles

This has been a guide to P-Value Formula. Here we discuss how to calculate the p-value, z statistic with practical examples and downloadable excel template. You can learn more about excel modeling from the following articles –

- Formula of Sample Size
- Normal Distribution Formula | Explanation
- Value Formula in Excel
- Standard Normal Distribution Formula | Examples
- Formula of Harmonic Mean
- Descriptive Statistics Excel
- Formula of Median in Statistics
- Formula of Binomial Distribution

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced