Errata

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling

Errata for Microsoft® Office Excel® 2007: Data Analysis and Business Modeling

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

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

Version Location Description Submitted by Date submitted
Other Digital Version Chapt. 2
Chapter 2 problems

Formula mistake I believe in Chapter 2 on the 6th problem in this Chapter on Lookup functions.

It involves the Citydata.xlsx file and the solution file s2_6.xlsx. The formula reads:

=69*SQRT((VLOOKUP($I7,$D$7:$F$27,2,FALSE)-VLOOKUP(J$6,$D$7:$F$27,2,FALSE))^2+(VLOOKUP($I7,$D$7:$F$27,3,FALSE)-VLOOKUP(J$6,$D$7:$F$27,3,FALSE))^2)

I get an NA error when I do it in the practice file.

Ronald Black  Apr 22, 2012 
Printed Page 21
Question 5 Solution on Excel Spreadsheet S3-5

the text is not flawed. The CD contains an incorrect spreadsheet. Cell C64 contains no data. It should contain the number 1 to reflect Atlanta as the destination. It causes the formula in cell E64 to arrive at an incorrect conclusion resulting in the total being incorrect in Cell E33

 Cathie blanchard  Sep 08, 2010 
Other Digital Version 43
solution 6-7

it is in the solutions to the problems on the disk, not in the text. Problem 6-7 should include the holidays rather than excluding them by including them in the formula on the spreadsheet.

 Cathie Blanchard  Sep 13, 2010 
Other Digital Version 65
problem 4

The question is not clear and the answer on the excel solution as received on the CD received with the book does not relate to the question.

 Cathie Blanchard  Sep 27, 2010 
Other Digital Version 65
QUESTION 7

No response on the solutions on the CD for the second response asked for on question 7 (beginning of the month payments)

 Cathie Blanchard  Sep 27, 2010 
Other Digital Version 65
Question 7

Question 7, part 2 is answered as S9-8, making the answers out of sync to the questions for the remainder of the questions for chapter 9

 Cathie Blanchard  Sep 27, 2010 
Other Digital Version 65
Question 9

If I have a liability of 1mill in 10 years, I would be earning interest on the amount I was setting aside, therefore, wouldn't =FV(.10,10,-62745.39,0,0) equaling 1,000,000 be the correct answer for the check calculation and =PMT(0.1,10,0,-1000000,0) equaling 62745.39 per year be the amount to set aside? The solution is determining 1,000,000 to be the present value.

 Cathie Blanchard  Sep 27, 2010 
Other Digital Version 67
problem 23

Rate stated in the text problem .08, in cd .077 and I don't understand why the formula for the 65 til death includes the exponential function affecting the rate (=-PV(0.077,H7-65,10000,0,1)/(1+H6)^3). Additionally, I would have used FV for this problem. FV = PV*(1+r)^n, so it seems to me to make the 62 and 65 examples equivalent, one should have shown FV and the function and the other PV*(1+r)^n.

 Cathie Blanchard  Sep 27, 2010 
Other Digital Version 67
Problem 24

Problem indicates student is to find the rate, but the solution on the cd appears to be just guessing at the rate by using the formula for pv. The formula for pv uses 50 periods. Supposed to be 20. I don't know how to do this problem with the information & solution given. =RATE(20,-50000,0,500000,0,D226)gives me -8.19% which comes close when I put it in the pv function to compare to a pv of $500000.

 Cathie Blanchard  Sep 27, 2010 
Other Digital Version 67
problem 26&27

CD solutions to not respond to the question. 27 solution talks about savings rather than borrowing and is at the beginning of the period. And, #26 appears to have something wrong with the interest calculation.

 Cathie Blanchard  Sep 27, 2010 
Printed Page 87
problem 9

Problem describes the game of craps without identifying the rolls that result in a loss (2,3,12). However, the solution on the cd includes that data.

Cathie Blanchard  Oct 04, 2010 
Other Digital Version 96
Question 2 a b c

problem 2 a b c solution files on cd cannot be opened, either corrupt of format wrong???

 Cathie Blanchard  Oct 18, 2010 
Other Digital Version 96
problem 3

same as problem 2 cd error on solution

 Cathie Blanchard  Oct 18, 2010 
Other Digital Version 101
problem 3

Problem 3 requires you to link copied data to original data but you can't do that. Solution 3 on the disk does not reflect the ability to do that either.

 Cathie Blanchard  Oct 21, 2010 
111
2

By this, I bring to notice of the publisher, Microsoft and the Author himself. The example of what if anlysis using data sheet function, posted at Microsoft web site does not show correct figures. For example, one variable case only intended for affect of a price change, also shows ?changes in variable cost column? used for data sheet range. Also if you manually check, for a price of $ 3.75, the figures of profit are respectively 50,700.00; 108,750.00 and not 58,125; 117,187.50 (since demand and unit cost are assumed constant in one variable analysis) as shown in Microsoft web site
Will the author take some time to correct this oblivious error in data analysis?

 Anonymous  Mar 18, 2011