This is a TurnItIn proctored INDIVIDUAL Learning Assignment and is worth 100 points . Week 6, Individual Case Analysis - Drout Advertising Research Project - Chapter 4 . Due Date: Sunday, June 16, 2019 at 11:55 PM --. Dear International Application of Quantitative Methods in Business Students: . Please read the following Data Analytics for Business case assigned for this Learning Week and please analyze and answer the Assignment(s) requested in this Case Analysis. .Assignment: Jamie received 105 responses, which are given in the Excel file Drout Advertising Survey. 1. Summarize the numerical data using frequency distributions and histograms, cross-tabulations, PivotTables, and descriptive statistics measures; find proportions for categorical variables; examine correlations; and so on. 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. . Please develop YOUR OWN Business Analytics Case Analysis EXCEL model(s) 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. . I expect high caliber Case Analysis Reports with top analyses and interesting insights!! If you have any questions, please let me know. I am here to help. . Jose Rocha - . Learning Assignment Guidelines . Case Analysis Written Report: This document should be a typed professional written report in Word and PDF format with a 1.5 max line space, a suitable font such as Times Roman or Calibri of 12 point maximum, and left, right, top, bottom margins of .8 inches maximum. . ** No Word and PDF format documents: No grading. . Please submit your Case Analysis Written Report and YOUR OWN Business Analytics Case Analysis EXCEL model(s) files. . ** No Case Analysis Written Report and YOUR OUR OWN Business Analytics Case Analysis EXCEL model(s) files: No grading. . TurnItIn Originality Score Index Case Analysis Reports with a TurnItIn Originality Score Index: * Orange (50-74% similarity index) and/or Red (75-100% similarity index) will NOT be graded and will be reviewed and assess for potential Academic Dishonesty misconduct. . Using APA Style and Tips in Writing You can find several readings and support material for your writing learning assignments and APA Style use at our Canvas Learning Management System section: Course Content: 1.2 Using APA Style and Tips in Writing Case Analysis Drout Advertising Research Project Backgound and Data Case Analysis Drout Advertising Research Project Drout+Advertising+Survey+Data.xlsx Reference: Business Analytics (3e). - James R. Evans. 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. Jamie conducted a survey using the following questionnaire: What is your gender? Male Female What is your age? 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 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 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, makeup, chemical hair color, razors, skin care, feminine care, and salon services. 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. On average, how many of those advertisements, if at all, specifically subscribe to gender roles and stereotypes? On the following scale, what role, if any, do these advertisements have in reinforcing specific gender stereotypes? Drastic Influential Limited Trivial None 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 On average, what percentage of advertisements that you view or hear per day currently utilize empowerment advertising?