Statistics
Calculate a z-score
=(B2-AVERAGE($B$2:$B$6))/STDEV.S($B$2:$B$6)How it works in Excel
- B2-AVERAGE shows how far the value is from the mean.
- Dividing by STDEV.S counts that in standard deviations.
- Above 2 or below -2 is unusual in many data sets.
- STANDARDIZE does the same job.
The idea in general
It puts different measures on one scale, so you can see what is unusual.
What I assumed
- Your numbers are in B2:B6, and this goes beside the first one.
Check the result on your own data before relying on it.