Chapter 6 Problem 2 (Hint: Use the Countif function in Excel and the Binomial Probability Distribution Template) Problem 3 (Hint: Use the Poisson Probability Distribution Template) Problem 6 (Hint: Use the Inverse Normal Distribution Template and the Normal Distribution Template) Problem 10 (Hint: Use the Exponential Probability Distribution Template) Problem 20 (Hint: Use Descriptive Statistics tool in the Excel Data Analysis menu) Problem 21 (Hint: Use the single factor ANOVA tool in the Excel Data Analysis menu) Problem 24 (Hint: Use the 22 Factorial Experiment Template) Problem 25 (Hint: Use the 23 Factorial Experiment Template)

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

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

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.5