Errata for Microsoft® Excel Data Analysis and Business Modeling
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. 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 |
|
|
| |
