This is not really the right forum for this question - you should come
here with the formula and ask how to make it work in Excel.
You're in luck, I work with statistics and probability every day, I
think this might be what you need:
For one person, there are 365 distinct birthdays.
For two people, there are 364 different ways that the second could
have a birthday without matching the first.
If there is no match after two people, the third person has 363
different birthdays that do not match the other two. So, the
probability of a match is 1 - (365)(364)(363)/(365)(365)(365).
This leads to the following formula for calculating the probability of
a match with N birthdays is:
1 - (365)(364)(363)...(365 - (N - 1))/(365)^N.
Now, how are you supposed to calculate this in Excel? Does your
instructor want to see a filled series of formulas? A macro? A chart?
Histograms?
Is this an Excel class or a statistics class?
The Disclaimer: This may not be even close to how your instructor
wants you to do it.
The Advice: Pay more attention in class.
I have a problem for class i cant figure out how to do this is it:
I have to create a worksheet that displays the percentage of people
having the same birthday and the percentage of them having different
birthdays. My problem is i have no idea what formula to use to get
these percentages for each amount of people. If anyone can help it
would be greatly appreciated.
------------------------------------------------
Mike Argy
Custom Office Solutions
and Windows/UNIX applications
Please post on-topic responses to the newsgroup
To e-mail me, remove nospam from the address in the headers
