Excel graph: basic bar chart
5:11
5 жыл бұрын
Excel table: average, min, max
7:32
5 жыл бұрын
Excel graph: 3D graph
11:19
5 жыл бұрын
Excel trick: activate macros
3:15
5 жыл бұрын
Excel graph: ICER scatter plot
29:04
5 жыл бұрын
Excel trick: automatic table
16:50
5 жыл бұрын
Пікірлер
@reading.dlc94
@reading.dlc94 2 ай бұрын
Hello, When inserting tables for the transition probabilities, is it possible to add 2 tables, with the first table being a first year transition probability and the second table being the transition probability for subsequent years? But the transition probabilities used for the cycles are the age in the simulation.
@gbadeboabayomi9241
@gbadeboabayomi9241 3 ай бұрын
How can one contact you?
@vladimirvillosladaterrones9354
@vladimirvillosladaterrones9354 5 ай бұрын
Excellent video Kibo, is posible share your Excel
@MuhammedawelKaso
@MuhammedawelKaso 5 ай бұрын
Interesting video
@adidasthottie
@adidasthottie 7 ай бұрын
Well explained. Thank you!
@dikshasingh9277
@dikshasingh9277 7 ай бұрын
in the above video, what is the rationale of using 70 cycle and how we can incorporate when we want to model accumulating monthly cycle.
@huipingjia
@huipingjia 10 ай бұрын
Thank you for the fabulous work. It's really helpful for my self-teaching on cost-effectiveness analysis. If you don't mind, I would like to ask your permission to share the all series of your videos to the other website in China for the embarrassing reason that KZbin is blocked from accessing in China. Of course, I will give sources of the original website. Thank you very much.
@ginginong-cornel2136
@ginginong-cornel2136 11 ай бұрын
very clear!
@tommasopagani7813
@tommasopagani7813 Жыл бұрын
How can I contact you? I need some help with my cost-effectiveness analysis! If you help me I would be grateful
@anvitaachadha5426
@anvitaachadha5426 Жыл бұрын
Thank you for your highly informative videos. Would have recommendations on how to do a PSA using DALYs instead of QALY?
@soheilaahmadi1839
@soheilaahmadi1839 Жыл бұрын
Tanx for your explanation🌹 . I have a question ,When we have an entervention such as screening every 5 years for example ,how we should inter it into the model??
@syedghauseibrahim8543
@syedghauseibrahim8543 Жыл бұрын
not visible and voice is not clear
@yangxulin5883
@yangxulin5883 Жыл бұрын
Thank you very much for your detailed and clear illustration of Markov model with cohort simulation! It is really enlightening. I would like to know: 1. how do we calculate total QALYs in each cycle? Is it adding up QALYs for each individual in the cohort and then dividing the sum by the number of individuals to get average QALYs or in other words per-patient QALYs? 2. I saw in the final result that you calculated the total effect per patient, and would like to confirm with you how per-patient QALY is derived? Is it done as I described in Q1 above? Thank you so much for your help in advance! With my best regards!
@YiSun-p7j
@YiSun-p7j Жыл бұрын
yes, I think. You can refer to the first video.
@maregaabdoulaye2467
@maregaabdoulaye2467 Жыл бұрын
Perfect clasroom. Many Thanks
@charlottekennedy3373
@charlottekennedy3373 Жыл бұрын
This is an introductory video to a cohort markov model, not a simulation model
@tejbeersingh4239
@tejbeersingh4239 Жыл бұрын
That reference 😅
@Kftlsjanvr
@Kftlsjanvr Жыл бұрын
Thank you for this
@prashanthkondaparthi9778
@prashanthkondaparthi9778 Жыл бұрын
Could you please share the excel sheet with us
@cady4105
@cady4105 Жыл бұрын
Thank you so much for this terrific video series on Health Economics! I was wondering if you have any textbooks or other books recommendation on Health Economics for people who are new in this field?
@nagrani6380
@nagrani6380 Жыл бұрын
Can you explain what is base case in economic evaluation
@yam6414
@yam6414 Жыл бұрын
Very helfpul thank you
@Li-zk7fr
@Li-zk7fr Жыл бұрын
hi could i know whats the background music that you used in between the video? thanks a lot
@scottellsworth284
@scottellsworth284 Жыл бұрын
This is an absolutely amazing video! You helped me with plotting 1000 iterations of equity curves on backtested data across 1000 columns in Excel using VBA with this code. Thank you so much!
@travissimpson1353
@travissimpson1353 Жыл бұрын
Scam, can anyone tell me??
@travissimpson1353
@travissimpson1353 Жыл бұрын
@DREXELCODE This seems so incredibly scripted and like actors, it looks and sounds terribly fake TO BE VERY HONEST WITH YOU!! Like thousands of other videos you promise free services and for me and others to make millions. What an amazing offer!! This same exact video almost scripted to the letter I've seen a millions times if feels like all promising the same program with zero losses and all gains and its incredibly challenging for someone who wants to learn and get into investing to potentially change there life that is in dire need when everything feels like false promises and scams! How does one tell who the hell are making true statements and who are making false promises and scamming already struggling individuals?? Can ANYONE answer that for me??? ANYONE???? It is incredibly troubling to invest with anyone when everyone makes these same promises and same videos and the same program, the same no losses, all gains. It makes my head spin 🤔🙄🤯😵‍💫🤕🤥🤥
@lexied4043
@lexied4043 2 жыл бұрын
Hey Kibo,excellent videos! Thanks a lot. I wonder if you can make a new video about generating tornado diagram using VBA code? Thank you so much!
@moathal_sarari5170
@moathal_sarari5170 2 жыл бұрын
Can i download this presentation?
@lexied4043
@lexied4043 2 жыл бұрын
nice video! I have one question, how can we get the standard deviation of each parameter?
@ABraam-wk2cc
@ABraam-wk2cc 2 жыл бұрын
Thank you! this video is really helping and very very clear!
@pharma.talents
@pharma.talents 2 жыл бұрын
the videos were incredible! I have done my modeling by watching them
@elchill684
@elchill684 2 жыл бұрын
Thank you so much!
@rodneychisha9972
@rodneychisha9972 2 жыл бұрын
Thanks for saving me from this nightmare
@zhaoqian58
@zhaoqian58 2 жыл бұрын
Nice video! I just have one concern - based on the way you defined the variable with distribution (gamma, for example), when you change the base case value for the cost of new drug, the "cost_new_drug_dist" will not be changed accordingly. So I think it would be better if you don't enter "30000" as the mean, but refer to "cost_old_drug"?
@zubairudalhatuzubairu7879
@zubairudalhatuzubairu7879 2 жыл бұрын
I have read four different text books trying to understand this concept, all to no avail. Thank you so much for this simple and detailed explanation, especially the ICER to CEAC transformation.
@carlosolimpo
@carlosolimpo 2 жыл бұрын
Wonderful explanation, thanks so much !!
@honestdisliker4362
@honestdisliker4362 2 жыл бұрын
Amazing
@konstantinoschristopoulos764
@konstantinoschristopoulos764 2 жыл бұрын
But where do you get the hazard ratio from?
@honestdisliker4362
@honestdisliker4362 2 жыл бұрын
wher can we get excrl files sir
@honestdisliker4362
@honestdisliker4362 2 жыл бұрын
can u prvide the excell sheet plz
@auzman45
@auzman45 2 жыл бұрын
very helpful content!
@becksbacks
@becksbacks 2 жыл бұрын
Fabulous
@cristiancabello8711
@cristiancabello8711 2 жыл бұрын
Nice video, very helpful. What book do you recommend about health economics theory?
@knoxyknox1992
@knoxyknox1992 2 жыл бұрын
Economic Analysis in Healthcare by Stephen Morris
@moussaanouguindo5391
@moussaanouguindo5391 2 жыл бұрын
very good...but i speak small small english
@DonbAyers
@DonbAyers 3 жыл бұрын
Excellent videos, very helpful
@kchriztian
@kchriztian 3 жыл бұрын
Thank you very much for your useful vides. I watch them closely. Thanks again! 🙏
@PhaimM
@PhaimM 3 жыл бұрын
Great video on making macros, but all this could have been done by using the offset excel formula nested in your sum formulae. You could then use 5 as height for 5 years, 10 for 10 years, and the total count of your expected time horizon for lifetime. Besides that, the markov model videos are amazing, I have spent the whole day making the model alongside the video tutorial!
@empt_rx43
@empt_rx43 3 жыл бұрын
Thank you so much for sharing these very helpful playlists, especially the Markov model. I love the way you explain and demonstrate. I have learned many techniques from your clips. Would you mind demonstrating how to build a Tornado plot and how to perform a threshold analysis ?
@basiliszag
@basiliszag 3 жыл бұрын
Your example 3 helped me a lot, appreciate it
@Shadabacademy
@Shadabacademy 3 жыл бұрын
So less views on it makes me sad.
@Shadabacademy
@Shadabacademy 3 жыл бұрын
He has explained it so thouroughly.Thank you sir for help.We need more of this and less of useless tik tok like videos here on youtube.