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.
20 Comments - Last post 10 minutes ago by hiddendoom45
19 Comments - Last post 1 hour ago by BattleChaing
83 Comments - Last post 2 hours ago by CulitoRiko7u7
2,673 Comments - Last post 3 hours ago by MeguminShiro
8 Comments - Last post 4 hours ago by AnonymousBroccoli
17 Comments - Last post 4 hours ago by NazaSekh
16,869 Comments - Last post 5 hours ago by WaxWorm
176 Comments - Last post 54 seconds ago by Zorskan
82 Comments - Last post 16 minutes ago by LieEater
69 Comments - Last post 18 minutes ago by Orionid
150 Comments - Last post 25 minutes ago by Lep9six
112 Comments - Last post 43 minutes ago by Habaruku
606 Comments - Last post 53 minutes ago by someonequeer
260 Comments - Last post 1 hour ago by TheMuzo
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.