Class This is another example finding or creating
a bar graph and a pie chart for qualitative
data.
We're still using the class survey data with
previous class data Excel file that we used
for ethnicity in the previous example.
We're now looking at gender this is the one
we did in class that was question 6 and the
responses were either female or male and as
you look down the list there's no organization
here at all so the first thing we would need
to do is click on Column A so that we select
the entire column and then on our home menu
go to sort and filter and let's sort A to
Z.
What happens is all of the female responses
are first and the male responses are at the
bottom.
Now you could create a table for gender and
frequency so this is another frequency distribution.
let me reset the size of column e doesn't
want to do it so I'll manually move it over
for the genders.
The two genders were female and maile.
If we count these female there's one two three
four five six seven eight nine females and
then I'm going to have to scroll down so I
can see the entire end of the row or column
excuse me male there's one two three four
five six seven eight nine 10 11 12 13 14 15
16 17 18.
So there are 18 males.
We've created a frequency distribution.Let
me fix the spelling on frequency and this
is an option for qualitative data.
If we want the options for graphical displays
for qualitative data are of course the frequency
distribution table or chart but we also have
graphs such as a bar graph or a pie chart.
I'm going to select the table when I click
on gender and shade.
I'm going to try that again click on gender
and shade there we have about shaded or selected
the table of values the frequency distribution.
I go to the menu and select insert or click
on insert and there is a column chart which
we refer to as a bar graph Here you See Your
Chart and the name of the chart frequency
isn't a good name for our chart.
We can call this gender.
If we click on the + icon we can add data
labels.
If I go to more options, we can change where
we have the numbers (frequencies).
There are 9 females and 18 males.
We can add an axis title.
The vertical is the one I need to add the
axis title there this is where we need to
put "Frequency".
From the frequency distribution table we have
a bar graph.
Now you might also want to insert, let's select
the table again and insert a Pie Chart.
I'm going to pull the pie chart down a little
over here to the left and I'll move the bar
graph over to the right so we can see both
of these.
When I click on the Pie Chart, we might want
to do the data labels. and I can have "more
options" Let me try clicking the + icon again.
Data Labels, "More Options" There we go.
I'm going to include the category name and
percentage.
So this way you can see the relative frequencies
for the two categories.
We could add that to our frequency distribution
table so the Relative Frequency ...Let me
fix the width of our column So the relative
frequency for females is 33% and for males
is 67%.
We can change the relative frequencies from
percents to decimals if we'd rather we can
say that that's 33% or 0.33 as a decimal.
The 67% would be 0.67 as a decimal so you
can have relative frequencies of this way.
What we've done is we have used a process
where we first sort the data and then count
the number of times each category appears
as a response from the column of values.
In the next video we will use the pivot table
inserting a pivot table and chart to make
the process a little easier.
