Markov cohort simulation in Excel - Probabilistic sensitivity analysis (Part 1)
Decision analytic modelling in health economics Decision analytic modelling in health economics
3.52K subscribers
14,084 views
119

 Published On May 20, 2021

In this video I show you how to prepare your Excel Markov model to run probabilistic sensitivity analysis (PSA). You will learn about giving cells in Excel names and see examples of sampling from the beta and gamma distributions.

Note - After recording the video I noticed a small error. On the parameters sheet, for cell F11 we should have '=BETA.INV(RAND(),60,40)' not '=BETA.INV(RAND(),90,10)'. Apologies for that!

show more

Share/Embed