Using 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.

The solution provides step by step method for the calculation of probabilities and conditional probabilities from the Cereal worksheet contingency table. Formula for the calculation and Interpretations of the results are also included.

Given the following contingencytable:
C D Total
A 10 30 40
B 20 40 60
Total 30 70 100
Find the probability of A and C.
a) 33.3%
b) 10%
c) 25%
Find the probability of A or C
a) 60%
b) 70%
c) 10%
Find the probability of B given C
a) 20%
b) 30%
c) 66.67%

Develop a hypothetical contingencytable of data using a grid of 3 rows and four columns (label the rows and columns as you see fit. For example, the rows might be age, and the columns might be income level). Insert hypothetical values for each cell in the table.
Create four probability questions using the table that you a

Many people think that job satisfaction in the workplace is directly related to the annual income. To check the validity of this assumption a survey of 430 active working adults in the U.S was taken that relates their job satisfaction to their annual income. The results are shown in the contingencytable below.
Annual Income

Four percent (4%) of the customers of a store buy cigars. Half of the customers who buy cigars buy beer and one fourth of those who buy beer buy cigars. The table is given below:
Beer No Beer Total
Cigars .02 .02 .04
No cigar .06 .90 .96
Total .08 .92

1. When we calculate chi-square tests in hypothesis testing we use contingencytables.
a. Set up a simple contingencytable for me.
b. Highlight a cell in your table.

Consider the following contingencytable:
Under 20 21-30 31-40
Male 12 12 17
Female 13 16 21
a. If one person is selected at random, what is the probability that person is Female? ______
b. If one person is selected at random, what is the probability that person is ei

Facebook reports that 70% of their users are from outside the United States and that 50% of their users log onto the Facebook everyday. Suppose that 20% of their users are United States users who log on every day.
1. What percentage of Facebook users are from the United States?
2. What type of probability is the 20% mentione

I am not sure how to compile the contingencytable from probabilities given.
Each yr ratings are compiled concerning the performance of new cars during the first 90 days of use. Suppose that the other cars have been categorized according to whether the car needs warranty - related repair (yes or no) and the country in which t

1. Define (a) random experiment, (b) sample space, (c) simple event, and (d) compound event.
2. What are the three approaches to determining probability? Explain the differences among them.
3. Sketch a Venn diagram to illustrate (a) complement of an event, (b) union of two events, (c) intersection of two events, (d) mutually e