会计数据分析Errata-for-IRC-09-04-19

DataAnalyticsforAccounting1e

Errata

Chapter1–Page9

Change"dependent"to"independent"onthe12thtextlineunderstep3content.

Chapter1–Page15

Change"ApprovedLoan"to"DeclinedLoanApplications"onthe1sttextline.

Chapter1–Exhibit1-9

Inexhibitdescription,thetitleshouldbe"LendingClubDeclinedLoanApplicationsbyEmploymentLength(YearsofExperience)"

Chapter2–Page42

UpdatedExhibit2.1below:

Chapter2–Pages68and72(Lab2-3and2-4)

InStep1forbothLab2-3and2-4,studentsaredirectedtoopentheirwebbrowserandgototheLendingClubwebsite.However,duetoaccessrightchanges,nowstudentsshouldaccessthedatafile(LoanStats3c.csv)ontheAdditionalStudentResourcespageviaConnect.

Chapter2–Page71

Instep26,replacetheword“month”with“year”inthefirstsentence,soitreads:“Usethe=YEAR([columnaddressforissue_d])formulatoextracttheyear”

Instep26,replacetheword“month”with“year”inthesecondsentence,soitreads“Youshouldseeayearnumbervalueineachcell.”

Chapter3–Page108

Switchyandxaxisinlastparagraph

Chapter4–Page139

Replace"Exhibit4-1showsthe"with"TheFiveThirtyEightbloggraphedthedifferencebetweentheactual..."onthe4thtextline.

Chapter5–Page191

Changesecondsentenceto"TakePwC'sHalo,forexample."Remove"showninExhibit5-1"onthe1stand2ndtextline.

Chapter6–Page235

Change“AccountsPayable”with“AccountsReceivable”onthe9thtextlinefromthetopofthepage.

Chapter6–Page238

InLab6-2,changethenotationforthelastbucket(>90)to90+

Chapter6–Page252

Change“DavidP.Porter”with“DavidP.Norton”onthe7thtextlinefromthebottomofthepage.

Chapter6–Page247

ChangePart4,Q3(line6)“mostChristmassalesarereturninJanuary”to“mostChristmassalesarereturnedinDecember”.

Chapter7–Page296/297

Change“LoadingthedataintoTableau”to“LoadingthedataintoExcel”

ChangeformulaforLastYearMeasureto=CALCULATE(sum([Amount]),SAMEPERIODLASTYEAR('Calendar'[Date])))

ChangeformulaforPreviousMonthMeasureto=CALCULATE(SUM([Amount],PREVIOUSMONTH('Calendar'[Date])))

Chapter8–Page306

Deletethesecondinstanceof(Netprofit/Sales)onthe6thtextlineunderthetitle“DuPontRatioAnalysis”.

Chapter8–Page315

ThenormalizedXBRLtagfordepreciation[Depreciation(&Amortization),IS]and[Depreciation(&Amortization),CF]shouldh