Analyzing Business Data with Excel
by Gerald Knight

This errata page lists errors corrected in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated August 7, 2007.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



{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)


(31) First paragraph, second sentence;
show only to two decimal places
should be
show only two decimal places


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