Here’s an example to help clarify. Say you wanted to compare the test results of two Algebra students taught by different teachers. The general formula looks like this: =(DataPoint-AVERAGE(DataSet))/STDEV(DataSet) It is defined as the number of standard deviations away from the mean a data point lies.
What is a Z-Score and what do the AVERAGE, STDEV.S, and STDEV.P functions do?Ī Z-Score is a simple way of comparing values from two different data sets.
