Analysis of Click Sales Data

Analysis of Click Sales
Data

Table of Contents
Question 1........................................................................................................................................3
Question 2........................................................................................................................................3
Question 3........................................................................................................................................5
Question 4........................................................................................................................................7
Question 5......................................................................................................................................11
REFERENCES..............................................................................................................................14

Question 1
A). The number of items sent from warehouses.
Number of items
sent
Mean 1738.833333
Median 1680
Mode 1646
Standard Devia-
tion 352.9609256
Range 1612
Minimum 1210
Maximum 2822
Sum 260825
Count 150
Q1 1445
Q3 1944.75
IQR 1680
B). The review ratings that are given to us by our customer.
From the data it is determined that from 150 responded 58 people are giving review of
medium satisfaction, 50 are looking to give low rating for the services and the remaining are
highly satisfied with the sales services of company.
Question 2
A) Is there a difference in the customer review ratings when comparing male and female
location managers?
SUMMARY
OUTPUT
Regression Statistics
Multiple R
0.86284
8
R Square
0.74450
7
Adjusted R
Square 0.74278

Standard
Error
30.9310
9
Observations 150
ANOVA
df SS MS F
Significan
ce F
Regression 1 412611.5
41261
1.5
431.2
717 1.06E-45
Residual 148 141596.4
956.7
322
Total 149 554207.9
Coeffici
ents
Standard
Error t Stat
P-
value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept
30.6606
1 11.0226
2.781
613
0.006
113 8.878601
52.4426
3 8.878601 52.44263
X Variable 1
104.120
5 5.013728
20.76
708
1.06E-
45 94.21277
114.028
2 94.21277 114.0282
From the above table it has been determined that there is a big difference in between the male
and female Location manager are being compared in the basis of customer review rating.
B) Is there a relationship between the annual sales and the number of team members operating at
that warehouse location?
SUMMARY OUT-
PUT
Regression Statistics
Multiple R
0.8628
48
R Square
0.7445
07
Adjusted R
Square
0.7427
8
Standard 30.931