Frontis

1

Principles of Scientific Graphical Display

1

Principles of Graphics

2

Overview of the Datasets Available for the Class

3

An Experiment in Graphical Perception

4

Critiquing a Graphic for Graphicacy

2

Getting Started with Data

5

Setting up Your Accounts

6

Creating a Simple Database – An Excel Strawman

7

Overview of SQL

8

Creating a Simple Database – Now with PostgreSQL

9

Simple SQL

3

Introduction to R

10

An Introduction to R and R Studio

11

Setting Up R

12

A Starting Point – Some Simple R

13

Reading in Data Files

14

R Plots

15

Learning Some Simple Plotting Features of R

act15_SomeSimplePlotting.r

16

Your First Advanced Plot

17

Code Sharing

18

Thinking like a Computer – Pseudo-coding and Functions

act18_ThinkLikeComputer.r

19

Write Your Own Function

act19_WriteYourOwnFunction.r

20

Connecting to the Class Database via RODBC and PostgresSQL Drivers

21

Using R with PostgreSQL

act21_RwSQL.r

22

Packages

23

Working with Time in R

act23_Time_Lubridate.R

4

Using Graphics for Exploratory Data Analysis

24

Interactive Review of Basic Statistics Using R

25

Basic Charts for Single Discrete Variable

26

Exploring Single Discrete Variable Plots

27

Exploratory and Diagnostic Plots for the Distribution of a Single Continuous Variable

28

Probability Distributions

29

Kernel Density Estimates and Histograms

30

Diagnosing a Distribution

31

Depicting the Distribution Involving Discrete Variables

32

Depicting the Distribution of Two Continuous Variables

33

Introduction of Final Project Topics

34

One and Two Sample Tests

35

Exploring Confidence Intervals and Simple Hypothesis Testing

36

An Application of Hypothesis Testing

5

Data Exploration for Understanding

37

Advanced Multivariate Continuous Displays and Diagnostics

38

Introduction to Random Sampling

act38_RandomSampling.R

6

Putting it All Together: An Independent Structured Analysis

T1

Assessing The Accessibility Of Trimet Bus Stops

T2

Assessing Trimet Bus Headway Reliability

T3

Bicycle Performance

T4

Freeway Data and Incidents

T5

Freeway Data and Weather

T6

WIM Data – Side By Side Loadings

Appendix

Dataset Narratives

Other Helpful Resources

Required:

Scientific Approaches to Transportation Research Volumes 1 and 2

Manuals:

R Manual

PostgreSQL 8.1.23 Documentation

R Help:

Quick R

R reference card

Great color reference PDF Image Maindonald & Braun, Data Analysis and Graphics Using R. Cambridge University Press, 2003

Excellent (indespensible) graph layout reference and parameters - Paul Murrell's R Graphics