>>>>Probability of only 1 person having the same birthday is around 0.016% calculated as (364 ^ 23) / (365 ^ 24)
>>>
>>>Where do you get these numbers from?
>>>
>>>Adapting the previous formula, you get:
>>>
>>>1 - (364/365) ^ 1 = 0,27%.
>>>
>>>Which is exactly the same as 1/365.
>>>
>>>Hilmar.
>>
>>Combination of the probability of 1 person having the same birthday (1/365) and the probability of the remaining 23 having a different birthday ((364/365)^23).
>>
>>(Actually, I've got the feeling I'm not totally right, but I can't work out why, but I think it's in the right area).
>
>I think your formula asks whether the first person in an arbitrary list has the birthday on the specific date. To get any person in the list would be more complicated with this approach.
>
>Hilmar.

Thats where I'm going wrong - also I'm not sure where 0.016% came from, the actual result is 0.257% - must have looked at the wrong spreadsheet result.