Analyzing Business Data with Excel by Gerald Knight The unconfirmed error reports are from readers. They have not yet been approved or disproved by the author or editor and represent solely the opinion of the reader. Here's a key to the markup: [page-number]: serious technical mistake {page-number}: minor technical mistake : important language/formatting problem (page-number): language change or minor formatting problem ?page-number?: reader question or request for clarification This page was updated April 7, 2008. UNCONFIRMED errors and comments from readers: [entire book] There is a lack of data available at http://examples.oreilly.com/9780596100735/ . The data is not nearly complete. As a glaring example, the data used for examining pivot tables in Chapter 2 is completely missing. (17) The reference to Figure 1-17 should instead be Figure 1-18 (22) Figura 1.7; the formula shown as: =PROMEDIO(B2:B6) should be =PROMEDIOA(B2:B6) (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) [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)