Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
P6-11 Statistics
Problem 6-11
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
142 264 44 15 77 49 85 82 102
8 Sum 3292.000
9 Count 100.000
9 Largest(1) 107.000
9 Smallest(1) 1.000
11 Confidence Level(95.0%) 5.139
12
12
13
13
13
21
21
23
25
25
26
27
27
28
29
30
30
31
31
32
34
35
35
36
38
45
49
49
49
49
52
53
53
55
58
Page 1
P6-11 Statistics
59
62
94
102
107
Page 2
P6-11 Histogram
Problem 6-11
Twenty First Century Laundry
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
30
35
Histogram
Page 3
Prob 6-12 Statistics
Blood Tests at Rivervalley Labs
Problem 6-12
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
2.5 3.9 3.8 4.9 3.6 3.5 2.9 3.8 2.1 1.9
1.7 Column1 4.9 4.4 3.6 4.0 2.6 4.0 2.4 4.1 3.4 3.0
1.7 3.6 3.9 2.5 4.2 3.1 4.1 5.0 1.7 3.3 4.5
1.9 Mean 3.578 4.3 3.1 4.0 2.6 5.0 3.7 3.0 4.3 3.8 4.0
1.9 Standard Error 0.081 1.9 2.7 3.6 4.4 2.0 4.5 4.1 4.7 2.6 4.6
2.0 Median 3.600 3.4 3.5 4.0 3.5 4.3 3.7 3.6 3.2 2.5 4.6
2.9
3.0
3.0
3.0
3.1
3.1
3.1
3.1
3.2
3.2
3.2
3.2
3.2
3.2
3.3
3.4
3.4
3.4
3.4
3.4
3.5
3.5
3.5
3.5
3.5
3.5
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.7
3.7
3.7
3.7
3.8
3.8
3.8
3.8
3.8
3.9
3.9
3.9
3.9
3.9
4.0
4.0
4.0
4.0
4.0
4.0
4.1
Page 4
Prob 6-12 Statistics
4.1
4.1
4.2
4.3
4.3
4.3
4.3
4.3
4.3
4.4
4.4
4.5
4.5
4.6
4.6
4.7
4.8
4.9
4.9
4.9
5.0
5.0
5.0
5.0
5.3
Page 5
Prob 6-12 Histogram
Problem 6-12
Blood Tests at Rivervalley Labs
Histogram Using Excel Data Analysis Tool - "Histogram"
Note that bin data must be input into the Histogram module before analysis can proceed.
Input Bin Bin Frequency
Data Here
1.9 4
1.9 2.2 3
2.2 2.5 5
2.5 2.8 7
2.8 3.1 8
3.1 3.4 12
1.7 2.5 3.9 3.8 4.9 3.6 3.5 2.9 3.8 2.1 1.9
1.7 4.9 4.4 3.6 4.0 2.6 4.0 2.4 4.1 3.4 3.0
1.9 3.6 3.9 2.5 4.2 3.1 4.1 5.0 1.7 3.3 4.5
2.5
2.6
2.6
2.6
2.6
2.7
2.8
2.8
2.9
3.0
3.0
3.0
3.1
3.1
3.1
3.1
3.2
3.2
3.2
3.2
3.2
3.2
12
14
16
18
20
Histogram
Page 6
Prob 6-12 Histogram
3.3
3.4
3.4
3.4
3.4
3.4
3.5
3.5
3.5
3.5
3.5
3.5
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.6
3.7
3.7
3.7
3.7
3.8
3.8
3.8
3.8
3.8
3.9
3.9
3.9
3.9
3.9
4.0
4.0
4.0
4.0
4.0
4.0
4.1
4.1
4.1
4.2
4.3
4.3
4.3
4.3
4.3
4.3
4.4
4.4
4.5
4.5
4.6
4.6
Page 7
Prob 6-12 Histogram
4.7
4.8
4.9
4.9
4.9
5.0
5.0
5.0
5.0
5.3
Page 8
Problem 6- 13
Fillmore Metalwork Foundry
Descriptive Statistics and Frequency Chart
This spreadsheet is designed for up to 100 pieces of data Enter data ONLY in yellow-shaded cells.
Note: The Histogram macro and the Descriptive Statistics macro have been used to develop this solution.
They can be loaded into the Tools menu during standard setup of Excel.
If available, they will show up as the Data Analysis label on the Tools menu.
DATA (x - x-bar)^2
138.1 0.306916
Calculation of mean & Sample Standard Deviation
238.1 0.306916
338.5 0.023716 Mean (x-bar) = 38.6540
438.5 0.023716 Sample Standard deviation = 0.3060
538.7 0.002116
638.8 0.021316
738.6 0.002916
838.3 0.125316 Check on the above formula - By using Excel Descriptive Statistics, below
938.3 0.125316
10 38.3 0.125316
11 38.5 0.023716 Column B Original Data set
35 38.6 0.002916
36 38.6 0.002916
37 38.6 0.002916
38 38.1 0.306916
39 38.1 0.306916
40 38.1 0.306916
41 38.4 0.064516
42 38.6 0.002916
43 38.7 0.002116
44 38.7 0.002116
45 38.9 0.060516
46 38.6 0.002916
61 38.9 0.060516
62 38.9 0.060516
63 38.9 0.060516
64 38.9 0.060516
65 38.9 0.060516
66 39.0 0.119716
67 38.7 0.002116
68 38.8 0.021316
69 38.7 0.002116
70 39.0 0.119716
78 38.8 0.021316
79 38.8 0.021316
80 38.8 0.021316
81 39.0 0.119716
82 39.0 0.119716
83 39.1 0.198916
84 38.7 0.002116
85 38.6 0.002916
