ASS - Week 9 Lab

pdf

School

Temple University *

*We aren’t endorsed by this school

Course

4501

Subject

Accounting

Date

Apr 3, 2024

Type

pdf

Pages

5

Uploaded by AgentDiscovery10054

Report
Lab 6-2 (Tableau track) Screenshots
Objective Questions Objective Questions Objective Answers Look at the Benford visual in the top-left corner of your dashboard. Which digit appears much greater than its expected value? L. Bybee Click the bar for the leading digit 4 to filter the transactions. What is the grand total of all transactions that begin with a 4 (rounded to the nearest dollar)? 13,934 Hover over the individuals in the Benford Average visualization (you could also create a new visualization to show the Benford average and Purchase Order count by user). What is the name of the individual with the smallest Benford Average who also has more than 10 transactions? D. Bryant Hover over the individuals in the Benford Average visualization. What is the average Benford Expected value for the person (round to two decimal places) with the smallest Benford Average who also has more than 10 transactions? .10 Hover over the individuals in the Benford Average visualization. Click the bar for the first individual with more than 10 transactions to filter the dashboard. What digit do most of that individual's transactions begin with? 0
Analysis Questions Analysis Questions Analysis Answers What does calculating the Benford Average tell us about individuals? Average purchase per individual What can we learn by looking at an individual's transactions through the lens of Benford's law? That the leading digits in data are going to be small As an auditor, why would we be concerned with a high volume of transactions that exceed the Benford Expected value? Yes it should be looked into
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Lab 6-3 (Microsoft track) Screenshots
Objective Questions Objective Questions Objective Answers How many duplicate records did you locate? 2 What is (are) the invoice number(s) of the duplicate payments? 4022595 How much money could the company recover from the supplier from these duplicate transactions? Enough to keep the company alive What data items do you need to combine to be able to find duplicate payments? Invoice number, vendor information and payment amount Analysis Questions Analysis Questions Analysis Answers Before computerization or Data Analytics, how would companies find that they had made duplicate payments? Manual Review of Records, Reconciliation and Supplier Communication What data items do you need to bé able to find duplicate payments? Invoice numbers, vendor information and payment accounts Would the date of the duplicate payments usually be the same or different? Processing delays, Human Error and System Issues