Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Birthday probability
Hi,
I can work out the probabilities for 2 people in the same room sharing a birthday by dragging formula down like so No People Different Same % 2 364 365 99.73% 0.274% 3 363 365 99.18% 0.820% 4 362 365 98.36% 1.636% But can anyone get this equation into a single formula where I imput n for the number of people in the room and the probability is calculated. And secodly a formula for the probability as the same birthday as me Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Days until birthday | Excel Worksheet Functions | |||
Getting 106 for Birthday Formula | Excel Discussion (Misc queries) | |||
Birthday calculations | Excel Discussion (Misc queries) | |||
Birthday Alert | Excel Discussion (Misc queries) | |||
Sorting by Birthday | Excel Discussion (Misc queries) |