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:
4. The
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Bundle: Essentials of Modern Business Statistics with Microsoft Office Excel, Loose-leaf Version, 7th + LMS Integrated for MindTap Business Statistics, 1 term (6 months) Printed Access Card
- You're a data analyst for an insurance company. You want to make sure that your employer is not over-paying for car repairs. To investigate this, you bring 38 different cars to two different garages, Bubba's Hubcap Heaven and Repair, and Merle's Motor Shop. Some of the cars need lots of repairs. Some of the cars need very few. By taking each car to both shops, we can directly compare the two sets of prices. The dataset is in an Excel file named "Bubba_v_Merle_3899.xls", which you can find in the "Data" folder under Course Documents. Before running your analysis, be sure to look at the data file and verify that each car requires a different amount of repairs, and that prices in one shop are correlated with prices at the other shop. That is, they're in the same ballpark. The question is whether one tends to charge more, on average, than the other. Your task is to use Excel to test the research hypothesis that prices are different in the two shops; the null hypothesis is that prices are…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 4 6 5 5 6 6 5 7 5 3 6 4 3 7 5 4 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: ?MM = ?MR = ?A Ha: ?MM ≠ ?MR ≠ ?A…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 At the ? = 0.05 level of significance, we can conclude that there are differences in the perceptions for marketing managers, marketing research specialists, and advertising specialists. Use the procedures in Section 13.3 to…arrow_forward
- In 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 4 6 7 3 6 6 3 5 6 4 5 5 5 5 6 5 6 6 Find the value of the test statistic. Find the p-value. (Round your answer to three decimal places.) p-value = (b) At the ? = 0.05 level of significance, we can conclude that there are differences in the perceptions for marketing…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 4 6 6 3 5 6 5 5 6 5 6 5 4 6 7 3 5 6 (a) Use ? = 0.05 to test for significant differences in perception among the three groups. State the null and alternative hypotheses. H0: Not all the population means are equal.Ha: ?MM = ?MR = ?A H0: ?MM ≠ ?MR ≠ ?AHa: ?MM = ?MR =…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_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