Probability debate / experiment

Percentage probablity 2/25 share the same birthday

  • <=10%

    Votes: 0 0.0%
  • >25% and <=50%

    Votes: 0 0.0%
  • >50% and <=75%

    Votes: 0 0.0%

  • Total voters
    2
Mortgageman, Yes your perfectly right. I realised with Eric's post that I was getting mixed up. :oops:

I then demonstrated to myself that probability of any 2 people having the same birthday does indeed approach certainty (1, 100%,..) as the sample number approaches infinity. I guess its exponential.

I bow to the better education / memories of my peers. :wink:

A very interesting discussion though; any more out there?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
I skimmed through the replies, and there seems to be a fundamental error in quite a few responses. The questions wasn't what are the odds of someone having the the same birthday as yours. but rather what are the odds of two people in the room having the same birthday? Those are two very different questions.
 
StACase, That was the very mistake I made; the question asked for the probability NOT the odds.

If there were 25 people in a room, what is the probability that at least any 2 people in that room have the same birthday anniversary?
 
Main Entry: odds

(1): the probability that one thing is so or will happen rather than another

Main Entry: prob·a·bil·i·ty

(2): the chance that a given event will occur
 
There's a very good chance that i'm probably even more confused now! :o
 
I think I have it….and used Excel to get there!!

I created a 25 x 25 grid and in each cell entered “=1/365” being the probability that each person will share a birthday with a specific other person. (obviously cells which refer to a person sharing with themselves is left blank).

Summing each row will give you 24/365 which is the probability of one person sharing a birthday with anyone else in the room.

Summing the whole 25 x 25 grid gives you 25(24/365) or 600/365 which needs to be divided by 2 to remove duplicates (i.e. person 2 sharing with person 3 and person 3 sharing with person 2).

So the final answer is:
In a room of 25 people, the probability that any 2 of them share the same birthday is 600/730 (or 60/73), which equates to approximately 0.82192
 
I must admit I calculate it differently as a 57% chance that at least 2 are born on the same day derived from Erik's approach - I think - that 43% chance of them all being born on different days (different Day/Month combinations to be more precise).
 

Forum statistics

Threads
1,222,716
Messages
6,167,822
Members
452,145
Latest member
Saikachi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top