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.