Fiber Type High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High Fiber High

Part 1: Contingency Table (Cross-Reference Table) and ProbabiltyUsing the Cereal worksheet (which we used in the Week 2 Lab for Linear Regression Analysis), the Calorie variable was recoded into "high calorie" and "low calorie" categories. We used 120 calories per serving as the break point (greater than or equal to 120 is "high calorie"). 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 answer the following probability questions. Write your answers inside the Week 4 Lab Template. You do not need to copy-and-paste anything from Excel. 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. Regarding Questions 5 and 6, 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?Place your answers inside the Week 4 Lab Template for submission. Be sure to follow the directions in the template. Part 2: Binomial Probability DistributionWork through the "Binomial Example" worksheet located inside the Week 4 Lab Excel file. (Click here to download it.) This example shows how to create a Binomial Probability Distribution to help answer the following question for practice:A surgical technique is performed on seven patients. You are told there is a 70% chance of success. Find the probability that the surgery is successful for (a) exactly 5 patients, (b) at least five patients, and (c) less than five patients.Answer: n = 7, p = 0.70; a) P(5) = 0.318; b) P(x >= 5) = 0.647; c) P(x < 5) = 0.353Also, here is another example: Binomial Distribution Example This file shows how a binomial distribution is created in Excel. The file shows the formula view as well as the probability calculation. Assignment: Work the following questions using Excel. Part 2 Questions For each question, create the entire binomial distribution for the situation described in the question. The "BINOMDIST" function will calculate the probability results. You’ll need to create a binomial distribution table and distribution graph for each problem. Use the table you build to answer all the probability questions. Show your work.You will copy-and-paste two Binomial Probability Distributions to the Week4 Lab Template for submission. You will also copy-and-paste the graph of the distribution for the first question. Be sure to also answer the questions using complete sentences to justify your work.Part 3: Poisson Probability DistributionWork through the "Poisson Example" worksheet located inside the Week 4 Lab Excel file. (Click here to download it.) This example shows how to create a Poisson Probability Distribution to help answer the following question:A newspaper finds that the mean number of typographical errors per page is 4. Find the probability that (a) exactly three typographical errors will be found on a page, (b) at most three typographical errors will be found on a page, and (c) more than three typographical errors will be found on a page.Answer: mu = 4; a) P(3) = 0.195; b) P(x <= 3) = 0.433; c) P(x > 3) = 0.567Also, here is another example: Poisson Example This file shows how a Poisson distribuiton is created in Excel. The file shows the formula view as well as the probability calculation. Assignment: Work the following questions using Excel. Poisson Questions For each question, create the entire Poisson distribution for the situation described in the question. The "POISSON" function will calculate the probability results. You’ll need to create a Poisson distribution table and distribution graph for each problem. Use the table you build to answer all the probability questions. Show your work.You will copy-and-paste two Poisson Probability Distributions to the Week 4 Lab Template for submission. You will also copy-and-paste the graph of the distribution for Question 1 from the Poisson Questions. Be sure to also answer the questions using complete sentences to justify your work