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.
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
- 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.
- The Relationship between the Age of customers and Net Sales. Explain your model
- The Relationship between Number of items purchased and Net Sales. Explain your model
Trending now
This is a popular solution!
Step by step
Solved in 5 steps