Financial Modeling Tutorials

- 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
- Present Value of an Annuity Formula
- Future Value of Annuity Due Formula
- Maturity Value
- 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
- Advantages and Disadvantages of NPV
- Mutually Exclusive Projects
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Break Even Analysis
- Breakeven Analysis Examples
- Break Even Chart
- Benefit Cost Ratio
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Payback Period Advantages and Disadvantages
- Profitability Index
- Feasibility Study Examples
- Cash Burn Rate
- Interest Formula
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Growth Rate Formula
- 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)
- Compounding
- Compounding Formula
- Compound Interest
- Compound Interest Examples
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Discounting Formula
- Rule of 72
- Geometric Mean Return
- Geometric Mean vs Arithmetic Mean
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- EWMA (Exponentially Weighted Moving Average)
- 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
- Relative Change
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- APR vs APY
- 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
- Correlation Examples
- Coefficient of Determination
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Standard Deviation Examples
- Effect Size
- Sample Size Formula
- Volatility Formula
- Binomial Distribution Formula
- Multicollinearity
- Hypergeometric Distribution
- Exponential Distribution
- Central Limit Theorem
- Poisson Distribution
- Central Tendency
- Hypothesis Testing
- Gini Coefficient
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- Z Score Formula
- Z Test vs T Test
- F-Test Formula
- Quantitative Research
- Histogram Examples

Related Courses

**Formula of Z Score (Table of Contents)**

## What is the Z-Score Formula?

The term “z-score” of a raw data refers to the score generated by measuring how many standard deviations above or below the population mean is the data, which helps in testing the hypothesis under consideration. In other words, a z-score is the distance of a data point from the population mean that is expressed as a multiple of the standard deviation.

- The z-scores vary in the range of -3 times the standard deviation (far left of the normal distribution) to +3 times the standard deviation (far right of the normal distribution).
- The z-scores have a mean of 0 and a standard deviation of 1.

The equation for z-score of a data point is calculated by subtracting the population mean from the data point (referred to as ** x**) and then the result is divided by the population standard deviation. Mathematically, it is represented as,

**Z Score Formula = (x –**

**μ) /**

**ơ**

where

- x = Datapoint
- μ = Mean
- ơ = Standard deviation

### Explanation of Z Score Formula

The Equation for z-score of a data point can be derived by using the following steps:

**Step 1:** Firstly, determine the mean of the data set based on the data points or observation which are denoted by x_{i}, while the total number of data points in the data set is denoted by N.

**Step 2: **Next, determine the standard deviation of the population on the basis of the population mean μ, data points x_{i} and the number of data points in the population N.

**Step 3: **Finally, the formula for z-score is derived by subtracting the mean from the data point and then the result is divided by the standard deviation as shown below.

### Examples of Z Score Formula

Let’s see some simple to advanced examples of Z Score equation to understand it better.

4.9 (1,067 ratings)

#### Example #1

**Let us take the example of a class of 50 students who have written the science test last week. Today is the result day and the class teacher told that John scored 93 in the test while the average score of the class was 68. Determine the z-score for John’s test mark if the standard deviation is 13.**

**Solution:**

Given,

- John’s test score, x = 93
- Mean, μ= 68
- Standard deviation, ơ = 13

Therefore, the z-score for John’s test score can be calculated using the above formula as,

Z = (93 – 68) / 13

**Z Score will be –**

**Z Score = 1.92**

Therefore, John’s Ztest score is 1.92 standard deviation above the average score of the class, which means 97.26% of the class (49 students) scored less than John.

#### Example#2

**Let us take another detailed example of 30 students (as z-test is not appropriate for less than 30 data points) who appeared for a class test. Determine the z-test score for the 4 ^{th} student of based on the marks scored by the students out of 100 – 55, 67, 84, 65, 59, 68, 77, 95, 88, 78, 53, 81, 73, 66, 65, 52, 54, 83, 86, 94, 85, 72, 62, 64, 74, 82, 58, 57, 51, 91.**

**Solution:**

Given,

- x = 65,
- 4
^{th}student scored = 65, - Number of data points, N = 30.

Mean = (55 + 67 + 84 + 65 + 59 + 68 + 77 + 95 + 88 + 78 + 53 + 81 + 73 + 66 + 65 + 52 + 54 + 83 + 86 + 94 + 85 + 72 + 62 + 64 + 74 + 82 + 58 + 57 + 51 + 91) / 30

**Mean = 71.30**

Now, the standard deviation can be calculated by using the formula as shown below,

**ơ = 13.44**

Therefore, Z-score of the 4^{th} student can be calculated using the above formula as,

Z = (x – x ) / s

- Z = (65 –30) / 13.44
- Z = -0.47

Therefore, the 4^{th} student’s score is 0.47 standard deviation below the average score of the class, which means that 31.92% of the class (10 students) scored less than the 4^{th} student as per z- score table.

### Z Score Formula (with Excel Template)

Now, let us take the case mentioned in example 2 to illustrate the concept of z-score in excel template below.

Below is given data for calculation of Z Score

You can refer the given excel sheet below for the detailed calculation of Z Score Test Statistics.

### Relevance and Uses

From the perspective of hypothesis testing, z-score is a very important concept to understand because it is employed to test whether or not a test statistic falls in the acceptable range of value. The z-score is also used to standardize data prior to analysis, calculate the probability of a score or comparison of two or more data points which are from different normal distributions. There are the diverse application of z-score across fields if applied properly.

### Recommended Articles

This has been a guide to Z Score Formula. Here we provide you the formula to calculate Z Score along with practical examples and downloadable excel template. You can learn more about financial analysis from the following articles –

- Formula of Discounting | Examples
- Altman Z Score Formula
- Standard Normal Distribution Calculation
- Normal Distribution Calculation
- Bell Curve Formula

- 250+ Courses
- 40+ Projects
- 1000+ Hours
- Full Lifetime Access
- Certificate of Completion