Need to learn how to do this in Excel: Let’s assume that the “prevalence” (i.e., the proportion of infected people) of COVID-19 in a particular area is 10%. Tests are randomly administered in this area (i.e., regardless of whether a person is symptomatic or not). The test has a 2% false positive rate and a 4% false negative rate. If a person tests positive, what is the probability that he or she is actually infected with COVID-19?

College Algebra
7th Edition
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter9: Counting And Probability
Section9.3: Binomial Probability
Problem 2E: If a binomial experiment has probability p success, then the probability of failure is...
icon
Related questions
Question

Need to learn how to do this in Excel: Let’s assume that the “prevalence” (i.e., the proportion of infected people) of COVID-19 in a particular area is 10%. Tests are randomly administered in this area (i.e., regardless of whether a person is symptomatic or not). The test has a 2% false positive rate and a 4% false negative rate. If a person tests positive, what is the probability that he or she is actually infected with COVID-19?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning