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
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.
Step by Step Solution
3.40 Rating (162 Votes )
There are 3 Steps involved in it
to evalute the sales by season wise 2017 Pre Winter Nov to Dec Winter Jna to Feb Spring Mar to April ... View full answer
Get step-by-step solutions from verified subject matter experts
Study Help