(A) Generate the "Birthdays" of 30 Different People, Assuming That

Essay

(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 DISCRETE 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?