he 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 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.

he 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 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.

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

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

Expert Solution

Step by step

Solved in 5 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.