October 27 - November 2
Section outline
-
-
Remaining part (264-288) is optional
The assignment for Data Visualization Lab #4 will involve a SCATTERPLOT. Please review the Scatterplot module (less than 8 minutes long) in the LinkedIn Learning course on Excel. For those still mastering Excel, it will be useful to practice with the sample data along with the video.
A FEW THINGS TO NOTE:
- be sure to be prepared to add a trendline (best fitting line) and R squared value (and note how you can reformat or manipulate both) to your scatterplot
- In the case of one x variable (one predictor) the value of R-squared is equal to lthe value of ittle r-squared. Little r-squared tells you how much variation the x and y variable share.
- the narrator in the Excel video characterizes a correlation ("r" or the sqrt of r-squared) of .5 as not being strong. We have talked in class about the common standards in social science research (r=.5=large; r=.3=medium; r=.1=small). In your write-up, I would like you to use the common social science standard.
7.3 MB · Uploaded 08/31/26, 14:29