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% (!!)

11 years ago*

Comment has been collapsed.

N - 4393

W - 25

S - 24.03

P- 0.00546% (24.03/4393)?

11 years ago
Permalink

Comment has been collapsed.

No, that P is the probability you win ONE SPECIFIC giveaway similar to the ones you entered... Your p is
BINOM.DIST(25,4393,24.03/4393), that is, about 63%. So, the chance that a user like you would win 25 OR LESS giveaways is 63% (in other words, the chance of winning 26 or more would be about 37%).

Vaguely: you belong to the 37% luckiest people on this site.

11 years ago
Permalink

Comment has been collapsed.

Oh, i knew i missed something. And awesome. :D

11 years ago
Permalink

Comment has been collapsed.

Just a word of warning: The reality might be someway off when the variance of the number of entries is quite high. Here goes a small example:
N = 2,
Entries: 1, infinity (think of trillions).
Then s = 1,
and p = 1/2.

The probability to win 1 or less times is now 1 (because you will not win a giveaway with infinite (trillion) entries).
But with your calculation it is (1/2)^2 + (1/2) = 3/4

The probability to win 0 or less times is now 0 (because you will win the giveaway with 1 entry).
But with your calculation it is (1/2)^2 = 1/4.

Now for my result with this method: p = 50.23%.

11 years ago
Permalink

Comment has been collapsed.

Fair enough -- we are making the HUGE assumption that the number of entries is about the same in every giveaway. But, with the data summary we have, it is the best we can do, I think.

11 years ago
Permalink

Comment has been collapsed.

I failed at Excel. Now I don't know how big my P is.

11 years ago
Permalink

Comment has been collapsed.

I will do it for you: BINOM.DIST(37,6283,40.18/6283) turns out to be 34.36%.

So, basically, you are among the 35% unluckiest users around. Unlucky, but not horrible.

11 years ago
Permalink

Comment has been collapsed.

The same, i got "The formula you typed contains an error" using the given formula :/

11 years ago
Permalink

Comment has been collapsed.

Hmm, strange. You have to type "=BINOM.DIST(37,6283,40.18/6283)" in any cell, without quotes -- the equal sign must be present.

It is possible this function has a different name in older versions. Try BINOMDIST without the dot, maybe?

11 years ago
Permalink

Comment has been collapsed.

37.42%

11 years ago
Permalink

Comment has been collapsed.

5,08%
:(

11 years ago
Permalink

Comment has been collapsed.

Don't have excel installed can someone calculate it for me??

11 years ago
Permalink

Comment has been collapsed.

I got 90.64% for ya. Very very lucky. :)

11 years ago
Permalink

Comment has been collapsed.

21cm :D

11 years ago
Permalink

Comment has been collapsed.

nice joke

11 years ago
Permalink

Comment has been collapsed.

The probability of exactly 11 successes out of 5,979 trials is 6.3096803349951660%.

The probability of 11 or fewer successes out of 5,979 trials is 17.2769583065577130%.

11 years ago
Permalink

Comment has been collapsed.

How big is my P?

11 years ago
Permalink

Comment has been collapsed.

Petrosian

11 years ago
Permalink

Comment has been collapsed.

p when small, P when it rises

11 years ago
Permalink

Comment has been collapsed.

N=616

w=2

s=4.13

p=0.218685214 or 21.8685%

11 years ago
Permalink

Comment has been collapsed.

I dont have execel installed :/ can i calculate this in any ohter way??

11 years ago
Permalink

Comment has been collapsed.

did it for ya.
p=0.266721405

11 years ago
Permalink

Comment has been collapsed.

thanks xD not sure if i should be glad or sad

11 years ago
Permalink

Comment has been collapsed.

well, it comes out that you are at 26.67%, so there are 73.33% above you in luckiness. Feel lucky that you aren't at the bottom I guess lol

11 years ago
Permalink

Comment has been collapsed.

Oh... what?

11 years ago
Permalink

Comment has been collapsed.

63,64% here

11 years ago
Permalink

Comment has been collapsed.

no, i'm not doin that and feeling horrible about the smaller p later.
TBH i am more then satisfied with my P IRL if u know what i mean ;)*

11 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 4 years ago.

11 years ago
Permalink

Comment has been collapsed.

I don't have Excel installed on my computer, how big/small is my "P"?

=BINOM.DIST(37,4484,31.77) (That's correct right? My maths have declined since I graduated 15 years ago... o_O )

11 years ago
Permalink

Comment has been collapsed.

p=0.846221866

84.62%

11 years ago
Permalink

Comment has been collapsed.

So I guess I'm in the top 20% of "luckiest SG users"? o_O

11 years ago
Permalink

Comment has been collapsed.

yes...which makes me hate you a little bit lol

11 years ago
Permalink

Comment has been collapsed.

I'm OK with that. :p

11 years ago
Permalink

Comment has been collapsed.

2% :(

11 years ago
Permalink

Comment has been collapsed.

89.37% I can live with that

11 years ago
Permalink

Comment has been collapsed.

34,79%...could be much much worse.

11 years ago
Permalink

Comment has been collapsed.

47% :<

11 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 3 years ago.

11 years ago
Permalink

Comment has been collapsed.

Wait, I believe that is 0.01277=1.277%. So, I would not want to be in your shoes, but it is not THAT bad. :)

Cheers!

11 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 3 years ago.

11 years ago
Permalink

Comment has been collapsed.

my p is so big

11 years ago
Permalink

Comment has been collapsed.

If I did it right, I am 12.90%. Well, 12 is my lucky number, so yay?

11 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 2 years ago.

11 years ago
Permalink

Comment has been collapsed.

99,84% - really nice :D

11 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 2 years ago.

11 years ago
Permalink

Comment has been collapsed.

Deleted

This comment was deleted 2 years ago.

11 years ago
Permalink

Comment has been collapsed.

Closed 11 years ago by Thexder.