Lesson 2: Scatterplots and Correlation

January 17, 2018

Review:

• Syllabus
• Join Slack
• Sheets
  • Filters
  • Line plots (time series)
  • Scatter Plots
  • Trendlines
  • Regression Equation
  • R²

Presentation:

• Scatterplots
  • Video
  • Examples
    • Colorado TCAP Scores and % Free-Reduced Lunch
    • Gender Wage Gap
  • Correlation
    • Positive and Negative
    • Strong, moderate, weak
• XL Miner for Sheets
  • Download and install Add-On
  • Correlation (2 variables)
  • Correlation Matrix (multiple variables)
• Demonstrate with NY Vehicle Data

Activity:

• Correlation analysis
  • Use this data set: Pueblo RE 2014 – 100 rows
  • Find correlations for Beds, Baths, Total SqFt and Selling Price
  • Identify the variable with the strongest correlation to Selling Price (y)
  • Create a scatterplot for the identified variable (x) and Selling Price (y)
  • Add a trendline and label with equation and R-squared
  • Generate regression output (using XL Miner) for the identified variable (x) and Selling Price (y) and then highlight R-Squared and Coefficients (do these values match the scatterplot labels?)
  • Save your file and then upload an image of the regression output (with highlights) to the #lesson02 channel in Slack.