Markov cohort simulation in Excel - Probabilistic sensitivity analysis (Part 1)
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!
Видео Markov cohort simulation in Excel - Probabilistic sensitivity analysis (Part 1) канала Decision analytic modelling in health economics
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!
Видео Markov cohort simulation in Excel - Probabilistic sensitivity analysis (Part 1) канала Decision analytic modelling in health economics
Комментарии отсутствуют
Информация о видео
20 мая 2021 г. 16:56:58
00:13:49
Другие видео канала
Spotlight on: Lognormal distribution
Probabilistic sensitivity analysis (PSA) - Part II (Analysing and presenting results)
Markov cohort simulation in Excel - Probabilistic sensitivity analysis (Part 2)
Implementing a decision tree in R
The Delta-PSA method #SMDM20 Abstract 13470
Spotlight on: Gamma distribution
Markov cohort simulation in R - Our first probabilistic sensitivity analysis
Markov cohort simulation in R - Rock-Paper-Scissors
Probabilistic sensitivity analysis (PSA) - Part I (Introduction)
Spotlight on: Beta distribution
Time varying transitions and payoffs in Markov cohort simulation
Choosing the right cycle length (Time in Markov cohort simulation)
Markov cohort simulation in Excel - Half-cycle adjustment
Spotlight on: Chi-square distribution
Markov cohort simulation in Excel - Tunnel states
Markov cohort simulation in R - Wrapping your model in a function
Learn about tunnel states (Time in Markov cohort simulation)
Risks versus rates in modelling
Spotlight on: Multivariate normal distribution
Markov cohort simulation in R - Tunnel states
Discounting (Time in Markov cohort simulation)
