Lesson 1: Intro to Multivariate Analysis

January 23, 2024

Presentation:

• Introduction
  • About me
  • Syllabus
  • Textbook
• Multivariate Analysis
  • Univariate, Bivariate, Multivariate
  • n=1, n=2, n>=2
  • We will cover Bivariate and Multivariate
• Platforms
  • Spreadsheets
  • Google Sheets or Microsoft Excel
  • Python
• Exploratory Data Analysis
  • Identify significant relationships
  • Visualize relationships (check for non-linear patterns)
  • Calculate correlation coefficients for all combinations
• Scatterplots
  • Examples
    • Colorado TCAP Scores and % Free-Reduced Lunch
    • Gender Wage Gap
  • Visual Correlation
    • Positive and Negative
    • Strong, moderate, weak
    • Curvilinear patterns
• Pearson Correlation Coefficient
  • -1 < r < 1

Activity:

• Download and install the XL Miner Analysis TookPak for Google Sheets
• Exploratory correlation analysis
  • Use this data set: Pueblo RE 2014 – 100 rows
  • Visualize correlations for Beds, Baths, Total SqFt and Selling Price
  • Create Scatterplots
    • Beds (x) vs Selling Price (y)
    • Baths (independent) vs Selling Price (dependent)
    • Total SqFt (explanatory) vs Selling Price (response)
  • Identify the independent variable (x) with the strongest correlation to Selling Price (y)

Assignment:

• Identify a dataset of interest and import into Google Sheets