Descriptive statistics use EXCEL need output data no more than 1000words sex=1 m
ID: 3355742 • Letter: D
Question
Descriptive statistics
use EXCEL
need output data
no more than 1000words
sex=1 man
sex=2 women
degree level sex sum of consumption number of shopping platforms 2 1 175 1 2 2 0 0 3 2 459 1 3 2 0 0 2 1 1203 3 2 1 0 0 1 2 2500 3 2 2 0 0 1 1 0 0 1 2 492 1 2 1 830 3 1 2 110 1 2 1 0 0 2 1 435 1 2 2 0 0 3 2 1551 2 2 2 243 2 3 2 0 0 2 2 334 1 1 1 628 1 2 2 0 0 1 1 765 1 2 2 281 1 3 1 0 0 1 1 6140 3 3 1 0 0 3 2 2768 2 2 2 0 0 2 1 414 2 2 1 0 0 3 2 0 0 3 1 168 1 1 1 0 0 1 2 404 1 2 2 0 0 2 2 776 1 3 2 0 0 3 1 0 0 2 2 570 2 2 2 141 1 1 1 0 0 3 1 676 1 3 1 0 0 1 1 380 1 2 2 722 1 3 1 482 1 1 2 724 2 1 1 651 1 3 1 316 3 3 2 266 2 3 1 167 1 1 2 698 2 3 1 1479 3 3 2 0 0 1 2 643 2 2 1 1464 3 2 1 0 0 2 2 1725 1 1 2 698 2 2 2 197 2 2 2 679 2 3 2 1690 2 1 2 602 1 3 1 557 1 3 2 0 0 1 1 169 1 2 2 0 0 3 1 530 1 1 1 60 1 3 2 715 1 3 2 480 2 2 2 0 0 1 2 341 1 1 2 400 1 2 1 338 2 2 2 124 2 2 1 674 1 1 1 542 1 2 2 714 2 1 1 118 1 2 1 685 1 2 1 791 2 2 1 182 1 2 2 769 1 2 1 508 2 2 1 1289 2 1 2 792 1 3 1 1316 1 2 1 1733 2 2 2 0 0 2 1 744 2 2 2 0 0 3 2 693 2 3 2 0 0 2 2 618 2 2 2 0 0 3 1 0 0 2 2 2556 1 2 1 204 2 2 1 0 0Explanation / Answer
a) Consumption
sum of consumption
Mean
542.88
Standard Error
80.93731491
Median
360.5
Mode
0
Standard Deviation
809.3731491
Sample Variance
655084.8945
Kurtosis
23.14513173
Skewness
3.984723304
Range
6140
Minimum
0
Maximum
6140
Sum
54288
Count
100
b) Number of Shopping Platforms
number of shopping platforms
Mean
1.08
Standard Error
0.091761659
Median
1
Mode
1
Standard Deviation
0.917616588
Sample Variance
0.842020202
Kurtosis
-0.743616065
Skewness
0.399430819
Range
3
Minimum
0
Maximum
3
Sum
108
Count
100
c) Degree level
degree level
Mean
2.05
Standard Error
0.072995088
Median
2
Mode
2
Standard Deviation
0.729950877
Sample Variance
0.532828283
Kurtosis
-1.097417737
Skewness
-0.077514633
Range
2
Minimum
1
Maximum
3
Sum
205
Count
100
By Gender: -
Women
degree level
sum of consumption
number of shopping platforms
Mean
2.056603774
Mean
518.3962264
Mean
1.018867925
Standard Error
0.098667076
Standard Error
91.85662907
Standard Error
0.118928959
Median
2
Median
341
Median
1
Mode
2
Mode
0
Mode
0
Standard Deviation
0.718307154
Standard Deviation
668.7263537
Standard Deviation
0.86581589
Sample Variance
0.515965167
Sample Variance
447194.9361
Sample Variance
0.749637155
Kurtosis
-1.005280074
Kurtosis
3.815937238
Kurtosis
-1.23945088
Skewness
-0.084425815
Skewness
1.965549784
Skewness
0.147586984
Range
2
Range
2768
Range
3
Minimum
1
Minimum
0
Minimum
0
Maximum
3
Maximum
2768
Maximum
3
Sum
109
Sum
27475
Sum
54
Count
53
Count
53
Count
53
Man
degree level
sum of consumption
number of shopping platforms
Mean
2.042553191
Mean
570.4893617
Mean
1.14893617
Standard Error
0.109483046
Standard Error
138.5995599
Standard Error
0.142589775
Median
2
Median
380
Median
1
Mode
2
Mode
0
Mode
1
Standard Deviation
0.750577946
Standard Deviation
950.1907102
Standard Deviation
0.977546249
Sample Variance
0.563367253
Sample Variance
902862.3858
Sample Variance
0.95559667
Kurtosis
-1.181505903
Kurtosis
26.1995472
Kurtosis
-0.56674168
Skewness
-0.070443801
Skewness
4.600737002
Skewness
0.564003127
Range
2
Range
6140
Range
3
Minimum
1
Minimum
0
Minimum
0
Maximum
3
Maximum
6140
Maximum
3
Sum
96
Sum
26813
Sum
54
Count
47
Count
47
Count
47
sum of consumption
Mean
542.88
Standard Error
80.93731491
Median
360.5
Mode
0
Standard Deviation
809.3731491
Sample Variance
655084.8945
Kurtosis
23.14513173
Skewness
3.984723304
Range
6140
Minimum
0
Maximum
6140
Sum
54288
Count
100
b) Number of Shopping Platforms
number of shopping platforms
Mean
1.08
Standard Error
0.091761659
Median
1
Mode
1
Standard Deviation
0.917616588
Sample Variance
0.842020202
Kurtosis
-0.743616065
Skewness
0.399430819
Range
3
Minimum
0
Maximum
3
Sum
108
Count
100
c) Degree level
degree level
Mean
2.05
Standard Error
0.072995088
Median
2
Mode
2
Standard Deviation
0.729950877
Sample Variance
0.532828283
Kurtosis
-1.097417737
Skewness
-0.077514633
Range
2
Minimum
1
Maximum
3
Sum
205
Count
100
By Gender: -
Women
degree level
sum of consumption
number of shopping platforms
Mean
2.056603774
Mean
518.3962264
Mean
1.018867925
Standard Error
0.098667076
Standard Error
91.85662907
Standard Error
0.118928959
Median
2
Median
341
Median
1
Mode
2
Mode
0
Mode
0
Standard Deviation
0.718307154
Standard Deviation
668.7263537
Standard Deviation
0.86581589
Sample Variance
0.515965167
Sample Variance
447194.9361
Sample Variance
0.749637155
Kurtosis
-1.005280074
Kurtosis
3.815937238
Kurtosis
-1.23945088
Skewness
-0.084425815
Skewness
1.965549784
Skewness
0.147586984
Range
2
Range
2768
Range
3
Minimum
1
Minimum
0
Minimum
0
Maximum
3
Maximum
2768
Maximum
3
Sum
109
Sum
27475
Sum
54
Count
53
Count
53
Count
53
Man
degree level
sum of consumption
number of shopping platforms
Mean
2.042553191
Mean
570.4893617
Mean
1.14893617
Standard Error
0.109483046
Standard Error
138.5995599
Standard Error
0.142589775
Median
2
Median
380
Median
1
Mode
2
Mode
0
Mode
1
Standard Deviation
0.750577946
Standard Deviation
950.1907102
Standard Deviation
0.977546249
Sample Variance
0.563367253
Sample Variance
902862.3858
Sample Variance
0.95559667
Kurtosis
-1.181505903
Kurtosis
26.1995472
Kurtosis
-0.56674168
Skewness
-0.070443801
Skewness
4.600737002
Skewness
0.564003127
Range
2
Range
6140
Range
3
Minimum
1
Minimum
0
Minimum
0
Maximum
3
Maximum
6140
Maximum
3
Sum
96
Sum
26813
Sum
54
Count
47
Count
47
Count
47