Publication Quality Scatter Plot in Excel for Research
HTML-код
- Опубликовано: 10 окт 2016
- This video shows Dr. Evan Matthews explaining how to create a publication quality scatter plot graph using Excel. The example data in this video represents the predicted 1 repetition maximum of the biceps curl and measured 1 repetition maximum of the biceps curl.
EXPORTING IN HIGH QUALITY via PowerPoint.
If the graph is copied and pasted from Excel into a PowerPoint slide set the instructions in the link below can be used to force PowerPoint slides to export in high resolution. The instuctions require manually editing Windows registry files, but be used to export in up to 1200dpi.
www.motifolio.com/tips2.html
EXPORTING IN HIGH QUALITY via Daniel's XL Toolbox Excel add-on.
www.xltoolbox.net/scientificp...
Link to video of how to perform a correlation on this same data set and how to interpret the results of that statistical test.
• Correlation Statistics...
Link to video showing how to create the basic scatter plot graph used as the starting place for this video.
• Basic Scatter Plot in ...
Link to video showing how to create publication quality bar graphs.
• Publication Quality Ba...
Excel Skills Playlist
• Excel Microsoft Office
Link to Dr. Evan Matthews website.
sites.google.com/site/evanmat... Наука
Thank you. I can tell you are an excellent teacher. Very helpful
Thank you. Thank you. Thank you.
Thanks so much!
You are welcome.
dear Evan, if values start from 50 then how to make graph, not possible to start from 0. then in that case can we start the graph from 50 or 40 instead of 0. if not then how to make graph. regards
It can be done in some chart types. Right click the axis and hit format axis. See if it lets you change it. Off the top of my head I do not know with this chart type. If you figure it out please reply here so others will know.
what if its hand drawn? I am assuming there is no line of best fit.
Figuring that out exactly would be beyond my math skills at this time. You basically figure out the line that would minimize the distance from the dots and all the lines.