In Excel worksheet D:

$1.$ Create a pivot table showing the counts of respondents$$ education level and their average spending amount paid yearly for hygiene products and services.

$2.$ Create a pivot table showing the counts of respondents$$ education level and their perception on whether advertisement reinforces specific gender stereotypes.

$3.$ Create a pivot table comparing the number of males versus females for each education level.

$4.$ Create a pivot table comparing the average spending amount between males and females.

$5.$ Create a pivot table comparing the average spending amount between males and females by each education level.

$6.$ Based on the results of the pivot tables, explain the role of education in this research project $(3$ sentences maximum$).$

Neatly organize each table. Include appropriate labels, format monetary values, and format numeric values to two decimal places as needed.