Rob's Market
Rob's Market (RM) is a regional food store chain in the southwest United States. David White, director of Business Intelligence for RM, would like to initiate a study of the purchase behavior of customers who use the RM loyalty card (a card that customers scan at checkout to qualify for discounted prices). The use of the loyalty card allows RM to capture what is known as "point-of-sale" data, that is, a list of products purchased by a given customer as he/she checks out of the market. David feels that understanding of which products tend to be purchased together could lead to insights for better pricing and display strategies as well as a better understanding of sales and the potential impact of different levels of coupon discounts. This type of analysis is known as market basket analysis, as it is a study of what different customers have in their shopping baskets as they check out of the store.
As a study, David wants to investigate customer buying behavior with regard to bread, jelly, and peanut butter. RM's Information Technology (IT) group, at David's request, has provided a data set of purchases by 1000 customers over a one-week period. The data set contains the following variables for each customer:
• Bread - wheat, white, or none
• Jelly - grape, strawberry, or none
• Peanut butter - creamy, natural, or none
The variables appear in the above order from left to right in the data set, where each row is a customer. For example, the first record of the data set is
white grape none
which means that customer #1 purchased white bread, jelly, and no peanut butter.
The second record is
white strawberry none
which means that customer purchased white bread, strawberry jelly, and no peanut butter. The sixth record in the data set is
none none none
which means that the sixth customer did not purchase bread, jelly, or peanut butter.
Other records are interpreted in a similar fashion.
David would like you to do an initial study of the data to get a understanding of RM customer with regard to these three products.
Managerial Report
Prepare a report that gives insight into the purchase behavior of customers who use the RM loyalty card. At a minimum your report should include estimates of the following:
6. The probability that a random customer purchases creamy peanut butter given that he/she purchases white bread.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
- In the digital age of marketing, special care must be taken to ensure that programmatic ads appear on websites aligned with a company’s strategy, culture, and ethics. For example, in , Nordstrom, Amazon, and Whole Foods each faced boycotts from social media users when automated ads for these companies showed up on the Breitbart website (ChiefMarketer.com website). It is important for marketing professionals to understand a company's values and culture. The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 9 8 8 8 8 9 7 7 8 8 7 7 9 8 8 7 7 8 Use a = 0.05 to test for a significant difference in perception among the three groups. Compute the values identified below (to 2 decimals, if necessary). Sum of Squares, Treatment Sum of Squares, Error Mean Squares,…arrow_forwardIn the digital age of marketing, special care must be taken to ensure that programmatic ads appear on websites aligned with a company’s strategy, culture, and ethics. For example, in 2017, Nordstrom, Amazon, and Whole Foods each faced boycotts from social media users when automated ads for these companies showed up on the Breitbart website (ChiefMarketer.com website). It is important for marketing professionals to understand a company's values and culture. The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 6 10 6 5 10 7 4 9 6 5 9 5 6 10 6 4 9 6 a. Use a = 0.05 to test for a significant difference in perception among the three groups. Compute the values identified below (to 2 decimals, if necessary). Sum of Squares, Treatment Sum of Squares, Error Mean…arrow_forwardIn the digital age of marketing, special care must be taken to ensure that programmatic ads appear on websites aligned with a company’s strategy, culture, and ethics. For example, in 2017, Nordstrom, Amazon, and Whole Foods each faced boycotts from social media users when automated ads for these companies showed up on the Breitbart website (ChiefMarketer.com website). It is important for marketing professionals to understand a company's values and culture. The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 10 8 11 9 8 12 8 7 11 9 7 10 10 8 11 8 7 11 a. Use a= 0.05 to test for a significant difference in perception among the three groups. Compute the values identified below (to 2 decimals, if necessary). Sum of Squares, Treatment ? Sum of Squares, Error ? Mean…arrow_forward
- In the digital age of marketing, special care must be taken to ensure that programmatic ads appear on websites aligned with a company’s strategy, culture, and ethics. For example, in 2017 , Nordstrom, Amazon, and Whole Foods each faced boycotts from social media users when automated ads for these companies showed up on the Breitbart website (ChiefMarketer.com website). It is important for marketing professionals to understand a company's values and culture. The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 6 5 6 5 5 7 4 4 6 5 4 5 6 5 6 4 4 6 a. Use to test for a significant difference in perception among the three groups. Compute the values identified below (to 2 decimals, if necessary). Sum of Squares, Treatment Sum of Squares, Error Mean Squares,…arrow_forwardThe success of an airline depends heavily on its ability to provide a pleasant customer experience. One dimension of customer service on which airlines compete is on-time arrival. The tables below contains a sample of data from delayed flights showing the number of minutes each delayed flight was late for two different airlines, Company A and Company B. Company A 34 59 43 30 3 32 42 85 30 48 110 50 10 26 70 52 83 78 27 70 27 90 38 52 76 Company B 44 63 43 34 67 104 45 28 38 84 76 45 33 49 63 43 36 34 65 65 (a) Formulate the hypotheses that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. (Let ?1 = population mean minutes late for delayed Company A flights and ?2 = population mean minutes late for delayed Company B flights.) H0: ?1 − ?2 ≥ 0 Ha: ?1 − ?2 < 0 H0: ?1 − ?2 < 0 Ha: ?1 − ?2 = 0 H0: ?1 − ?2 ≠ 0 Ha: ?1 − ?2 = 0 H0: ?1 − ?2 = 0 Ha: ?1 − ?2 ≠ 0 H0: ?1 − ?2 ≤…arrow_forwardThe success of an airline depends heavily on its ability to provide a pleasant customer experience. One dimension of customer service on which airlines compete is on-time arrival. The tables below contains a sample of data from delayed flights showing the number of minutes each delayed flight was late for two different airlines, Company A and Company B. Company A 34 59 43 30 3 32 42 85 30 48 110 50 10 26 70 52 83 78 27 70 27 90 38 52 76 Company B 46 65 42 33 67 105 44 28 37 86 74 44 33 50 62 43 34 34 65 65 (a)Formulate the hypotheses that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. (Let ?1 = population mean minutes late for delayed Company A flights and ?2 = population mean minutes late for delayed Company B flights.) H0: ?1 − ?2 = 0 Ha: ?1 − ?2 ≠ 0 H0: ?1 − ?2 < 0 Ha: ?1 − ?2 = 0 H0: ?1 − ?2 ≤ 0 Ha: ?1 − ?2 > 0 H0: ?1 − ?2 ≥ 0 Ha: ?1 − ?2 < 0 H0: ?1 − ?2…arrow_forward
- A landscaping company has collected data on home values (in thousands of $) and expenditures (in thousands of $) on landscaping with the hope of developing a predictive model to help marketing to potential new clients. Suppose the following table represents data for 14 households. HomeValue($1,000) LandscapingExpenditures($1,000) 243 8.2 322 10.7 199 12.3 340 16.3 300 15.7 400 18.8 800 23.5 200 9.5 522 17.5 548 22.0 438 12.2 463 13.5 635 17.8 357 13.8 a. Use the least squares method to develop the estimated regression equation. (Let x = home value (in thousands of $), and let y = landscaping expenditures (in thousands of $). Round your numerical values to five decimal places.) b. Use the equation estimated in part (b) to predict the landscaping expenditures (in $) for a home valued at $275,000. (Round your answer to the nearest dollar.)arrow_forwardThe success of an airline depends heavily on its ability to provide a pleasant customer experience. One dimension of customer service on which airlines compete is on-time arrival. The tables below contains a sample of data from delayed flights showing the number of minutes each delayed flight was late for two different airlines, Company A and Company B. Company A 34 59 43 30 3 32 42 85 30 48 110 50 10 26 70 52 83 78 27 70 27 90 38 52 76 Company B 46 65 41 34 67 106 45 28 39 86 74 46 33 51 63 43 34 32 64 65 (a) Formulate the hypotheses that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. (Let μ1 = population mean minutes late for delayed Company A flights and μ2 = population mean minutes late for delayed Company B flights.) H0: μ1 − μ2 ≤ 0 Ha: μ1 − μ2 > 0 H0: μ1 − μ2 ≥ 0 Ha: μ1 − μ2 < 0 H0: μ1 − μ2 = 0 Ha: μ1 − μ2 ≠ 0 H0: μ1 − μ2 ≠ 0 Ha: μ1 − μ2 = 0 H0: μ1 − μ2 < 0…arrow_forwardA study of the career plans of young women and men sent questionnaires to all members of the senior class in a College of Business Administration at the University of Illinois. One question asked which major within the business program the student had chosen. Another question asked about their job status, whether they worked full-time (40+ hours/week) or part-time (<40 hours/week). Here are the data from the students who responded. accounting administration economics total work full time 68 91 5 164 work part time 56 40 6 102 total 124 131 11 266 The expected number of responses were tabulated as the following: accounting administration economics total work full time 76.45 80.77 6.78 164 work part time 47.55 50.23 4.22 102 total 124 131 11 266 Conduct a χ2 test at α = .005 to determine if the job status of the students is independent of their choice of major. On all hypothesis test: 1) clearly state the null and alternative hypotheses; 2) sketch a graph…arrow_forward
- In recent years, a growing array of entertainment options competes for consumer time. By 2004, cable television and radio surpassed broadcast television, recorded music, and the daily newspaper to become the two entertainment media with the greatest usage (The Wall Street Journal, January 26, 2004). Researchers used a sample of 15 individuals and collected data on the hours per week spent watching cable television and hours per week spent listening to the radio. Individual Television Radio 1 22 25 2 8 10 3 25 29 4 22 19 5 12…arrow_forwardIn the digital age of marketing, special care must be taken to make sure that programmatic ads appearing on websites align with a company's strategy, culture and ethics. For example, in 2017, Nordstrom, Amazon and Whole Foods each faced boycotts from social media users when automated ads for these companies showed up on the Breitbart website (ChiefMarketer.com). It is important for marketing professionals to understand a company's values and culture. The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 5 7 5 3 6 5 4 7 6 4 6 5 5 6 4 3 7 5 (a) Use ? = 0.05 to test for significant differences in perception among the three groups. State the null and alternative hypotheses. H0: ?MM = ?MR = ?AHa: Not all the population means are equal. H0: At least two of the population…arrow_forwardIn the digital age of marketing, special care must be taken to make sure that programmatic ads appearing on websites align with a company's strategy, culture and ethics. For example, in 2017, Nordstrom, Amazon and Whole Foods each faced boycotts from social media users when automated ads for these companies showed up on the Breitbart website (ChiefMarketer.com). It is important for marketing professionals to understand a company's values and culture. The following data are from an experiment designed to investigate the perception of corporate ethical values among individuals specializing in marketing (higher scores indicate higher ethical values). Marketing Managers Marketing Research Advertising 5 4 6 6 5 6 6 5 6 4 4 5 5 5 7 4 4 6 #1) Use ? = 0.05 to test for significant differences in perception among the three groups.State the null and alternative hypotheses A) H0: Not all the population means are equal.Ha: ?MM = ?MR = ?A B) H0: ?MM = ?MR = ?AHa: ?MM ≠ ?MR ≠…arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt