Statistics
Find a percentile
=PERCENTILE.INC(B2:B6,0.9)How it works in Excel
- B2:B6 is your data.
- 0.9 means the 90th percentile.
- Use 0.5 for the median.
The idea in general
It finds the value that a chosen share of the data sits below.
What I assumed
- Your numbers are in B2:B6.
Check the result on your own data before relying on it.