Module 2: Data Visualization

March 13, 2022

• Watch this Module Introduction Video first!
• Please note: I’ve changed this module
  • You’ll be working with Colorado’s Economic Regions instead of Congressional Districts.
  • This should make life easier for you because the Congressional Districts are tricky.
  • I haven’t changed the video so I still refer to Congressional Districts.
  • Whenever you hear Congressional Districts think Economic Regions instead.
  • If you have questions about this ask on the discussion board in Bb!

• Step 1
  • DataCamp: Introduction to Pivot Tables for Google Sheets
• Step 2
  • Video 2.1: Data Assembly
    • Compile a Colorado County Data Set
    • Download population data for all US counties
    • Download County GDP from the Bureau of Economic Analysis
    • Look up Economic Regions and assign each Colorado County to one of 14 regions
• Step 3
  • Video 2.2: Pivot Tables
    • If you haven’t already, complete Pivot Tables in Spreadsheets
    • Chapter 1 ONLY
    • Use a Pivot Table to aggregate GDP and Population by Economic Region
  • Video 2.3: Visualizing frequency distributions
    • Make two histograms
  • Video 2.4: Visualizing bivariate relationships
    • Make one scatterplot
• Step 4
  • Download US County Dataset
  • Create a Pivot Table
    • 49 rows and 4 columns
    • Each row corresponds to 48 States and Washington DC (Alaska and Hawaii are excluded)
    • Each column corresponds to four variables: Population, GDP, Median HH Income, Poverty %
    • Calculate the “Sum” for Population and GDP by State
    • Calculate the “Average” for Median HH Income and Poverty % by State
• Step 5
  • Create graphs (use Insert > Chart)
    • Use the resulting State aggregation (from the Pivot table)
    • Make four (4) histograms
      • (1) Population
      • (2) GDP
      • (3) Median HH Income
      • (4) Poverty %
    • Make four (4) scatter plots:
      • (1) Population (x) vs GDP (y)
      • (2) GDP (x) vs Poverty % (y)
      • (3) GDP (x) vs Median HH Income (y)
      • (4) Median HH Income (x) vs Poverty % (y)
    • All graphs must have axis labels
    • All scatter plots must include a “Trendline” along with labels for the “Equation” and “R^2 value”
• Step 6
  • Submit your assignment in Bb.
    • Click the “Share” (green button, upper right)
    • Under “Get Link”, click “Change” to be sure “Anyone” with the link can view, comment or edit.
    • Click “Copy Link” and paste the link into Bb.