Problem 4

profilecanada2016
C06Data.xlsx
Home>Reading homework help>Problem 4

Prob 06-2 Bill Count

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
Valles Verdes Partners, P.S.C.
Applying the COUNTIF FUNCTION
Answers the question: Is the bill overdue?
FALSE TRUE TRUE FALSE FALSE TRUE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE
FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
FALSE FALSE TRUE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
TRUE FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE TRUE FALSE TRUE FALSE FALSE FALSE
FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE TRUE
TRUE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE
FALSE FALSE FALSE FALSE FALSE FALSE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
TRUE FALSE TRUE FALSE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE
FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE FALSE
FALSE FALSE FALSE TRUE FALSE FALSE TRUE FALSE TRUE FALSE FALSE FALSE TRUE FALSE FALSE

Prob 06-11

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
32.92
23 25 25 26

Prob 06-12

Problem 6-12
Blood Tests at Rivercreek Labs
Descriptive Statistics
2.3 3.7 3.6 4.7 3.4 3.3 2.7 3.6 1.9 1.7
5.0 4.5 3.7 4.1 2.7 4.1 2.5 4.2 3.5 3.1
3.4 3.7 2.3 4.0 2.9 3.9 4.8 1.5 3.1 4.3
4.4 3.2 4.1 2.7 5.1 3.8 3.1 4.4 3.9 4.1
1.7 2.5 3.4 4.2 1.8 4.3 3.9 4.5 2.4 4.4
3.5 3.6 4.1 3.6 4.4 3.8 3.7 3.3 2.6 4.7
3.0 3.4 3.0 4.6 4.8 2.6 3.6 2.9 2.8 3.7
4.1 3.8 3.6 5.1 4.0 3.5 3.3 3.7 4.4 1.8
2.9 4.7 2.4 3.3 3.3 2.6 4.1 1.9 3.6 3.7
3.7 3.7 3.8 3.3 5.4 2.6 3.3 3.5 3.5 4.4
3.528

Prob 06-13

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

Prob 06-20

Problem 6-20
Rabbitfoot Bank, Inc.
Rabbitfoot Industry Data
33.9 40.0 37.4 40.3 39.2 40.8 35.9 41.1 35 32.8
34.8 39.6 43.8 36.7 43.7 38.3 37.2 40 36.3 34.5
35.0 38.5 36.0 41.4 39.9 39.5 36.8 41.6 40.1 42.2
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 z-Test: Two Sample for Means
38.4
37.5 Variable 1 Variable 2
40.2 Mean 39.475 38.8933333333
Known Variance 6.1534 6.6307
Observations 36 30
Hypothesized Mean Difference 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

Prob 06-21

Problem 6-21
Softswell 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

Prob 06-22

Problem 6-22
White Clay Pottery
Temp-deg C Brittleness
700 3.2
750 1.8
800 3.9
850 2.8
900 4.2
950 4.8
1000 4.7
1050 5.3
1100 5.5
1150 5.4
1200 6.3
1250 7.0
1300 6.8
1350 7.7
1400 8.1

Prob 06-23

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

Prob 06-24

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

Prob 06-25

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