Errata

Microsoft® Excel Data Analysis and Business Modeling

Errata for Microsoft® Excel 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 CD-ROM

s10_4.xls sample file uses a period of 240 rather than 120
In the s10_4.xls sample file, cells C6, C9, and C10 respectively read:

=-FV(0.008,240,1000,0,0)=(1000000-C6)/1.008^240=-PV(0.008,240,0,(1000000-C6),0)They should read:

=-FV(0.008,120,1000,0,0)=(1000000-C6)/1.008^120=-PV(0.008,120,0,(1000000-C6),0)

 Microsoft Press  Jul 13, 2010 
Other Digital Version
CD-ROM

s3_4.xls sample file uses an incorrect formula In the s3_4.xls sample file, cells D5-D8 read: =D4+C5*(B5-B4) =D5+C6*(B6-B5) =D6+C7*(B7-B6) =D7+C8*(B8-B7)They should read: =D4+C4*(B5-B4-1)+C5 =D5+C5*(B6-B5-1)+C6 =D6+C6*(B7-B6-1)+C7 =D7+C7*(B8-B7-1)+C8

 Microsoft Press  May 06, 2010 
Other Digital Version
CD-ROM

Missing Solution Files
End-of-chapter solution files 11-13 for Chapter 10 are missing from the companion CD, and the end-of-chapter problem 2 solution file for Chapter 15 provided on the companion CD is incorrect..

The following file is available for download from the Microsoft Download Center: SolutionFiles.exe
http://download.microsoft.com/download/8/5/4/85442c18-0b73-487b-a216-3dcb5aed57f0/solutionfiles.exe

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

 Microsoft Press  May 06, 2010 
Printed
Page 362

"AMade and BMade" referenced instead of "BMade and CMade"
On page 362, the first sentence reads:

"We see that AMade and BMade each have very low p-values (.002 and .007, respectively)."

It should read:

"We see that BMade and CMade each have very low p-values (.002 and .007, respectively)."

 Microsoft Press  Jul 13, 2010 
Printed
Page 393

Low Should Be Medium There is an error on the bottom of page 393. The word "low" should be changed to "medium."

 Microsoft Press  May 06, 2010 
Printed
Page 472

Cell J19 referenced instead of cell I19
On page 472, the first sentence reads:

"Next we select our table range (J19:K1019) and select Data, Table."

It should read:

"Next we select our table range (I19:K1019) and select Data, Table."

 Microsoft Press  Jul 13, 2010 
Printed
Page 504

40 Should Be $50 There are two errors on page 504. The instances of "40" on lines 5 and 9 should be changed to "$50". Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.

 Microsoft Press  May 06, 2010