Lesson 4: Exploring Time Series Data

January 23, 2019

Review:

• Python
• Sheets

Presentation:

• Google Sheets
  • Stock Charts
  • CSV files
    • OilPrices
    • PuebloRESales2014
  • Line Plots
  • Scatter Plots (if you need a refresher: Video)
  • Trendlines
  • Linear Equation
  • R²

Activity:

• Using the OilPrices data
  • Open in Sheets
  • Go to “Insert > Chart” and produce a “Line Chart”
  • Make a chart like the one below
  • Be sure to label axes and give the chart a title
  • Add the chart to your portfolio

• Using the PuebloRESales2014 data
  • Open in Google Sheets
  • Select a neighborhood and filter so only properties in that neighborhood are visible
  • Highlight the “Total SqFt” and “Selling Price” columns (Shift-Ctl-Down Arrow helps)
  • Go to “Insert > Chart” to produce a scatter plot
  • Fit a “Trendline” to the data and display the equation and the R² value.
  • Label your chart with the neighborhood name, linear equation and R² value
  • Repeat until you’ve recorded data for 3 separate neighborhoods (you may choose any set of 3 neighborhoods)
  • Add the 3 charts, with labels, to your portfolio