# 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, …]) 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. Thus, the Z-score values will be; 