I am trying to come up with a formula to calculate my percentile finish in fantasy sports games while also learning some statistics along the way. Rather than trying to work with the complete list of scores and places for each contest, I want to calculate percentile from the aggregate data they allow me to download from the site. I Googled and found several examples of determining percentile from a list of scores but not from one's finishing place in a contest.
Contest A Places Paid: 100 Entries: 200 My Finish: 153
I lost this contest as can be seen from the results. And intuitively I would guess I am in something like the 25th percentile, but I don't know how to write that out quantitatively or generalize it into an Excel formula that I can use on an ongoing basis. I would like to have this formula ready to see if my entries are improving, staying the same, or getting worse in terms of my percentile rank vs my opponents.