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!
Excel question: How do I calculate what percentile I am in using a Win/Loss record?
Collapse
X
-
JohnGalt2341SBR Hall of Famer
- 12-31-09
- 9125
#1Excel question: How do I calculate what percentile I am in using a Win/Loss record?Tags: None -
Waterstpub87SBR MVP
- 09-09-09
- 4108
#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.Comment -
JohnGalt2341SBR Hall of Famer
- 12-31-09
- 9125
#3Thanks a bunch!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.Comment
Search
Collapse
SBR Contests
Collapse
Top-Rated US Sportsbooks
Collapse
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code
