From the course: Excel PivotTables: Real-World Case Studies

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

U.S. voters

U.S. voters - Microsoft Excel Tutorial

From the course: Excel PivotTables: Real-World Case Studies

Start my 1-month free trial

U.S. voters

“

- [Instructor] Alrighty so the first case study that we're going to dive into is for US voters in 2012. Now a quick dataset summary. This is 2012 population and voter registration data from the US Census Bureau, broken down by state and by age group. So you can see the screenshot of the dataset here on the right side of the slide, and what I've done here is actually format the column headers to indicate what we're working with in terms of dimensions or measures. So again, dimensions are your categorical fields. Measures are your numerical or quantitative fields. So the n=255, just indicates that we're looking at 255 records or rows of data in this case, so pretty small dataset to kick things off. As far as dimensions are concerned, we've got two: state and age in columns A and B. And then for measures we've got total population, citizen population, registered voters, and confirmed voters. And the concepts that we'll cover in this particular case study are calculated fields and value…

Contents