MS Excel - Percentile graph

A percentile graph is a chart that shows the progression frequency of categories of data. For example, in a country, you would like to know what is the age of 10% of your population? 20%, 30%, 40% and so on?

In MS Excel, the score of a percentile is calculated using the following functions:

• PERCENTILE: This function is deprecated. It is still available for backward compatibility. Use the other 2 functions below.
• PERCENTILE.EXC: This function will return k-th percentile of values in a range, where k is in the range 0..1, exclusive.
• PERCENTILE.INC: This function will return k-th percentile of values in a range, where k is in the range 0..1, inclusive.

I chose to use PERCENTILE.INC(array, k) function. Here are the results for every 10%, from 0% to 100%.

From the percentile graph generated, we can say the followings:

• 0% of the population is less than 20 years old. Or, no one has less than 20 years old.
• 50% of the population is less than 35 years old.
• 100% of the population is less than 51 years old. Or, no one is older than 50 years old.