Abbott’s Covid-19 rapid test is called BinaxNOW. Test information indicates that the sensitivity of the test is .846 and the specificity is .985. a. What is the probability that a person truly has Covid-19 given that the BinaxNOW test shows positive when 5% of the population has Covid-19 b. when 10% of the population has Covid-19? c. when 20% of the population has Covid-19? d. In the first column in Excel, create a column for Pr(B) -- this probability denotes the fraction of the general population that has Covid-19. The first entry in this column is 0 and increase this value by .01 in successive rows until you reach 1.00. That is, the entries in the first column are 0, .01, .02, .03, …, .99, 1.00. In the second column in Excel, use Bayes Theorem to compute Pr(B|A) for all of the rows in the first column. That is, Pr(B|A) denotes the probability that a person truly has Covid-19, given that the BinaxNOW test shows positive. Use the graphing tool in Excel to create a graph with the first column values on the horizontal axis and the second column values on the vertical axis. Show your Excel calculations.
Abbott’s Covid-19 rapid test is called BinaxNOW. Test information indicates that the sensitivity of the test is .846 and the specificity is .985.
a. What is the probability that a person truly has Covid-19 given that the BinaxNOW test shows positive when 5% of the population has Covid-19
b. when 10% of the population has Covid-19?
c. when 20% of the population has Covid-19?
d. In the first column in Excel, create a column for Pr(B) -- this probability denotes the fraction of the general population that has Covid-19. The first entry in this column is 0 and increase this value by .01 in successive rows until you reach 1.00. That is, the entries in the first column are 0, .01, .02, .03, …, .99, 1.00. In the second column in Excel, use Bayes Theorem to compute Pr(B|A) for all of the rows in the first column. That is, Pr(B|A) denotes the probability that a person truly has Covid-19, given that the BinaxNOW test shows positive.
Use the graphing tool in Excel to create a graph with the first column values on the horizontal axis and the second column values on the vertical axis. Show your Excel calculations.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Can you please also answer question d?
d. In the first column in Excel, create a column for Pr(B) -- this
Use the graphing tool in Excel to create a graph with the first column values on the horizontal axis and the second column values on the vertical axis. Show your Excel calculations.
by Bartleby Expert