Scribd
Upload
259 views16 pages

C06 Data

This document contains data sets and problems for chapter 6. It includes data on answers to test questions, descriptive statistics on test scores, temperature readings, supplier performance, and experimental factors and results. The data is provided to help solve problems that require substantial amounts of data from the chapter.

Uploaded by

Andrei Moreno
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
259 views16 pages

C06 Data

This document contains data sets and problems for chapter 6. It includes data on answers to test questions, descriptive statistics on test scores, temperature readings, supplier performance, and experimental factors and results. The data is provided to help solve problems that require substantial amounts of data from the chapter.

Uploaded by

Andrei Moreno
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 16

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

You might also like