版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
ModelingandEvaluationChapter3Wherewearenow1.DataAnalytics2.DataPreparationandCleaning3.ModelingandEvaluation4.Visualization5.TheModernAudit6.AuditAnalytics7.KeyPerformanceIndicators8.FinancialStatementAnalyticsObjectivesLO3-1Whatdoyouneedtoknowaboutdatamodels?LO3-2Whataresomeunsupervisedandsupervisedapproaches?LO3-3Howdoyouperformprofiling?LO3-4Howdoyouperformdatareduction?LO3-5Howdoyouperformregression?LO3-6Howdoyouperformclassification?LO3-7Howdoyouperformclustering?IntheIMPACTcycle,we’renowgoingtolookatPerformingtheTestPlanandAddressingtheResults.IdentifythequestionsMasterthedataPerformtestplanAddressandrefineresultsCommunicateinsightsTrackoutcomesExhibit1-1TheIMPACTCycleWhatdoyouneedtoknowaboutdatamodels?LO3-1Whatdoyouneedtoknowaboutdatamodels?Atargetisanexpectedattributeorvaluethatwewanttoevaluate.Example:FraudscoreInterestrateAclassisamanuallyassignedcategoryappliedtoarecordbasedonanevent.Example:Accept/RejectFraud/NotfraudWhatdoyouneedtoknowfirst?Anunsupervisedapproachisusedwhenyoudon’thaveaspecificquestion.Example:“Doourvendorsformnaturalgroupsbasedonsimilarattributes?”Asupervisedapproach
isusedwhenyouaretryingtopredictafutureoutcomebasedonhistoricaldata.Example:“Willanewvendorshipalargeorderontime?”Whataresomeunsupervisedapproaches?Clustering
–findundiscoverednaturalgroupingsinthedataCo-occurrencegrouping–eventsthathappentogetherProfiling
–identifytypicalbehaviorinthedataDatareduction–filterorgroupthedatatosimplifytheanalysisWhataresomesupervisedapproaches?Classification
–predictwhetherdatabelongstooneclassoranotherSimilaritymatching–groupdatabyattributesRegression
–predictaspecificvalueLinkprediction–socialnetworksCausalmodeling–aneventinfluencesanotherUseaflowcharttoidentifyanappropriateapproach.Q.Whatisthemaindifferencebetweensupervisedandunsupervisedmethods?Howdoyouperformprofiling?LO3-2Profilingreliesongatheringsummarystatisticsandidentifyingoutliers.Identifytheobjectsoractivityyouwanttoprofile.Determinethetypesofprofilingyouwanttoperform.Setboundariesorthresholdsfortheactivity.Interprettheresultsandmonitortheactivityand/orgeneratealistofexceptions.Followuponexceptions.Whataresomeexamplesofprofiling?Internalauditorsanalyzetravelandentertainmentexpensesforviolationsofinternalcontrols.Managersuseprofilingtocomparevariancesfromtargetranges.Whataresomeexamplesofprofiling?Inthecontinuousaudit,anauditormayuseBenford’sLawtoevaluatethefrequencydistributionofthefirstdigitsfromalargesetofnumericaldata.Q.Profilingisusedinlawenforcementforoffenderorcriminalprofiling.Howdoesthiscomparewithprofilingaccountingdata?Howdoyouperformdatareduction?LO3-3Datareductionisusedtofilterresults.1.Identifytheattributeyouwouldliketoreduceorfocuson.2.Filtertheresults.3.Interprettheresults.4.Followupontheresults.Whataresomeexamplesofdatareduction?InternalauditorsmaywanttolocatepaymentsmadetoSquarevendors.FinancialstatementanalystswilltakeXBRLinstancedocumentsandfilteronspecifictags.Q.HowmightthedatareductionapproachbeusedtosimplifyT&Eexpenses?Howdoyouperformregression?LO3-4Regressionallowstheaccountanttodevelopmodelstopredictexpectedoutcomes.Identifythevariablesthatmightpredictanoutcome.Determinethefunctionalformoftherelationship.Identifytheparametersofthemodel.Dependentvariable=f(independentvariables)Whataresomeexamplesofregression?Inmanagerialaccounting,regressionmaypredictemployeeturnover:Employeeturnover=f(currentprofessionalsalaries,healthoftheeconomy[GDP],salariesofferedbyotheraccountingfirmsorbycorporateaccounting,etc.)Inauditing,regressionmaybeusedtodeterminetheappropriatenessofallowanceaccounts:Allowanceforloanlosesamount=f(currentagedloans,loantype,customerloanhistory,collectionssuccess)Q.Regressionisusedtopredictstockreturnsfollowingarestatementofpastearnings.Whatfactors(independentvariables)doyouthinkmightpredictthechangeinstockprice(dependentvariable)?Howdoyouperformclassification?LO3-5Thegoalofclassificationistopredictwhetheranindividualweknowverylittleaboutwillbelongtooneclassoranother.Identifytheclassesyouwishtopredict.Manuallyclassifyanexistingsetofrecords.Selectasetofclassificationmodels.Divideyourdataintotrainingandtestingsets.Generateyourmodel.Interprettheresultsandselectthe“best”model.Whatelsedoyouneedtoknowaboutclassification?Trainingdataareexistingdatathathavebeenmanuallyevaluatedandassignedaclass.Testdataareexistingdatausedtoevaluatethemodel.Decisiontreesareusedtodividedataintosmallergroups.Decisionboundariesmarkthesplitbetweenoneclassandanother.Whatelsedoyouneedtoknowaboutclassification?Pruning
removesbranchesfromadecisiontreetoavoidoverfittingthemodel.Whatelsedoyouneedtoknowaboutclassification?Linearclassifiersareusefulforrankingitemsratherthansimplypredictingclassprobability.Theseareusefulfordeterminingthereallyimportantvalues,suchasvaluablecustomers,orwhichtransactionsaremostlikelyfraudulent.Whatelsedoyouneedtoknowaboutclassification?Supportvectormachineisadiscriminatingclassifierthatisdefinedbyaseparatinghyperplanethatworksfirsttofindthewidestmargin(orbiggestpipe)andthenworkstofindthemiddleline.Howdoweevaluateclassifiers?Trytoavoidoverfitting,ormodelsthataretooaccurate.Theyareactuallyprettybadapredictingafutureobservation.Lookforthesweetspotwherewemaximizetheaccuracyofthetestingdata.Q.Ifwearetryingtopredictwhetheraloanwillberejected,wouldyouexpectcreditscoretobepositivelyornegativelyassociatedwithloanrejection?Howdoyouperformclustering?LO3-6Howdoyouperformclustering?Clusteringisusedtoidentifygroupsofsimilardataelementsandtheunderlyingdriversofthosegroups.Clusteringalgorithmscalculatetheminimumdistanceofallobservationsandgroupsthoseelements.Whataresomeexamplesofclustering?Internalauditorscanuseclusteringtoidentifygroupsoftransactionsthatmayindicateriskorfraudininsuranceorotherpayments.Q.WhatarethreeclustersofcustomerswhomightshopatWalmart?SummaryInthischapter,weaddressedthethirdstepoftheIMPACTcyclemodel:the“P”for“performingtestplan.”Thatis,howarewegoingtotestoranalyzethedatatoaddressaproblemwearefacing?Basedonourproblemandthedataavailable,weprovidedaflowchartthathelpstheanalyst
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 公用工程题库练习试题及答案
- 高考数学复习解答题提高第一轮专题复习专题10数列求和(插入新数列混合求和)(典型题型归类训练)(学生版+解析)
- 语文统编版(2024)一年级上册语文园地5 教案
- 高中英语语法第一讲定语从句
- 第2章 心理的生理基础课件
- 班主任家长会课件
- 5年中考3年模拟试卷初中生物八年级下册第三节两栖动物的生殖和发育
- 三分钟爱国小故事简短
- 苏少版小学音乐三年级上册教案全册
- 地质灾害危险性评估报告专家审查表
- Q∕GDW 11442-2020 通信电源技术、验收及运行维护规程
- 我国现役主要科考船对比
- 标本运输溢洒应急处置流程
- GB∕T 13761.1-2022 土工合成材料 规定压力下厚度的测定 第1部分:单层产品
- 体育教学——专题讲座
- (完整版)1电缆通道维修施工方案
- 安徽怀洪新河河道堤防白蚁防治情况普查报告
- 供热行业安全生产风险隐患双重预防体系建设实施细则
- 七年级数学上册有理数的混合运算(华师大版)精选教学PPT课件
- 财务收支记账表
- 液压爬模计算书
评论
0/150
提交评论