A B C D E A B C D E Type of Quality Characteristic Consistency Type of Quality Characteristic # Consistency Field(s) that failed Amount Customer First Name Customer Last Name Date ID Item N.A. Show Transcribed Text Ű Field(s) that failed How to fix How to fix No error PBC should be spelled out "Peanut Butter Cookies" There should be three leading 0's The date was misstated-you can verify that there are not 31 days in April The last name is missing The first name is missing The amount is misstated A
A B C D E A B C D E Type of Quality Characteristic Consistency Type of Quality Characteristic # Consistency Field(s) that failed Amount Customer First Name Customer Last Name Date ID Item N.A. Show Transcribed Text Ű Field(s) that failed How to fix How to fix No error PBC should be spelled out "Peanut Butter Cookies" There should be three leading 0's The date was misstated-you can verify that there are not 31 days in April The last name is missing The first name is missing The amount is misstated A
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please do not Give image format and Proper solution

Transcribed Image Text:A
B
с
D
E
A
B
с
D
E
Type of Quality
Characteristic
Consistency
Type of Quality
Characteristic
#
Consistency
Field(s) that failed
Amount
Customer First Name
Customer Last Name
Date
ID
Item
N.A.
Show Transcribed Text
Field(s) that failed
Ċ
The first name is missing
The amount is misstated
How to fix
How to fix
No error
PBC should be spelled out "Peanut Butter Cookies"
There should be three leading O's
The date was misstated - you can verify that there are not 31 days in April
The last name is missing
#
;
#
#
#

Transcribed Image Text:A
B
с
D
E
You have a table full of data but have started finding some quality issues. Go through the table and identify the data quality issues that
you notice, the field in which each issue occurs, and how you would fix it. Choose from the following data quality characteristics:
comparability (consistency), understandability, error free, completeness, confirmatory value.
A
B
ID
000238
239
4/8/2020
Date
4/9/2020
C
000240
4/31/2020
D 000241 4/10/2020 PBC
E
✓ Consistency
Type of Quality
Chaunabauintin
Item
Chocolate chip cookies
Oatmeal raisin cookies
000242 4/11/2020 Chocolate chip cookies
Confirmatory value
Completeness
Error Free
Understandability
Snickerdoodle cookies
J
Customer First Name
Johnny
Johnny
Julia
Field(s) that failed
Annette
Show Transcribed Text
Brian
Customer Last Name
Ramirez
Ramirez
Rodriguez
Álvarez
Amount
How to fix
$9.56
$8.51
$4.20
$6.51
$11.23
;
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education