Errata
Statistics for Managers using Microsoft Excel 6/e
p. 24 Problem 2.24 the columns in the table are out of order. The third column should be first. The columns should be
136 224 360
104 36 140
240 260 500
p. 45 Problem 2.49 there should be an additional 7 in the line (stem) beginning with 11
p. 58 Problem 2.81 a third line change do their banking to pay their monthly bills
p. 58 Problem 2.82 a second line change “in that show where people prefer to do their banking” to “for the risk level”
p. 62 In Problem 2.96 at the top of the left column, the numbers in the female and total columns are switched. The numbers in the table should be
40 96 136
240 224 464
187 413 600
p. 144 in the equation above the Example 4.7 box, insert a vertical slash between Actually purchased and Planned to purchase
p. 268 In Example 8.4, next to last line, change 0.1292 to 0.2192
p. 293 right column, under In-Depth Excel line 3 NORSMINV should be NORMSINV
p. 293 lower right; fifth line of PHStat2 delete the word Intervals
p. 332 right column, next to last line at bottom worksheets should be worksheet
p. 351 In Figure 10.10 row 18 should say Reject the null hypothesis NOT do not reject the null hypothesis
p. 364 In Problem 10.41, first line, should be problems 10.39 and 10.40
p. 366 In the Summary, left column, first line of second paragraph, Table 10.8 should be Table 10.7
p. 367 Table 10.8 should be 10.7
p. 368 In Equation 10.6, right column, second line, under the square root sign, in the denominator the second n1 should be n2.
p. 369 Problem 10.60 line 6 Section 17.8 not 17.7
p. 377 right column under Analysis ToolPak, step 2, it should be select t-Test not t t-test
p. 409 Equation (11.11) the bar above X sub ij. Should be a single bar not a double bar
p. 420 second column in In-depth Excel, next to last sentence in second indented paragraph – delete of the new worksheet, using Paste Special Values – replace with and
p. 507 Problem 13.56c line 2 change Problem 13.47 to 13.55
p.509 In Table 13.7 in Data Set D, in the last column the heading should be Y not X
p. 524 second column, first paragraph, fifth line, it should be package delivery not Sunflowers Apparel
p. 566 left column, under PHStat2, line 5, delete Linear
p. 596 last line, after 0.1305 hour add for each additional labor hour
p. 600 Problem 15.41 third line under the list of variables. Change objective and type to type and risk
p. 634 last line above figure change 23 to 14
p. 670 next to last line on the page, in the middle, should be 1 +3(d3/d2) not 1 +3(d3 + d2)
p. 741 row 6 degrees of freedom column 0.005, change 18.458 to 18.548
p. 765 3.20 (b) should be $693.72 (c) change $687.70 to $472.93
p. 782 13.30 line 3 change right to left
p. 783 13.62 (a) should be 214.1497 to 279.416
p. 783 13.82 (g) should be 442.9125 to 457.9236 (h) should be 417.394 to
p. 790 (b) and (c)
Linear / Quadratic / Exponential / AR1SSE / 1,130.3499 / 1,111.5207 / 2,971.8765 / 642.6098
Syx / 7.5178 / 7.64860 / 12.1899 / 5.8156
MAD / 5.3475 / 5.4482 / 7.4636 / 4.0881
Online Chapter 19 Problem 19.22 Add the following after the fourth sentence
In the past, for novels that sold 2,000 copies, only 1% received favorable reviews