Comparison of Sampling Methods in Verification of Data Entry

Abstract

Data entry is considered vital for the quality of the data. Each of the data entry’s method is unique in
the way of working, complication of the process and limitation. This research studied the sampling methods in
verification of data entry by using Continuous Sampling Plan 1 (CSP-1), CSP-2, Systematic Continuous
Sampling Plan 1 (SCSP-1), and SCSP-2 methods. There were 8 samples (p = 0.0034, 0.0080, 0.0130, 0.0188,
0.0254, 0.0528, 0.0670, and 0.0822) which were random error by Microsoft Office Excel 2007.
The results of the study of CSP-1 sampling found that when the value of p tended to increase, the
Percent Gain in Average Quality ; PGAQ also tended to rise according to the value of p. The value of PGAQ
and the average value of record proportion of Average Fraction Inspection; AFI were higher when p=0.03345
and i=5. When i=10, 15, 20 and p=0.0822 and i=20, the value of PGAQ and AFI was higher than i=5, 10, 15.
The results of CSP-2 sampling showed that every value of p, the value of PGAQ and AFI tended to be stable.
When i=5, the value of PGAQ and AFI was higher than i=10, 15 and 20. The results of SCSP-1 found that,
every value of PGAQ and AFI tented to be stable. I=5 caused the value of PGAQ and AFI to be higher than
i=10, 15, and 20. In SCSP-2 sampling, it was found that in every value of p, the value of PGAQ and AFI tended
to be stable. I-5 caused PGAQ and AFI to be higher than i=10, 15, and 20. The best method was SCSP-1 and
it had the least conditions in using. Therefore, it was used easily and gave the most efficient data after random
error. According to the study, it was found that the value of PGAQ and AFI were in accordant when there were
a number of the investigated data sets. The opportunity to find errors was higher; consequently, the value of
PGAQ was hither and gave better efficiency of the method.