Note: on this and succeeding worksheets in this file are
data sets for all problems that require substantial
amounts of data in Chapter 6
Problem 6-2
Numeros Verdes Partners, P.S.C.
Applying the COUNTIF FUNCTION
1 0 0 1 0 0 1 1 0
Answers th 0 0 1 0 0 0 0 0 1
0 0 0 1 1 0 0 1 0
0 0 1 1 0 0 1 0 0 0
0 0 0 0 0 1 0 0 0 1
0 0 0 1 1 0 0 0 0 0
1 0 0 0 0 1 0 0 0 1
0 0 0 0 0 0 0 0 0 1
0 0 0 0 1 0 0 1 0 0
1 1 0 0 0 0 0 0 0 0
0
1
0
0 0 0 1 0 0 1 0 1 0
1 0 0 0 0 0 0 0 0 1
0 0 0 1 0 0 0 0 0 0
0 1 0 1 0 1 0 0 0 0
1 0 1 0 0 1 0 0 1 0
0 0 1 0 1 0 1 0 0 0
0 0 0 1 0 0 0 0 0 0
1 0 0 0 0 0 0 0 1 0
1 0 1 0 0 0 0 0 0 0
0 1 0 0 1 0 1 1 0 0
Problem 6-11
Twenty First Century Laundry
Descriptive Statistics
69 3 1 72 93 3 80 6 5 36
42 2 64 44 15 77 49 85 82 102
28 70 41 30 25 45 31 49 49 49
13 42 27 13 45 31 14 34 32 39
19 29 12 19 30 14 21 14 14 52
7 13 18 8 14 19 18 21 21 5
94 19 6 107 19 2 41 7 15 15
53 8 90 55 2 64 16 12 27 53
35 16 35 38 3 9 9 9 11 39
16 17 18 23 74 25 26 58 59 62
23 25
25 26
Problem 6-12
Rivervalley Labs
Descriptive Statistics
2.5 3.9 3.8 4.9 3.6 3.5 2.9 3.8 2.1 1.9
4.9 4.4 3.6 4.0 2.6 4.0 2.4 4.1 3.4 3.0
3.6 3.9 2.5 4.2 3.1 4.1 5.0 1.7 3.3 4.5
4.3 3.1 4.0 2.6 5.0 3.7 3.0 4.3 3.8 4.0
1.9 2.7 3.6 4.4 2.0 4.5 4.1 4.7 2.6 4.6
3.4 3.5 4.0 3.5 4.3 3.7 3.6 3.2 2.5 4.6
3.2 3.6 3.2 4.8 5.0 2.8 3.8 3.1 3.0 3.9
4.0 3.7 3.5 5.0 3.9 3.4 3.2 3.6 4.3 1.7
3.1 4.9 2.6 3.5 3.5 2.8 4.3 2.1 3.8 3.9
3.6 3.6 3.7 3.2 5.3 2.5 3.2 3.4 3.4 4.3
Problem 6-13
Fillmore Metalwork Foundry
Descriptive Statistics
38.1 38.5 38.3 37.3 38.4 39.2 38.9 38.5 39.0 38.6
38.1 38.8 38.6 38.6 38.6 38.6 38.9 38.8 39.0 38.6
38.5 38.5 38.8 38.7 38.7 38.7 38.9 38.6 39.1 38.7
38.5 38.6 38.5 38.5 38.7 38.8 38.9 38.7 38.7 38.6
38.7 38.6 38.7 38.6 38.9 38.7 38.9 38.5 38.6 38.5
38.8 38.6 38.4 38.6 38.6 38.7 39.0 38.7 38.7 38.5
38.6 38.6 38.5 38.6 38.5 38.6 38.7 38.7 39.1 38.6
38.3 38.6 38.4 38.1 38.4 39.5 38.8 38.8 39.1 38.6
38.3 38.6 38.4 38.1 38.5 39.6 38.7 38.8 39.2 38.8
38.3 38.6 38.4 38.1 38.5 39.3 39.0 38.8 39.2 38.7
Mean
Std Dev
38.6540
0.3060
Problem 6-20
Rabbitfoot Bank, Inc.
Rabbitfoot Industry Data
33.9 40.0
34.8 39.6
35.0 38.5
39.1 40.0
40.1 42.4
37.7 38.6
39.0 42.3
35.7 34.9
40.2 33.0
43.9 41.4
38.0 38.3
34.3 41.6
41.3 41.5
35.4 37.9
39.3 40.0
35.9 43.1
41.5 40.5
37.9 41.8
36.3 41.6
43.0 40.9
39.1 40.9
35.9 40.3
40.5 39.8
34.9 40.8
38.2 36.4
39.1 34.6
36.6 41.1
38.5 34.4
38.3 37.0
39.5 41.4
41.4
41.2
37.8
38.4
37.5
40.2
37.4 40.3 39.2
43.8 36.7 43.7
36.0 41.4 39.9
40.8 35.9 41.1 35 32.8
38.3 37.2 40 36.3 34.5
39.5 36.8 41.6 40.1 42.2
z-Test: Two Sample for Means
Variable 1 Variable 2
Mean 39.475 38.8933333333
Known Variance 6.1534 6.6307
Observations 36 30
Hypothesized Mean 0
z 0.9290909433
P(Z<=z) one-tail 0.1764209788
z Critical one-tail 1.644853627
P(Z<=z) two-tail 0.3528419577
z Critical two-tail 1.9599639845
Problem 6-21
Softswift Software Developers
Sub 1 Sub 2 Sub 3
86 90 89
73 85 82
69 77 74
77 80 70
86 92 88
72 71 66
88 86 72
67 78 72
65 98 78
84 83 66
76.7 84 75.7
Problem 6-22
Rockglass, Inc.
Temp-deg C Brittleness
600 3.2
650 1.8
700 3.9
750 2.8
800 4.2
850 4.8
900 4.7
950 5.3
1000 5.5
1050 5.4
1100 6.3
1150 7.0
1200 6.8
1250 7.7
1300 8.1
Problem 6-23
Sival Electronics
Supplier 1 Supplier 2 Supplier 3
Finish 1 11.9 6.8 13.5
Finish 2 10.3 5.9 10.9
Finish 3 9.5 8.1 12.3
Finish 4 8.7 7.2 14.5
Finish 5 14.2 7.6 12.9
Problem 6-24
Paintfast Manufacturing Co.
Description Name Low level High level
Factor 1 Drying agent 10 mg. 20 mg.
Factor 2 Temperature 80 degrees 100 degrees
Treatment Factor 1 Factor 2 Response=Dryability
A Low Low 78
B High Low 91
C Low High 85
D High High 87
Problem 6-25
Sival Electronics
Signal Material Temperature Output Voltage
Low Silicon Low 7
High Silicon Low 16
Low Gold Low 8
High Gold Low 18
Low Silicon High 14
High Silicon High 10
Low Gold High 11
High Gold High 12
