A data audit is a critical activity that must be done at the beginning of any analytics
Question:
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 company’s 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 | 6,000 | 9.99 | $ 59,940 |
2017 | February | 4,500 | 12.49 | $ 56,205 |
2017 | March | 4,500 | 14.99 | $ 67,455 |
2017 | April | 3,000 | 16.99 | $ 50,970 |
2017 | May | 3,000 | 17.99 | $ 53,970 |
2017 | June | 1,500 | 14.99 | $ 22,485 |
2017 | June | 1,500 | 14.99 | $ 22,485 |
2017 | August | 3,000 | 17.49 | $ 52,470 |
2017 | September | 4,000 | 19.99 | $ 79,960 |
2017 | October | 5,000 | 19.99 | $ 99,950 |
2017 | November | 6,000 | 17.49 | $ 104,940 |
2017 | December | 7,500 | 14.99 | $ 112,425 |
2018 | January | 6,250 | 8.49 | $ 53,063 |
2018 | February | 5,000 | 12.99 | $ 64,950 |
2018 | March | 6,000 | 12.99 | $ 950 |
2018 | April | 3,500 | 17.49 | $ 61,215 |
2018 | May | 2,500 | 16.49 | $ 41,225 |
2018 | June | 2,000 | 14.99 | $ 29,980 |
2018 | July | 3,000 | 10.99 | $ 32,970 |
2018 | August | 3,000 | 10.99 | $ 32,970 |
2018 | September | 4,500 | 19.49 | $ 87,705 |
2018 | October | 5,200 | 21.49 | $ 111,748 |
2018 | December | 8,000 | 13.99 | $ 111,920 |
Use this worksheet to answer any written questions for this exercise.
Write your answer in the merged open cell next to each Question number.
Chemistry The Central Science
ISBN: 978-0321696724
12th edition
Authors: Theodore Brown, Eugene LeMay, Bruce Bursten, Catherine Murphy, Patrick Woodward