The management of a certain company would like to use the following data to learn about its customer base and to evaluate the first day promotional campaign purchases. Customers who made purchases with discount coupons were labelled as “Promotional Customers”, and “Regular Customers” was used for those who did not use coupons. Customer Type of Customer Items Net Sales (GH¢) Method of Payment Gender Marital Status Age 1 Regular 1 100 Vodacash Male Married 32 2 Promotional 1 105 MTN mobile money Female Single 36 3 Regular 1 230 Airtel money Female Married 32 4 Promotional 5 300 MTN mobile money Male Married 28 5 Regular 2 150 Vodacash Female Single 34 6 Regular 20 450 Vodacash Female Married 44 7 Promotional 2 78 MTN mobile money Male Married 30 8 Promotional 3 120 MTN mobile money Female Single 22 9 Promotional 6 345 Airtel money Female Married 56 10 Promotional 1 200 MTN mobile money Female Single 28 11 Promotional 4 300 MTN mobile money Female Married 38 12 Promotional 10 250 Airtel money Female Married 50 13 Regular 2 74 MTN mobile money Female Married 42 14 Promotional 2 400 Airtel money Male Married 48 15 Promotional 1 310 MTN mobile money Female Married 60 16 Regular 1 85 Vodacash Female Married 54 17 Promotional 3 90 MTN mobile money Female Single 32 18 Promotional 1 82 MTN mobile money Female Married 70 19 Promotional 2 63 Airtel money Female Married 28 20 Regular 15 350 MTN mobile money Male Married 52 21 Promotional 3 160 MTN mobile money Female Married 44 22 Promotional 1 62 Airtel money Female Single 54 23 Promotional 2 340 MTN mobile money Female Married 60 24 Promotional 5 120 MTN mobile money Male Married 68 25 Regular 1 58 Vodacash Female Single 78 26 Regular 2 74 Vodacash Female Single 20 27 Promotional 5 255 Vodacash Male Married 28 28 Regular 2 90 Vodacash Female Married 54 29 Promotional 2 80 Airtel money Female Married 68 30 Promotional 6 50 Airtel money Male Single 80   Use descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign, by finding Frequency distribution of the Net Sales using the intervals 50-99,100 -149, 150 -199,

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

The management of a certain company would like to use the following data to learn about its customer base and to evaluate the first day promotional campaign purchases. Customers who made purchases with discount coupons were labelled as “Promotional Customers”, and “Regular Customers” was used for those who did not use coupons.

Customer

Type of Customer

Items

Net Sales (GH¢)

Method of Payment

Gender

Marital Status

Age

1

Regular

1

100

Vodacash

Male

Married

32

2

Promotional

1

105

MTN mobile money

Female

Single

36

3

Regular

1

230

Airtel money

Female

Married

32

4

Promotional

5

300

MTN mobile money

Male

Married

28

5

Regular

2

150

Vodacash

Female

Single

34

6

Regular

20

450

Vodacash

Female

Married

44

7

Promotional

2

78

MTN mobile money

Male

Married

30

8

Promotional

3

120

MTN mobile money

Female

Single

22

9

Promotional

6

345

Airtel money

Female

Married

56

10

Promotional

1

200

MTN mobile money

Female

Single

28

11

Promotional

4

300

MTN mobile money

Female

Married

38

12

Promotional

10

250

Airtel money

Female

Married

50

13

Regular

2

74

MTN mobile money

Female

Married

42

14

Promotional

2

400

Airtel money

Male

Married

48

15

Promotional

1

310

MTN mobile money

Female

Married

60

16

Regular

1

85

Vodacash

Female

Married

54

17

Promotional

3

90

MTN mobile money

Female

Single

32

18

Promotional

1

82

MTN mobile money

Female

Married

70

19

Promotional

2

63

Airtel money

Female

Married

28

20

Regular

15

350

MTN mobile money

Male

Married

52

21

Promotional

3

160

MTN mobile money

Female

Married

44

22

Promotional

1

62

Airtel money

Female

Single

54

23

Promotional

2

340

MTN mobile money

Female

Married

60

24

Promotional

5

120

MTN mobile money

Male

Married

68

25

Regular

1

58

Vodacash

Female

Single

78

26

Regular

2

74

Vodacash

Female

Single

20

27

Promotional

5

255

Vodacash

Male

Married

28

28

Regular

2

90

Vodacash

Female

Married

54

29

Promotional

2

80

Airtel money

Female

Married

68

30

Promotional

6

50

Airtel money

Male

Single

80

 

Use descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign, by finding

Frequency distribution of the Net Sales using the intervals 50-99,100 -149, 150 -199, …

Туре of
Customer
Net Sales
Marital
Status
Method of Payment Gender
Vodacash
MIN mobile money
Airtel money
MIN mobile money
Vodacash
Vodacash
MIN mobile money
MIN mobile money
Airtel money
MIN mobile money
MIN mobile money
Airtel money
MIN mobile money
Airtel money
MIN mobile money
Vodacash
MIN mobile money
MIN mobile money
Airtel money
MIN mobile money
MIN mobile money
Airtel money
MIN mobile money
MIN mobile money
Vodacaşh
Vodacash
Customer
Items
(GHC)
Age
1
Male
Regular
Promotional
1
100
Married
32
105
Female Single
36
Regular
1
230
Female
Married
32
4
Promotional
300
Male
Married
28
Female Single
Regular
Regular
150
34
6
20
450
Female
Married
44
7
Promotional
2.
78
Male
Married
30
8
Promotional
120
Female Single
22
Promotional
6
345
Female
Married
56
Female Single
Married
10
Promotional
1
200
28
11
Promotional
4
300
Female
38
12
Promotional
10
250
Female
Married
50
13
Regular
74
Female
Married
42
14
Promotional
400
Male
Married
48
15
Promotional
310
Female
Married
60
16
Regular
1
85
Female
Married
54
17
Promotional
3
90
Female Single
32
18
Promotional
1
82
Female
Married
70
19
Promotional
2.
63
Female
Married
28
20
Regular
15
350
Male
Married
52
21
Promotional
3.
160
Female
Married
44
22
Promotional
1
62
Female Single
54
23
Promotional
2.
340
Female
Married
60
24
Promotional
120
Male
Married
68
Regular
Regular
Promotional
Female Single
Female Single
25
1
58
78
26
2
74
20
27
255
Vodacash
Vodacash
Airtel money
Artel money
Male
Married
28
28
Female
Regular
Promotional
2
90
Married
54
29
2
80
Female
Married
68
30
Promotional
6.
50
Male
Single
80
Transcribed Image Text:Туре of Customer Net Sales Marital Status Method of Payment Gender Vodacash MIN mobile money Airtel money MIN mobile money Vodacash Vodacash MIN mobile money MIN mobile money Airtel money MIN mobile money MIN mobile money Airtel money MIN mobile money Airtel money MIN mobile money Vodacash MIN mobile money MIN mobile money Airtel money MIN mobile money MIN mobile money Airtel money MIN mobile money MIN mobile money Vodacaşh Vodacash Customer Items (GHC) Age 1 Male Regular Promotional 1 100 Married 32 105 Female Single 36 Regular 1 230 Female Married 32 4 Promotional 300 Male Married 28 Female Single Regular Regular 150 34 6 20 450 Female Married 44 7 Promotional 2. 78 Male Married 30 8 Promotional 120 Female Single 22 Promotional 6 345 Female Married 56 Female Single Married 10 Promotional 1 200 28 11 Promotional 4 300 Female 38 12 Promotional 10 250 Female Married 50 13 Regular 74 Female Married 42 14 Promotional 400 Male Married 48 15 Promotional 310 Female Married 60 16 Regular 1 85 Female Married 54 17 Promotional 3 90 Female Single 32 18 Promotional 1 82 Female Married 70 19 Promotional 2. 63 Female Married 28 20 Regular 15 350 Male Married 52 21 Promotional 3. 160 Female Married 44 22 Promotional 1 62 Female Single 54 23 Promotional 2. 340 Female Married 60 24 Promotional 120 Male Married 68 Regular Regular Promotional Female Single Female Single 25 1 58 78 26 2 74 20 27 255 Vodacash Vodacash Airtel money Artel money Male Married 28 28 Female Regular Promotional 2 90 Married 54 29 2 80 Female Married 68 30 Promotional 6. 50 Male Single 80
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman