• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Financial Modeling

          • What is Financial Modeling
          • Financial Modeling Excel
          • Financial Model Types
        • Excel Modeling

          • Financial Functions Excel
          • Sensitivity Analysis in Excel
          • Time Value of Money
        • Excel-Modeling
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment-Banking-Guides
        • Excel

          • Excel Functions
          • Excel Charts
          • Excel Tips
        • Excel
        • Others

          • Resources (A to Z)
          • Accounting
          • Financial Statement Analysis
          • Equity Research
          • Private Equity
          • Corporate Finance
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Financial Modeling Course

          Financial-Modeling-Course
        • Investment Banking Course

          Investment-Banking-Training
        • Others

          • M&A Modeling Course
          • LBO Modeling Course
          • Valuation Modeling Course


          • PE Modeling Course
          • VC Modeling Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Z Score Formula

Home » Financial Modeling » Excel Modeling » Z Score Formula

By Harshada Khot Leave a Comment

Z-Score Formula

Formula of Z Score (Table of Contents)

  • Formula
  • Examples

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 xi, while the total number of data points in the data set is denoted by N.

Z Score Formula Step 1

Step 2: Next, determine the standard deviation of the population on the basis of the population mean μ, data points xi and the number of data points in the population N.

 Step 2

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.
Step 3

Examples of Z Score Formula

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

Popular Course in this category
Cyber Monday Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) 250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,067 ratings)
Course Price

View Course

Related Courses
M&A Modeling CourseLBO Modeling CourseValuation Modeling Course
You can download this Z Score Formula Excel Template here – Z Score Formula Excel Template

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

Z Score Formula Example 1

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

Example 1.1

Z = (93 – 68) / 13

Z Score will be –

Z Score Formula Example 1.2

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 4th 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,
  • 4th 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,

Z Score Formula 4

ơ = 13.44

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

Z = (x – x ) / s

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

Therefore, the 4th 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 4th 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

Z Score Formula Example 0.3

Z Score Formula Example 3.2

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
14 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel Modeling, Financial Modeling

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Download Colgate's Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Z Score Formula Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More