Pelican Stores 2

Pelican Stores
Course : Probability and Statistics
Member : Sonsoem, Nattima Saldivar, Penelope Rice, Leslie

Managerial Report
1. Percent frequency distribution for key variables.
Frequency for Net Sales

Maximum
287.59
Minimum
31.60
Range
255.99
# of Classes
6
Calc Width
42.665

Frequency for Type of Customer

Status
Freq
Rel. Freq
Regular
30
0.3
Promotional
70
0.7
Total
100
1

Frequency for Method of Payment
AmEx
2
0.02
Discover
4
0.04
Mastercard
14
0.14
Visa
10
0.1
Proprietary Card
70
0.7
Total
100
1

Frequency for Gender

Male
7
0.07
Female
93
0.93
Total
100
1

Frequency for Marital Status

Single
16
0.16
Married
84
0.84
Total
100
1

Class
Freq
Rel. Freq
Cum Freq.
C. Rel. Freq
20-30
18
0.18
18
0.18
30-40
26
0.26
44
0.44
40-50
32
0.32
76
0.76
50-60
15
0.15
91
0.91
60-70
6
0.06
97
0.97
70-80
3
0.03
100
1.00
Total
100
1.00

2. A bar chart or pie chart showing the number of customer purchases attributable to the method of payment.

Frequency for Method of Payment
AmEx
2
0.02
Discover
4
0.04
Mastercard
14
0.14
Visa
10
0.1
Proprietary Card
70
0.7
Total
100
1

Most customers used Proprietary Card for their payments which is about 70% of all customers payments.

3. A cross tabulation of type of customer (regular or promotional) versus net sales.

Sales

10-60
60-110
110-160
160-210
210-260
260-310
Gran Total
Promotional
1258.28
1704.85
1172.46
728.62
482.5
553.59
5900.3
Regular
776
656.5
427.25

1859.75
Gran Total
2034.28
2361.35
1599.71
728.62
482.5
553.59
7760.05

Count of Net Sales

10-60
60-110
110-160
160-210
210-260
260-310
Grand Total
Promotional
32
21
9
4
2
2
70
Regular
19
8
3

30
Grand Total
51
29
12
4
2
2
100

70% of Pelican Stores sales was made customers using a discount coupons while 30% of sales was made by customers who did not use a discount coupon.
4. A scatter diagram to explore the relationship between net sales and customer age.

Conclusion
According to the data analysis presenting in percent frequency