# Corrections to Applied Statistics with Microsoft Excel

#### Despite our best efforts to produce error-free books various types of mistakes remain. On this page we will announce all such errors and their corrections. If you discover a new one please e-mail us at gkeller@wlu.ca

#### 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.28a**There 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.28a**There 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.