How to make a forest plot in excel

Поділитися
Вставка
  • Опубліковано 23 жов 2024

КОМЕНТАРІ • 35

  • @XerxesBreakSama
    @XerxesBreakSama 11 місяців тому +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! 😃

  • @nicholascrabb1687
    @nicholascrabb1687 7 місяців тому +1

    Hardly ever comment on UA-cam videos, but this has been so helpful, thank you. Really like how quick and to the point you are, and that you don't ask for anything. Weirdly makes me want to support you on Patreaon or Kickstarter - are you an evil genius, lol? Many thanks again!

  •  8 місяців тому

    Great video! Very clear and concise. Thank you!

  • @shiruit815
    @shiruit815 Рік тому

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

  • @fuhlerei4764
    @fuhlerei4764 2 роки тому

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

  • @Chartomy
    @Chartomy 2 роки тому

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

  • @DrPKSingh-cl3wv
    @DrPKSingh-cl3wv 11 місяців тому +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.... 7 місяців тому

      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.

  • @karolperez4286
    @karolperez4286 2 роки тому

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

  • @rajivpatel1118
    @rajivpatel1118 2 роки тому +2

    That was awesome. Simple and straightforward. Thank you!

  • @anwarsalim8925
    @anwarsalim8925 Рік тому

    Thank you for this video.

  • @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 11 місяців тому

      have you resolve the issue

  • @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

  • @ceciliaxu5617
    @ceciliaxu5617 11 місяців тому

    this is very helpful, thank you!

  • @xiaoli7352
    @xiaoli7352 2 роки тому

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

  • @michaelthompson9126
    @michaelthompson9126 2 роки тому

    INCREDIBLE! Thank you so much!!

  • @TheWhiteguard
    @TheWhiteguard 6 місяців тому

    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?

  • @WeirdPatagonia
    @WeirdPatagonia Рік тому

    dude you are awesome, thanks

  • @abhiramdb927
    @abhiramdb927 Рік тому

    Thank you

  • @Investmentsindustrytradedepart
    @Investmentsindustrytradedepart 6 місяців тому

    Hi. Could you help with creating forest plot please?

  • @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

  • @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 10 місяців тому

      ​@@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