From the course: Complete Guide to Excel Statistics with Copilot

Unlock this course with a free trial

Join today to access over 24,500 courses taught by industry experts.

Percentiles

Percentiles

From the course: Complete Guide to Excel Statistics with Copilot

Start my 1-month free trial Buy for my team

Percentiles

“

- [Instructor] Suppose your annual salary is in the 95th percentile. Is that good or bad? How about if your exam score was in the 10th percentile? Good or bad? A percentile tells us the percentage of people below you. So 95th percentile salary, good. 95% of all salaries are below yours. You are among the top 5% in salaries. 10th percentile exam score, not good. Only 10% of test scores are below your score. Or if you want to try and put a positive spin on this, your score is among the top 90% of the scores in the class. Let's continue this discussion with exam scores. Look at these 10 scores from a 20 question test. Student C got two questions wrong. So they got 18 questions right out of 20 questions. That's a score of 90% on the exam. But be careful, they are not in the 90th percentile of this class. That would mean that 90% of scores, nine out of 10 students would have lower scores than Student C. As we can see, they have the third highest score in the class. So seven out of 10…

Contents