Question

Which of the following is an example of data that needs to be cleaned before it can be analyzed?

a) The data has dates in two different formats (MM/DD/YY and DD/MM/YY).
b) The data contains misstatements.
c) The data comes from a system with poor internal controls.
d) The data has information from customers in data files from two different divisions.

Answer 1

Data cleaning is the process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in data before it can be analyzed. The correct answer is a) The data has dates in two different formats (MM/DD/YY and DD/MM/YY).

Step-by-step explanation:

The correct answer is a) The data has dates in two different formats (MM/DD/YY and DD/MM/YY).

Data cleaning is the process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in data before it can be analyzed.

In this case, the data containing dates in different formats needs to be cleaned because it may lead to incorrect analysis if not standardized.

By converting the dates to a consistent format, such as MM/DD/YY or DD/MM/YY, the data can be properly analyzed.