Publication Quality Bar Graph in Excel for Research

[@ncs_95]

MAN YOU SAVED MY LIFE WITH THIS! My stats course in undergrad was complete bull crap and now i’m doing my MS and needed to do this. And you saved me. Cheers from Auburn!

[@VivoPhys]

Good luck!

[@shortwhat157]

Found this very useful! Am in my final degree for my sports science degree and wish I saw this video in year 1! keep up the great work

[@VivoPhys]

+ShortWhat happy to hear this helped. Good luck finishing your degree!

[@danelarsen9184]

This is incredibly helpful. I used to use Prism in my old lab, but my new lab is reluctant to shell out the money for it. Thank you for making my life easier!

[@VivoPhys]

I use both Prism and Excel, but I find myself using Excel more and more. Good luck.

[@gabethefish7585]

There is a far easier way to add an '*' to indicate significance 1. Select the Column 2. Right Click > Select add Label - the label will be the value of the column 3. Click select the box with the value in > delete the number > change font to larger size > type '*' > move to top of error bar

[@Ojos_]

I think you just saved my life, mister. Thank you, thank you a lot.

[@VivoPhys]

You are welcome.

[@JamesBrown-qv9vs]

The DPI issue is easily worked around on a Mac: right click on excel graph, save as pdf, open file with 'preview'. In preview, select file -> export. Select tiff/png/whatever, and enter DPI you want. I have done this using 1200 Dpi and it looks great.

[@VivoPhys]

Thanks for the helpful comment.

[@Structural_analysis]

How to save excel graphs as a quality image kzbin.info/www/bejne/npzWi2Wig6aIh68

[@maythuzaw7467]

Thank you for this incredible video! You make my life way easier and now I'm getting more sleep thanks to your tips :)

[@VivoPhys]

I'm glad they helped!

[@hayovm]

A LOT of thanks. Your videos are high in quality and clarity

[@VivoPhys]

Best of luck.

[@hayovm]

@@VivoPhys I past the course!! Comment of the teacher: Format Nice figures, but labels were not always explained well. So can you do a topic about labels as well XD

[@VivoPhys]

@hayovm congrats! I'll consider it for the future.

[@wizamphande6455]

Dr. Evan Matthews, Thank you very much for the tutorial. It has helped me very much!

[@VivoPhys]

You're welcome Wiza Mphande!

[@guillermomartinez-negrin4557]

Thanks so much for making this video!! Everything was explained so well and I was able to follow you step by step!! You helped make my graphs for my lab report look ten times better!!

[@VivoPhys]

I'm glad it was helpful.

[@arsenalerbest13]

Great video! loved it! - Master student in exercise physiology

[@VivoPhys]

I'm glad it helped.

[@unays]

Master student in Medical and Molecular Biotechnology

[@anoukhamers8602]

Great tutorial! Thanks. One thing though: Since your data set does not have a normal (bell-shaped) distribution nor is it a continuous variable, you cannot use a T-Test. It is a discrete variable and statistical testing should be performed with either a Chi-square test or Fishers exact test.

[@VivoPhys]

Thanks for the comment!

[@sunnyyoda5511]

WOW AMAZING, I found this extremely helpful, thank you so much Sir!

[@VivoPhys]

I'm glad you found it helpful.

[@aiahseyadi2338]

Thank you very much for the explanation!! it was very helpful♥♥

[@VivoPhys]

I'm happy it helped.

[@xcentertainment4368]

thank you so much, need this for my ecology class.

[@VivoPhys]

XCEntertainment I'm happy it helped!

[@throxlol8107]

Hi Evan. Great video! I had a quick question about what to do for calculating the SEM in a different circumstance in regard to the sample. So I have my total sample (n = 71); however this sample has been split into 5 different groups (n = 15, 14, 15, 13, 14) respectively. When calculating SEM for the n=15 group for example, do I use the total sample (stdv(of each group)/'root'71) ) or (stdv(ofeachgroup)/'root'15). I'm really confused what to use! Also, if there are outliers/anomolous results in my data, do I discount these from my calculation of my mean, and subsequent SEM? Just trying to get my dissertation finished and it's stressing me out! Hope you can help. Thank you for the video!

[@VivoPhys]

You would use the sample size that matches the mean value you are calculating SEM for. If it is a group mean with 15 subjects, then that is the sample size for SEM. If removing outliers from the mean calculation than it makes sense to do the same for SEM.

[@SebastianGaticaMoris]

Hey, thank you a lot for this video. I have a question about the statistic you are using, my project looks a lot like your table. I wanted to ask you about benefits of using SEM instead of SD. Thanks!BTW (my sample is just 11 subjects)

[@VivoPhys]

I find that most purist suggest SD. However what you use will likely depend on the norms of your field of study. In my field SEM tends to be more common. To learn more: www.sportsci.org/resource/stats/meansd.html

[@citron2725]

Thank you for such a wonderful vedio. very clear explaination and useful skills as well.:)

[@VivoPhys]

I'm glad it helped.

[@rafeeakand6801]

Very useful video!

[@VivoPhys]

I'm happy it helped.

[@catherinebenjamin7905]

Why did you choose to use the SEM instead of SD for your figure ?

[@VivoPhys]

It was a matter of tradition in my field. I now use SD for my error bars.

[@tj2705]

I watched the whole ad.... Thank you

[@VivoPhys]

I hope it helped.

[@dayanidhijena9726]

Thank you very much for this very useful video.

[@VivoPhys]

You're welcome Dr. Dayanidhi Jena!

[@anapatino4243]

Great video! Thank you :)

[@VivoPhys]

You're welcome Ana Patino!

[@ambernaz5036]

THANK YOU SO MUCH FOR THIS VIDEO

[@VivoPhys]

I'm glad it helped.

[@domr8796]

Man, thats one big screen you've got behind you there

[@muhammadzakariahossain2447]

Thanks Evan.

[@VivoPhys]

You're welcome Muhammad Zakaria Hossain!

[@Anits1989]

Thanks so much! I’m doing drugged studies with age and cholesterol…some biostatistics and l am not a math person. So it’s drug A and Drug B effects on cholesterol with age

[@gigimatz9222]

so if a data set in a published paper doesnt have a star then it isnt statistically significant?

[@gigimatz9222]

this is for each data set in a graph. Thank you for an awesome video btw! Your answer will be greatly appreciated :)

[@VivoPhys]

It depends on how the authors choose to display their statistical results. You need to read the text below the graph to see if a symbol is defined to mean statistical significance or not. If symbols are not defined it may or may not be statically significant and you need to read further in the text.

[@gigimatz9222]

@@VivoPhys Awesome, thank you so much for your well written response! So if they have star at the bottom to represent values of significance but the data set states ns or does not have a star, then it is not statistically significant? Does this indicate a flaw in the research/conclusion presented?

[@VivoPhys]

It does not tell us there is a flaw in the conclusion. It does show us that the data is not significant.

[@gigimatz9222]

@@VivoPhys Thank you so much! So not being significant means that a random effect could have caused the result?

[@juquinha3181]

Excelent! Thank you.

[@VivoPhys]

You are welcome.

[@buklau3676]

Wow, this is great.

[@VivoPhys]

Thank you Buk Lau!

[@musicwithmatthew1020]

Most Helpful!

[@VivoPhys]

I'm glad it helped.

[@johnnysmith6876]

Thank you sir!

[@VivoPhys]

You are welcome.

[@DVM-DoctorOfVeterinaryMedicine]

AWESOME.........

[@VivoPhys]

I'm glad it helped.

[@jessicascannell8833]

Why are you using SE as opposed to 95% CI?

[@VivoPhys]

SEM is the traditional convention in physiology research. What is thought of as "correct" varies by discipline and academic journal. I generally use standard deviation for my more recent work.

[@VivoPhys]

Hello again. I am reading an article right now about graphing in physiology journals (link below). It states that 77.6% of bar graphs in top tier physiology journals display standard error as the error bars and 15.3% display standard deviation. I hope this is helpful! journals.plos.org/plosbiology/article?id=10.1371/journal.pbio.1002128

[@putradaninla-aesong7758]

Thx so much

[@VivoPhys]

You are welcome!

[@faustin289]

I now know that Excel can do error bars. I am not sure whether this info will ever be useful to me. It's better to leave these type of things to specialized tools such as R or Python. Excel is for office guys and these people don't know what standard error is (from my experience).

[@sarahali482]

If I was rich I would rather give you money instead of Prism

[@VivoPhys]

I'm glad it was helpful!

[@Yk-xo6kq]

PROF IBIYEMI

[@avinashjadhav2436]

Man you look so similar to BEN STOKES , Same-to-Same

[@chiv2011]

Ur pretty smart for a red head

[@Jerrysis]

lmao

[@hassanyousouph3160]

I can't see clearly. Your is head blocking the whole thing