Crooked Scenario 5

Part 1: 1. Scan the Summary data, make some observations and perform any relevant analysis on the data. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 “Data-Driven Fraud Detection” 2. From the Detail tab data, create a Pivot Table and manipulate the data to determine if this data is the same as the data in the Summary tab. Create any additional inferences and make any other observations. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 6 “Data-Driven Fraud Detection” Part 2: 1. From your work in 1 and 2 above, create a set of questions you would like to ask the CFO of CrookEd (your instructor) specifically pertaining to the payroll data you have reviewed. For this portion of the assignment consider Fraud Examination, 5th Edition Chapters 10 “Inquiry Methods and Fraud Reports.” 2. Based on your data analysis and interview write a two page memo describing your techniques, observations and conclusions. Include any questions you still have and information you would still like to obtain.