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
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 Solution
3.45 Rating (164 Votes )
There are 3 Steps involved in it
This problem follows closely from the example given in the ... View full answer
Get step-by-step solutions from verified subject matter experts
