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

question 25

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

---

Definitions:

Diminishing Returns

A rule that asserts when one input in the production process is augmented without changes to the others, there will ultimately be a decline in output after reaching a specific level.

Average Fixed Cost

The cost per unit that remains constant regardless of the level of production or output.

Output

The total amount of goods or services produced by a company or economy.

Total Cost

The total expense incurred in the production of goods or services, including both fixed and variable costs.