P6-11 Statistics
Twenty-first Century Laundry
Summary Statistics Using Excel Data Analysis Tool – “Descriptive Statistics”
Note that the data must be put into a unidimensional array in order to run the summary statistics
Summary Data in
Original Data
Ascending Order
69 3 1 72 93 380 6 5 36
1
42 264 44 15 77 49 85 82 102
2Column1
28 70 41 30 25 45 31 49 49 49
2
13 42 27 13 45 31 14 34 32 39
5 Sample Variance 670.741
16 17 18 23 74 25 26 58 59 62
6 Kurtosis 0.233
6 Skewness 0.994
7 Range 106.000
7 Minimum 1.000
8 Maximum 107.000
12
12
13
13
13
14
14
14
14
14
15
15
15
16
16
16
17
18
18
18
Page 1
19 29 12 19 30 14 21 14 14 52
94 19 6107 19 241 715 15
53 890 55 264 16 12 27 53
35 16 35 38 3 9 9 9 11 39
P6-11 Statistics
19
19
19
19
19
21
21
21
23
25
25
26
27
27
28
29
30
30
31
31
32
34
35
35
36
38
39
39
41
41
42
42
44
45
45
49
49
49
49
52
53
53
55
58
59
62
64
64
Page 2
P6-11 Statistics
69
70
72
74
77
80
82
85
90
93
94
102
107
Page 3
P6-11 Histogram
Twenty-first Century Lanudry
Histogram Using Excel Data Analysis Tool – “Histogram”
Note that bin data must be input into the Histogram module before analysis can proceed.
Input Bin
Data here
Bin Frequency
15 15 32
30 30 25
45 45 17
60 60 10
Page 4