Site Accessibility Statement
 July 1, 2016

# Contact:

email: Gerald Keller

# Corrections to Applied Statistics with Microsoft Excel

#### To determine the printing turn to page iv where the following appears:

"Printed in the United States of America" followed by a series of numbers.
The first printing is identified by: 10 9 8 7 6 5 4 3 2 1
The second printing will display 10 9 8 7 6 5 4 3 2
The third printing will display 10 9 8 7 6 5 4 3

# First Printing

Page 75, Exercise 3.42 c: Add "What are they"?

Page 114, Exercise 4.61: Add "If the company loses contract A the probability of winning contract B is .2".

Page 220, Exercise 8.33, second sentence: To examine this belief he took a random sample of 25 male drivers and asked each what he did when lost.

Page 535, Exercise 16.53, second-last sentence: Change three to four.

Pages 548 and 558, Excel printout:coefficients and t Stat for Odometer Change them as follows

Coefficient = -0.0312; t Stat = -13.49

Page 568, Exercise 17.41: Change 17.27 to 17.28.

Page 592, Excel printout:coefficients and t Stat for ROOMS, NEAREST, and INCOME Change them as follows

ROOMS: Coefficient = -.0076; t Stat = -6.07

NEAREST: Coefficient = -1.65; t Stat = -2.60

INCOME: Coefficient = -0.41; t Stat = -2.96

Page 607, Excel printout:coefficients and t Stat for LOT SIZE Change them as follows

Coefficient = -4.36; t Stat = -0.26

Page 617, Excel printout:coefficients and t Stat for TEMPERATURE Change them as follows

Coefficient = -8.75; t Stat = -0.44

Page 620, Excel printout:coefficients and t Stat for TEMPERATURE Change them as follows

Coefficient = -9.23; t Stat = -0.84

Page 624, Excel printout:coefficients and t Stat for Odometer and Color Change them as follows

Odometer: Coefficient = -0.0313; t Stat = -13.56

Color: Coefficient = -21.67; t Stat = -1.20

Page 626, Excel printout:coefficients and t Stat for Odometer Change them as follows

Coefficient = -0.0278; t Stat = -11.72

### Appendix C

1.4g Change reject to support.

3.18 Variance = 54.19 and standard deviation = 7.36

5.28c Change 0 to .001.

10.34 There is enough evidence to infer that the population mean differs from 25.

10.54 Change .0176 to .0773.

11.70 The p-value decreases.

12.18 Decreasing the mean of sample 1 decreases the p-value and increasing the mean of sample 1 increases the p-value. The width of the interval does not change.

12.20a Change yes to no.

12.28b 6.03 +/- 6.60

14.28aThere are 12 treatments. b Factor A (columns) is the form and factor B (samples)is the income group.

14.52b F = 2.84

18.64f Change 49.01 to 49.02.

# Second Printing

Page 75, Exercise 3.42 c: Add "What are they"?

Page 114, Exercise 4.61: Add "If the company loses contract A the probability of winning contract B is .2".

Page 220, Exercise 8.33, second sentence: To examine this belief he took a random sample of 25 male drivers and asked each what he did when lost.

Page 535, Exercise 16.53, second-last sentence: Change three to four.

Pages 548 and 558, Excel printout:coefficients and t Stat for Odometer Change them as follows

Coefficient = -0.0312; t Stat = -13.49

Page 568, Exercise 17.41: Change 17.27 to 17.28.

Page 592, Excel printout:coefficients and t Stat for ROOMS, NEAREST, and INCOME Change them as follows

ROOMS: Coefficient = -.0076; t Stat = -6.07

NEAREST: Coefficient = -1.65; t Stat = -2.60

INCOME: Coefficient = -0.41; t Stat = -2.96

Page 607, Excel printout:coefficients and t Stat for LOT SIZE Change them as follows

Coefficient = -4.36; t Stat = -0.26

Page 617, Excel printout:coefficients and t Stat for TEMPERATURE Change them as follows

Coefficient = -8.75; t Stat = -0.44

Page 620, Excel printout:coefficients and t Stat for TEMPERATURE Change them as follows

Coefficient = -9.23; t Stat = -0.84

Page 624, Excel printout:coefficients and t Stat for Odometer and Color Change them as follows

Odometer: Coefficient = -0.0313; t Stat = -13.56

Color: Coefficient = -21.67; t Stat = -1.20

Page 626, Excel printout:coefficients and t Stat for Odometer Change them as follows

Coefficient = -0.0278; t Stat = -11.72

### Appendix C

1.4g Change reject to support.

3.18 Variance = 54.19 and standard deviation = 7.36

5.28c Change 0 to .001.

10.34 There is enough evidence to infer that the population mean differs from 25.

10.54 Change .0176 to .0773.

11.70 The p-value decreases.

12.18 Decreasing the mean of sample 1 decreases the p-value and increasing the mean of sample 1 increases the p-value. The width of the interval does not change.

12.20a Change yes to no.

12.28b 6.03 +/- 6.60

14.28aThere are 12 treatments. b Factor A (columns) is the form and factor B (samples)is the income group.

14.52b F = 2.84

18.64f Change 49.01 to 49.02.

# Third Printing

### Appendix C

10.54 Change .0176 to .0773.

# Student Solutions Manual

10.54 Change alpha .05 to .01 and .0176 to .0773.