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!
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.
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?
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.
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?
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.
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.
![MV วิถีชีวิตใต้ - ผา อัยย๊ะ [Official MV HD]](http://i.ytimg.com/vi/nODlkOUu9B0/mqdefault.jpg)
Absolutely amazing video! You saved our bachelors thesis!
Seriously thank you. This was taking forever to figure out and there was truly not another resource on this that was so succinct.
Thank you so much. My boss explained the concept but visualizing with Excel was exceedingly difficult until I watched your video.
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!
Dude you rock this was so easy and I was making my life so complicated. Thank you!!
You are an absolute legend.
THANK YOU.
God bless you!!!! 😭❤️
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.
Great video! Help me get over the barrier I had with my data! Thank you.
Thanks, this was extremely helpful!
Thanks so much! This was a real lifesaver
Greetings from Denmark. Niels and i are in great dept to you oh wise sensei Andrew.
Very useful Andrew. Thanks a lot.
Thank you so much for your video. :) i would have never figured it out on my own T_T
Very helpful and creative.
this is a great tutorial! thank you!
Look up how to make templates, once you have a template customized for you, you can get to making soft quickly
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.
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?
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.
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?
Same as in the example. You will have more rows of data and more data points.
@@andrewleynes9726 If you have 20 values just go ahead and use box-plot... Why bother yourself with all this mess..
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.
nevermind, solved. The issue was with the secondary axis tick box, when I unchecked it, the datapoints showed up.
Huge help! Many thanks! :)
Thank for clearly explanation
Thank you so much!
Thanks , thats good stuff
thanks this really helped!!!
Toooo helpful! Thank you v much my man🫶🏾
amazing... thank you
Thank you sir!
Wonderful.
how would you connect the data points in a paired data set?
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.
Legend