Homework answers / question archive / Objective: Use Tableau to conduct a Newcomb-Benford Law analysis on real data

Objective: Use Tableau to conduct a Newcomb-Benford Law analysis on real data

Business

Share With

Objective: Use Tableau to conduct a Newcomb-Benford Law analysis on real data. Download the file of US spending for 2019: transactions 2019.csv.zip • Create a new Tableau workbook and connect the data. • Browse through the data to get an understanding on the data. • Select and award type and an award agency. You cannot select Purchase Orders from the Department of Education. • Conduct a Newcomb-Benford Law on the first digit of the amount of the award (current_total_value_award). • Write the working paper of the analysis you conducted including (objective, procedure, findings, challenges). . Make sure you include a heading on the working paper and figures. • Submit your working paper (including the diagrams in Tableau). Do not submit your Tableau workbook. How to perform a Newcomb-Benford Law analysis in Tableau: https://help.tableau.com/current/pro/desktop/en- us/benford.htm Links about working papers: https://pcaobus.org/oversight/standards/archived-standards/details/AU339A https:/www.accountingtools.com/articles/audit-working-papers.html https://www.journalofaccountancy.com/issues/2017/jun/audit-documentation.html For Case 2 part 2 we are going to use real data data to conduct a Newcomb-Benford Law analysis. The data is from the USASpending.gov website that provides data on the contracts and assistance paid out by the U.S. Government. https://www.usaspending.gov/#/download center/award data archive The original full download file for the contract data contains 235 columns, but the zip file provided includes only 74 columns. I downloaded the data for you using the API because the transaction and award downloads generate a zip file limited to 1GB in size. Although the download parameters can be set to a full quarter of data (or even a full year), only 1 GB of data will be delivered, so some data might be silently omitted. Below is a list of the columns included in the file. Columns