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 Managerial Report 1: Use descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign, by finding the following; Frequency distribution of the Net Sales using the intervals 50-99,100 -149, 150 -199, … The Skewness for the Net Sales distribution. Interpret your results. The Kurtosis for the Net Sales distribution. Interpret your results.

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
Topic Video
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

Managerial Report 1:

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

  1. Frequency distribution of the Net Sales using the intervals 50-99,100 -149, 150 -199, …
  2. The Skewness for the Net Sales distribution. Interpret your results.
  3. The Kurtosis for the Net Sales distribution. Interpret your results.
  4. The Relationship between the Age of customers and Net Sales. Explain your model
  5. The Relationship between Number of items purchased and Net Sales. Explain your model
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Propositional Calculus
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar 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