[SOLVED] 代写 R graph Audit Data Analytics

Audit Data Analytics
Assignment 4
(Adopted from “A Risk-Based Approach to
Conducting a Quality Audit”, 10th Edition, Johnstone)
Due on December 2

Part I
Download US Census estimates for population of states and counties form US Census Bureau:
https://www2.census.gov/programs-surveys/popest/datasets/2010-2018/counties/totals/co-est2018-alldata.csv

•Import the data in columns A to Rinto an ACL project.
•Filter data to keep only rows at county level (SUMLEV =50)
•Perform 2-digit Benford analysis on columns Census 2010, and PopEstimate2018.Send the results to Screen and to Graph.Are there any significant deviations from the expected counts? For PopEstimate2018, print results to a .pdf file.
•Now take the difference of estimated population in 2018 and estimated base population in 2010.Use a filter to exclude rows for which the change in population is in single digits.Perform a 2-digit Benford analysis on the difference. Identify any significant deviations.
•Now use a filter keep data at the state level (SUMLEV = 40). Run the 1-digit Benford analysis on the State level population for 2010 and estimates for 2018. Do you see any significant changes?

Part II
Assume that you are the internal auditor for Knot Manufacturing Company and are auditing the travel, Scheduling entertainment, and meal reimbursements. Company policy requires receipts for expenses greater than $25. Management must separately approve all reimbursements over $5,000. Download the file Expense Reimbursements from Blackboard. Analyze expense reimbursements using Benford’s Law and ACL. Import the Expense Reimbursements file, which contains the reimbursement document numbers, employee numbers, and the amount of each reimbursement. Click Analysis | Perform Benford Analysis for the AMOUNT of the reimbursement.
•Analyze on the leading digit. Choose Output to Screen and again to Graph. Print both outputs.
•Analyze on the leading two digits. Choose Output to Screen and again to Graph. Print both outputs.
•Summarize the number and amount of reimbursements between $24 and $25 by employee number. Do the same for amounts between $4,900 and $5,000. (Hint: Create filters for each of these dollar ranges.) Print the results.
•Analyze the results and provide possible explanations for the results. Identify reimbursements that may need further investigation.
Submit
Output form Part I.c and I.e including a commentary on any significant deviations
Output form Part II, including your commentary on which reimbursements may need further investigation.