Tip:
Highlight text to annotate it
X
Part 2 of 2, Now that we have the basic idea of sorting by single columns, let’s learn
how to sort by multiple levels. Lets go back to organizing the data by score.
Sort Creativity Score, Values Largest to Smallest. Notice that Jacob Marshall has the highest
score out of both the extrinsic and intrinsic group. But now I don’t just want to see
the highest out of both groups, I want to see the highest score out of first the Intrinsic
group and then out of the Extrinsic group. So now I want to Sort by Creative Group, then you see this button that says Add level,
this adds another level. Now you want sort then by Creative Score.
Now this allows me to see who scored the highest in each group. We can see that Jacob Marshall scored the
highest out of the Intrinsic group and Harris Teeter scored the highest out of the extrinsic
group. Having them sorted by creativity group lets me see specific trends among each group.
Notice how the extrinsic group consists of people who are majoring in Science, Engineering,
or Business, and the highest score comes from a person who is majoring in art. And most
of the people in the Intrinsic group, which scored significantly higher, are mostly English
or Creative Writing majors. Let’s take sorting our last name and first
name to another level. We can sort columns within columns. First by Creativity Group,
then by Last name, then by first name.
The creativity Group chosen as first level, and then I’ll add another level, last name
from A to Z, then by first name. Notice how the subjects are arranged according
to their Creativity Group. Notice, how the subjects are also alphabetically ordered by
their last name. Furthermore, if the subjects have the same last name, they have been alphabetized
further by their first name. For example, if you take a closer look at Davidson, notice
how all the people with the Last name Davidson, are also alphabetized by their first name
too. From Andy to Zach. The same occurs with Summers and Smith.
Now I can do a few more examples that require multiple levels. I would like to see if there
is any correlation between gender and creativity score. Click Sort
by Gender, next Values. Then From A to Z. This option will allow me to make the Females
come first or the Males come First. Then by Creativity Score. Values. Largest to Smallest. Now I can see
, now I can see the range of Creativity scores among the Males and females. Surprisingly,
the males have the, the males have the top two scores for being Creative. However, the
general scores of the male range from 5 to 29.7, while the females have a range where
the minimum value is 12. This type of sorting allows me to recognize important information
or pick up on different patterns. Now, I have demonstrated how to sort data individually
and by multiple levels