Analysis of Click Sales Data

This document provides an analysis of click sales data, including the number of items sent from warehouses, review ratings given by customers, the relationship between customer review ratings and gender of location managers, the relationship between annual sales and number of team members, the relationship between wages and gender of location managers, and more. It also discusses the average annual sales of warehouses managed by females, the proportion of stores with high customer review ratings, and the comparison of wages paid to Click Sales warehouse staff with the industry average. The document concludes with a discussion on sample size and making reliable estimates.

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
Deviation 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
OUTPUT
Regression Statistics
Multiple R
0.8628
48
R Square
0.7445
07
Adjusted R
Square
0.7427
8
Standard 30.931

Error 09
Observatio
ns 150
ANOVA
df SS MS F
Significa
nce F
Regressi
on 1
41261
1.5
41261
1.5
431.27
17 1.06E-45
Residual 148
14159
6.4
956.73
22
Total 149
55420
7.9
Coefficie
nts
Standa
rd
Error t Stat
P-
value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Interce
pt 30.66061
11.022
6
2.7816
13
0.0061
13
8.8786
01
52.442
63
8.8786
01
52.442
63
X
Variab
le 1 104.1205
5.0137
28
20.767
08
1.06E-
45
94.212
77
114.02
82
94.212
77
114.02
82
B) The Business Intelligence team would like to get an understanding of the relationship
between the wages paid and whether or not the location managers were male or female.
SUMMARY
OUTPUT
Regression Statistics
Multiple R
0.1159
31
R Square
0.0134
4
Adjusted R
Square
0.0067
74
Standard
Error
2.4990
11
Observatio
ns 150
ANOVA

df SS MS F
Significa
nce F
Regressi
on 1
12.591
41
12.591
41
2.016
22 0.157729
Residual 148
924.26
83
6.2450
56
Total 149
936.85
97
Coefficie
nts
Standa
rd
Error t Stat
P-
value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Interce
pt 65.98302
0.3579
97
184.31
15
9.4E-
177
65.275
57
66.690
46
65.275
57
66.690
46
X
Variab
le 1 -0.16663
0.1173
5
-
1.4199
4
0.1577
29
-
0.3985
3
0.0652
68
-
0.3985
3
0.0652
68
Question 3
A). The average annual sales of all warehouses managed by Females.
Total sales = 31954.4
Total count = 125
Average sales = 255.6
B). The proportion of all of our stores that have a customer review rating of “high”
RevRat
ing
High
High
High
High
High
High
High
High
High
High
High
High
High

High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
High
Total 46 customer review rating of “high”
Question 4
A) The average wage for warehouse staff who do not work for Click Sales is 65,000 dollars.
Is this wage we pay our Click Sales warehouse staff higher than this?

There are 141 worker Click Sales is 65,000 dollars. Is this wage we pay our Click Sales
warehouse staff higher than this.
B) Based on the industry observations, it is known that elsewhere, fewer than 22% of
warehouse managers are male, is this the same for Click Sales managers? That is, is the
proportion of Click Sales managers who are male really less than 22%?
MgrSx WagePer
Male 64.6
Male 73.6
Male 67.6
Male 66.4
Male 67.6
Male 65.8
Male 63.4
Male 66.4
Male 62.8
Male 67
Male 71.2
Male 64.6
Male 63.4
Male 62.8
Male 64
Male 64
Male 63.4
Male 65.2
Male 63.4
Male 63.4
Male 69.4
Male 65.8
Male 64.8

Male 65.2
Male 65.2
The above table is help in determining the total number of male worker is lower than the average
of 22% workers of male working in the managerial post within an organisation. The main fact
behind this is that female are more focused and hardworking whenever given a responsibility of
doing a job, and on the other side males are more likely to do job within sales sectors. This is
because they think chances of getting higher rewards and salaries are their if compared with
managerial job.
Question 5
a) Is a sample size of 150 suitable to make reliable estimates form?
Yes the selected size is correct in the context of research which support to make reliable
estimate.
B) What size sample should be taken in order to accurately estimate the true proportion of
warehouses that have a high customer review rating to with plus and minus 5%
In case for more accurate results there can be 200 members so that to accurately estimate the
true proportion of warehouses that have a high customer review rating to with plus and minus
5%

Confidence Interval for mean Confidence Interval for proportion
Data Data
Sample Standard Deviation 10 Sample Size 20
Sample Mean 15 Count of Successes 25
Sample Size 161 Confidence Level 95%
Confidence Level 95%
Intermediate Calculations Intermediate Calculations
Standard Error of the Mean 0.7881 Sample Proportion 1.25
Degrees of Freedom 160 Z Value 1.9600
t Value 1.9749 Standard Error of the Proportion 12
Margin of Error 1.5564 Margin of Error 23.5196
Confidence Interval Confidence Interval
Interval Lower Limit 13.44 Interval Lower Limit -2226.96%
Interval Upper Limit 16.56 Interval Upper Limit 2476.96%
Hypothesis Test for μ Hypothesis Test for π
Hypotheses Hypotheses
Null Hypothesis μ ≤ 20 Null Hypothesis π ≥ 15%
Alternative Hypothesis μ > 20 Alternative Hypothesis π < 22%
Test Type Upper Test Type Lower
Level of significance Level of significance
α α 5.00
Critical Region Critical Region
Degrees of Freedom 9 Critical Value #NUM!
Critical Value #NUM!
Sample Data
Sample Data Sample Size 40
Sample Standard Deviation 15 Count of 'Successes' 6
Sample Mean 12
Sample Size 10 Sample proportion, p 15.00%
Standard Error 5.65%
Standard Error of the Mean 4.7434 z Sample Statistic 5.0000
t Sample Statistic -1.6865 p-value 3.0000
p-value 3.0000
Decision
Decision Reject Null Hypothesis
Fail to reject Null Hypothesis

REFERENCES
Books and Journals