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

3. Calculate the average product price paid by purchaser. For example, calculate the average price paid for All Purpose Wipers when Jose, Sally, and Daniel are purchasing. Compare these average prices. (HINT: Use a PivotTable) Do you see any issues to search further?