Errata

Microsoft® Excel® 2010: Data Analysis and Business Modeling

Errata for Microsoft® Excel® 2010: Data Analysis and Business Modeling

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

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

Version Location Description Submitted By Date submitted Date corrected
Printed
Page xi
Bottom

Unable to register book online - no voucher is bound to the back of the book!! Also, there is a link provided on page xv where you can allegedly go to access the online material and the necessary study files - NO SUCH INFORMATION IS AVAILABLE AT THAT SITE. Needs to be resolved ASAP

Note from the Author or Editor:
In some print books the voucher to access the online version of the book hosted by Safari is not bound into the back of the book. To receive your 24-character access code, please call O'Reilly Customer Service at: T: +1.707.827.7000 / 800.998.9938 Customer Service will supply you with your access code.

To access the companion content files, type http://go.microsoft.com/FWLink/?Linkid=207235 into your browser, then click on the Companion Content link on the left sde of the browser window (just below the cover thumbnail).

 Jordan Salins  Jan 18, 2011 
Printed
Page 1
1

The online voucher is missing from my book ... you know this already. However, as far as I can tell, the phone numbers you list for me to call to get a voucher number are US numbers. I live in the UK and I bought my copy of the book in the UK. Please advise.

Best wishes

Duncan

Note from the Author or Editor:
U.K. purchasers should still call the U.S. numbers for voucher support.

 Duncan Williamson  Jul 28, 2011 
Printed
Page 11
end of 1st paragraph

in cell E10 yields 4.75

should be: in cell E11 yields 4.75 ?

 Anonymous  May 02, 2012  Aug 10, 2012
Printed
Page 15
2nd paragraph

"...=AVERAGE(Stocks), computes the average return on stocks (12.05 percent)"
The companion file has the average calculated as 11.28%.

JFrank  Jun 18, 2012  Aug 10, 2012
Printed
Page 17
3rd para

when selecting "apply names" excel crashes. did it five times and crashed five times.
also, it says to select the left row option when it should be select the left column option. He is not clear about what to select prior to using some commands.

 trenholme lodge  Jan 13, 2012  Aug 10, 2012
Printed
Page 27
2nd paragraph

In the book, it calculated the equation below by mistake:

1/4*(9)+3/4*(10)=9.25%

However, the right result of this equation should be 9.75%.

It's a minor mistake.:)

 Anonymous  Jul 02, 2011  Aug 19, 2011
Printed
Page 28
grade table

If grade F is below 60, the grading for D should be 60-69.

David  Feb 04, 2013  Mar 22, 2013
Printed
Page 31
Question 5

In the companion material, the solution for question 5 has the distance from Washington to Atlanta calculated wrongly. The distance should actually be 541.8 whereas the solution file has it as 394.

 Narayana  Jul 08, 2011 
Printed
Page 225
2

2nd paragraph, first bullet point
In cell C15 the formula = COUNTA(Table1[All#]) is given. But it should actually be COUNTA(Table1[#All]).

Again in the 6th bullet point
=SUM(Table1[[Data#],[Q1]:[Q3]]) is printed. But it should actually be
SUM(Table1[[#Data],[Q1]:[Q3]]) .

 BASTIAN K ITTYAVIRAH  Jun 18, 2012  Aug 10, 2012
Printed
Page 450
United States

Page 450, second paragraph 6th line: says "Any independent variable with a p-value (see Column E) of less than or equal to .15 is considered...." The standard is .05.

Page 451, first paragraph, first line says "You can see that A Made and B Made each..." Should say "B Made and C Made."

 Stephen J. Huxley  Feb 23, 2012  Aug 10, 2012
Printed
Page 556
2nd paragraph

In the second sentence of the second paragraph it says "Select the table range (A15:E1014)", the range should be "A15:E1015" to include the 1000th iteration.

It would also be good to mention to push F9 to recalculate the data table at the end of the paragraph to avoid confusion with generating the output from the data table.

 Daniel S  Feb 24, 2012  Aug 10, 2012
Printed
Page 591
middle of page (line 15)

The formula shown as:

d2= d2- rho * sqrt(t)

should be:

d2= d1- rho * sqrt(t)


The formula is entered correctly in the Bstemp.xlsx spreadsheet, however.

 Rashid Beg  Sep 23, 2011  Aug 10, 2012