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
2 Mean 32.920
19 29 12 19 30 14 21 14 14 52
3 Standard Error 2.590
713 18 814 19 18 21 21 5
3 Median 25.500
94 19 6107 19 241 715 15
12
13
13
13
14
14
14
14
14
15
15
15
16
16
16
17
18
18
18
19
19
19
19
19
21
21
21
23
25
25
26
27
27
28
29
30
30
31
31
32
34
35
Page 1
53 890 55 264 16 12 27 53
35 16 35 38 3 9 9 9 11 39
16 17 18 23 74 25 26 58 59 62
P6-11 Statistics
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
69
70
72
74
77
80
82
85
90
93
94
102
107
Page 2
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
20
25
30
35
Histogram
Page 3