From the course: Data Literacy: Exploring and Describing Data

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

Exploring tables

Exploring tables

From the course: Data Literacy: Exploring and Describing Data

Start my 1-month free trial Buy for my team

Exploring tables

“

- [Instructor] When you take the rows and columns of a spreadsheet, you can put them into tables, which again have rows and columns, but in a summary format that makes it easier to understand the patterns that are going on. For this example, I'm going to use the yoga studio data that we've used before, which you can access in Google Sheets at j.mp\yoga-studio-data, or you can open up the Microsoft Excel version that's available in our files. I'm going to take this and make it just a little bit larger for right now. And then this is the regular data. Again, we have one row for each class on each day. And I do have a table right here, but the one that I'm interested in is right here on tables day and session. And so let me show you what we've got. The original thing, which by the way I calculated using what's called a pivot table, shows the sum of attendance by day and session. In fact, let me show you. This is what the pivot table looks like, and this is something that a spreadsheet…

Contents