Statistical Analysis Project Report

The assignment involves analyzing a dataset using various statistical tools, including frequency tables, descriptive statistics, correlation, and regression analysis. It aims to determine the relationship between order quantity and sales. The report presents findings from the analysis, including correlations and regression results, which show no significant difference between average sales and order quantity.

STATISTIC PROJECT

TABLE OF CONTENTS
TASK 1............................................................................................................................................1
Selection of a random sample of size 60................................................................................1
TASK 2............................................................................................................................................3
1. Frequency table in percentage and graph...........................................................................3
2. Summary statistics..............................................................................................................9
Graphical presentation..........................................................................................................11
TASK 3..........................................................................................................................................14
Analysing the Average sales for Home office customers....................................................14
Shipping cost and all sample variables.................................................................................15
TASK 4..........................................................................................................................................18
Hypothesis test......................................................................................................................18
TASK 5..........................................................................................................................................19
Correlation and Regression analysis on sales and order quantity........................................19
TASK 6..........................................................................................................................................23
Conclusion............................................................................................................................23
REFERENCES..............................................................................................................................24

TASK 1
Selection of a Random Sample of size 60
Order
ID
Order
Priority
Order
Quantity Sales Ship Mode
Shipping
Cost Region
Customer
Segment Days to ship
52929 3 19 $53.94 1 $1.25 1 4 1
40964 4 40 $301.12 1 $8.37 2 1 3
32198 2 31 $240.63 1 $5.53 2 3 0
6433 2 41 $159.26 1 $0.50 2 2 1
30626 4 23 $220.82 3 $1.09 2 1 1
40134 1 1 $9.75 1 $4.72 1 4 5
15205 4 42 $1,753.51 1 $9.20 1 1 1
34660 0 36 $3,832.37 1 $5.81 1 2 2
31556 4 35 $269.35 1 $3.68 1 3 1
12323 0 32 $513.74 1 $10.13 2 1 1
20486 3 42 $163.98 1 $0.70 2 1 1
45248 2 38 $154.85 1 $5.13 2 1 2
326 3 17 $100.95 1 $3.37 2 3 1
57799 3 25 $12,343.07 2 $69.30 1 3 2
5347 2 39 $276.03 1 $5.03 1 1 3
29318 0 21 $2,954.14 3 $35.00 2 1 1
42081 1 36 $188.34 1 $5.74 2 4 5
16805 1 26 $172.33 1 $5.74 1 1 2
54882 4 17 $86.29 1 $0.49 2 3 3
10210 0 10 $767.34 1 $14.52 1 1 1
54215 3 14 $321.21 1 $1.99 1 4 2
12293 3 31 $283.17 1 $1.39 2 2 1
51200 2 29 $1,617.88 1 $5.50 1 4 3
27904 3 8 $460.59 1 $8.99 1 3 1
1

32580 3 38 $261.38 1 $8.74 2 1 2
53443 4 35 $1,477.63 1 $4.62 1 3 1
51008 3 20 $269.66 1 $4.59 2 3 2
57350 3 33 $140.63 1 $5.68 1 4 1
56577 4 30 $7,497.08 2 $54.12 2 4 1
50854 4 27 $137.50 1 $4.95 2 1 0
18688 0 49 $14,346.73 1 $19.99 1 2 2
40643 4 23 $258.74 1 $5.72 2 2 2
23558 1 17 $579.71 2 $45.51 2 2 5
49479 2 46 $5,615.40 2 $26.30 2 3 2
37891 3 24 $163.36 1 $6.60 2 4 2
6432 4 30 $311.08 1 $4.50 2 1 2
42788 4 26 $241.92 1 $2.27 1 4 2
42081 1 3 $32.49 1 $1.39 2 4 2
22149 1 17 $48.24 1 $1.01 2 4 5
15622 3 21 $135.99 1 $9.68 1 3 1
15428 4 50 $1,444.96 3 $4.00 1 4 1
11815 1 22 $351.27 1 $7.42 2 3 2
58755 1 18 $47.11 1 $7.09 1 2 9
52930 1 40 $1,865.59 1 $1.25 2 1 0
49312 4 19 $1,882.18 3 $5.81 2 1 2
31046 4 42 $3,900.53 1 $2.50 2 1 1
38950 0 30 $288.45 1 $3.98 2 4 3
21542 3 43 $11,674.97 2 $84.84 2 1 1
53637 3 12 $451.09 3 $9.83 2 3 1
48837 0 39 $4,799.79 1 $3.90 2 1 2
56387 2 32 $128.14 3 $7.01 1 4 2
42370 3 33 $125.27 1 $4.83 1 2 2
25028 4 5 $477.39 2 $55.81 1 2 1
25318 4 22 $440.92 3 $10.49 1 4 2
6304 3 30 $199.11 1 $6.65 1 1 2
2

21414 4 46 $3,644.60 1 $35.00 2 3 2
41987 0 25 $6,481.05 2 $29.20 1 1 1
47015 0 19 $5,441.06 2 $61.76 1 1 1
32069 0 8 $1,100.00 2 $17.85 2 3 0
52642 1 15 $764.13 1 $4.86 2 2 7
TASK 2
1. Frequency Table in percentage and graph
Statistics
Order
Priority
Sales
N Valid 60 60
Missing 0 0
Mean 2.33 $1,737.8300
Std. Error of Mean .190 $401.20189
Median 3.00 $306.1000
Mode 4 $9.75a
Std. Deviation 1.469 $3,107.6964
5
Variance 2.158 9657777.195
Skewness -.374 2.631
Std. Error of
Skewness .309 .309
Kurtosis -1.296 6.911
Std. Error of Kurtosis .608 .608
Range 4 $14,336.98
Percentiles 25 1.00 $163.5150
3

50 3.00 $306.1000
75 4.00 $1,719.6025
a. Multiple modes exist. The smallest value is
shown
Frequency Table
Order Priority
Frequency Percent Valid Percent Cumulative
Percent
Valid
0 10 16.7 16.7 16.7
1 10 16.7 16.7 33.3
2 7 11.7 11.7 45.0
3 16 26.7 26.7 71.7
4 17 28.3 28.3 100.0
Total 60 100.0 100.0
4

5

Sales
Frequency Percent Valid
Percent
Cumulative
Percent
Valid
$9.75 1 1.7 1.7 1.7
$32.49 1 1.7 1.7 3.3
$47.11 1 1.7 1.7 5.0
$48.24 1 1.7 1.7 6.7
6

$53.94 1 1.7 1.7 8.3
$86.29 1 1.7 1.7 10.0
$100.95 1 1.7 1.7 11.7
$125.27 1 1.7 1.7 13.3
$128.14 1 1.7 1.7 15.0
$135.99 1 1.7 1.7 16.7
$137.50 1 1.7 1.7 18.3
$140.63 1 1.7 1.7 20.0
$154.85 1 1.7 1.7 21.7
$159.26 1 1.7 1.7 23.3
$163.36 1 1.7 1.7 25.0
$163.98 1 1.7 1.7 26.7
$172.33 1 1.7 1.7 28.3
$188.34 1 1.7 1.7 30.0
$199.11 1 1.7 1.7 31.7
$220.82 1 1.7 1.7 33.3
$240.63 1 1.7 1.7 35.0
$241.92 1 1.7 1.7 36.7
$258.74 1 1.7 1.7 38.3
$261.38 1 1.7 1.7 40.0
$269.35 1 1.7 1.7 41.7
$269.66 1 1.7 1.7 43.3
$276.03 1 1.7 1.7 45.0
$283.17 1 1.7 1.7 46.7
$288.45 1 1.7 1.7 48.3
7

$301.12 1 1.7 1.7 50.0
$311.08 1 1.7 1.7 51.7
$321.21 1 1.7 1.7 53.3
$351.27 1 1.7 1.7 55.0
$440.92 1 1.7 1.7 56.7
$451.09 1 1.7 1.7 58.3
$460.59 1 1.7 1.7 60.0
$477.39 1 1.7 1.7 61.7
$513.74 1 1.7 1.7 63.3
$579.71 1 1.7 1.7 65.0
$764.13 1 1.7 1.7 66.7
$767.34 1 1.7 1.7 68.3
$1,100.00 1 1.7 1.7 70.0
$1,444.96 1 1.7 1.7 71.7
$1,477.63 1 1.7 1.7 73.3
$1,617.88 1 1.7 1.7 75.0
$1,753.51 1 1.7 1.7 76.7
$1,865.59 1 1.7 1.7 78.3
$1,882.18 1 1.7 1.7 80.0
$2,954.14 1 1.7 1.7 81.7
$3,644.60 1 1.7 1.7 83.3
$3,832.37 1 1.7 1.7 85.0
$3,900.53 1 1.7 1.7 86.7
$4,799.79 1 1.7 1.7 88.3
$5,441.06 1 1.7 1.7 90.0
8

$5,615.40 1 1.7 1.7 91.7
$6,481.05 1 1.7 1.7 93.3
$7,497.08 1 1.7 1.7 95.0
$11,674.97 1 1.7 1.7 96.7
$12,343.07 1 1.7 1.7 98.3
$14,346.73 1 1.7 1.7 100.0
Total 60 100.0 100.0
9

10

2. Summary Statistics
Descriptive Statistics
Descriptive Statistics
N Range Minimu
m
Maximu
m
Mean Std.
Deviation
Variance Skewness Kurtosis
Statisti
c
Statistic Statistic Statistic Statistic Std. Error Statistic Statistic Statisti
c
Std.
Erro
r
Statisti
c
Std.
Erro
r
Sales 60 $14,336.9
8 $9.75 $14,346.7
3
$1,737.830
0
$401.2018
9
$3,107.6964
5
9657777.19
5 2.631 .309 6.911 .608
Region 60 1 1 2 1.57 .065 .500 .250 -.276 .309 -1.991 .608
Order
Priority 60 4 0 4 2.33 .190 1.469 2.158 -.374 .309 -1.296 .608
Order
Quantity 60 49 1 50 27.37 1.539 11.922 142.134 -.179 .309 -.618 .608
Ship
Mode 60 2 1 3 1.38 .089 .691 .478 1.551 .309 .958 .608
Shipping
Cost 60 $84.35 $0.49 $84.84 $13.0487 $2.38632 $18.48439 341.673 2.332 .309 4.944 .608
Custome
r
Segment
60 3 1 4 2.38 .156 1.209 1.461 .104 .309 -1.562 .608
Days to
ship 60 9 0 9 1.97 .209 1.615 2.609 2.253 .309 6.525 .608
1

Valid N
(listwise
)
60
Graphical Presentation
Figure 1. Bar chart of Order Priority
2

Figure 2. Pie chart of Order Quantity
3

Figure 3. Line chart of Sales
4

Figure 4. Histogram of Ship Mode
TASK 3
Analysing the average sales for Home office customers
Null Hypothesis: There is no mean significant difference between sales and Home Office Customers
Alternative hypothesis: There is a mean significant difference between sales and Home Office Customers
T-test:
Group Statistics
Customer
Segment
N Mean Std.
Deviation
Std. Error
Mean
5

Sales
>= 2 39 $1,539.4284 $3,212.7412
9 $514.45033
< 2 21 $2,106.2901 $2,942.7692
8 $642.16490
Independent Samples Test
Levene's Test for
Equality of Variances
t-test for Equality of Means
F Sig. t df Sig. (2-
tailed)
Mean
Difference
Std. Error
Difference
95% Confidence Interval of
the Difference
Lower Upper
Sales
Equal variances
assumed .098 .755 -.671 58 .505 -
$566.86169 $845.09647 -
$2,258.50607 $1,124.78268
Equal variances
not assumed -.689 44.305 .494 -
$566.86169 $822.82131 -
$2,224.82688 $1,091.10349
Interpretation: On the basis of above presented independent sample test, which represents outcomes based on differences in the
sales volume and their impacts on the home office customers. Moreover, as per considering significant value of the outcomes, which
determines results as more than p value of 0.5 such as 0.755. In this case, it can be said that there will be rejection to the null
hypothesis and acceptance to the fact that, there is a mean significant difference between home office customers and sales.
Additionally, it can be said that variation in sales will affect the number of customers at home office.
6

Shipping cost and all sample variables
Null Hypothesis: There is no mean significant difference between shipping cost and other variables
Alternative hypothesis: There is a mean significant difference between shipping cost and other variables
T- test:
Group Statistics
Shipping Cost N Mean Std. Deviation Std. Error Mean
Sales >= $5.00 36 $2,413.7179 $3,756.74757 $626.12460
< $5.00 24 $723.9983 $1,228.89713 $250.84758
Order Priority >= $5.00 36 2.11 1.489 .248
< $5.00 24 2.67 1.404 .287
Order Quantity >= $5.00 36 27.64 11.586 1.931
< $5.00 24 26.96 12.651 2.582
Ship Mode >= $5.00 36 1.53 .736 .123
< $5.00 24 1.17 .565 .115
Region >= $5.00 36 1.50 .507 .085
< $5.00 24 1.67 .482 .098
Customer Segment >= $5.00 36 2.25 1.180 .197
< $5.00 24 2.58 1.248 .255
Days to ship >= $5.00 36 1.97 1.612 .269
< $5.00 24 1.96 1.654 .338
Independent Samples Test
Levene's Test for Equality of
Variances
t-test for Equality of Means
1

F Sig. t df Sig. (2-
tailed)
Mean
Difference
Std. Error
Difference
95% Confidence Interval of
the Difference
Lower Upper
Sales
Equal variances
assumed 13.142 .001 2.124 58 .038 $1,689.71965 $795.62280 $97.10759 $3,282.33172
Equal variances not
assumed 2.505 45.359 .016 $1,689.71965 $674.50464 $331.49429 $3,047.94502
Order Priority
Equal variances
assumed .228 .635 -1.448 58 .153 -.556 .384 -1.323 .212
Equal variances not
assumed -1.466 51.416 .149 -.556 .379 -1.316 .205
Order Quantity
Equal variances
assumed .212 .647 .215 58 .831 .681 3.167 -5.660 7.021
Equal variances not
assumed .211 46.383 .834 .681 3.224 -5.809 7.170
Ship Mode
Equal variances
assumed 10.596 .002 2.035 58 .046 .361 .177 .006 .716
Equal variances not
assumed 2.145 56.764 .036 .361 .168 .024 .698
Region
Equal variances
assumed 4.350 .041 -1.272 58 .208 -.167 .131 -.429 .096
Equal variances not
assumed -1.286 51.192 .204 -.167 .130 -.427 .094
Customer Segment
Equal variances
assumed .225 .637 -1.047 58 .299 -.333 .318 -.970 .304
Equal variances not
assumed -1.036 47.499 .306 -.333 .322 -.981 .314
2

Days to ship
Equal variances
assumed .373 .544 .032 58 .974 .014 .429 -.845 .873
Equal variances not
assumed .032 48.551 .974 .014 .432 -.854 .881
Interpretation: On the basis of above listed analysis on which, relationship between shipping costs and other variables were
addressed and analysed. Thus, with respect to the same, it can be said that, there are majority of outcomes that are more than p value
such as 0.5. Therefore, this has been analysed here that there is a mean significant difference between shipping cost and other
variables.
TASK 4
Hypothesis test
Null Hypothesis: There is no mean significant difference between order priority and shipping costs
Alternative Hypothesis: There is a mean significant difference between order priority and shipping costs
One-way Anova
ANOVA
Order Priority
Sum of Squares df Mean Square F Sig.
Between Groups 107.333 54 1.988 .497 .909
Within Groups 20.000 5 4.000
Total 127.333 59
3

Interpretation: By considering the above listed table that represents one-way ANOVA analysis of two variables such as order
priority and shipping cost. Thus, in the significant value had been derived is 0.909 which is more than p value of 0.5. Moreover, it can
be said that, there is a mean significant difference between order priority and Shipping costs.
Null Hypothesis: There is no mean significant difference between Average sales and Region
Alternative Hypothesis: There is a mean significant difference between Average sales and Region
One-way ANOVA
ANOVA
Sales
Sum of
Squares
df Mean Square F Sig.
Between
Groups 4152415.330 1 4152415.330 .426 .517
Within Groups 565656439.1
55 58 9752697.227
Total 569808854.4
85 59
Interpretation: With consideration with the above listed analysis, which presents the outcomes of variables sales and region.
Thus, changes in one variable affect results of another variable. Therefore, with respect to significant value, which has been analysed
here are 0.517 which is more than p value of 0.5. Thus, it can be said that, there is a mean significant difference between average sales
and region.
4

TASK 5
Correlation and Regression analysis on sales and order quantity
Null Hypothesis: There is no mean significant difference between average sales and order quantity
Alternative Hypothesis: There is a mean significant difference between average sales and order quantity
Regression
Descriptive Statistics
Mean Std. Deviation N
Sales $1,737.8300 $3,107.69645 60
Order
Quantity 27.37 11.922 60
Correlations
Sales Order
Quantity
Pearson Correlation
Sales 1.000 .336
Order
Quantity .336 1.000
Sig. (1-tailed)
Sales . .004
Order
Quantity .004 .
N
Sales 60 60
Order
Quantity 60 60
5

Variables Entered/Removeda
Model Variables Entered Variables
Removed
Method
1 Order Quantityb . Enter
a. Dependent Variable: Sales
b. All requested variables entered.
Model Summary
Model R R Square Adjusted R Square Std. Error of the
Estimate
Change Statistics
R Square Change F Change df1 df2 Sig. F Change
1 .336a .113 .098 $2,951.92431 .113 7.391 1 58 .009
a. Predictors: (Constant), Order Quantity
ANOVAa
Model Sum of Squares df Mean Square F Sig.
1
Regression 64405142.270 1 64405142.270 7.391 .009b
Residual 505403712.215 58 8713857.107
Total 569808854.485 59
a. Dependent Variable: Sales
b. Predictors: (Constant), Order Quantity
Coefficientsa
6

Model Unstandardized Coefficients Standardized
Coefficients
t Sig. 95.0% Confidence Interval for B
B Std. Error Beta Lower Bound Upper Bound
1 (Constant) -660.486 960.964 -.687 .495 -2584.065 1263.092
Order Quantity 87.636 32.235 .336 2.719 .009 23.111 152.162
a. Dependent Variable: Sales
Interpretation: In relation with the above listed regression analysis of the variables, on which it can be said that independent
variable order quantity and dependent variable sales were analysed. Thus, with respect to this, significant value is less than 0.5 such as
0.49 and 0.009, therefore there will be acceptance to null hypothesis. Thus, there is no mean significant difference between Average
sales and Order Quantity.
Correlations:
Descriptive Statistics
Mean Std. Deviation N
Order Quantity 27.37 11.922 60
Sales $1,737.8300 $3,107.69645 60
Correlations
Order Quantity Sales
Order Quantity
Pearson Correlation 1 .336**
Sig. (2-tailed) .009
N 60 60
Sales Pearson Correlation .336** 1
7

Sig. (2-tailed) .009
N 60 60
**. Correlation is significant at the 0.01 level (2-tailed).
Interpretation: As per analysing the above listed Correlation analysis of the data base, on which it can be said that order quantity
and sales were being analysed. Significant value if less than 0.5 on which, there is no mean significant difference between Average
sales and Order Quantity (SPSS Correlation analysis, 2018). Therefore, changes in order quantity will not affect sales.
TASK 6
Conclusion
On the basis of above report, it can be said that there has been analysis of data base with considering various statistical tools. It
includes frequency tables analysis, descriptive analysis, correlation, regression etc. that had been addressed to have appropriate
determination of facts. Along with this, there have been creation of various hypothesis on which application of statistical tools brought
valid outcomes.
8

REFERENCES
Online
SPSS Correlation analysis. 2018. [Online]. Available through :< https://www.spss-tutorials.com/spss-correlation-analysis/ >.
9