Excel Project: Auditing a Data Extract You work as an auditor for the city of Washington DC and have been asked to audit employee purchasing card (p-cards) expenses. You have been asked to validate that the cleaned data for a sample of the p-card transactions match the original records before the transformation process. Go to the student download page at http://www.pearson highered.com/romney and download the data file titled “P6-

7WashingtonDCDataAudit.xlsx” The file contains two sheets. The sheet labeled

“Population” includes all p-card transactions from January 2009 to February 2019.

The sheet labeled “Sample” contains the 20 transactions from 2019 you have selected for examination.

REQUIRED

a. Determine whether all the data in the sample transactions matches the original data.

If there are errors, document any you find.

b. Once you are finished, estimate how many errors are likely for each field in the 2019 data.