The probability of a certain medical test being positive is 90%, if a
patient has disease D. 1% of the population have the disease, and the
test records a false positive 5% of the time. If you receive a positive
test, what is your probability of having D?
I know how to answer it by traditional Bayesian fomula. My question is how to use Excel Solver to run Monte Carlo simulation to solve this problem. Please be as specific as possible(what Excel Formula should I use, etc). Thank you for your help!!
Bookmarks