Errata

Analyzing Business Data with Excel

Errata for Analyzing Business Data with Excel

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page 7
Fugure 1-8

Hi

In figure 1-8, on page 7, Cell D2 has the formula shown as ="= "&D5 which produces the value '= East'.

This stops the 'DAVERAGE' formula in Cell D15 from working.

The value needs to just have the value 'East' to work properly.

Only a minor issue but it took some time for me to go to Microsoft help page to find why it didn't work.

For someone learning the formulae in the book, a reader assumes they are wrong rather than the book being wrong.

Thanks

 Anonymous  Sep 14, 2009 
Printed Page 10
Figure 1-11

The Filtered Average formula is incorrect.

The result in Cell D5 is 14,938, however, it shows in Cell F5 the formula subtracting the maximum value in the A2:A100 range but adding the Minimum value in that range.

The Minimum should also be subtracted from the dataset.

It is written above how the formula should work but I copy the exact format of the formula as shown in the book & then have to correct it.

Thanks

Anonymous  Sep 14, 2009 
Printed Page 10
Formula in figure 1-11

The person that posted that the filtered average is incorrect is actually wrong. It is not subtracting the max and adding the min, it is subtracting the sum of the max and min (check the parentheses). They book is right for once, but the reviewer is wrong.

 Anonymous  Apr 12, 2010 
Printed Page 17
The reference to Figure 1-17 should instead be Figure 1-18

Anonymous   
Printed Page 17
4th paragraph

The reference to the value of 'Q1' & 'Q2' are actually in Figure 1-18 & not in 1-17.

Did anyone proof read this?

This is the 3rd error I've found from page 7 to page 17.

I'm not going to bother sending you any other corrections or I'll never finish the book.

It's just as well I can workaround the mistakes otherwise the book would not be useful as I wouldn't understand why things written out don't work.

This is the most unreliable O'Reillys book I've purchased & I will check reviews before I buy another.

I'd also be interested to know why the errors I've reported aren't on your errata page already from another reader....

Anonymous  Sep 14, 2009 
Printed Page 17
5th paragraph

Figure 1-17 in the following sentence should be 1-18: In Figure 1-17 cell Q1 has the average and Q2 has the standard deviation.

 Anonymous  Jun 23, 2012 
Printed Page 22
Figura 1.7

the formula shown as:
=PROMEDIO(B2:B6)
should be
=PROMEDIOA(B2:B6)

 Anonymous   
Printed Page 25
tha last paragraph

the formula in the last paragraph shown as:
=SUMAR.SI(A2:A18;D2;D2:B18)/CONTAR.SI(A2:A18;D2)
should be:
=SUMAR.SI(A2:A18;D2;B2:B18)/CONTAR.SI(A2:A18;D2)

 Anonymous   
Printed Page 50
Figure 3-5 formula for Standardize

Are we are trying to assess whether the current error of 538 (b17-d17) is an anomaly, i thought that the
standardize formula should be equal to {=abs(standardize(b17-d17, d24,d23)

However in my version (2006) it is written {=abs(standardize(b17-c17, d24,d23)

 Anonymous