Excel question: How do I calculate what percentile I am in using a Win/Loss record?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JohnGalt2341
    SBR Hall of Famer
    • 12-31-09
    • 9138

    #1
    Excel question: How do I calculate what percentile I am in using a Win/Loss record?
    Let's assume that all of my bets are -110(or have a 50% chance of winning in theory). And let's say I have a record of 116 Wins and 84 Losses. How do I calculate what percentile I am in compared to what would happen by chance(or compared to everyone else that also placed 200 bets)? I'm pretty sure this is a pretty simple formula on Excel but for some reason I forgot how to do it. Any help is appreciated. Thanks!
  • Waterstpub87
    SBR MVP
    • 09-09-09
    • 4102

    #2
    =Binom.dist(116,200,.5,True)=.99

    Check it by

    Stdev of coinflp with 200 trials is 7.07

    you are 2.26 stdev away from the mean

    This is equivalent to .9881 percentile.
    Last edited by Waterstpub87; 11-17-17, 04:04 PM.
    Comment
    • JohnGalt2341
      SBR Hall of Famer
      • 12-31-09
      • 9138

      #3
      Originally posted by Waterstpub87
      =Binom.dist(116,200,.5,True)=.99

      Check it by

      Stdev of coinflp with 200 trials is 7.07

      you are 2.26 stdev away from the mean

      This is equivalent to .9881 percentile.
      Thanks a bunch!
      Comment
      SBR Contests
      Collapse
      Top-Rated US Sportsbooks
      Collapse
      Working...