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.
308 Comments - Last post 43 minutes ago by radagast82
28 Comments - Last post 1 hour ago by Chris76de
362 Comments - Last post 1 hour ago by Detruire
24 Comments - Last post 1 hour ago by RobbyRatpoison
28 Comments - Last post 2 hours ago by UnknownEAK
809 Comments - Last post 2 hours ago by MeguminShiro
2,677 Comments - Last post 2 hours ago by ToatsMcGoats
177 Comments - Last post 1 minute ago by AwakenGoGoGo
2 Comments - Last post 2 minutes ago by damianea103
60 Comments - Last post 2 minutes ago by PoeticKatana
13 Comments - Last post 6 minutes ago by Cim
95 Comments - Last post 11 minutes ago by CASA0
2 Comments - Last post 50 minutes ago by CTPAX001RUS
10,112 Comments - Last post 1 hour ago by popocho
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.