00:01
In this exercise, we're given a table that lists the presidents of the united states and their state of birth.
00:09
Now, we're going to use this data to construct a frequency bar graph for the state of birth.
00:16
So, of interest, is the state of birth.
00:21
But first, i wish to arrange this data in a way that all the presidents and the states of birth are in two columns.
00:30
So what i want to do is to move the data in this excel sheet all the way down and then i want to give a summary or create a pivot table to get to see the different presidents and the accounts.
00:55
So what i want to do now is to select the column for the state of birth.
01:15
And then i go to the insert tab and then click on the pivot table.
01:20
So the range has already been selected.
01:24
So what i want to do is to select the cell which the summary should go to.
01:30
Then click ok.
01:33
Now the state of bath field should be dragged down to the rows section.
01:39
So i've done that.
01:40
And also should be dragged down to the total section...