Microsoft KB Archive/842652

= Microsoft Excel Data Analysis And Business Modeling Comments And Corrections =

Article ID: 842652

Article Last Modified on 8/15/2006

-

APPLIES TO


 * MSPRESS Microsoft Excel Data Analysis And Business Modeling Comments And Corrections, ISBN 0-7356-1901-8

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft Excel Data Analysis and Business Modeling, 0-7356-1901-8.

The following topics are covered:


 * CD-ROM: s3_4.xls sample file uses an incorrect formula
 * CD-ROM: s10_4.xls sample file uses a period of 240 rather than 120
 * CD-ROM: Missing Chapter 10 Solution Files
 * Page 362: &quot;AMade and BMade&quot; referenced instead of &quot;BMade and CMade&quot;
 * Page 393: Low Should Be Medium
 * Page 472: Cell J19 referenced instead of cell I19
 * Page 504: 40 Should Be $50



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

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)

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

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

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.

Page 362: &quot;AMade and BMade&quot; referenced instead of &quot;BMade and CMade&quot;
On page 362, the first sentence reads:

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

It should read:

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

Page 393: Low Should Be Medium
There is an error on the bottom of page 393. The word &quot;low&quot; should be changed to &quot;medium.&quot;

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

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

It should read:

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

Page 504: 40 Should Be $50
There are two errors on page 504. The instances of &quot;40&quot; on lines 5 and 9 should be changed to &quot;$50&quot;.

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.

Additional query words: 0-7356-1901-8 978-0-7356-1901-2

Keywords: kbdocfix kbdocerr KB842652

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.