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
- 9138
#1Excel question: How do I calculate what percentile I am in using a Win/Loss record?Tags: None -
Waterstpub87SBR 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
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