Lesson 2: Intro to Data Analysis

August 23, 2016

Wed, Aug 24

Review:

  • Syllabus
  • Google Sheets
  • Twitter

Presentation:

  • Survey Results in Google Sheets
    • Use Data Filter
  • Types of Data
    • Numeric
      • Discrete (counting)
      • Continuous (measuring)
    • Categorical (nominal)
    • Ordinal (ranking)
    • *Spatial
    • *Temporal
  • Types of Analysis Presentation
    • Exploratory – looking for patterns
    • Descriptive – summarizing and presenting data
    • Inferential – estimating population parameters based on sample statistics
    • Experimental – testing for significance
    • Predictive – forecasting, simulation
    • Prescriptive – optimization

Assignment:

  • Read Textbook Ch. 1, pp. 4-6
  • Open the Survey Results in Google Sheets
    • Go to “File > Make a Copy”
    • Save a copy of the spreadsheet in your own Google Drive folder
    • Use “Data > Filter” to sort and filter data elements
  • If you’ve never used Sheets before you might want to first check out Tutorial 1 for Google Sheets

 

Justin

Justin Holman is CEO of Aftermarket Analytics, where he leads efforts to develop cutting edge sales forecasting and inventory optimization technology for the Automotive Aftermarket. Prior to joining Aftermarket Analytics, Justin managed corporate consulting for the Strategy & Analytics division at MapInfo Corporation, leading major projects for retail clients including The Home Depot, Darden Restaurants, Bridgestone-Firestone, Sainsbury’s and New York & Company. Before that, Justin served as Vice President of Software Development at LogicTools, now part of IBM's supply chain application software group. Justin holds a B.A. from Claremont McKenna College, a Ph.D. from the University of Oregon and an Executive Management certificate from Northwestern University's Kellogg School of Management.

Leave a Reply