Markov cohort simulation in Excel - Probabilistic sensitivity analysis (Part 1)
13.6 هزار بار بازدید -
3 سال پیش
-
In this video I show
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!
3 سال پیش
در تاریخ 1400/02/30 منتشر شده
است.
13,628
بـار بازدید شده