Part 1. Cross-Reference Tables and Probability What is the probability that the cereal would be high calorie?


Part 1. Cross-Reference Tables and Probability

  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 probability 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. Regarding Questions 5 and 6, how might you interpret this information as a consumer?
  8. Using the simple test of independence (described in the lecture), 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?
Price: $12.49
Solution: The downloadable solution consists of 8 pages, 449 words and 4 charts.
Deliverable: Word Document


log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in