@JamesChevalier Is there an easy way to show the number of completed streets to be in a percentile? For example: “CityStriders in the Nth percentile completed at least X streets.”
I’m sure I’m misunderstanding the request, since I’m thinking that the existing Percentile that’s displayed on each person’s profile page already does this. For example, I’m in the 70th percentile based on my 601 completed streets.
I also can’t quite tell if you’re looking for your percentile, or if you’re looking to get a list of people at that percentile.
Or if you’re looking for the “edges” of each percentile to get a sense of how many streets need to be completed in order to go from e.g. 70th to 80th percentile.
To calculate a percentile of a distribution, you need to know all values so in this case how many streets every user of CityStrides has run. Unless you want to flip through 6000+ pages and record all entries on each, that seems cumbersome 
Like James mentioned, it’s easiest to perform a binary search for the percentile you want:
- Pick a starting range that contains the % (e.g. page 1-1000 for the 90%)
- Look at the middle page (500) and see if it has your %
- If the % is too high, continue with the bottom half (1-499)
- If the % is too low, continue with the top half (501-1000)
- Repeat step 2 until you’ve found the first page with your %
Maybe I’m missing something here, but surely if you’re just looking for street counts at the boundary of a percentile, you can just navigate straight to the end of that percentile.
We know how many total users are registered on CS (= number of pages in total on the leader board x 12. If you want to be “perfect” you can adjust for how many members are on the final page.)
If you want to find the minimum number of streets someone in the 99th percentile has walked, just calculate 1% of that total number of members, and then navigate to the page that person is on (by dividing that number by 12). You’ll find the person at the very bottom of the 99th percentile and you can read how many streets they’ve covered. Until, of course, it changes the next time they (or someone around them) completes another activity.
It would be a bit tedious (but not hard) to look up the street counts for members at the edge of every percentile (or dectile), but if you’re just looking to see how far off you are hitting the percentile above you, it won’t take that long.
Aaah you’re absolutely right! I was overcomplicating things as per usual…
That’s what I’m interested in. I know my percentile, but I’d like to know how many more streets I need to reach the next percentile.