Project 3

Introduction: Using the same data set as your previous two projects you will calculate the relative frequency approximation for probabilities in your sample. You will also create tree diagrams to explore various probabilities

1. Using the field you added in project 1 that contains 0’s and 1’s calculate the probability of the outcome described by your field. Since each 1 represents a yes, adding up all the values in the column will tell you how many are 1’s.
   1. In an empty cell, type=sum(and then select the cells which contain all the 0’s and 1’s and press enter. This is the number of values that have that outcome.
   2. The number that do not have this outcome will be the number of data values minus the number in a.
   3. Calculate the probability of the outcomes in this field.
2. Add another column to your data which has a 1 for a certain outcome and a 0 for another. Add this field to your key.
3. Create a pivot table to summarize your data. This will create a pivot table off of which you can calculate various probabilities.
   1. Click data>Pivot Table and Pivot Chart Report. When the wizard appears, click Next
   2. Select all of the data in your table, including the labels. Put the table in new worksheet. Click finish. You now have an empty pivot table.
   3. Drag the first of your created data fields to the left hand area of the table "Drop Row fields here/"
   4. Drag the second of your created data fields to the top area of the table "Drop Column fields here" and then to the main area "Drop data Fields here" and then to the main area "Drop data field here".
   5. Double click the upper left hand corner that says "Sumof…"Click "count" in the dialog box that pops up, then click OK.
   6. This table now shows the count for each possible combination.
   7. Interpret your probability, finding the probability of each of the four outcomes and one "OR" probability.
4. Create a tree diagram on a piece of paper to describe
   1. Flipping a coin three times and what the possible outcomes are and the probability of each.
   2. A family with four children and what the possible outcomes are and the probability of each.
   3. Answer the following questions.

What is the probability of having a girl for the fourth child?

What is the probability of having a girl for the fourth child if the first three children were boys?

What is the probability that a couple who have already had nine boys in a row, will have a boy for their next child?

Price: $6.69

Solution: The downloadable solution consists of 2 pages, 469 words.
Deliverable: Word Document