How many purchases in the sample are large

Assignment Help Business Management
Reference no: EM133143629

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

Click this button to reveal the data

Download CSV file

Customer

Registration

Purchase_Level

Payment_Method

1

Unregistered

Large

Credit

2

Registered

Medium

Debit

3

Registered

Medium

Debit

4

Unregistered

Medium

Debit

5

Unregistered

Large

Cash

6

Unregistered

Large

Credit

7

Registered

Large

Cash

8

Registered

Small

Other

9

Registered

Medium

Mobile

10

Unregistered

Large

Cash

11

Unregistered

Small

Other

12

Unregistered

Medium

Mobile

13

Unregistered

Large

Cash

14

Unregistered

Large

Credit

15

Registered

Medium

Debit

16

Unregistered

Small

Other

17

Unregistered

Medium

Mobile

18

Unregistered

Medium

Mobile

19

Unregistered

Large

Cash

20

Unregistered

Medium

Mobile

21

Unregistered

Large

Credit

22

Unregistered

Medium

Mobile

23

Registered

Small

Mobile

24

Registered

Large

Credit

25

Unregistered

Medium

Debit

26

Registered

Medium

Mobile

27

Unregistered

Medium

Mobile

28

Registered

Large

Credit

29

Registered

Small

Other

30

Unregistered

Large

Debit

31

Unregistered

Medium

Mobile

32

Unregistered

Large

Credit

33

Registered

Small

Other

34

Registered

Large

Cash

35

Registered

Small

Other

36

Unregistered

Medium

Debit

37

Unregistered

Large

Credit

38

Registered

Medium

Debit

39

Unregistered

Small

Other

40

Registered

Medium

Credit

41

Registered

Large

Cash

42

Registered

Large

Cash

43

Unregistered

Medium

Mobile

44

Unregistered

Small

Other

45

Unregistered

Medium

Debit

46

Unregistered

Large

Credit

47

Registered

Large

Cash

48

Unregistered

Large

Credit

49

Unregistered

Small

Other

50

Unregistered

Medium

Debit

51

Registered

Small

Mobile

52

Unregistered

Medium

Debit

53

Unregistered

Large

Credit

54

Unregistered

Large

Cash

55

Registered

Small

Mobile

56

Unregistered

Small

Other

57

Unregistered

Large

Cash

58

Unregistered

Large

Debit

59

Registered

Small

Other

60

Unregistered

Medium

Mobile

61

Registered

Medium

Debit

62

Unregistered

Small

Mobile

63

Unregistered

Large

Cash

64

Unregistered

Small

Mobile

65

Registered

Large

Credit

66

Unregistered

Small

Other

67

Registered

Small

Mobile

68

Unregistered

Medium

Mobile

69

Registered

Small

Mobile

70

Unregistered

Small

Other

71

Unregistered

Medium

Mobile

72

Unregistered

Large

Cash

73

Unregistered

Medium

Mobile

74

Unregistered

Medium

Mobile

75

Unregistered

Medium

Mobile

76

Unregistered

Large

Cash

77

Unregistered

Small

Other

78

Unregistered

Medium

Debit

79

Registered

Large

Cash

80

Registered

Small

Other

81

Unregistered

Medium

Mobile

82

Unregistered

Medium

Debit

83

Unregistered

Small

Other

84

Unregistered

Large

Debit

85

Unregistered

Medium

Mobile

86

Registered

Small

Mobile

87

Unregistered

Small

Other

88

Unregistered

Large

Credit

89

Unregistered

Large

Cash

90

Unregistered

Large

Debit

91

Unregistered

Small

Other

92

Unregistered

Large

Credit

93

Registered

Medium

Debit

94

Unregistered

Medium

Mobile

95

Unregistered

Small

Other

96

Unregistered

Small

Other

97

Unregistered

Small

Other

98

Registered

Medium

Credit

99

Registered

Medium

Mobile

100

Unregistered

Medium

Debit

101

Unregistered

Medium

Debit

102

Registered

Large

Credit

103

Unregistered

Medium

Debit

104

Registered

Medium

Debit

105

Registered

Small

Other

106

Unregistered

Medium

Mobile

107

Unregistered

Large

Credit

108

Registered

Large

Cash

109

Registered

Large

Cash

110

Unregistered

Medium

Mobile

111

Registered

Small

Mobile

112

Unregistered

Small

Other

113

Unregistered

Large

Debit

114

Registered

Medium

Credit

115

Unregistered

Large

Credit

116

Unregistered

Large

Cash

117

Registered

Large

Credit

118

Unregistered

Small

Other

119

Unregistered

Large

Debit

120

Unregistered

Small

Other

121

Unregistered

Large

Cash

122

Unregistered

Small

Other

123

Unregistered

Medium

Debit

124

Unregistered

Small

Other

125

Unregistered

Small

Other

126

Registered

Small

Mobile

127

Unregistered

Medium

Debit

128

Registered

Small

Other

129

Unregistered

Medium

Debit

130

Unregistered

Medium

Mobile

131

Registered

Small

Mobile

132

Unregistered

Large

Debit

133

Unregistered

Large

Debit

134

Registered

Medium

Credit

135

Registered

Small

Other

136

Unregistered

Large

Credit

137

Unregistered

Small

Other

138

Unregistered

Small

Other

139

Unregistered

Small

Other

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 large
  2. How many customers paid with cash
  3. How many unregistered customers' purchases are medium
  4. How many registered customers paid with credit
  5. What percent of all customers are registered and paid with credit? %%
  6. What percent of all customers are unregistered and made a large purchase? %%
  7. What percent of unregistered customers' purchases are medium? %%
  8. What percent of registered customers paid with credit?

Reference no: EM133143629

Questions Cloud

Costs and benefits of government regulation : Using the concepts about the costs and benefits of government regulation, and your own experience with social media, answer the following question: should Faceb
Healthier lifestyle for everyone in the community : Review and revise your introduction paragraph. Below We live in a community not designed for physical activity. Having a park in our community will encourage us
What is the cost of the finished goods on hand from this job : Bramble, Inc. completed Job No. 814 during 2022. What is the cost of the finished goods on hand from this job
Needing a community park in the neighborhood : Revise this paragraph below about the effects of the problem Of needing a community park in the neighborhood
How many purchases in the sample are large : 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
Calculate the earnings per share of common stock : On April 1, 16,000 additional common shares were issued, and another 32,000 common shares were issued on August 1. Calculate earnings per share of common stock
Negotiation strategy and plan : Identify at least 5 potential situations or risk areas where negotiation may be required, such as conflict resolution.
What is the total cost of goods manufactured : Sunland Company has beginning and ending work in process inventories of $160000 and $175000 respectively. What is the total cost of goods manufactured
What three areas of finance : 1. What three areas of finance? Are these areas independent of one another, or are they interrelated in the sense that someone working in one area should know s

Reviews

Write a Review

Business Management Questions & Answers

  Possible values of ebit

Also, let's assume that the firm's expected values for EBIT depend upon which state of the economy occurs this year, with the possible values of EBIT

  Shares of toronto-dominion bank

A Canada-based investor buys shares of Toronto-Dominion Bank (Toronto: TD.TO) for C$72.08 on 15 October 2007 with the intent of holding them for a year. The dividend rate was C$2.11 per year.

  Importance of managerial accounting

Discuss the importance of managerial accounting as "decision-making tool" in your organization.

  Assessing the quality of quantitative research

"Reliability and validity are tools of an essentially positivist epistemology" (Winter, 2000: 7). In light of the above, discuss the measures of validity and re

  Per capita nominal gdp

In the United States, if the average growth rate of nominal GDP is 2.8 percent, inflation is 1.6 percent, and population growth is 0.5 percent, what is the growth of real GDP? Per capita nominal GDP? Per capita real GDP?

  Have you witnessed unethical practices in the workplace

If so, share your experience with the class and explain how this impacted your perception of the business.??

  Create ethical code of conduct for those in governance

Create an ethical code of conduct for those in governance, management, and professional staff for any one of these health care organizations.

  Context of management and coaching

Why do we discuss the neurological responses of our brains in the context of management and coaching?

  Outline two areas in which the marketing department

Outline two areas in which the Marketing Department can cooperate with the Productions Department to ensure product success.

  Self-leadership skills to in turn motivate

Leadership studies demonstrate that the most effective leaders know how to draw upon self-leadership skills to in turn motivate

  Explain the concept of variation in processes

Explain the concept of variation in processes. State the primary sources of process variation.

  Determine the expression for the electric field

Determine the expression for the electric field in the region between the sheets for positive values of x.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd