How to generate same event (has 2 possible outcomes) 200 times?
 

Yes, this is a homework problem.

We have to randomly generate the birth of 2 children to a family 200 times
in Excel and find the probabilty of a certain event. Their are two possible
outcomes, either a boy or a girl.

I have no idea about how to do this in Excel 2003. Can anyone help please?

Thanks so much in advance!

How to generate same event (has 2 possible outcomes) 200 times?
 

Open a workbook
Enter 1 in A2
Choose Data|Series
Choose in Columns, End at 200
Click Ok
You will get 1-200 in Col A
Now in B2 enter
=Randbetween(1,2)
Copy this to B2:C201

Col A will represent a family
Col B will denote first born (1-boy, 2-girl) and
Col C will have second born



"lnwdros" wrote:

Yes, this is a homework problem.

We have to randomly generate the birth of 2 children to a family 200 times
in Excel and find the probabilty of a certain event. Their are two possible
outcomes, either a boy or a girl.

I have no idea about how to do this in Excel 2003. Can anyone help please?

Thanks so much in advance!