How to make a forest plot in excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 18 ธ.ค. 2024

ความคิดเห็น • 36

  • @XerxesBreakSama
    @XerxesBreakSama ปีที่แล้ว +7

    For you to graph the confidence interval properly, you have to create two columns for "Graph upper 95% CI (Upper CI minus RR)" and Graph for lower 95% CI (RR minus lower CI). These are the variables you need when specifying the values for your error bars.

  • @brannigandupreez2083
    @brannigandupreez2083 2 ปีที่แล้ว +2

    Hello, Karina.
    I'd watch this even if I don't need it. But I just want to thank you so much for making a difference in the lives of many.
    Thank you so much for helping me during my thesis write-up. You made the learning process more enjoyable! 😃

  •  9 หลายเดือนก่อน

    Great video! Very clear and concise. Thank you!

  • @laithhajahmad8687
    @laithhajahmad8687 หลายเดือนก่อน

    THANK YOU!! I was about to lose my mind trying to figure this out. THANK YOU SO MUCH

  • @karolperez4286
    @karolperez4286 2 ปีที่แล้ว

    Wow! This was so simple and straight forward. Thank you so much for saving my brain!

  • @fuhlerei4764
    @fuhlerei4764 2 ปีที่แล้ว

    So short, so simple, very good explained! Look so many explanation but only yours bring light into the dark.

  • @shiruit815
    @shiruit815 ปีที่แล้ว

    This is exactly what I'm looking for. Thanks Karina!

  • @xiaoli7352
    @xiaoli7352 2 ปีที่แล้ว

    It's really helpful!! This works well compared with other methods introduced by other youtuber
    Thank you!

  • @DrPKSingh-cl3wv
    @DrPKSingh-cl3wv ปีที่แล้ว +2

    you need to subtract odds value with upper bound for CI+ value and lower bound with odds ratio for CI- value. then only you can get the actual plot of lower and upper confidence interval

    • @SD....
      @SD.... 9 หลายเดือนก่อน

      This is correct. The goal is to specify the length of the error bar on the negative and positive sides, which will involve subtracting the lower value (of the estimate vs. upper or lower bound of CI) from the higher value.

  • @Chartomy
    @Chartomy 2 ปีที่แล้ว

    Thank you for saving my meta-analysis 🙏🏽🙏🏽🙏🏽

  • @rajivpatel1118
    @rajivpatel1118 2 ปีที่แล้ว +2

    That was awesome. Simple and straightforward. Thank you!

  • @bluebird30318
    @bluebird30318 2 ปีที่แล้ว +3

    Hi, I'm wondering why the lower and upper confidence intervals don't match up with the line we created.

    • @xiaoli7352
      @xiaoli7352 2 ปีที่แล้ว

      Hi you should calculate the different value

    • @academia2policy
      @academia2policy 2 ปีที่แล้ว

      Did you figure this out?

    • @robertasampong
      @robertasampong 2 ปีที่แล้ว +3

      I think confidence intervals we see are not intervals per se....but actually how much to add to or subtract from main effect estimates (odds ratios) to obtain the confidence intervals.

    • @intercardioLSD
      @intercardioLSD ปีที่แล้ว

      whay do you mean "different value"?
      @@xiaoli7352

    • @DrPKSingh-cl3wv
      @DrPKSingh-cl3wv ปีที่แล้ว

      have you resolve the issue

  • @JamafricanAfro
    @JamafricanAfro 2 ปีที่แล้ว

    INCREDIBLE! Thank you so much!!

  • @ceciliaxu5617
    @ceciliaxu5617 ปีที่แล้ว

    this is very helpful, thank you!

  • @anwarsalim8925
    @anwarsalim8925 ปีที่แล้ว

    Thank you for this video.

  • @Makeiteasynutrition
    @Makeiteasynutrition 13 วันที่ผ่านมา

    Thank you!!!

  • @WeirdPatagonia
    @WeirdPatagonia ปีที่แล้ว

    dude you are awesome, thanks

  • @oL5re9re55ion
    @oL5re9re55ion ปีที่แล้ว

    My values are effect sizes, and some of the lower bound of the confidence intervals are negative. When I select the data for the positive and negative error values, the error bars do not show negative values. Is there something else I need to do? By the way thank you for your video

  • @TheWhiteguard
    @TheWhiteguard 7 หลายเดือนก่อน

    Hi Karina, how can i get the CI+ and CI- i have all the raw data and i also calculated the odds ratio

  • @jankicheese
    @jankicheese ปีที่แล้ว

    What kind of error bars do you add? Standard error or STD?

  • @abhiramdb927
    @abhiramdb927 ปีที่แล้ว

    Thank you

  • @anilpaul2912
    @anilpaul2912 2 ปีที่แล้ว

    I have question how to match exact letters or word in excel like eg: Anil-C1 AnilPaul-C1 so i need C1 status and confirmed as C1 status

  • @anilpaul8341
    @anilpaul8341 2 ปีที่แล้ว

    How to match exact words or letters in two data like example: anil-C1 and AnilPaul-C1 so i need C-1 status is exact match

  • @Investmentsindustrytradedepart
    @Investmentsindustrytradedepart 8 หลายเดือนก่อน

    Hi. Could you help with creating forest plot please?

  • @intercardioLSD
    @intercardioLSD ปีที่แล้ว +1

    Hi, I'm wondering why the lower and upper confidence intervals don't match up with the line we created. any one knows?

    • @intercardioLSD
      @intercardioLSD ปีที่แล้ว

      i found it...
      put the figures extracted from ci values to HR or OR for error bars

    • @rohanmay4040
      @rohanmay4040 ปีที่แล้ว

      ​@@intercardioLSDHi, I am trying to work out how to do this, what are HR and OR?

  • @anilpaul2912
    @anilpaul2912 2 ปีที่แล้ว

    I have question how to match exact letters or word in excel like eg: Anil-C1 AnilPaul-C1 so i need C1 status and confirmed as C1 status