In this video, I gonna  try to show you the 
quickest and most efficient way to make a pie 
chart, a frequency table and a pie chart if you 
have a really large set of data. And what I'm 
gonna use to do this is the Teen Maze data, and  
I'm gonna do it for item Q1.
So the first thing that I need to do is make some 
room for the frequency table.
So I'm gonna click on the column and right click 
and insert to insert another column. And I'm 
gonna do that twice.
then in column F here beside my data, I'm 
gonna make the numbers that we're gonna 
count. So 1 through 5
So we have to tell it what we're trying to count, 
and then we're ganna use the command to do 
it. We're gonna type 
equals to tell it we're doing a math formula and 
then frequency
and then you have to tell it where the data is 
located. You can type in the cell numbers but I 
like to click and drag.
This can take awhile if you have a really big set 
of data. We have about 300 something here in 
the Teen Maze (data).
and then I'm gonna click "comma", and then I'm 
going over to the side. Gonna scroll back up
and then select the
the bin arrays which are the numbers that its 
gonna count. And close that up and hit enter.
And it counted all of the ones. To get the rest of 
them, what I have to do is click on that cell, drag 
it
and select all five of the cells, and then hit
F2 to select everything, and then 
control+shift+enter (together)
So that was F2 followed by control+shift+enter
And there's the frequency table. Apparently Q1, 
there were five students that responded with a 
1.
16 that responded with a 2 and so on. And then 
to make the pie chart, I just select those entries
click on insert; click on the pie chart picture; and 
there you go. I can change the label,
or deleted it. I can click on the pie chart, right 
click, and tell it to add labels
I can click on those labels, right click and tell it 
to format the labels, and then I'm gonna go over 
and tell it to show percents.
So there is my pie chart that counts the 
outputs, and it looks like 33% responded with a 
5, 27 percent with a 4, and so on.
So that is how you can use excel pretty quickly 
to make a frequency table and a pie chart.
