Excel Project: Creating Data Errors This problem asks you to create a data set with specified errors.
Question:
Excel Project: Creating Data Errors This problem asks you to create a data set with specified errors.
REQUIRED
a. Create a fake dataset that has at least 20 rows and 6 columns. The dataset can relate to any setting in accounting or business. In the dataset, include at least one of each of the following types of errors: cryptic data values, data contradiction errors, data entry errors, data threshold violations, misfielded data values, and violated attribute dependencies.
b. Prepare a memo to go with your dataset that describes the nature of the data. Then define each error and describe the example error you included in your dataset.
Step by Step Answer:
Accounting Information Systems
ISBN: 9780138099497
16th Edition
Authors: Marshall B Romney, Paul J. Steinbart, Scott L. Summers, David A. Wood