See video at related links for instructions.
Chat with our AI personalities
Use =PERCENTILE(range,0.85) where range is the data that you want to analyse.
In Excel you can use the SMALL() function The small function can retrieve the smallest values from data based on rank. For example: =SMALL(range,1) // smallest =SMALL(range,2) // 2nd smallest =SMALL(range,3) // 3rd smallest
Percentile rank
It;s the rank which determines your rank and reputation on answer site
Yes it is. It is an ordinal variable ( which means it is meaningful ) because rank has an order and it is meaningful to rank the soldiers.