Excel: Graphing with separate Error Bars of Standard Deviation

Поделиться
HTML-код
  • Опубликовано: 1 дек 2024

Комментарии • 290

  • @alajononon
    @alajononon 5 лет назад +62

    Doing astrobiology work at NASA for my internship and this was sooooooo helpful thanks! No one taught us how to plot these. Just how to calculate STDEV and percent error.

    • @PeterStanley
      @PeterStanley  5 лет назад +38

      Well now I can say I helped someone at NASA... that's a first.

    • @lindam8791
      @lindam8791 4 года назад +4

      Hi, this is the first time I've ever seen someone who is doing astrobiology at NASA. I cannot express how that's exactly my goal. I really, really want to be an astrobiologist and I'm limited in resources where I am. Do you have any tips? And if you don't mind, where did you go to university and what did you study? Thank you x

    • @alajononon
      @alajononon 4 года назад +14

      @@lindam8791 Hi! I'm just finishing up an MS thesis in geosciences right now. For my undergrad I started out in biology classes and then switched to Biogeoscience which is a study of where biology and geology interact. I'm currently at the University of Tulsa and we don't have any kind of space themed program or much of a connection to NASA so where you go to college isn't a huge factor. The thing that helps is networking. My advisor is friends with a prominent astrobiologist at JPL. So I sent her an email expressing interest in an internship. When she got funding she sent me an invite. If you haven't started college, I do recommend looking for schools with space and astrobiology programs. But again it is not essential. You're just more likely to find the connections there. Much of it involves geochemistry because so much research shows that interactions between rock and water do lots of chemistry that can create organic molecules. So I recommend some sort of biology and geology background. Microbiology is really good because it's thought if we find anything it will be similar to that. Look up scientists in the field that are doing stuff that interests you and reach out to them. Do some preliminary research on what they do so you're not just saying HI I WANNA WORK AT NASA. You don't have to be an expert, It just helps to know what it is they do. I worked in a lab that ranged from freshmen that hardly knew anything. Ans that's fine. We're all there to learn. These folks are much more likely to extend an internship offer to someone who reaches out to them than going through the main system blind. That said, you should still apply for internships in the system. JPL and all of the NASA centers should have a website to apply. Wherever you go to college, let your professors know you are interested in research and that you are interested in astrobiology. They may be doing that kind of research or something that you can spin to be astrobiology related. Try to keep term projects and papers focused on that field if you have the option. That's all stuff you can put on a resume as experience. Look at what talks are happening on campus (I guess virtually, now). Scientists that do all kinds of things get invited to speak at colleges and you might get to see an astrobiologist speak. Speaking of, here is a link to my mentor on Nasa's astrobiology youtube channel. Check that out and don't be afraid to reach out to her. ruclips.net/video/UTILC0vHux8/видео.html&feature=emb_title

    • @PeterStanley
      @PeterStanley  4 года назад +11

      @@alajononon I really appreciate you taking the time to write about your experience. This will hopefully inspire many others thinking about their next chapter in life. Thank you.

  • @TidesLive
    @TidesLive 4 года назад +63

    Thanks John Stamos. Good to learn this new excel skill from you.

  • @TheLeeshylou
    @TheLeeshylou 7 лет назад +72

    THANK YOU. you have no idea how long I spent trying to do this.

    • @PeterStanley
      @PeterStanley  7 лет назад +5

      happy to hear it saved you some time.

    • @pmalik7404
      @pmalik7404 6 лет назад

      same here .. it really useful, thankyou Mr Peter :)

    • @VikasSinghMinimalist
      @VikasSinghMinimalist 5 лет назад +1

      @@PeterStanley It is extremely simple and helpful brother. Thanks a lot

    • @PeterStanley
      @PeterStanley  5 лет назад +4

      @@VikasSinghMinimalist Appreciate you saying that, cheers.

  • @uhuihiuhuihi
    @uhuihiuhuihi 7 лет назад +50

    I've been up 2 days straight grinding out lab reports and assignments and still found this easy to understand. Solid tutorial, cheers.

    • @PeterStanley
      @PeterStanley  7 лет назад +10

      Hope you are all done now and get some much needed sleep.

  • @ItzRanok_
    @ItzRanok_ 6 месяцев назад +2

    OMG THANK YOU, YOU JUST SAVED MY FINAL GRADE IN SCIENCE!

  • @mackenziefaller4370
    @mackenziefaller4370 4 года назад +18

    AMAZING TUTORIAL. I HAVE BEEN TRYING TO DO THIS FOR THE PAST HOUR AND THIS IS THE ONLY VIDEO THAT SHOWED ME HOW TO DO IT. YOU ARE AN AMAZING PERSON AND I WILL THANK YOU FOR THE REST OF MY LIFE. sincerely, a struggling college student & your future doctor :)

    • @PeterStanley
      @PeterStanley  3 года назад +2

      I'm glad this helped and I hope you are beyond the struggling stage and on to saving lives. We need you out there.

  • @shakyabhattacharjee9100
    @shakyabhattacharjee9100 3 года назад +1

    Thanks a lot, you are the first person who helped me get rid of the horizontal value

  • @AnimeUni-versed
    @AnimeUni-versed 5 лет назад +12

    You literally just saved my life. I wish I could like this a thousand times. Thank youuuu!

  • @x_leady8616
    @x_leady8616 Месяц назад

    Thank you so much to this guy. I was about to light myself on fire with how infuriating it was and how other videos were not helping. Big props to him I hope he has a peaceful life where no bad happens to him. Lots of Love to him!!!!!!!!! Peter Stanley the man you are.

  • @lindsayrowland4098
    @lindsayrowland4098 2 года назад +1

    I have been trying to figure out how to make separate error bars for each bar on my graphs for my entire freshman year of college. Did not realize all you had to do was select the values already in excel! Thank you so much.

  • @xvgx
    @xvgx 2 года назад

    After watching 5 videos, this was the only one that helped. Thank you!

  • @rudranimukerji1685
    @rudranimukerji1685 Год назад

    THANK YOU SO MUCH FOR THIS. LITERALLY STRUGGLED OVER THIS FOR 40 MINS.

  • @MexicanDre
    @MexicanDre 5 месяцев назад

    8 years later and I used this video for my nano materials research. Thanks for posting.

  • @usmanakhtar4768
    @usmanakhtar4768 6 лет назад +1

    This is short and best tutorial i search google a lot now i can make my own error bars :)

  • @fabiozapata657
    @fabiozapata657 4 года назад

    you help me out for my IA and you are explained it better than my teacher Thank you so much!!!

  • @jaegeriglesias
    @jaegeriglesias 9 лет назад +14

    Thanks for the tutorial...way better than the official office support!

    • @PeterStanley
      @PeterStanley  8 лет назад +1

      +Antonio Jaeger thanks Antonio, much appreciated

  • @noellea1435
    @noellea1435 2 года назад

    Hi Mr. Stanley! Thank you for helping me with SD - even after 3 years of being your student at AISB

  • @itaycohen9055
    @itaycohen9055 7 лет назад +1

    I could'nt find videos regarding this specific topic. Thank u very much! Helped me a lot

  • @armanjalalipour9044
    @armanjalalipour9044 5 лет назад +3

    Came here to learn about graphs, left feeling relaxed, easy and like I made a new friend

  • @salimkhoso7995
    @salimkhoso7995 3 года назад +1

    This is the best video I have ever seen regarding the data range and plotting in excel.
    Very well done

    • @PeterStanley
      @PeterStanley  3 года назад

      I really appreciate that, thanks.

  • @maryc5905
    @maryc5905 4 года назад +3

    THANK YOU!!!!!!!!!!!!!!!!!!!!! I've been searching for hours with no luck!!

  • @nidiaburucamajano4367
    @nidiaburucamajano4367 6 лет назад +2

    THANK YOU!
    Struggled for a really long time trying to the horizontal bars!

    • @PeterStanley
      @PeterStanley  5 лет назад

      I struggled a bit in the video... but later realized you can also just click the horizontal bars and hit 'delete' on your keyboard.

  • @laynie113
    @laynie113 7 месяцев назад +1

    wow none of my profs ever taught me this THANK YOUUU

    • @PeterStanley
      @PeterStanley  7 месяцев назад +1

      Glad this was helpful for you √

  • @aishwaryapanchakshikar9937
    @aishwaryapanchakshikar9937 4 года назад +2

    This makes SL Physics so much easier! This was super helpful thank you!

  • @asifmangat
    @asifmangat 5 лет назад +13

    You saved my life I was failed in my PhD defence just because some graph were mixed with some stats error you are savage God bless you . I would love to take you on a dinner if you live in Sydney

  • @janemoraaprilia5809
    @janemoraaprilia5809 4 месяца назад

    currently writing my thesis and I've been struggling to make separate error bars for my chart... it's past midnight now and I just wanna say thank you sir for saving my life

  • @blissieee
    @blissieee 6 лет назад +9

    Thank you!! This whole video was so helpful for my biology lab :)

  • @Raiden_Amani
    @Raiden_Amani 4 года назад +1

    5 years later, and it's still helpful. 👍🏾

    • @PeterStanley
      @PeterStanley  3 года назад

      I initially made this for a few students who kept struggling on lab reports. So glad to know that it has helped so many out there.

  • @NicDufour7
    @NicDufour7 9 лет назад +2

    Thanks you so much ! I am just searching all day long to find this tool for one of my work and I was beginning to be frustrated about the new Excel. So... Thanks again ! you make my day :)

    • @PeterStanley
      @PeterStanley  8 лет назад

      +Nic Duff cheers Nic, happy that this was useful for you

  • @muhammadhasnainali5723
    @muhammadhasnainali5723 7 лет назад +1

    Thank you very much. It helped me to draw the error bars on line graph easily. Some other tutorials on youtube were confusing.

    • @PeterStanley
      @PeterStanley  7 лет назад

      Glad to know that this helped Muhammed. Cheers.

  • @callofduty_Moh
    @callofduty_Moh 3 года назад

    Thank you Peter for this brief and clear explanation!

  • @diyashajid3752
    @diyashajid3752 5 лет назад +4

    You just saved me from failing,.. thank YOU soooo much

  • @kianooshramezani2535
    @kianooshramezani2535 3 года назад

    thank you john
    i am a chemist
    it was sooo helpful
    i did the same in libre calc (linux) by learning from your toturial🙏🏻

    • @PeterStanley
      @PeterStanley  3 года назад

      That's great to hear that you translated it. Well done and glad it helped.

  • @mochipepper
    @mochipepper 4 года назад +1

    THanks so much for making this so simple to follow.

  • @kittyforster1279
    @kittyforster1279 3 года назад +1

    Thank you so much - I've struggled (for years!) with the simple task of getting the SEM bars to be showing accurately - rather than the same size error bar across all the bars!

    • @PeterStanley
      @PeterStanley  3 года назад

      I had to reteach it to myself each year so figured I'd make the video once and for all. Glad it helped.

  • @toadstoolring
    @toadstoolring 7 лет назад +1

    Thank you so much! Your tutorial was really simple and easy to understand, and it cleared up a lot of confusion I had about this! You saved me so much time, thank you again!

    • @PeterStanley
      @PeterStanley  5 лет назад

      Great to hear it helped you, thanks for your comment.

  • @StrLo
    @StrLo 8 лет назад +1

    This video is a big help for my biology investigation, Thanks!

    • @PeterStanley
      @PeterStanley  8 лет назад

      +Struan That's good to hear it helped. Thanks for saying thanks.

  • @chloerainbow7810
    @chloerainbow7810 6 лет назад +2

    Finally a clear explanation! thankyou so much!!

  • @CaptainCrunch7100
    @CaptainCrunch7100 6 лет назад +3

    Very well made, it really helps seeing an example, thanks!

  • @semaniafefadja458
    @semaniafefadja458 10 месяцев назад +1

    Thanks man you're a hero. Legit I was gonna get a zero if u didnt come in very clutch 🙏🙏🙏

    • @PeterStanley
      @PeterStanley  8 месяцев назад

      Well done not getting that zero and putting time in to find a solution. You've got this!

  • @jamieosorio3596
    @jamieosorio3596 5 лет назад +1

    You seriously save lives, THANK U

  • @InoNOheart
    @InoNOheart 4 года назад +1

    Words cannot express my gratitude to you. Thank you though.

    • @PeterStanley
      @PeterStanley  4 года назад

      very much appreciated, thank you.

  • @SuperPintu2010
    @SuperPintu2010 5 лет назад +1

    Very useful and easily illustrated. Thanks

  • @rawan4297
    @rawan4297 4 года назад +1

    This is more than helpful, thank you very much

  • @thek5593
    @thek5593 6 лет назад +1

    I feel like you are a GENIUS right now

  • @nooshinshahbazi5616
    @nooshinshahbazi5616 6 лет назад +2

    Thanks for your awesome explanation.

  • @Charlie-vf8hw
    @Charlie-vf8hw 5 лет назад +20

    Thank you so much John Stamos

  • @annurkamarudinutm6825
    @annurkamarudinutm6825 7 лет назад +1

    thank you so much for this simple and comprehensive video! love it!

    • @PeterStanley
      @PeterStanley  7 лет назад

      You're very welcome. I'm happy to hear that it helped.

  • @vestia8444
    @vestia8444 5 лет назад +57

    didnt know iron man was making lessons

  • @mrpapadopoulos9033
    @mrpapadopoulos9033 5 лет назад +2

    YOU ARE MY SAVIOUR. Thank you, kind man.

  • @oxidemuzik
    @oxidemuzik 10 месяцев назад +1

    THANK YOU SO MUCH IT WAS HELPFUL IN MY BIOLOGY IA IN IB DP2

    • @PeterStanley
      @PeterStanley  8 месяцев назад

      Great to hear this. It's exactly what I made the video for (my IB Bio and ESS students doing the IA). Good luck on your upcoming exams!

  • @Rainbowfire100
    @Rainbowfire100 7 лет назад +3

    Thank you this video saved my life you are a beautiful soul

  • @Supamancam
    @Supamancam 5 лет назад +1

    Great video, thanks for that. Works great in 2016 with very minor differences.

  • @vhfamily
    @vhfamily 6 лет назад +1

    you are an incredible teacher!!

  • @dianaccalvo
    @dianaccalvo 5 лет назад +2

    Extremely useful and to the point... thanks!

  • @milicatubic1092
    @milicatubic1092 4 года назад +2

    this video was very helpful to me, thank you!

  • @MrCityGaming
    @MrCityGaming 8 лет назад +1

    Great help with an assignment good job!!

  • @umarabdulmutalib7637
    @umarabdulmutalib7637 5 лет назад +2

    Straight away and useful

  • @kayshascorner
    @kayshascorner 2 года назад

    Exactly what I needed (and more in fact). Thank you for this!

  • @jytan98
    @jytan98 4 года назад +1

    straight forward and easy to understand. Thank you

  • @kkrwazie
    @kkrwazie 5 лет назад +2

    Thankyou for this, this will help me so much.

  • @nairasahakyan2170
    @nairasahakyan2170 4 года назад +3

    Thank you. It was very useful for me.

  • @VikasSinghMinimalist
    @VikasSinghMinimalist 5 лет назад +1

    EXTREMELY HELPFUL BRO. THANKS A TON

  • @chrstina
    @chrstina 5 лет назад +1

    this video saved my life!!! thank you so much!!!

  • @ebrukuyumcusavan8900
    @ebrukuyumcusavan8900 5 лет назад +1

    Many thanks for this useful information

  • @Oiseau1
    @Oiseau1 2 года назад +1

    Okayyyy very very gratefull for this tutorials, definetely save my life T_T

    • @PeterStanley
      @PeterStanley  2 года назад

      Very happy to hear it helped - cheers.

  • @CasualGamer121
    @CasualGamer121 3 года назад

    Thank you sir. Excellent video that was simple and to the point.

  • @arjunhehehjejejejdjejdjdje1952
    @arjunhehehjejejejdjejdjdje1952 26 дней назад

    You’ve saved me today was about to crash out

  • @DebalikasLife
    @DebalikasLife 3 года назад

    Thank u it's really very helpful.i am from India West Bengal

  • @leratosharonmphahlele8006
    @leratosharonmphahlele8006 4 года назад +2

    this was super helpful. thank you

  • @tahinaakthar4826
    @tahinaakthar4826 8 лет назад +2

    Made it look so easy! thank you so much.

  • @OuroMorpheus
    @OuroMorpheus 2 года назад

    Very helpful, saved my butt today.

  • @qingyu1080
    @qingyu1080 7 лет назад

    Thanks a lot for posting. Very useful

  • @lostinthesauce9319
    @lostinthesauce9319 4 года назад +3

    Thank you for saving me while I'm trying to do a last minute assignment at 3 am (sadly not joking, send help and coffee)

    • @PeterStanley
      @PeterStanley  4 года назад +1

      We've all been there before. Hope it worked out.

  • @yaozhongsong4041
    @yaozhongsong4041 6 лет назад +2

    Great video! Thanks a lot!

  • @tandty321
    @tandty321 2 года назад

    Thank you so much you saved my life😭😭

  • @josuavantonder7447
    @josuavantonder7447 6 лет назад +1

    Thank you, you were an amazing help!!!

  • @bobxu9367
    @bobxu9367 7 лет назад

    Thank you so much! Very clear and precise !

  • @hampshireoak
    @hampshireoak 5 лет назад

    Very well done, Thank you Peter

  • @chrispinchisanga1477
    @chrispinchisanga1477 6 лет назад +1

    Awesome! Please do a video on calculating the EC/IC50 too!

  • @abeerameen4832
    @abeerameen4832 6 лет назад +2

    thank you very much thats real helpful

  • @arungoudediga964
    @arungoudediga964 4 года назад

    Thanks you sir.... pretty much useful

  • @lesliesherman7834
    @lesliesherman7834 5 лет назад +1

    So very helpful. Thank you.

  • @nourelshahawy3662
    @nourelshahawy3662 5 лет назад +2

    Very helpful :) Thank you!!

  • @AnimeFan-zs2ed
    @AnimeFan-zs2ed 6 лет назад +2

    Helped me with Management Skills Assignment!

  • @amarbyakodi5651
    @amarbyakodi5651 4 года назад

    nice description !!!! Thanks..

  • @naomi-ee-ee1197
    @naomi-ee-ee1197 5 лет назад +1

    LIFE SAVER Exactly what i need thanks! :D

  • @rebecab.737
    @rebecab.737 5 лет назад +1

    Clearly explained... Thanks a lot!

  • @reinvainik6797
    @reinvainik6797 3 года назад

    This helped me a lot, thanks!

  • @dododog5002
    @dododog5002 Год назад

    THIS just saved my life haha ty ty for this

  • @edemeyo4796
    @edemeyo4796 6 лет назад +2

    Thank you for this video. It helped me big time

  • @sophiamartins3009
    @sophiamartins3009 7 лет назад +2

    This video was so helpful! Thank you!

  • @maxsydenham5529
    @maxsydenham5529 3 года назад

    Thank you so much for your help. Great video - really clear!

  • @AM07638
    @AM07638 6 лет назад +1

    nicely explained 👌👌👌

  • @monikamakuszynska9349
    @monikamakuszynska9349 3 года назад +1

    Good staff, thank you so much for posting :-).

  • @nicosp4475
    @nicosp4475 4 года назад +1

    thank you from 2020

    • @PeterStanley
      @PeterStanley  3 года назад

      You are welcome from 2021 (I'm slow with replying)

  • @muhammadsaad7480
    @muhammadsaad7480 5 лет назад +3

    Excellent! you saved my ass. Cheers!!

  • @sadraadineh2044
    @sadraadineh2044 6 лет назад +2

    You're awesome man!! Thanks a lot

  • @talyakolukfaki2313
    @talyakolukfaki2313 4 года назад +1

    LIFESAVER!!!

  • @filipcerny5325
    @filipcerny5325 5 лет назад

    Thank you! super helpful :)