Skip to Main Content
Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems
book

Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems

by Larry P. English
October 2009
Beginner to intermediate content levelBeginner to intermediate
839 pages
29h 16m
English
Wiley
Content preview from Information Quality Applied: Best Practices for Improving Business Information, Processes and Systems
Chapter 5 Assessing Information Quality 217
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
A B C D E F G H I J K L M
x x
x x x
x x
xx
x
x
x x x x
x x
x
x
x x
x
x
Figure 5-18: Sample of 50 Records with 23 NOT Accurate Data Values
Marked “X” in 10 Records with One or More Defects
34474c05.indd 217 8/31/09 1:24:55 PM
218 Part II The Step-by-Step Guide to the TIQM Quality System
Table 5-9: Example Calculation of the Standard Deviation of a Sample
6
STANDARD DEVIATION
CALCULATION STEPS
CALCULATION RESULT
1. Count the number of records in the
sample.
50 = 50
2. Count the number of data elements
in all records that contain a defect of
the IQ Characteristic measured.
23 = 23
3. Calculate the Mean (x) or average
number of errors per record by divid-
ing the total number of errors by the
number of sampled records.
23 / 50 = 0.46
4. Calculate the Deviation (d) of each
record by subtracting the Mean num-
ber of errors from the actual number
of errors in the record.
Record 1 = 0 - 0.46 =
Record 2 = 1 - 0.46 =
etc.
-0.46
0.54
5. Calculate the Deviation Squared (d
2
)
for each record by multiplying the
deviation by itself.
Rec 1 = -0.46 x -0.46=
Rec 2 = 0.54 x 0.54 =
etc.
0. 2116
0.2916
6. Calculate the Sum of the Deviations
Squared (Σd
2
) by adding all of the
deviat
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

Larry P. English
Information Quality

Information Quality

Ron S. Kenett, Galit Shmueli
Business Metadata: Capturing Enterprise Knowledge

Business Metadata: Capturing Enterprise Knowledge

W.H. Inmon, Bonnie O'Neil, Lowell Fryman

Publisher Resources

ISBN: 9780470134474Purchase book