# Z-Score in Excel: Easy Calculation Steps

Probability and Statistics > Z-Score in Excel

## Z-Score in Excel: Overview

A z-score tells you how many standard deviations a certain piece of data (“X”) is above or below the mean. A z-score in Excel can quickly be calculated using a basic formula. The formula for calculating a z-score is z=(x-μ)/σ, where μ is the population mean and σ is the population standard deviation (note: if you don’t know the population standard deviation or the sample size is below 6, you should use a t-score instead of a z-score). In other words, the formula is z = (data point – mean) / standard deviation.

## Z-Score in Excel: Steps

Watch the video or read the steps below:

Sample question: You take the GRE and scored 650 in the verbal section of the test. Calculate a z-score in Excel to determine how good your score is compared to the general population of test takers. The population mean (μ) is 469 and the population standard deviation (σ) is 119.

Step 1: Type the population mean into a blank cell in Excel. For this example, type “469” into cell A2. Optional: type the word “mean” as a column header in cell A1 so you remember what the value in cell A2 stands for.

Step 2: Type the population standard deviation into a blank cell. For this example, type “119” into cell B2. Optional: type the words “standard deviation” as a column header in cell B1 so you remember what the value in cell B2 stands for.

Step 3: Type the X-value (in this sample problem, X is your GRE score) into a blank cell. For this example, type “650” into cell C2. Optional: type the words “X” as a column header in cell B1 so you remember what the value in cell B2 stands for.

Step 4: Type the following formula into an empty cell:
=(C2-A2)/B2

Step 5: Press “Enter.” The z-score will appear in cell D2: The z-score of 1.521008 in this sample problem indicates your GRE score was 1.521008.

That’s it! You’ve found a z-score in Excel.

Tip: Once you’ve entered the formula once, you can use it over and over again. Just type a new mean, standard deviation and X value into the relevant boxes.

Z-Score in Excel: Easy Calculation Steps was last modified: February 6th, 2016 by

# 6 thoughts on “Z-Score in Excel: Easy Calculation Steps”

1. Rich Martinez

Stephanie, You are AWESOME! Thanks for the help with all your MS Excel instructions. This particular one has a video which makes instruction even easier. Cheers!

2. Aaron

While this is correct, the ‘=standardize’ function works just as well if you have the x, mean, and sd of a dataset.

3. Rockson

Thanks for your tutorials. They have been generally useful for me.

I however, cannot seem to find my way around the question below. Could you please help me with it?

A tire store finds that the tread life of its tires is normally
distributed, with a mean of 266 miles and a standard
deviation of 40 miles. The store sold 90 tires this month.
How many of them can be expected to last more than 350
miles?

4. Chandramouli

Dear Team Members,

Request you to mail us Z score card details which will help to take correct decision on the financial of the company.

Regards,
Chandramouli