1. #1
    JohnGalt2341
    46 and 2 are just ahead of me
    JohnGalt2341's Avatar SBR PRO
    Join Date: 12-31-09
    Posts: 8,764
    Betpoints: 3643

    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!

  2. #2
    Waterstpub87
    Slan go foill
    Waterstpub87's Avatar Become A Pro!
    Join Date: 09-09-09
    Posts: 4,043
    Betpoints: 7236

    =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 at 03:04 PM.
    Points Awarded:

    JohnGalt2341 gave Waterstpub87 10 Betpoint(s) for this post.


  3. #3
    JohnGalt2341
    46 and 2 are just ahead of me
    JohnGalt2341's Avatar SBR PRO
    Join Date: 12-31-09
    Posts: 8,764
    Betpoints: 3643

    Quote Originally Posted by Waterstpub87 View Post
    =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!

Top