Question

In: Statistics and Probability

PART I Starbucks launched its prepaid (debit) Starbucks Card in November 2001. The card, which holds...

PART I Starbucks launched its prepaid (debit) Starbucks Card in November 2001. The card, which holds between $5 and $500 can be used at any Starbucks location. Suppose Starbucks management wants to study the reasons why some people purchase debit cards with higher prepaid amounts than do other people. Suppose a study of 25 randomly selected prepaid purchasers is taken. Respondents are asked the amount of the prepaid card, the customer’s age, the number of days per month the customer makes a purchase at Starbucks, the number of cups of coffee that customer drinks per day, and the customer’s income. The data is given in the Excel spreadsheet.

Amount of Prepaid Card ($) Age Days per Month at Starbucks Cups of Coffee per Day Income ($1,000)
5 25 4 1 20
25 30 12 5 35
10 27 10 4 30
5 42 8 5 30
15 29 11 8 25
50 25 12 5 80
10 50 8 3 30
15 45 6 5 35
15 32 16 7 25
15 23 10 1 20
20 40 18 5 40
35 35 12 3 40
40 28 10 3 50
15 33 12 2 30
200 40 15 5 80
15 37 3 1 30
40 51 10 8 35
5 20 8 4 25
30 26 15 5 35
100 38 19 10 45
30 27 12 3 35
25 29 14 6 35
25 34 10 4 45
50 30 6 3 55
15 22 8 5 30

1. Using these data, develop a multiple regression model to study how well the amount of the prepaid card can be predicted by the other variables and which variables seem to be more promising in doing the prediction.

2. Rerun your model based on the significant independent variables only and explain the results.

3. What sales implications might be evident from this analysis?

PART II Suppose marketing wants to be able to profile frequent visitors to a Starbucks store. Using the same data set already provided, develop a multiple regression model to predict days per month at Starbucks by Age, Income and Number of cups of coffee per day.

4. How strong is the model?

5. Which independent variables seem to have more promise in predicting how many days per month a customer visits Starbucks?

6. What marketing implications might be evident from this analysis?

Solutions

Expert Solution


Related Solutions

BACKGROUND Starbucks launched its prepaid (debit) Starbucks Card in November 2001. The card, which holds between...
BACKGROUND Starbucks launched its prepaid (debit) Starbucks Card in November 2001. The card, which holds between $5 and $500 can be used at any Starbucks location. Suppose Starbucks management wants to study the reasons why some people purchase debit cards with higher prepaid amounts than do other people. Suppose a study of 25 randomly selected prepaid purchasers is taken. Respondents are asked the amount of the prepaid card, the customer’s age, the number of days per month the customer makes...
Starbucks launched its prepaid (debit) Starbucks Card in November 2001. The card, which holds between $5...
Starbucks launched its prepaid (debit) Starbucks Card in November 2001. The card, which holds between $5 and $500 can be used at any Starbucks location. Suppose Starbucks management wants to study the reasons why some people purchase debit cards with higher prepaid amounts than do other people. Suppose a study of 25 randomly selected prepaid purchasers is taken. Respondents are asked the amount of the prepaidcard, the customer’s age, the number of days per monththe customer makes a purchase at...
Amount of Prepaid Card ($) Age Days per Month at Starbucks Cups of Coffee per Day...
Amount of Prepaid Card ($) Age Days per Month at Starbucks Cups of Coffee per Day Income ($1,000) 5 25 4 1 20 25 30 12 5 35 10 27 10 4 30 5 42 8 5 30 15 29 11 8 25 50 25 12 5 80 10 50 8 3 30 15 45 6 5 35 15 32 16 7 25 15 23 10 1 20 20 40 18 5 40 35 35 12 3 40 40 28...
Define money and discuss its various functions. Is debit card money? Credit Card? Why? Why not?...
Define money and discuss its various functions. Is debit card money? Credit Card? Why? Why not? Explain.
Why Starbucks launched its first overseas “Reserve Roastery," a flagship store combining gourmet coffees and a...
Why Starbucks launched its first overseas “Reserve Roastery," a flagship store combining gourmet coffees and a bakery in Shanghai? (Please explain it by all learning from the class of strategic management). And here below is what I learn so far. so use them marketing planning .looking for marketing direction-SWOT Analysis .Looking for customer-S.T.P Analysis .Looking for method -p marketing mix Maslow's hierarchy of needs (three waves of coffee industry) positing map efficiency frontier curve
A retail company receives most of its revenue from credit or debit card transactions or payments...
A retail company receives most of its revenue from credit or debit card transactions or payments by check. Funds received from credit and debit card transactions automatically deposit in interest bearing accounts. However, the company does receive some cash payments from customers each day. These cash receipts total $7,250,000 annually. The company makes no cash payments to its suppliers or creditors. Money held in the cash account earns no interest. The company estimates that the transaction cost of moving funds...
Part I – Consumer Credit Gregg is planning to apply for a new credit card and...
Part I – Consumer Credit Gregg is planning to apply for a new credit card and is considering the following three choices. He is also planning to buy a $500 big screen television and plans to pay for this over a two-year period by making equal monthly. Credit Card Annual Interest Rate Annual Fee MBNA True Line Master Card 8.99% $39 Desjardins Classic Visa 12.90% $30 American Express Essential Credit Card 12.99% $0 Question 71 What would be his monthly...
I need a project and well detailed report on the business performance of starbucks which will...
I need a project and well detailed report on the business performance of starbucks which will entails the criterial used for the evaluation, ability of starbucks to create value and performance metrics, how well do they make their coffee and other service they render, competative advantage over other companies and most importantly their strategy map in excecuting their plans..
Genetics Multip Choice Questions: 1) Which part of the tRNA structure holds the amino acid when...
Genetics Multip Choice Questions: 1) Which part of the tRNA structure holds the amino acid when charged? a) D loop arm b) T loop arm c) acceptor arm d) anticodon arm 2) Which RNAs need to fold back on itself to form a 3D structure for function? a) mRNA and rRNA b) tRNA and mRNA c) rRNA and tRNA d) All 3 types 3) Microarray analysis is based on the amount of a) complementary binding b) cDNA sequencing c) radioactivity...
Suppose the Capital Asset Pricing Model (CAPM) holds, which of the following statements is/are correct? I)             All...
Suppose the Capital Asset Pricing Model (CAPM) holds, which of the following statements is/are correct? I)             All securities lie on the capital market line. II)           The risk premium on securities with a negative beta coefficient will be lower than the risk-free rate. III)          The market portfolio is the tangency point between the capital market line and the indifference curve. IV)          The market portfolio lies on the efficient frontier.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT