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?
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?
Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section: Chapter Questions
Problem 8CR
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill