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;