Excel: Graphing with separate Error Bars of Standard Deviation

If this was useful, please SUBSCRIBE and I'll keep the tutorials coming.
Here is a short tutorial on how to convert a simple data table into a scatter plot graph with error bars of standard deviation. I made this for my biology students, but hope it helps others as well.
This was made in Excel 2016 on a MacBook Pro... using Screen-o-matic.

[@alajononon]

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]

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

[@lindam8791]

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]

@@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. kzbin.info/www/bejne/i4WsfXZmq62orpo&feature=emb_title

[@PeterStanley]

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

[@ItzRanok_]

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

[@TidesLive]

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

[@PeterStanley]

;)

[@ellemariea2620]

JOHN STAMOS HAHAHA

[@TheLeeshylou]

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

[@PeterStanley]

happy to hear it saved you some time.

[@pmalik7404]

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

[@VikasSinghMinimalist]

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

[@PeterStanley]

@@VikasSinghMinimalist Appreciate you saying that, cheers.

[@laynie113]

wow none of my profs ever taught me this THANK YOUUU

[@PeterStanley]

Glad this was helpful for you √

[@uhuihiuihiuh3042]

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

[@PeterStanley]

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

[@mackenziefaller4370]

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]

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

[@lindsayrowland4098]

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.

[@caterine4604]

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

[@MexicanDre]

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

[@janemoraaprilia5809]

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

[@usmanakhtar4768]

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

[@itaycohen9055]

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

[@jaegeriglesias]

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

[@PeterStanley]

+Antonio Jaeger thanks Antonio, much appreciated

[@Raiden_Amani]

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

[@PeterStanley]

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.

[@asifmangat]

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

[@piusschretzmeir8209]

would you pay for the flight?

[@shakyabhattacharjee9100]

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

[@PeterStanley]

Glad to hear that!

[@mochipepper]

THanks so much for making this so simple to follow.

[@PeterStanley]

Glad it was helpful!

[@nooshinshahbazi5616]

Thanks for your awesome explanation.

[@fabiozapata657]

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

[@umarabdulmutalib7637]

Straight away and useful

[@rudranimukerji1685]

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

[@thek5593]

I feel like you are a GENIUS right now

[@armanjalalipour9044]

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

[@rawan4297]

This is more than helpful, thank you very much

[@PeterStanley]

Glad it was helpful!

[@nidiaburucamajano4367]

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

[@PeterStanley]

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

[@noellea1435]

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

[@xvgx]

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

[@aishwaryapanchakshikar9937]

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

[@semaniafefadja458]

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

[@PeterStanley]

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

[@brennanmitchell4525]

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

[@Charlie-vf8hw]

Thank you so much John Stamos

[@salimkhoso7995]

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

[@PeterStanley]

I really appreciate that, thanks.

[@hampshireoak]

Very well done, Thank you Peter

[@PeterStanley]

Cheers

[@maryc5905]

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

[@diyashajid3752]

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

[@InoNOheart]

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

[@PeterStanley]

very much appreciated, thank you.

[@muhammadhasnainali5723]

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

[@PeterStanley]

Glad to know that this helped Muhammed. Cheers.

[@kkrwazie]

Thankyou for this, this will help me so much.

[@PeterStanley]

Good to hear it helped

[@NicDufour7]

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]

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

[@kittyforster1279]

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]

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

[@coppercrusader6791]

excellent stuff

[@yaozhongsong4041]

Great video! Thanks a lot!

[@mrpapadopoulos9033]

YOU ARE MY SAVIOUR. Thank you, kind man.

[@jamieosorio3596]

You seriously save lives, THANK U

[@abeerameen4832]

thank you very much thats real helpful

[@chloerainbow7810]

Finally a clear explanation! thankyou so much!!

[@callofduty_Moh]

Thank you Peter for this brief and clear explanation!

[@MrCityGaming]

Great help with an assignment good job!!

[@qingyu1080]

Thanks a lot for posting. Very useful

[@oxidemuzik]

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

[@PeterStanley]

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!

[@SuperPintu2010]

Very useful and easily illustrated. Thanks

[@kianooshramezani2535]

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]

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

[@milicatubic1092]

this video was very helpful to me, thank you!

[@nairasahakyan2170]

Thank you. It was very useful for me.

[@StrLo]

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

[@PeterStanley]

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

[@mari-liiskotsar4448]

Thanks a lot, very helpful!

[@hassanm8675]

excellent. Thank you

[@vhfamily]

you are an incredible teacher!!

[@filipcerny5325]

Thank you! super helpful :)

[@PeterStanley]

glad to hear this helped.

[@Supamancam]

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

[@toadstoolring]

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]

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

[@lesliesherman7834]

So very helpful. Thank you.

[@OuroMorpheus]

Very helpful, saved my butt today.

[@brunoramirez2602]

Thanks, very clear

[@chrstina]

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

[@leratosharonmphahlele8006]

this was super helpful. thank you

[@bobxu9367]

Thank you so much! Very clear and precise !

[@PeterStanley]

Appreciate it Bob, Cheers.

[@jytan98]

straight forward and easy to understand. Thank you

[@Rainbowfire100]

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

[@PeterStanley]

very kind of you. cheers.

[@josuavantonder7447]

Thank you, you were an amazing help!!!

[@DebalikasLife]

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

[@tandty321]

Thank you so much you saved my life😭😭

[@dianaccalvo]

Extremely useful and to the point... thanks!

[@CaptainCrunch7100]

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

[@minalbhalerao]

Thank you so much for this video. It was very helpful.

[@nourelshahawy3662]

Very helpful :) Thank you!!

[@annurkamarudinutm6825]

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

[@PeterStanley]

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

[@ebrukuyumcusavan8900]

Many thanks for this useful information

[@VikasSinghMinimalist]

EXTREMELY HELPFUL BRO. THANKS A TON

[@PeterStanley]

Cheers, I'm glad it helped

[@NhiHuynh-hz5wi]

I have done the same way with you, but why was it also present horizontal bar and no vertical bar? Thanks!

[@PeterStanley]

Nhi Huỳnh I’m not sure why it does that but you can simply click on the horizontal bar and delete.

[@carlosalan7]

Thank you! super helpful!!

[@Oiseau1]

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

[@PeterStanley]

Very happy to hear it helped - cheers.

[@vestia8444]

didnt know iron man was making lessons

[@tahinaakthar4826]

Made it look so easy! thank you so much.

[@kaysaysso]

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

[@AnimeFan-zs2ed]

Helped me with Management Skills Assignment!

[@edemeyo4796]

Thank you for this video. It helped me big time

[@sefatergbashi]

Thank you Sir!

[@nakubulwapreciouseditor3675]

Thank you so much, it was helpfull

[@lostinthesauce9319]

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]

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

[@K.Frizzy]

Thanks!

[@rebecab.737]

Clearly explained... Thanks a lot!

[@anythinggoes4588]

Thanks for that!

[@AM07638]

nicely explained 👌👌👌

[@reinvainik6797]

This helped me a lot, thanks!

[@naomi-ee-ee1197]

LIFE SAVER Exactly what i need thanks! :D

[@dododog5002]

THIS just saved my life haha ty ty for this

[@AussieManny]

Thank you, sir!

[@massimobaldini5912]

Great and clear video!