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 |
Excel sheet F18 reads =ADDRESS(D12,D11..."MyDataSheet"),
it should be =ADDRESS(D12,D11,,,"MyDataSheet")
|
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 |