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