This video describes how to create a bar graph and then overlay the individual data points for each group to show the within-group variability. Creating publication quality graph in excel ( • Creating a publication... ).
Пікірлер: 35
@nreggente2 жыл бұрын
Seriously thank you. This was taking forever to figure out and there was truly not another resource on this that was so succinct.
@shiprapuri3214Ай бұрын
Huge Thank you! This was extremely helpful. The reviewers on my paper asked for the individualized data in the graphs. I would not have figured it on my own. You got a new subscriber here!
@maximebrants82434 ай бұрын
Absolutely amazing video! You saved our bachelors thesis!
@aamyavohra171016 күн бұрын
Dude you rock this was so easy and I was making my life so complicated. Thank you!!
@thi8a Жыл бұрын
You are an absolute legend. THANK YOU. God bless you!!!! 😭❤️
@annaireinova31953 ай бұрын
Thanks, this was extremely helpful!
@Steve-kq1vl Жыл бұрын
Wow, this is so helpful- thanks a ton! I want to submit to a journal that requires individual data points, means and SD's. Very clearly explained, but it's too bad that the process is so convoluted in Excel.
@deulgis6644Ай бұрын
Thanks so much! This was a real lifesaver
@Raxor1913 ай бұрын
Greetings from Denmark. Niels and i are in great dept to you oh wise sensei Andrew.
@philipjanz9753 Жыл бұрын
Great video! Help me get over the barrier I had with my data! Thank you.
@shailaayisha21 күн бұрын
Thank you so much!
@javierdelpino7374 Жыл бұрын
Thank you so much for your video. :) i would have never figured it out on my own T_T
@rameshabt81242 жыл бұрын
Very useful Andrew. Thanks a lot.
@yoonheevivienko7 сағат бұрын
I am using the secondary axis for the dots. It doesn't allow me to use scatter type for the dots. I am stuck. Please help.
@mohammadsalahradi22932 жыл бұрын
Very helpful and creative.
@benysmart16432 жыл бұрын
Thank for clearly explanation
@kingabarbara1168 Жыл бұрын
this is a great tutorial! thank you!
@kasiamyga8687 Жыл бұрын
Huge help! Many thanks! :)
@user-gf9of9lc7c2 жыл бұрын
Look up how to make templates, once you have a template customized for you, you can get to making soft quickly
@sheenclean65412 жыл бұрын
thanks this really helped!!!
@solotch28042 жыл бұрын
Thank you sir!
@drahomirmichalko6 ай бұрын
Thanks for the tutorial. I've ran into some issues with this, however. I have 20 data points, yet only 3 are displayed in the plot when I follow your method. Any idea on what might bewrong? I've plotted the data points with respect to the secondary y-axis which covers the whole range of the values, I've also added a small jitter, so I know that the data points are not overlaying each other. The displayed datapoints also seem to be picked randomly.
@drahomirmichalko6 ай бұрын
nevermind, solved. The issue was with the secondary axis tick box, when I unchecked it, the datapoints showed up.
@Timgroschkeprivat Жыл бұрын
Thanks , thats good stuff
@nermeenbastawy170911 ай бұрын
amazing... thank you
@martinemallyon7037 Жыл бұрын
Thx for the helpful video. My data points (y values) are quite close together and the dots overlap in the scatterplot. Should I change the x values so that the data points spread out horizontally or should I keep them all in the same vertical line?
@andrewleynes9726 Жыл бұрын
I would say that this is a stylistic decision that should be left up to the author(s). You might consider changing the y-axis because a restricted y range could make it appear that the individual points are close together when they aren't as similar. Assuming that you have a representative y range, a tight cluster is a good feature of your data in so far as the members of the group (or observations) are very similar. I wouldn't alter the x-axis because the point is to show how the individuals do (or do not) represent the group/condition average.
@smsabbiralam85142 жыл бұрын
Wonderful.
@yeasmeenali34232 жыл бұрын
Thank for nice explanation. If I have a number of values (i.e. 20) how can i see each value on the bar graph. I mean how can I make bar graph and scattered plot together?
@andrewleynes97262 жыл бұрын
Same as in the example. You will have more rows of data and more data points.
@TR_Conqueror Жыл бұрын
@@andrewleynes9726 If you have 20 values just go ahead and use box-plot... Why bother yourself with all this mess..
@osio97376 ай бұрын
Legend
@qm65952 жыл бұрын
how would you connect the data points in a paired data set?
@andrewleynes97262 жыл бұрын
Sorry, I don't know. I would have to figure it out. I would look at using box plots in R. They seem to be very easy to provide the kind of graph you are seeking. I hope this helps.