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: "AMade and BMade" referenced instead of "BMade and CMade"
- Page 393: Low Should Be Medium
- Page 472: Cell J19 referenced instead of cell I19
- Page 504: 40 Should Be $50
MORE INFORMATION
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:
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: "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)."
Page 393: Low Should Be Medium
There is an error on the bottom of page 393. The word "low" should be changed to "medium."
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."
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.