Part I: Construct a probability tree

Using the dog breed data posted in google classroom first build the following:

  1. Use the COUNTIFS function to complete the contingency table that is embedded within the dog breed data set
  2. Use the contingency table you just constructed to calculate the marginal, conditional, and joint probabilitities associated with each possible combination of dog intelligence and friendliness.
  3. Use the probabilities you constructed to draw out a probability tree, and be sure to clearly label the marginal, conditional, and joint probabilities.

Part II: Analyze the probability tree

Consider the probability tree you just constructed.

  1. Does it seem like there is a relationship between how intelligent a dog is and how friendly a dog is? Does the intelligence of a dog seems to effect the probability it will rarely be friendly?
  2. How did the probability tree you constructed make the different probabilities more readible?