# Community Data Science Course (Spring 2019)/Day 8 notes

From CommunityData

Revision as of 04:33, 22 May 2019 by Benjamin Mako Hill (talk | contribs) (Benjamin Mako Hill moved page Day 8 notes to Community Data Science Course (Spring 2019)/Day 8 notes without leaving a redirect: wrong name)

Today we'll take a partial digression from python to talk about Pivot Tables in Excel.

Outline:

- Load the SDOT data from last time
- Creating basic pivot tables
- Rows, columns, values, filters
- Aggregation functions
- Common tricks
- Percentiles
- Visualizations
- Filters
- Sorting

- Stats! Let's talk about the Odds Ratio

Let's use what we learned to answer some questions

- What kinds of accidents are more likely to occur at Intersections than in a Block?
- Do accidents with speeding involved result in a higher chance of injury? (Hint: use an odds ratio)
- Look at columns HITPARKEDCAR and COLLISIONS. What do you notice about HITPARKEDCAR
- Is speeding more likely to result in injuries or death?
- what is the most dangerous corner in Seattle?
- What do JunctionType and AddrType tell you about this data set?