F. Descriptive Statistics: Grouping Variables

Analyses

• Using a pivot table, group the data by education level. Use the following groupings:

Less than 12 = less than high school diploma

o

12 = high school diploma

13-15 = some college

16 = bachelor's degree

o

17 and over = some graduate school/ graduate degree

Use crosstabulation to display the relationship between education level and gender.

Create a stacked bar chart to display the relationship between education level and gender as

well.

O

Questions

15. What percentage of men have a bachelor's degree as their highest education level? Women?

16. What percentage of those who have a high school diploma as their highest education level are

men? Women?