Errata

Excel Scientific and Engineering Cookbook

Errata for Excel Scientific and Engineering Cookbook

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 71
second example (2-25)

Two reasons the Magnitude function can't work as printed:
1) VBA uses Sqr rather than sqrt
2) x and y haven't been declared as arguments of the function

 Anonymous   
Printed Page 95
next to last bullet point

It does not help to say "You can perform calculations on your filtered data just as
you normally would." This touches on a tricky feature of Excel where normal is not
obvious. Performing calculations on filtered data will surprise many people.

Excel calculations ignore any filtering, whereas the casual user might expect Excel
to perform calculations only on visible data.

 Anonymous   
Printed Page 158
6th paragraph, before equation

First, as the surrounding text suggests, this is a formula for computing the
"Spearman" rank correlation coefficient, not the "Pearson" rank correlation
coefficient.

Second, this formula is not valid in the general case; it is only correct when there
are no ties. (For instance, see the entry for Spearman rank correlation coefficient
in Wikipedia.)

 Anonymous   
Printed Page 161
last paragraph

In "The formula to use . . .", the second RANK( needs to be preceded by a plus sign
rather than a minus sign to get a reasonable result.

 Anonymous   
Printed Page 206/7
In Figure 6-31 and 1st para on page 207

Cells E17 to E31 are not calculated by the given formula in the text (f(i) - i/n.) The cell formula used from the downloaded spreadsheet is of the form (16 - i+16)/n which works. However no explanation is given.

 Anonymous  Mar 07, 2012 
Printed Page 226
Figure 7-3

I cannot calculate the inverse or transpose of the matrix C4:E6. Is something
missing or an instruction left out?

 Anonymous   
Printed Page 293
Example 9.7

while loop does not increment i. So, no protection against infinite loop. Same error in example 9.8 on next page.

 Anonymous  Aug 04, 2014 
Printed Page 300
2nd equation

The equation is

f(t) = exp( -1/4 (t+1) )

The (t+1) should be squared.

This is known from the context of the book as well as Example 10-1 on the same page where the VBA code has (t+1)^2

 Anonymous   
Printed Page 327
1st line after equations

in the equations the author states y' represents dy/dx in the equations. It is y, not y', that represents dy/dx and y' represents the acceleration. This typo caused me great confustion in interpreting the code.

 Anonymous   
Printed Page 331
4th equation (for dy4/dt)

In order to agree with the VBA code on p. 333 and the results shown in the chart on p. 336, the 2nd term of the equation should be preceded by a minus sign, rather than a plus sign.

 Anonymous   
Printed Page 337
1st equation

The first equation is du^2/dt^2

Presumably this is meant to be d^2u/dt^2

 Anonymous   
Printed Page 338
1st equation

The first equation is dy^2/dt

Presumably the superscript should be a subscript,
dy_2/dt (using _ to indicate subscript)

 Anonymous