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 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 | 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. | ||||||||
Question | Response | |||||||
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | ||||||||
5 | ||||||||
6 | ||||||||
7 | ||||||||
8 | ||||||||
9 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started