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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |