E1. Investigate the relationship between respondent’s sex (SEX) and highest degree earned

(DEGREE).

1. Use Excel’s PivotTable command to create a bivariate table of SEX (independent variable) and DEGREE (dependent variable).

2. What percentage of all respondents reported a high school diploma as their highest degree earned?

3. What percentage of males reported a bachelor’s degree was their highest degree earned?

4. What percentage of females reported a bachelor’s degree was their highest degree earned?

5. Does there appear to be a relationship between respondent’s sex and highest degree earned?

Use percentages in your answer.