(A)Generate the "birthdays" of 30 different people,assuming that each person has a 1/365 chance of having a given birthday (call the days of the year 1,2,3,……..,365).You can use a formula involving the INT and RAND functions to generate birthdays.
(B)Once you have generated 30 people's birthdays,you can tell whether at least two people have the same birthday using Excel's RANK function (i.e.,in the case of a tie,two numbers are given the same rank).Do you see any people with the same birthday in your sample?
(C)Obtain at least 20 samples of the 30 person group using the F9 key.What do you estimate the probability of finding two people with the same birthday in a sample of 30 people to be?

Question

Quizplus · Accepted Answer

The Answer of (A)Generate the "birthdays" of 30 different people,assuming that each person has a 1/365 chance of having a given birthday (call the days of the year 1,2,3,……..,365).You can use a formula involving the INT and RAND functions to generate birthdays.
(B)Once you have generated 30 people's birthdays,you can tell whether at least two people have the same birthday using Excel's RANK function (i.e.,in the case of a tie,two numbers are given the same rank).Do you see any people with the same birthday in your sample?
(C)Obtain at least 20 samples of the 30 person group using the F9 key.What do you estimate the probability of finding two people with the same birthday in a sample of 30 people to be?

(A)Generate the "Birthdays" of 30 Different People,assuming That Each Person