I want to know the function I should use to calculate students' grade such that the highest 10% scores get "As", the second highest 20% gets "Bs", the third 40% highest get "Cs", the fouth 20% get "Ds" and lowest 1.0% get "Es".
Thanks
I want to know the function I should use to calculate students' grade such that the highest 10% scores get "As", the second highest 20% gets "Bs", the third 40% highest get "Cs", the fouth 20% get "Ds" and lowest 1.0% get "Es".
Thanks
I don't think it's as simple as that. You might be able to adapt that once you've ranked the students:
http://allenbrowne.com/ranking.html