Discussion:
A contingency table was created inside the Cereal worksheet showing the breakdown of fiber and how it relates to calorie content. Use the contingency table to help response the following probability questions.
Suppose one type of cereal is randomly selected.
1. What is the probability that the cereal would be high calorie? In other words, what is P(high calorie)?
2. What is the probability that the cereal would be high fiber? In other words, what is P(high fiber)?
3. What is the probability that a cereal would both high calorie and high fiber? In other words, what is P(high calorie and high fiber)?
4. What is the probability that a cereal would either high calorie or high fiber? In other words, what is P(high calorie or high fiber)?
5. What is the probability that a cereal would be high calorie, given that it is high fiber? In other words, what is P(high calorie, given high fiber)?
6. What is the probaility that a cereal would be high calorie, given that is is low fiber? In other words, what is P(high calorie, given low fiber)?
7. How might you interpret this information as a consumer?
8. Using the simple test of independence, decide if the events high calorie and high fiber are independent or dependent. Show your work.
9. Discuss how the Excel command "countif" was used in the table above. Why were the ranges (such as f2:f23) used as they were?
Attachment:- probability.rar