Math 221

Week 4 Lab

Submitted by:

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)?
  1. 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)?
  2. 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)?
  1. 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)?
  2. Regarding Questions 5 and 6, how might you interpret this information as a consumer?
  3. If a high fiber cereal is randomly selected, the probability that is a high calorie cereal is 0.8182. If a low fiber cereal is randomly selected, the probability that it is a high calorie cereal is0.3636. So a high fiber cereal is most probably a high calorie cereal also.
  4. 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.
  5. The events “high calorie’ and “ high fiber” are independent if and only if

The condition of independence is not satisfied. The events are not independent.

  1. Discuss how the Excel command "countif" was used in the table above. Why were the ranges (such as f2:f23) used as they were?
  2. The function COUNTIF() counts the number of cells within a rage that meet the given condition. COUNTIF(F2:F23, “High Calorie”) counts the number of cells in the range “F2:F23” with the text “ high Calorie”.

Part 2. Binomial Probability Distribution

(Insert your answers to Part 2 here. Be sure to copy-and-paste the two Binomial Probability Distributions. Also, copy-and-paste the graph of the distribution used for the first question here. See the worksheet Binomial Example from the Week4Lab.xls file for examples similar to your assigned questions. **REMOVE THIS NOTE PRIOR TO SUBMITTING**)

Part 3. Poisson Probability Distribution

(Insert your answers to Part 3 here. Be sure to copy-and-paste the two Poisson Probability Distributions. Also, copy-and-paste the graph of the distribution used for the first question. See the worksheet Poisson Example from the Week4Lab.xls file for examples similar to your assigned questions. **REMOVE THIS NOTE PRIOR TO SUBMITTING**)