Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting, Chapters 1- 15

Authors: James A. Heintz, Robert W. Parry

23rd Edition

0357391942, 9780357391945

More Books

Students also viewed these Accounting questions