Errata
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
| Version |
Location |
Description |
Submitted By |
| 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 |
| 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 |
| 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 |
| 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 |
