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

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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