Strict and Generous Judges: Judge Averages, Centred Scores and z-Scores
This lesson is part of the course
In this lesson
You measure how strict each judge is with AVERAGEIFS and STDEV.S, centre every score on its judge's average and turn it into a z-score, so routines scored by different judges can be compared fairly.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Panel Score Sheets: Totals, Averages and Missing Marks Locked
- Dropping the Highest and Lowest Mark: Trimmed Totals, Trimmed Means and New Ranks Locked
- Weighted Criteria: Weights That Add Up to 100 % and a SUMPRODUCT Score Locked
- Strict and Generous Judges: Judge Averages, Centred Scores and z-Scores Locked
- Penalties and Deductions: Time Overruns, Rule Points and Net Scores Locked
- Ranks and Tie-Breaks: RANK.EQ, a Secondary Criterion and a Tie Check Locked
- Categories and Leaderboards: Winners per Category and a Top-3 List Locked
- Judge Consistency Check and the Final Results Chart Locked