LAB $3$

Building on the Bayes example

$*$ Write a scalar UDF that calculates the P$($Infected $|$ Test $=$ t$)-$ it should take the test result, sens$,$ spec, and prevalence

$*$ What if there are two kinds of tests $($Rapid and PCR$)$

$*$ Modify the structure of the sheet appropriately

$*$ Use your UDF

$*$ Write a second UDF with dynamic arrays that uses the first, use it in your sheet

$*$ Part $2$: In the real world, we don't know what the prevalence is$.$

$*$ Choose a method to estimate the prevalence

$*$ This will require a little background research

$*$ May or may not require a new UDF, Goal Seek, or Solver