# Errata for Analyzing Business Data with Excel

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page 5
Figure 1-4. Working with INDIRECT and ADDRESS

Anonymous
Printed
Page 20
1.3.3.4. Binomial distribution

"Excel has a function that answers this question. The formula is: =BINOMDIST(10,75,0.1,TRUE) should be: =BINOMDIST(10,75,0.1,FALSE)

Anonymous    Aug 01, 2007
Printed
Page 31
First paragraph, second sentence

show only to two decimal places should be show only two decimal places

Anonymous    Aug 01, 2007
Printed
Page 47
Both figure 3-4 and the formula on pg 47 are wrong.

the formula in the second para shown as: =C16*(1+(B16/C16))/2) should be =C17*((1+(B16/C16))/2)

Anonymous
Printed
Page 48
3rd paragraph

The paragraph on page 48 that reads: In FIGURE 3-6 above the adjusted prediction for the next day is 14,630. There is a 90% probability that the actual value will be 14,630 +/- 305. The array formula for this calculation is ={CONFIDENCE(0.1,STDEV(D3:D16-B3:B16),15)}. The CONFIDENCE function returns the confidence interval. It takes three arguments. The first is the desired confidence level. This is entered as the amount of expected error, so if you want a confidence level of .9 the entry is 1-.9 or .1. Next is the standard deviation. In this case it is the standard deviation of the difference between the actual and the adjusted prediction. This is calculated as part of the formula and accounts for this being an array formula. The last argument is the number of values being used. There are 15 values. Should read: In FIGURE 3-6 above the adjusted prediction for the next day is 14,630. There is a 90% probability that the actual value will be 14,630 +/- 1180. The array formula for this calculation is ={STDEV(D65:D78-B65:B78)*1.64}. We expect about 90% of errors to be within 1.64 standard deviations of the average error. At this point we expect an average error of zero, since there is no trend. This is an array formula because we are calculating the errors inside the STDEV function.

Anonymous    Aug 01, 2007