2.2 - Excel pivot tables and group by

Thursday, January 23

In class

  • Understanding group by / pivot tables
  • Creating a crosstab

Data used in class:

Due this week

Sunday, Jan. 26: Assignment to filter, sort and group on one week of Phoenix police calls for service data.

Preparation

Tutorials

  • Group By tutorial, and follow along using this dataset (NOTE: I converted Matt’s original dataset into Excel – we haven’t gotten to data file types yet. We’ll get there right after the test.). Make sure to look at the video embedded in the middle to walk you through it. )

  • Pivot tables with baseball stats. Try doing this tutorial with a newer dataset of the 2019 season that might be a little easier to understand, since the record wasn’t as even in wins versus losses.

Reading