Z-Score Formula

Publication Date :

Blog Author :

Download FREE Z-Score Formula In Excel Template and Follow Along!
Z Score Formula Excel Template.xlsx

Table Of Contents

arrow

Z Score Formula Meaning

The Z score formula is an expression that helps calculate the score generated by measuring how many standard deviations are above or below the population mean. It helps in testing the hypothesis under consideration. In other words, the distance of a data point from the population is a multiple of the standard deviation.

Z-Score-Formula
You are free to use this image on your website, templates, etc.. Please provide us with an attribution link.

The equation for the Z-score of a data point is calculated by subtracting the population mean from the data point (referred to as x). Then the result is divided by the population standard deviation.

Key Takeaways

  • The Z-score of raw data is the score created by estimating how many standard deviations are above or below the population mean. In addition, it helps to test the hypothesis under consideration.
  • The Z-scores vary from -3 times the standard deviation to +3 times the standard deviation (far right of the normal distribution).
  • The equation for the Z-score of a data point is calculated by eliminating the population mean from the data point, which is referred to as x. Then, it is divided by the population standard deviation.
  • From the hypothesis testing point of view, the Z-score is vital to understand since it is applied to test whether or not a test statistic comes in the acceptable range.
  • One may also use it to standardize data before determining and calculating the probability score or comparing two or more data points from various normal distributions.

Z Score Formula Explained

The Z score formula results range from -3 times to +3 times. The Z-scores with -3 times the standard deviation indicate deviation to the far left of the normal distribution. On the other hand, the figure with +3 times the standard deviation denotes deviation to the far right of the normal distribution.

The Z-scores have a mean of 0 and a standard deviation of 1.

Z Score Formula
You are free to use this image on your website, templates, etc.. Please provide us with an attribution link.

where

  • x = Datapoint
  • ÎĽ = Mean
  • ơ = Standard deviation

The equation for the Z-score of a data point derives by using the following steps:

  • Step 1: Firstly, determine the mean of the data set based on the data points or observations, which are denoted by xi, while the total number of data points in the data set denotes by N.

Z Score Formula Step 1

  • Step 2: Next, determine the standard deviation of the population based on the population mean ÎĽ, data points xi, and the number of data points in the population N.

Step 2

  • Step 3: Finally, the Z-score derives by subtracting the mean from the data point, and then the result is divided by the standard deviation, as shown below.
    Step 3

Examples

Let us consider the following examples to understand how to use the formula to calculate the Z score.

Example #1

Let us take the example of a class of 50 students who wrote the science test last week. Today is the result day, and the class teacher told me that John scored 93 on the test while the average class score was 68. So first, 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, one can calculate the Z-score for John’s test score using the above formula,

Example 1.1

Z = (93 - 68) / 13

Z Score will be –

Z Score Formula Example 1.2

Z  Score = 1.92

Therefore, John’s Z-test 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 the 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,
  • The 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, one can calculate the standard deviation by using the formula as shown below,

Z Score Formula 4

ơ = 13.44

Therefore, one can calculate the Z-score of the 4th student using the above formula,

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 the Z- score table.

Z Score Formula in Excel

Let us take the case mentioned in example 2 to illustrate the concept of Z-score in the Excel template below.

Below is given data for the calculation of the Z-score.

Z Score Formula Example 0.3
Z Score Formula Example 3.2

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

How To Use?

Here is a list of ways in which the Z-score formula results can be used:

  • From the hypothesis testing perspective, the Z-score is very important to understand because it is employed to test whether or not a test statistic falls in the acceptable range.
  • The Z-score is also used to standardize data before analysis and calculate the probability of a score or comparison of two or more data points from different normal distributions.

Frequently Asked Questions (FAQs)

1

Can the Z-score be negative?

Arrow down filled
2

How to find the percentile from the Z-score?

Arrow down filled
3

What is a good Z-score?

Arrow down filled
4

Which Z-score is better?

Arrow down filled