You have recently joined the international audit team at a large company responsible for janitorial work at many different local businesses. Because of the significant number of consumables used in janitorial work, your company has a large purchasing department. You have been asked to analyze the purchases data set for potential frauds.

Steps/Questions

4. Verify that all purchases are included in the data set. If a purchase was left out, its ID would be removed from the sequential list of IDs. Compare each ID and ensure the column increases by one in each record.