Fluent Essays

Please read the following Data Analytics for Business case in the excel file and please analyze the data on the data page with a written report and excel model file requested in this Case Analysis. Please submit the Case Analysis Written Report AND the Business Data Analytics Case Analysis EXCEL model files pertaining approiate charts that Summarize the data using frequency distributions and histograms for numerical variables, cross-tabulations, and other appropriate applications of PivotTables to break down and visualize the data. LABEL and/or PLACE the appropriate headings and subheadings clearly for EACH part of the question and/or section.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 masculiJamie 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 https://hbr.org/1982/09/consulting-is-more-than-giving-advice · Data Analysis Steps https://www.r-bloggers.com/data-analysis-steps/ · The Difference Between Reporting and Analysis and Why it Matters https://datahero.com/blog/2017/08/14/data-reporting-and-analysis/ · How to Write a Data Report https://smallbusiness.chron.com/write-data-report-61330.html · The Seven Key Steps of Data Analysis https://rizkashifs.wordpress.com/2015/09/03/the-seven-key-steps-of-data-analysis/