# Simulating Birthdaysa.Develop a simulation for finding the probability that when 50 people are randomly selected, at least 2 of them have the same birth date. Describe the simulation and estimate the probability.b. Develop a simulation for finding the probability that when 50 people are randomly selected, at least 3 of them have the same birth date. Describe the simulation and estimate the probability.

Question
14 views

Simulating Birthdays

a.Develop a simulation for finding the probability that when 50 people are randomly selected, at least 2 of them have the same birth date. Describe the simulation and estimate the probability.

b. Develop a simulation for finding the probability that when 50 people are randomly selected, at least 3 of them have the same birth date. Describe the simulation and estimate the probability.

check_circle

Step 1

Note:

Hi there! Thank you for posting the question. Since the question is based on simulation, the answers will vary. One of the possible answers is as follows.

Step 2

a) Step-by-step software procedure to generate random numbers using EXCEL is as follows:

• Open an EXCEL file.
• In cell A1, enter the formula “=RANDBETWEEN (1,365)”
• Clicks ‘ENTER’.

Click and hold down the mouse button to drag the lower right corner of the cell A1, pull it down the column until 50 cells are highlighted. Repeat the procedure 5 times. Count the numbers that repeats at least twice.

The formula for probability of an event is as follows:

Step 3

The probability that at least two of them have same birthday...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in