2.99 See Answer

Question: Jamie Drout is interested in perceptions of


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 are represented 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. Jamie’s project is focused on understanding consumer perceptions of these advertising strategies.
Jamie conducted a survey using the following questionnaire:
1. What is your gender?
Male
Female
2. What is your age?
3. 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. 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. 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.
6. 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. On average, how many of those advertisements, if any, specifically subscribe to gender roles and stereotypes?
8. On the following scale, what role, if any, do these advertisements have in reinforcing specific gender stereotypes?
Drastic
Influential
Limited
Trivial
None
9. 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. On average, what percentage of advertisements that you view or hear per day currently utilize empowerment advertising?
Assignment: Jamie received 105 responses, which are organized as a database in the Excel file Drout Advertising Survey.
1. 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.
2. Create some PivotTables to draw some initial insights from the data.
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. This case will continue in Chapters 3, 4, 6, and 7, and you will be asked to use a variety of descriptive analytics tools to analyze the data and interpret the results. Your instructor may ask you to add your insights to the report, culminating in a complete project report that fully analyzes the data and draws appropriate conclusions.



> Use the data in the Excel file Canned Food to find a multiple regression model to predict the total sales as a function of all the other given variables. State the model and explain R2, Significance F, and p-values.

> Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. State the model and explain R2, Significance F, and p-values.

> The Excel file World Tour Sales provides data on sales (£) and the number of radio, TV, and newspaper ads promoting the world tour for a group of countries. Develop simple linear regression models for predicting sales as a function of the number of each

> A consumer products company has collected some data relating to the advertising costs and sales of one of its products: What type of model would best represent the data? Use the Trendline tool to find the best among the options provided.

> In a toy manufacturing company, the manufacturer needs to pay rent (p) each month and monthly electricity (q). To produce each toy, the company incurs costs for plastic (r) and for cloth (s). The variables p, q, r, and s are positive constants. Given the

> Use the results (Weddings) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible outliers exist.

> Use the results (Student Grades) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible outliers exist.

> Use the results (Horsepower versus Gasoline) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible outliers exist.

> Use the results for Problem 10 (Demographics) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible outliers exist. Data from Problem 1

> Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and the couple’s income as the independent variable, only for those weddings paid for by the bride and groom. Interpret all key regression res

> Using the Excel file Weddings, apply the Regression tool using the wedding cost as the dependent variable and attendance as the independent variable. a. What is the regression model? b. Interpret all key regression results, hypothesis tests, and confiden

> Using the data in the Excel file Student Grades, apply the Excel Regression tool using the midterm grade as the independent variable and the final exam grade as the dependent variable. Interpret all key regression results, hypothesis tests, and confidenc

> The Excel file Horsepower versus Gasoline provides data on the amount of gasoline used per 100 miles by different brands of cars along with their horsepower. a. Construct a scatter diagram for gasoline used per 100 miles and horsepower in the given Excel

> Using the data in the Excel file Kidney, apply the Excel Regression tool using kidney frailty rates and age of a person as the variables. Interpret all key regression results, hypothesis tests, and confidence intervals in the output.

> According to a magazine, people read an average of more than three books in a month. A survey of 20 random individuals found that the mean number of books they read was 2.9 with a standard deviation of 1.23. a. To test the magazine’s claim, what should t

> The yearly government tax revenue (in $ millions) depends on customer income, business profits, and capital gains defined as tax = -2.556 + 3.799 *income + 1.583 * profit + 0.739 * capital. a. Interpret the numbers in this model. b. What is the governmen

> An analyst at a business school in France is assessing students’ performance. Historical records of applicants suggest that the mean score obtained by students attending the school is 350. The business school administration wants to know whether the perf

> A pharmaceutical company in Australia is testing a medical drug that intends to increase heart rate. A sample of 124 tests yielded a mean increase of 1.4 beats per minute, with a population standard deviation known to be 3.6. Since the company wants to a

> Looking at the data and information in the Excel file TV Viewing Survey, state some examples of interesting hypothesis tests by proposing null and alternative hypotheses.

> Conduct a chi-square test to determine if a normal distribution can reasonably model the sum of the midterm and final exam grades in the Excel file Student Grades.

> Conduct a chi-square test to determine if a normal distribution can reasonably model the expense data in the Excel file Travel Expenses.

> Conduct a chi-square test to determine if a normal distribution can reasonably model the data in the Excel file Airport Service Times.

> Four call service representatives were monitored over a period of three months. After each call, every customer was asked whether they were satisfied with the service by answering &acirc;&#128;&#156;Yes&acirc;&#128;&#157; or &acirc;&#128;&#156;No.&acirc;

> A manufacturer of automobiles is bringing out a new model. To create its advertising campaign, the manufacturer wants to determine whether the model&acirc;&#128;&#153;s appeal will be dependent on a particular age group. A sample of a customer survey rev

> For the following cross-tabulation data, which represent a count of the type of books that individuals prefer, verify that the assumptions of the chi-square test are not met, and aggregate the data in an appropriate way so that the assumptions are met. T

> Conduct the chi-square test for independence using the aggregated results using a level of significance of 0.05.

> Use the model to predict the total sales for weeks 2 through 16, and compare the results to the observed sales. Does the accuracy of the model seem to be different when coupons are used or not? When advertising is used or not?

> Looking at the data and information in the Excel file Retail Survey, state some examples of interesting hypothesis tests by proposing null and alternative hypotheses.

> The following cross-tabulation shows the number of people who rated a customer service representative as friendly and polite based on whether the representative greeted them first. a. Write the hypotheses for the chi-square test for independence. b. Find

> The cross-tabulation data given below represent the number of passed and failed results of male and female students at a university for the last semester. a. Write the hypotheses for the chi-square test for independence. b. Find the expected frequencies.

> The cross-tabulation data given below represent the number of males and females in a work group who feel overstressed and those who don&acirc;&#128;&#153;t. a. Write the hypotheses for the chi-square test for independence. b. Find the expected frequencie

> For the data in the Excel file Freshman College Data, a. use ANOVA to determine whether significant differences exist in the mean retention rate for the different colleges over the four-year period. b. use ANOVA to determine if significant differences ex

> Using the data in the Excel file Broadband Service Providers, apply ANOVA to determine if the mean response for value for the pound is the same for different types of broadband service providers in the United Kingdom.

> For the data in the Excel file Helpdesk Survey, determine if the mean overall satisfaction ratings differ by the ratings given for response time.

> For the Excel file Job Satisfaction, use ANOVA to determine if the mean overall job satisfaction ratings differ by department.

> Looking at the data and information in the Excel file Car Sharing Survey, state some examples of interesting hypothesis tests by proposing null and alternative hypotheses.

> Determine if there is evidence to conclude that rain fall in area A is significantly more than that of area B using the data in the Excel file Rainfall.

> A firm installs 1,500 air conditioners that need to be checked every six months. The firm can hire a team from its logistics department at a fixed cost of €6,000. This team will check each unit for €15.00. The firm can also outsource this at a cost of €1

> For the data in the Excel file Netflix Views Survey, conduct a hypothesis test to determine if married individuals watch less Netflix than single individuals.

> For the data in the Excel file Coffee Shop Preferences, conduct a hypothesis test to determine if price and taste ratings are the same for large/chain stores versus small/independent coffee shops.

> The Excel file Fortune100 Accountants provides the results of a survey of 35 employees in a tax division of a Fortune 100 company. a. Is there sufficient evidence at the 0.01 level of significance that the average number of years of service is the same

> A research group in Sweden estimated that almost 1.5 million people in Sweden have used Netflix from September to December 2018. Formulate an appropriate one-sample test of hypothesis to test this.

> Using the Excel file YouTube Hours, determine if the mean number of hours spent online per week is the same for males as it is for females.

> A two-sample test for means was conducted to determine if the completion time for continuing education programs for nurses differed when costs are paid by employers (Yes) versus when individuals paid out of his or her own funds (No). The following are th

> A two-sample test for means was conducted to test whether the mean number of movies watched each month differed between males and females. The Excel Data Analysis tool results are shown below. a. Explain how to use this information to draw a conclusion i

> The Excel file Room Inspection provides data for 100 room inspections at each of 25 hotels in a major chain. Management would like the proportion of nonconforming rooms to be less than 2%. Formulate a one sample hypothesis test for a proportion and perfo

> Suppose that a previous record of a blood donation campaign conducted in the city of London indicates that the probability of a donor having blood type O is 0.6. Of a sample of 120 donors who have come to donate blood at this year’s blood donation camp,

> A financial advisor believes that the proportion of investors who are risk-averse (that is, try to avoid risk in their investment decisions) is at least 0.6. A survey of 31 investors found that 19 of them were risk averse. Formulate a one-sample hypothes

> For each of the following scenarios, state whether descriptive, predictive, or prescriptive analytics tools would most likely be used. a. An insurance firm wants to analyze fraudulent claims to predict their future losses. b. A store manager has to revie

> An industry trade publication stated that the average profit per customer for this industry was greater than $4,500. The Excel file Sales Data provides data on a sample of customers. Using a test of hypothesis, do the data support this claim or not?

> A gym trainer in Cologne, Germany, believes that the average time spent exercising each day by the city is greater than 1.5 hours. Formulate an appropriate one sample test of hypothesis to test this belief.

> A survey on female health stated that the standard body fat percentage of a woman of the average age of 25 years with an average weight of 140 pounds and an average height of 64 inches is 16%. The Excel file Women Body Fat Percentage provides the data fo

> A computer repair firm believes that its average repair time is less than two weeks. Using the data in the Excel file Computer Fix Times, determine if the company can continue to support this claim.

> A diet program claims that the average amount of water that a person on a diet should drink each day to lose weight is 4 liters. A random sample of 13 people enrolled in the diet program found that the average consumption is 3.6 liters of water per day w

> A gum manufacturer claims that on average the flavor of an entire packet of its gum would last for more than 39 minutes. A quality controller selects a random sample of 55 packets of gum. She finds the average time for which the gum flavor lasts is 40 mi

> Using the data in the Excel file Consumer Transportation Survey, test the following null hypotheses: a. Individuals spend at least eight hours per week in their vehicles. b. Individuals drive an average of 600 miles per week. c. The average age of SUV dr

> A pharmacist believes that in manufacturing a pill or tablet medicine, the need for an active ingredient in each pill is less than 14 milligrams. She selects a random sample of 15 pills and determines that each pill has an average of 10.5 milligrams of t

> A marine biologist wants to use a parrotfish for research purposes as she believes that the variability of weights among parrotfish is small. From a random sample of 50 parrotfish, she found that their mean weight is 6.3 pounds with a standard deviation

> When President Donald Trump took office, he believed that the reason he did not win the popular vote was because 3 to 5 million people voted illegally. Explain how hypothesis testing might be used in a similar fashion as the legal analogy example.

> An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region as well as industry sales to assess future changes in market share

> Suppose that the mean score for the mathematics test cited in Problem 7 is 607. What is the probability that a random sample of 324 students will have a mean score of more than 619? Less than 588?

> In one region in your country, suppose that the standard deviation of monthly expenditure of the residents is about $7,000. In a random sample of 380 residents, what is the standard error of the mean monthly expenditure?

> Based on extensive data from a national high school educational testing program, the standard deviation of national test scores for mathematics was found to be 118 points. If a sample of 324 students are given the test, what would be the standard error o

> Using the Excel file Diabetes Check, draw five random samples by repeating the sampling experiment for sample sizes 10, 15, and 20. For each sample sizes, find the stabilized glucose point estimates for the mean and standard deviation. Estimate the sampl

> After launching a new range of health drinks, a local fitness company conducted a survey to understand how the products were being received. From a random sample of 500 customers, who were asked to participate in the survey, 230 had bought the new produc

> A gym instructor records the weights of a random sample of 31 male high school students. The mean weight was found to be 140 pounds and the standard deviation of this population is 20 pounds. How large a sample should be selected to estimate that the mea

> If a manufacturer conducted a survey among randomly selected target market households and wanted to be 99% confident that the difference between the sample estimate and the actual market share for its new product was no more than 6%, what sample size wou

> Trade associations, such as the United Dairy Industry Association, frequently conduct surveys to identify characteristics of their membership. If this organization conducted a survey to estimate the annual per capita consumption of milk and wanted to be

> The Excel file High Blood Pressure records the results of 30 individuals who were tested for hypertension. Use the Excel Sampling tool to obtain a random sample of 5 individuals and compute point estimates for the mean and standard deviation for the syst

> A survey of 23 patients at a hospital found 95% confidence intervals for the following: Construct a stock chart-based visualization of these confidence intervals. What conclusions can you draw from the chart?

> In reviewing the data in the Performance Lawn Equipment Database, Elizabeth Burke noticed that defects received from suppliers have decreased (worksheet Defects After Delivery). Upon investigation, she learned that in 2014, PLE experienced some quality p

> For the data in the Excel file Debt and Retirement Savings, find 95% confidence intervals for the mean income, long-term debt, and retirement savings for individuals who are single and individuals who are married. What conclusions can you reach by compar

> For the data in the Excel file Education and Income, find 95% confidence intervals for the mean annual income of males and the mean annual income of females. Can you conclude that the mean income of one group is larger than the other?

> Due to rapid developments in technology, the number of laptops per household has also increased. A study was conducted for two housing areas to determine the average number and proportion of laptops per household in both areas. The data recorded by the s

> The Excel file Professionality shows select lecturers at a university and their related information such as gender, status of current position, number of years in current position, highest degree, number of years of working since obtaining the degree, an

> A survey of 270 individuals found that one-sixth of them use their cell phones primarily for email. Can you conclude statistically that the population proportion who use cell phones primarily for email is less than 0.20?

> A survey of 50 young professionals found that they spent an average of $20.21 when dining out, with a standard deviation of $13.88. Can you conclude statistically that the population mean is greater than $23?

> According to Moovit Insights website, the average amount of time people in Singapore spend commuting to and from work, on a weekday, using public transport is 84 minutes. Recent studies have shown that 90% of people in Singapore took public transports to

> Using the data in the Excel file Accountants, find and interpret 90% confidence intervals for the following: a. mean years of service b. proportion of employees who have a graduate degree Use the appropriate formulas and Excel functions.

> A study was conducted to examine the time spent on studying by students at a university and whether they pass or fail a course. It found that to pass or fail a course the standard deviation were 5 hours and 7 hours, respectively. The study also found tha

> For the data in the Excel file Debt and Retirement Savings, find 95% confidence intervals for the mean income, long-term debt, and retirement savings. Use the appropriate formulas and Excel functions.

> Elizabeth Burke has identified some additional questions she would like you to answer using the Performance Lawn Equipment Database. 1. Are there significant differences in ratings of specific product/service attributes in the Customer Survey worksheet?

> The Excel file Diabetes Check contains the records of patients with diabetes who have received treatment at a local hospital. Number each row in the dataset and help the hospital to select a simple random sample of 20 unique results by using the Excel Sa

> For the data in the Excel file Grade Point Averages, find 90%, 95%, and 99% confidence intervals for the mean GPA. Compute the confidence intervals using the appropriate formulas and verify your results using the Excel Confidence Intervals template.

> A survey of 23 individuals found that they spent an average of $39.48 on headphones to use for exercising. The margin of error for a 95% confidence interval was found to be 21.2. a. What are the lower and upper limits of the confidence interval? b. What

> A sample of 40 individuals at a shopping mall found that the mean number of visits to a restaurant per week was 2.88 with a standard deviation of 1.59. Find a 99% confidence interval for the mean number of restaurant visits. Use the appropriate formula a

> A survey of 34 freshmen found that they get an average of 6.26 hours of sleep each night. A 90% confidence interval had a margin of error of 0.509. a. What are the lower and upper limits of the confidence interval? b. What was the standard deviation, ass

> A random sample of 100 teenagers was surveyed, and the mean number of songs that they had downloaded from the iTunes store in the past month was 9.4 with the results considered accurate being within 1.4 (18 times out of 20). a. What percent of confidence

> Each can of a certain brand of sweet corn contains an average of 375 corn kernels with a standard deviation of 8 in each can. Yesterday, Winnie went to a local store and purchased four cans of corn. a. Find the probability that the average number of corn

> In determining automobile mileage ratings, it was found that the mpg in the city for a certain model is normally distributed, with a mean of 41 mpg and a standard deviation of 1.8 mpg. Suppose that the car manufacturer samples five cars from its assembly

> Suppose that the mean monthly expenditure of the region identified in Problem 8 is $15,500. What is the probability that the random sample of 380 residents will have a mean monthly expenditure of more than $15,000? Less than $14,500?

> Your college or university wishes to obtain reliable information about student perceptions of administrative communication. Describe how to design a sampling plan for this situation based on your knowledge of the structure and organization of your colleg

> The background for this case was introduced in Chapter 2. This is a continuation of the case in Chapter 6. For this part of the case, propose and test some meaningful hypotheses that will help Ms. Drout understand and explain the results. Include two-sam

> Students in the new MBA class at a state university have the following specialization profile: Finance—83 Marketing—36 Operations and Supply Chain Management—72 Information Systems—59 Find the probability that a student is either a finance or a marketin

> Answer the following by referring to the scenario described in Problem 4. a. Let A be the event “without blue marble.” Find P(A). b. Let B be the event “first marble selected is green.” Find P(B). c. Let C be the event “last marble selected is red.” Find

> Refer to the ball scenario described in Problem 3. a. Let A be the event with the sum of the selected two balls is an odd number. Find P(A) and P(Ac). b. What is the probability that the sum of the two balls will not be more than 5? c. What is the probab

> The latest nationwide political poll in a particular country indicates that the probability for the candidate to be a republican is 0.55, a communist is 0.30, and a supporter of the patriots of that country is 0.15. Assuming that these probabilities are

> Compute the daily change of the closing price for the data in the Excel file S&P 500. Compute descriptive statistics, a frequency distribution, and histogram for the closing prices (using a bin width of 25). What probability distribution would you propos

> Apply the chi-square goodness of fit test to the data in the Airport Service Times Excel file to determine if an exponential distribution models the data. Use bins of width 100. Note that for an exponential distribution, the number of degrees of freedom

> Apply the chi-square goodness of fit test to the data in the Airport Service Times Excel file to determine if a normal distribution models the data. Use bins of width 100. Note that for a normal distribution, the number of degrees of freedom for the CHIS

2.99

See Answer