Assignment
a. The Vendor column contains the names of the vendors from which the purchases were made. Use a fuzzy matching algorithm to find any vendors with similar names. Do you suspect any purchases were made from phantom vendors?
b. Find any vendors who are charging too much for their product compared with other vendors. In addition to average prices for each product and vendor, do you see any increasing trends that might indicate kickbacks?
c. 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. Do you see any issues to search further?
d. 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.
e. Verify the values in the Quantity and Total columns. Are any missing or abnormal values present?
f. Analyze the Product Price column from each company using Benford's Law. Analyze only the first digit of the column. On average, do any of the vendors stand out? In other words, are the transactions from any vendor not matching Benford's Law?
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.
Attachment:- Case-Data.rar