Class statistics: mean, median, spread & pass rate
This lesson is part of the course
In this lesson
You describe the results of the unit test with mean, median and standard deviation, then calculate the pass rate of the students who sat the test.
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
- A weighted gradebook with SUMPRODUCT Locked
- Dropping the lowest score Locked
- Letter grades with an approximate-match lookup Locked
- Class statistics: mean, median, spread & pass rate Locked
- Curving scores: bonus, scaling & z-scores Locked
- Attendance tracking & at-risk flags Locked
- Progress over terms: growth & rankings Locked
- Item analysis: difficulty & discrimination Locked