Title: Analyzing Consumer Perceptions of Gender Stereotypes and Empowerment Advertising in Beauty Product Advertising

Assignment:
Jamie received 105 responses, which are given in the Excel file Drout Advertising Survey.
Review the questionnaire and classify the data collected from each question as categorical, ordinal, interval, or ratio.
Next, explain how the data and subsequent analysis using business analytics might lead to a better understanding of stereotype versus empowerment advertising. Specifically, state some of the key insights that you would hope to answer by analyzing the data.
Use appropriate charts to visualize the data. Summarize the data using frequency distributions and histograms for numerical variables, cross-tabulations, and other appropriate applications of PivotTables to break down the data and develop useful insights.
An important aspect of business analytics is good communication. Write up your answers to this case formally in a well-written report as if you were a consultant to Ms. Drout USING our class:
Please develop YOUR OWN Business Data Analytics EXCEL models to support all your answers and analyses and post this(these) file(s) in addition to your Case Analysis Drout Advertising Research Project Report.
Finally, please answer ALL Questions and Sections of this Data Analytics for Business Case with great detail AND STEP BY STEP being extremely methodical and accurate in your answers. It is extremely important that for each Question and Section, you write the entire question and you LABEL and/or PLACE the appropriate headings and subheadings clearly for EACH part of the question and/or section.
Please address, analyze, and discuss in great detail and thoroughly support and explain the what’s, how’s, and why’s of each of your answers.
Case Analysis Background
Jamie Drout is interested in perceptions of gender stereotypes within beauty product advertising, which includes soap, deodorant, shampoo, conditioner, lotion, perfume, cologne, makeup, chemical hair color, razors, skin care, feminine care, and salon services; as well as the perceived benefits of empowerment advertising. Gender stereotypes specifically use cultural perceptions of what constitutes an attractive, acceptable, and desirable man or woman, frequently exploiting specific gender roles, and are commonly employed in advertisements for beauty products. Women are represented as delicately feminine, strikingly beautiful, and physically flawless, occupying small amounts of physical space that generally exploit their sexuality; men as strong and masculine with chiseled physical bodies, occupying large amounts of physical space to maintain their masculinity and power. In contrast, empowerment advertising strategies negate gender stereotypes and visually communicate the unique differences in each individual. In empowerment advertising, men and women are to represent the diversity in beauty, body type, and levels of perceived femininity and masculinity. Her project is focused on understanding consumer perceptions of these advertising strategies.
**On the Template, Please do 1 through 5 and and include whats in this text box**