Question: A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 125 walk-in customers about registration in

A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 125 walk-in customers about registration in the store's points program, purchase level, and payment method.

Click this button to reveal the data

Customer Registration Purchase Level Payment Method
1 Unregistered Large Credit
2 Registered Medium Mobile
3 Registered Small Mobile
4 Unregistered Large Credit
5 Unregistered Small Other
6 Registered Medium Mobile
7 Registered Small Other
8 Registered Large Cash
9 Registered Large Credit
10 Registered Small Mobile
11 Unregistered Medium Debit
12 Unregistered Large Credit
13 Unregistered Large Credit
14 Registered Large Cash
15 Unregistered Small Mobile
16 Unregistered Medium Mobile
17 Registered Medium Debit
18 Unregistered Large Credit
19 Unregistered Small Other
20 Unregistered Small Mobile
21 Unregistered Medium Debit
22 Unregistered Small Mobile
23 Registered Large Cash
24 Registered Small Other
25 Unregistered Large Cash
26 Unregistered Large Cash
27 Registered Small Other
28 Registered Large Credit
29 Unregistered Large Cash
30 Registered Small Other
31 Unregistered Medium Debit
32 Unregistered Small Other
33 Unregistered Small Mobile
34 Registered Small Other
35 Unregistered Large Credit
36 Unregistered Small Other
37 Registered Medium Debit
38 Unregistered Small Other
39 Unregistered Large Cash
40 Registered Large Credit
41 Unregistered Small Other
42 Unregistered Large Credit
43 Unregistered Medium Debit
44 Unregistered Small Mobile
45 Unregistered Medium Debit
46 Unregistered Large Cash
47 Unregistered Medium Mobile
48 Registered Small Mobile
49 Registered Small Other
50 Unregistered Medium Mobile
51 Unregistered Medium Debit
52 Unregistered Small Other
53 Registered Large Cash
54 Unregistered Medium Credit
55 Unregistered Small Mobile
56 Registered Small Other
57 Unregistered Small Mobile
58 Unregistered Small Mobile
59 Unregistered Medium Mobile
60 Unregistered Medium Debit
61 Unregistered Large Credit
62 Registered Medium Debit
63 Registered Small Other
64 Unregistered Small Mobile
65 Unregistered Large Cash
66 Unregistered Medium Debit
67 Unregistered Small Mobile
68 Unregistered Large Credit
69 Registered Medium Mobile
70 Unregistered Medium Debit
71 Unregistered Large Credit
72 Registered Medium Debit
73 Unregistered Medium Debit
74 Unregistered Medium Credit
75 Registered Large Credit
76 Unregistered Large Cash
77 Unregistered Large Credit
78 Unregistered Medium Debit
79 Registered Medium Mobile
80 Registered Medium Mobile
81 Unregistered Medium Debit
82 Registered Large Cash
83 Unregistered Small Mobile
84 Unregistered Small Other
85 Unregistered Small Mobile
86 Registered Large Credit
87 Unregistered Large Credit
88 Registered Large Credit
89 Unregistered Medium Debit
90 Unregistered Small Mobile
91 Unregistered Large Credit
92 Unregistered Large Credit
93 Registered Large Credit
94 Unregistered Small Other
95 Unregistered Medium Debit
96 Unregistered Small Other
97 Unregistered Large Cash
98 Unregistered Medium Mobile
99 Registered Medium Debit
100 Unregistered Small Other
101 Registered Large Cash
102 Unregistered Medium Debit
103 Registered Small Other
104 Unregistered Large Cash
105 Unregistered Small Mobile
106 Unregistered Large Cash
107 Unregistered Medium Debit
108 Registered Small Mobile
109 Unregistered Large Credit
110 Unregistered Large Credit
111 Unregistered Small Other
112 Unregistered Medium Mobile
113 Unregistered Large Credit
114 Unregistered Medium Debit
115 Unregistered Large Cash
116 Unregistered Small Other
117 Unregistered Small Other
118 Registered Medium Mobile
119 Registered Medium Debit
120 Registered Large Cash
121 Unregistered Large Cash
122 Unregistered Large Cash
123 Unregistered Small Other
124 Unregistered Medium Mobile
125 Unregistered Large Cash

Download CSV file

Download the .csv file or copy/paste the data into Excel or Google Sheets and use the Pivot Table function to generate the tables needed to answer the following questions:

  1. How many purchases in the sample are medium?
  3. How many customers paid with credit?
  5. How many registered customers purchases are large?
  7. How many unregistered customers paid with cash?
  12. Round percentages to two decimal places.
  17. What percent of all customers are unregistered and paid with cash? %%
  18. What percent of all customers are registered and made a medium purchase? %%
  19. What percent of registered customers purchases are large? %%
  20. What percent of unregistered customers paid with cash? %%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

The City of Amarillo is authorized to issue $8,000,000, 3 percent regular serial bonds in 2023 for the construction of a new exit off the interstate highway within city limits. The bonds mature in...

Q:

A used car dealership sells sedans, SUVs, convertibles, minivans and coupes. Vehicles sold are mainly of American, German, and Japanese origin. Data on the last 275 completed sales showing origin,...

Q:

A used car dealership sells sedans, SUVs, convertibles, minivans and coupes. Vehicles sold are mainly of American, German, and Japanese origin. Data on the last 275 completed sales showing origin,...

Q:

Content X DO IDEAS * *Homework Help - Q&A from Onl x + X - C imathas.humber.ca/assess2/?cid=359&aid=10202#/skip/4 : Apps M Gmail YouTube W MyHumber W Humber and Guelp... W Humber and Guelp.. Search...

Q:

A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 133 walk-in customers about registration in the store's points program and about...

Q:

Please organize on excel and find the answers please and to see what the picture would look like go down to organize and please answer this for me right. A retail store has recently started paying...

Q:

I have attached the link to access for the data sets on the comment. Thank you #4 w Question 15 - E 2/8 pts '0 2 23 9 G Details Score on last try: 2 of 8 pts. See Details for more. Next question Get...

Q:

A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 132 walkin customers about registration in the store's points program, purchase...

Q:

A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 1 3 2 walk - in customers about registration in the store's points program and...

Q:

Wal-Mart Stores This case was prepared by Charles W. L. Hill of the School of Business, University of Washington, Seattle. CI0-1 Introduction In July 1962, Sam Walton opened his first Wal-Mart...

Q:

Wal-Mart Stores This case was prepared by Charles W. L. Hill of the School of Business, University of Washington, Seattle. CI0-1 Introduction In July 1962, Sam Walton opened his first Wal-Mart...

Q:

A comprehensive critical analysis of the case study, incorporating any 3 themes3 themes, with help of relevant OB concepts and research, should be provided. Please note that you need to identify...

Q:

Portfolio Analysis. You have been given the expected return data shown in the first table on three assets-F,G and H- over the period 2016-2019. Expected return Year Asset F Asset G Asset H 2016 16%...

Q:

Common-Size Statements Below is the most recent income statement for Philippe. Prepare a common-size statement of comprehensive income based on this information. How do you interpret the standardized...

Q:

Which of the following was not a consequence of the data breach? Multiple Choice Target concealed more information about its IT systems. Target greatly improved its security policies. Target had to...