How to Calculate Z-Scores in google sheets

Consider we have a dataset of 15 raw data values and are asked to find the z score of each value.

The data is given as 80,75,76,78,74,76,87,79,82,84,75,73,81,83,77

STEP 1: Find the mean of the dataset

To find the mean in google sheets, we use the FORMULA=AVERAGE(value1, [value2, …])


Thus, the value of the mean will be 78.666666667

STEP 2: Find the Standard Deviation of the Dataset

To find the Standard Deviation in google sheets, we use the FORMULA =STDEV.P(value1, [value2, …])

calculating Standard deviation in google sheets

Thus, the value of the standard deviation is 3.944053189

STEP 3: Calculating the Z-scores

In Calculating the z scores, we will use the formula for calculating the z score

Therefore, to calculate the z score of the first data value, we will subtract Cell B18 from B2 and divide the answer by Cell B19. The Z score will be 0.3380617019.


Notably, to calculate the Z-score of the remaining 14 data values, we drag and drop the auto-fill to our last value in Cell B16.

Note: We usually add the ($) dollar sign on the mean and standard deviation since these two values are constant.

calculating value of the other data values

Thus, the Z-score values will be;

The z score values in google sheets


Edutized is a learning platform that offers tutorials in over 100  subject fields. We also offer free calculators in Statistics, Calculus, Math etc.

If you are looking for more assistance, post a question for our tutors to help your out directly or create a tutorial for you.

We create tutorials for all queries with a huge interest and post them for free on our website. 

Happy Learning!

Related Content