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

L

lnwdros

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!
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Totals 6
Formula to calculate 4 possible answers in one cell 3
show data dependant on certain columns (2 dif questions) 8
how to generate email list for Outlook from Excel cells 4
How to generate a list of prime number? 16
How to generate Outlook mail event 2
How to keep the orignial path? 1
Excel How to add numbers in same cell? 2

Top