A data audit is a critical activity that must be done at the beginning of any analytics project when you are working with an existing workbook or are given a dataset from another person The purpose of this exercise is to conduct a data audit on a worksheet that contains sales data for a hypothetical apparel retailer The data shown in the file named Chapter 1 DA Exercise 2 contains data that was provided to you by a coworker The Excel file should contain sales data for two years by month You intend to use this data to evaluate the companys sales trend by season In addition you will need to analyze the average price per month to determine if there are months where customers are spending more money for each item purchased The data should contain sales in units and dollars For any given month the sales in units multiplied by the average price should equal the sales in dollars Open the file named Chapter 1 DA Exercise 2 Audit the data in the Sheet1 worksheet Record any problems you find in the dataset in the AnswerSheet worksheet Note that there are more rows to document problems in the dataset than are needed Company Sales Data Year Month Unit Sales Average Price Sales Dollars 2017 January 6000 999 59940 2017 February 4500 1249 56205 2017 March 4500 1499 67455 2017 April 3000 1699 50970 2017 May 3000 1799 53970 2017 June 1500 1499 22485 2017 June 1500 1499 22485 2017 August 3000 1749 52470 2017 September 4000 1999 79960 2017 October 5000 1999 99950 2017 November 6000 1749 104940 2017 December 7500 1499 112425 2018 January 6250 849 53063 2018 February 5000 1299 64950 2018 March 6000 1299 950 2018 April 3500 1749 61215 2018 May 2500 1649 41225 2018 June 2000 1499 29980 2018 July 3000 1099 32970 2018 August 3000 1099 32970 2018 September 4500 1949 87705 2018 October 5200 2149 111748 2018 December 8000 1399 111920 Use this worksheet to answer any written questions for this exercise