BUS 210 George Mason Advertisement Reinforces Specific Gender Stereotypes Worksheet

Worksheet: PART A

Problem 1: In column L, use the IF function to recode education using this classification:

• High school diploma = 1
• Some undergraduate courses = 2
• Associate Degree = 3
• Bachelor Degree = 4
• Any other degree (Masters, J.D., Doctorate) = 5

Problem 2: In column M, use the IF function and AVERAGE functions together to include a new column which assesses each respondent’s spending based on the following: If the respondent’s spending is greater than the overall average spending amount of all respondents, then display HIGH, otherwise, display NOT HIGH.

Worksheet: PART B

Use the VLOOKUP and MATCH functions together to find a record in the database by entering the respondent identification number.

Worksheet: PART C

In Excel worksheet C, create a pivot table for each question that displays the results of the survey in the following order.

Question 1 (Gender): The table should show how many males versus females responded to the survey.

Question 2 (Age): The table should show the age distribution of the respondents.

Question 3 (Education): The table should show the distribution of education levels of the respondents.

Question 8 (Reinforcing Gender Stereotypes): The table should show the count for each response to this question.

Question 9 (Transform Gender Stereotypes): The table should show the count for each response to this question.

Neatly organize each table. Include appropriate labels and monetary values. Display only two decimal points as needed.

Worksheet: PART D

In Excel worksheet D:

1. Create a pivot table that compares education level by the number (count) of respondents and the average spending amount paid yearly for hygiene products and services.

2. Create a pivot table that compares education level with the respondents’ perception on whether advertisement reinforces specific gender stereotypes.

3. Create a pivot table that shows a comparison between education level and the average spending amount between males and females.

4. Based on the results of the pivot tables, explain the role of education in this research project.

Neatly organize each table. Include appropriate labels and monetary values.