Uh, really have no idea how to do that in excel. Anyone care to help since formulas were never my strong suit?
Comment has been collapsed.
I really have no idea how to do that in Excel.
But if anyone is willing to help here are my stats:
Giveaways Entered 4,103
Gifts Won 16
Estimated Wins 18.18
Comment has been collapsed.
seriously, anybody else read it as "how big is your D?
Comment has been collapsed.
seriously, anybody else read it as "how big is your D?
Comment has been collapsed.
16,860 Comments - Last post 1 hour ago by Deleted2137
2,658 Comments - Last post 2 hours ago by DemonFox
24 Comments - Last post 4 hours ago by BlazeHaze
7 Comments - Last post 5 hours ago by mm3n
1,181 Comments - Last post 6 hours ago by NeStric
21 Comments - Last post 6 hours ago by FranEldense
391 Comments - Last post 7 hours ago by kiseli
409 Comments - Last post 26 seconds ago by NoOne127
37 Comments - Last post 2 minutes ago by Kirouse
68 Comments - Last post 5 minutes ago by xMisiu
675 Comments - Last post 7 minutes ago by xMisiu
124 Comments - Last post 19 minutes ago by singinprincess
530 Comments - Last post 33 minutes ago by Eiion
200 Comments - Last post 1 hour ago by Patxxv
Yep, I am that guy that is worried about the size of everybody's p's. ;) ;) ;)
Here is how it works. Go to your profile and find:
N=Entered Giveaways
w=Giveaway Wins
s=Estimated Wins
s/N = probability of winning EACH giveaway (assuming that all have the same number of entries)
Now go into Excel and calculate p=BINOM.DIST(w,N,s/N,1) -- watch the order. That is the probability you win w or less times (well, if all your giveaways had the same number of entries, which is the best we can do with these numbers). So, the smaller the p, the unluckier you are.
So, for example, from other threads:
c00lizz (5244,107,123.52) means p=6.991% (unlucky!)
kumori (4104,2,8.67) means p=0.807%
TheFinalBing (3795,0,5.06) means p=0.632%
Kuroisama (4528,42,66.33) p=0.0866% (Unluckiest one?)
On the other side of the scale:
RainBoom (680,6,1.93) p=99.6% (Lucky bastard!)
Arpione (1552,36,21.76) p=99.83% (!!)
Comment has been collapsed.