In: Statistics and Probability
A random sample of 100 adults were surveyed, and they were asked if the regularly watch NFL games. They were asked in their favorite team had ever won the Super Bowl.
Won Super Bowl | Did not win Super Bowl | Row total | |
Watch games | 24 | 56 | 80 |
Do not watch games | 11 | 9 | 20 |
Column total | 35 | 65 | 100 |
Find:
a) P(watch NFL games given their favorite team won the Super Bowl)
b) P(favorite team won the Super Bowl and watch NFL games)
c) P(favorite team won the Super Bowl or watch NFL games)
Please use and show excel formulas
Solution: Please note there are no excel in-build functions for such problems. This problem can be solved using the basic rules of probability.
We are given below tabular information:
Won Super Bowl | Did not win Super Bowl | Row total | |
Watch games | 24 | 56 | 80 |
Do not watch games | 11 | 9 | 20 |
Column total | 35 | 65 | 100 |
a) P(watch NFL games given their favorite team won the Super Bowl)
Answer: Here we have to use the conditional formula of probability.
b) P(favorite team won the Super Bowl and watch NFL games)
Answer:
c) P(favorite team won the Super Bowl or watch NFL games)
Answer: Here we have to use the addition rule of probability as: