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 .

The overall structure of a data analysis report is simple: 1. Introduction 2. Body 3. Conclusion(s)/Discussion 4. Appendix/Appendices Supporting Documents for this Learning Assignment · Structure of a Data Analysis Report PDF Document · Consulting Is More Than Giving Advice · Data Analysis Steps · The Difference Between Reporting and Analysis and Why it Matters · How to Write a Data Report · The Seven Key Steps of Data Analysis Questionnaire Question Variable Survey Question 1 Gender What is your gender?

Male Female 2 Age What is your age? 3 Education What is the highest level of education you have completed? Some High School Classes High School Diploma Some Undergraduate Courses Associate Degree Bachelor Degree Master Degree J.D. M.D. Doctorate Degree 4 Income What is your annual income?

Jamie Received 105 Responses Which Are Given In The Excel Filedrouta

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 .

The overall structure of a data analysis report is simple: 1. Introduction 2. Body 3. Conclusion(s)/Discussion 4. Appendix/Appendices Supporting Documents for this Learning Assignment · Structure of a Data Analysis Report PDF Document · Consulting Is More Than Giving Advice · Data Analysis Steps · The Difference Between Reporting and Analysis and Why it Matters · How to Write a Data Report · The Seven Key Steps of Data Analysis Questionnaire Question Variable Survey Question 1 Gender What is your gender?

Male Female 2 Age What is your age? 3 Education What is the highest level of education you have completed? Some High School Classes High School Diploma Some Undergraduate Courses Associate Degree Bachelor Degree Master Degree J.D. M.D. Doctorate Degree 4 Income What is your annual income? $0 to < $10,000 $10,000 to < $20,000 $20,000 to < $30,000 $30,000 to < $40,000 $40,000 to < $50,000 $50,000 to < $60,000 $60,000 to < $70,000 $70,000 to < $80,000 $80,000 to < $90,000 $90,000 to < $110,000 $110,000 to < $130,000 $130,000 to < $150,000 $150,000 or More 5 Spending On average, how much do you pay for beauty and hygiene products or services per year?

Include references to the following products: soap, deodorant, shampoo, conditioner, lotion, perfume, cologne, make-up, chemical hair color, razors, skin care, feminine care, and salon services. 6 Ad Frequency On average, how many beauty and hygiene advertisements, if at all, do you think you view or hear per day? Include references to the following advertisements: television, billboard, internet, radio, newspaper, magazine, and direct mail. 7 Stereotype On average, how many of those advertisements, if at all, specifically subscribe to gender roles and stereotypes? 8 Reinforcing On the following scale, what role, if any, do these advertisements have in reinforcing specific gender stereotypes?

Drastic Influential Limited Trivial None 9 Transform To what extent do you agree that empowerment advertising, which explicitly communicates the unique differences in each individual, would help transform cultural gender stereotypes? Strongly Agree Agree Somewhat Agree Neutral Somewhat Disagree Disagree Strongly Disagree 10 Empowerment% On average, what percentage of advertisements that you view or hear per day currently utilize empowerment advertising? 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. Data Respondent Gender Age Education Income Spending Ad Frequency Stereotype Reinforcing Transform Empowerment% 1 Female 23 Some undergraduate courses $10,000 to < $20,000 $500. Drastic Strongly Agree 10% 2 Male 22 High school diploma $20,000 to < $30,000 $75. Influential Somewhat Agree 2% 3 Female 24 Bachelor Degree $60,000 to < $70,000 $1,500. Influential Neutral 8% 4 Female 23 Bachelor Degree $30,000 to < $40,000 $500.

Influential Agree 0% 5 Female 23 Bachelor Degree $30,000 to < $40,000 $4,000. Influential Agree 10% 6 Female 24 Bachelor Degree $10,000 to < $20,000 $300. Drastic Agree 10% 7 Female 30 Doctorate Degree $60,000 to < $70,000 $700. Influential Somewhat Agree 10% 8 Female 28 Bachelor Degree $50,000 to < $60,000 $500. Influential Somewhat Agree 5% 9 Female 20 Some undergraduate courses $0 to < $10,000 $1,000.

Drastic Strongly Agree 10% 10 Male 24 Some undergraduate courses $20,000 to < $30,000 $337. Drastic Strongly Agree 1% 11 Female 24 Associate Degree $20,000 to < $30,000 $600. Influential Strongly Agree 3% 12 Female 24 Bachelor Degree $30,000 to < $40,000 $240. Limited Agree 0% 13 Female 27 Bachelor Degree $70,000 to < $80,000 $3,000. Influential Somewhat Agree 0% 14 Female 24 Master Degree $0 to < $10,000 $250.

Influential Neutral 10% 15 Female 21 Bachelor Degree $0 to < $10,000 $500. Influential Agree 10% 16 Female 23 Master Degree $70,000 to < $80,000 $2,500. Drastic Strongly Agree 2% 17 Female 23 Master Degree $50,000 to < $60,000 $2,000. Drastic Strongly Agree 1% 18 Female 20 Some undergraduate courses $0 to < $10,000 $400. Influential Strongly Agree 5% 19 Female 46 J.D. $10,000 to < $20,000 $100.

Influential Somewhat Disagree 0% 20 Female 23 Bachelor Degree $40,000 to < $50,000 $1,000. Influential Agree 10% 21 Female 23 Some undergraduate courses $10,000 to < $20,000 $750. Drastic Strongly Agree 15% 22 Male 23 Associate Degree $10,000 to < $20,000 $400. Influential Agree 10% 23 Female 21 Some undergraduate courses $0 to < $10,000 $800. Influential Strongly Agree 5% 24 Male 23 Associate Degree $20,000 to < $30,000 $500.

Trivial Somewhat Agree 10% 25 Male 19 Some undergraduate courses $0 to < $10,000 $600. Influential Agree 5% 26 Female 59 Associate Degree $150,000 or more $2,500. Drastic Strongly Agree 0% 27 Female 65 Doctorate Degree $70,000 to < $80,000 $350. Influential Somewhat Agree 0% 28 Male 32 Bachelor Degree $90,000 to < $110,000 $400. Limited Somewhat Agree 0% 29 Female 50 Doctorate Degree $40,000 to < $50,000 $350.

Drastic Strongly Agree 1% 30 Male 23 Bachelor Degree $20,000 to < $30,000 $200. Influential Somewhat Agree 0% 31 Female 31 Some undergraduate courses $20,000 to < $30,000 $200. Drastic Neutral 0% 32 Male 25 Bachelor Degree $0 to < $10,000 $100. Influential Somewhat Agree 0% 33 Male 23 Some undergraduate courses $20,000 to < $30,000 $100. Drastic Agree 1% 34 Female 55 J.D. $110,000 to < $130,000 $1,000.

Influential Agree 10% 35 Female 68 Doctorate Degree $110,000 to < $130,000 $1,500. Influential Agree 0% 36 Female 21 Some undergraduate courses $0 to < $10,000 $50. Drastic Agree 0% 37 Male 22 Bachelor Degree $20,000 to < $30,000 $100. Limited Strongly Agree 2% 38 Male 27 Master Degree $0 to < $10,000 $250. Influential Somewhat Agree 20% 39 Female 33 Doctorate Degree $60,000 to < $70,000 $250.

Drastic Somewhat Agree 0% 40 Female 32 Master Degree $70,000 to < $80,000 $310. Influential Agree 0% 41 Female 22 Some undergraduate courses $0 to < $10,000 $40. Drastic Strongly Agree 0% 42 Female 44 Bachelor Degree $60,000 to < $70,000 $1,000. Drastic Agree 10% 43 Female 49 Bachelor Degree $50,000 to < $60,000 $600. Influential Somewhat Agree 0% 44 Female 22 High school diploma $10,000 to < $20,000 $5,000.

Drastic Strongly Agree 0% 45 Female 26 Master Degree $30,000 to < $40,000 $2,500. Limited Agree 5% 46 Female 49 Bachelor Degree $50,000 to < $60,000 $500. Influential Agree 0% 47 Female 58 Doctorate Degree $90,000 to < $110,000 $500. Influential Somewhat Agree 5% 48 Female 61 Bachelor Degree $30,000 to < $40,000 $300. Drastic Somewhat Agree 10% 49 Female 21 Bachelor Degree $0 to < $10,000 $1,200.

Influential Agree 0% 50 Female 24 Bachelor Degree $10,000 to < $20,000 $400. Drastic Somewhat Agree 0% 51 Female 27 Bachelor Degree $40,000 to < $50,000 $500. Influential Somewhat Agree 15% 52 Female 21 Some undergraduate courses $0 to < $10,000 $400. Influential Strongly Agree 0% 53 Female 25 Associate Degree $0 to < $10,000 $50. Drastic Strongly Agree 0% 54 Female 23 Bachelor Degree $20,000 to < $30,000 $500.

Influential Agree 20% 55 Female 23 Bachelor Degree $50,000 to < $60,000 $1,500. Drastic Somewhat Agree 10% 56 Female 23 Bachelor Degree $20,000 to < $30,000 $150. Influential Strongly Agree 10% 57 Female 23 Bachelor Degree $10,000 to < $20,000 $400. Influential Somewhat Agree 2% 58 Male 23 Bachelor Degree $0 to < $10,000 $75. Limited Agree 20% 59 Female 46 Some undergraduate courses $0 to < $10,000 $600.

Influential Strongly Agree 1% 60 Female 39 Doctorate Degree $60,000 to < $70,000 $100. Influential Somewhat Agree 1% 61 Male 27 Bachelor Degree $20,000 to < $30,000 $390. Drastic Strongly Agree 1% 62 Female 24 Bachelor Degree $30,000 to < $40,000 $350. Influential Agree 10% 63 Male 23 Bachelor Degree $0 to < $10,000 $200. Influential Somewhat Agree 5% 64 Male 22 Bachelor Degree $0 to < $10,000 $25.

Trivial Disagree 0% 65 Female 24 Bachelor Degree $0 to < $10,000 $300. Influential Somewhat Agree 0% 66 Female 20 Some undergraduate courses $0 to < $10,000 $800. Drastic Strongly Agree 10% 67 Female 23 Bachelor Degree $10,000 to < $20,000 $300. Drastic Strongly Agree 10% 68 Male 25 Bachelor Degree $20,000 to < $30,000 $100. Influential Somewhat Agree 25% 69 Male 19 Some undergraduate courses $10,000 to < $20,000 $250.

Influential Agree 10% 70 Female 25 Master Degree $10,000 to < $20,000 $180. Drastic Agree 0% 71 Female 23 Bachelor Degree $10,000 to < $20,000 $500. Drastic Somewhat Agree 5% 72 Female 23 Some undergraduate courses $10,000 to < $20,000 $400. Influential Strongly Agree 1% 73 Female 20 Some undergraduate courses $0 to < $10,000 $250. Drastic Agree 2% 74 Female 64 Doctorate Degree $90,000 to < $110,000 $500.

Influential Neutral 0% 75 Female 49 Master Degree $30,000 to < $40,000 $20. Influential Strongly Agree 0% 76 Female 26 Bachelor Degree $0 to < $10,000 $240. Influential Agree 10% 77 Female 29 Some undergraduate courses $10,000 to < $20,000 $600. Drastic Strongly Agree 5% 78 Female 23 Master Degree $30,000 to < $40,000 $500. Influential Strongly Agree 10% 79 Female 23 Bachelor Degree $30,000 to < $40,000 $500.

Drastic Strongly Agree 7% 80 Female 22 Some undergraduate courses $30,000 to < $40,000 $1,500. Drastic Strongly Agree 0% 81 Female 26 Master Degree $20,000 to < $30,000 $200. Drastic Somewhat Agree 10% 82 Female 24 Bachelor Degree $10,000 to < $20,000 $1,000. Influential Strongly Agree 10% 83 Female 29 Master Degree $30,000 to < $40,000 $1,500. Influential Neutral 10% 84 Male 27 High school diploma $20,000 to < $30,000 $50.

Influential Somewhat Agree 8% 85 Female 22 Bachelor Degree $10,000 to < $20,000 $300. Influential Somewhat Agree 10% 86 Female 54 Doctorate Degree $90,000 to < $110,000 $2,000. Influential Agree 1% 87 Female 26 Master Degree $10,000 to < $20,000 $550. Influential Somewhat Agree 0% 88 Female 40 Some undergraduate courses $90,000 to < $110,000 $1,000. Influential Agree 0% 89 Female 19 Some undergraduate courses $0 to < $10,000 $80.

Influential Agree 5% 90 Female 24 Bachelor Degree $50,000 to < $60,000 $1,500. Influential Agree 0% 91 Female 22 Bachelor Degree $10,000 to < $20,000 $200. Influential Somewhat Agree 20% 92 Female 24 Bachelor Degree $20,000 to < $30,000 $250. Drastic Somewhat Agree 0% 93 Female 20 Some undergraduate courses $0 to < $10,000 $200. Drastic Strongly Agree 5% 94 Female 24 Associate Degree $30,000 to < $40,000 $100.

Influential Strongly Agree 5% 95 Female 27 Bachelor Degree $30,000 to < $40,000 $1,500. Influential Somewhat Agree 0% 96 Female 30 Some undergraduate courses $50,000 to < $60,000 $600. Drastic Strongly Agree 10% 97 Female 25 Master Degree $10,000 to < $20,000 $50. Influential Somewhat Agree 10% 98 Female 54 Master Degree $50,000 to < $60,000 $100. Influential Agree 0% 99 Male 37 Bachelor Degree $110,000 to < $130,000 $400.

Trivial Neutral 30% 100 Female 23 Master Degree $80,000 to < $90,000 $200. Influential Somewhat Agree 15% 101 Female 21 Some undergraduate courses $0 to < $10,000 $200. Influential Somewhat Agree 1% 102 Female 42 Doctorate Degree $50,000 to < $60,000 $600. Influential Somewhat Agree 0% 103 Female 23 Bachelor Degree $10,000 to < $20,000 $380. Drastic Strongly Agree 5% 104 Female 32 Master Degree $10,000 to < $20,000 $100.

Drastic Somewhat Agree 0% 105 Female 24 Bachelor Degree $30,000 to < $40,000 $250. Influential Agree 2%