An institute has some 200 students. They have to study in different courses and appear for the test which is of 100 marks. However, all of them do not appear in the same number of tests. Depending on their experience, the number of tests they appear may vary.
But at the end of the academic year, their performance has to be evaluated and a relative ranking has to be generated. What is the best way to do this?
A sample on how the data would look like is given below:
|Student|No. of Tests|Total Marks|