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

Auditing: A Risk Based-Approach to Conducting a Quality Audit
10th Edition
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Chapter8: Specialized Audit Tools: Sampling And Generalized Audit Software
Section: Chapter Questions
Problem 62RSCQ
icon
Related questions
Question
Please do not Give image format and Proper solution
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 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 # ; # # #
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
;
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Database management system (DBMS)
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Auditing: A Risk Based-Approach to Conducting a Q…
Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub
Pkg Acc Infor Systems MS VISIO CD
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Accounting Information Systems
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage