article

Free access

Implications of data quality for spreadsheet analysis

Authors:

Donald P. Ballou,

Harold L. Pazer,

Salvatore Belardo,

Barbara KleinAuthors Info & Claims

ACM SIGMIS Database: the DATABASE for Advances in Information Systems, Volume 18, Issue 3

Pages 13 - 19

https://doi.org/10.1145/27544.27546

Published: 01 March 1987 Publication History

PDF eReader

Abstract

This paper examines the impact of deficiencies in data quality on the results generated for spreadsheet applications. The purpose is to describe a framework which can be systematically used to determine the relative importance of potential errors in operational and judgmental data. Special emphasis is placed on analyzing the implications of deficiencies in data quality on projected spreadsheet results.

References

[1]

[1] Alonso, W. "Predicting Best with Imperfect Data," Journal of American Institute of Planners Volume 35, 1968, pp. 248-255.

Crossref

Google Scholar

[2]

[2] Bailey, R. Human Error in Computer Systems, Prentice-Hall, Englewood Cliffs, New Jersey, 1983.

Digital Library

Google Scholar

[3]

[3] Ballou, D. and Pazer, H. "Modeling Data and Process Quality in Multi-Input, Multi-Output Information Systems," Management Science, Volume 31, Number 2, February 1985, pp. 150-162.

Digital Library

Google Scholar

[4]

[4] Cashing, B. "A Mathematical Approach to the Analysis and Design of Internal Control Systems," Accounting Review, Volume 49, Number 1, January 1974, pp. 24-41.

Google Scholar

[5]

[5] Davis, G. and Olsen, J. Management Information Systems: Conceptual Foundations, Structure and Development, 2nd Ed., McGraw Hill, New York, New York, 1985.

Digital Library

Google Scholar

[6]

[6] Duncan, A. Quality Control and Industrial Statistics, 4th Ed., Richard D. Irwin, Homewood, Illinois, 1974, pp. 102-104.

Google Scholar

[7]

[7] E.P.S., Inc. Introductory Guide FCS-EPS, E.P.S. Inc., Windham, New Hampshire, February 1983.

Google Scholar

[8]

[8] Johnson, J., Leitch, R. and Neter J. "Characteristics of Erosion Accounts Receivable and Inventory Audits," Accounting Review, Volume 56, Number 2, April 1981, pp. 270-293.

Google Scholar

[9]

[9] Laudon, K. "Data Quality and Due Process in Large Interorganizational Record Systems," Communication of ACM, Volume 29, Number 1, January 1986, pp. 4-11.

Digital Library

Google Scholar

[10]

[10] Martin, J. Security, Accuracy, and Privacy in Computer Systems, Prentice-Hall, Englewood Cliffs, New Jersey, 1973.

Digital Library

Google Scholar

[11]

[11] Nesbit, I. "On Thin Ice: Micros and Data Integrity," Datamation, Volume 31, Number 21, November 1985 pp. 80-85.

Digital Library

Google Scholar

[12]

[12] Percy, T. "My Data, Right or Wrong," Datamation , Volume 32, Number 11, June 1986, pp. 123-128.

Digital Library

Google Scholar

[13]

[13] Sehr, R. "Saying It With Spreadsheets," Personal Computing, Volume 8, Number 8, August 1984, pp. 79-87.

Google Scholar

[14]

[14] Stratton, W. "The Reliability Approach to Internal Control Evaluation," Decision Sciences, Volume 12, 1981, pp. 51-67.

Crossref

Google Scholar

Cited By

View all

El-ghafar REl-Bastawissy ANasr EGheith M(2021)An Effective Entity Resolution Approach for Big DataInternational Journal of Innovative Technology and Exploring Engineering10.35940/ijitee.K9503.0910112110:11(100-112)Online publication date: 30-Sep-2021
https://doi.org/10.35940/ijitee.K9503.09101121
Gallivan M(2019)Author Highlights for the Past 35 YearsACM SIGMIS Database: the DATABASE for Advances in Information Systems10.1145/3312576.331258650:1(54-76)Online publication date: 12-Feb-2019
https://dl.acm.org/doi/10.1145/3312576.3312586
Hermans FSedee BPinzger MDeursen ANotkin DCheng BPohl K(2013)Data clone detection and visualization in spreadsheetsProceedings of the 2013 International Conference on Software Engineering10.5555/2486788.2486827(292-301)Online publication date: 18-May-2013
https://dl.acm.org/doi/10.5555/2486788.2486827
Show More Cited By

Index Terms

Implications of data quality for spreadsheet analysis

Recommendations

Can big data improve firm decision quality? The role of data quality and data diagnosticity
Abstract
Anecdotal evidence suggests that, despite the large variety of data, the huge volume of generated data, and the fast velocity of obtaining data (i.e., big data), quality of big data is far from perfect. Therefore, many firms defer ...
Highlights
- Data quality (DQ) enhances data diagnosticity and firm decision quality.
- Big ...
Measuring Manufacturing Test Data Analysis Quality
2018 IEEE AUTOTESTCON
Manufacturing test data volumes are constantly increasing. While there has been extensive focus in the literature on big data processing, less focus has existed on data quality, and considerably less focus has been placed specifically on manufacturing ...
Towards Data Quality into the Data Warehouse Development
DASC '11: Proceedings of the 2011 IEEE Ninth International Conference on Dependable, Autonomic and Secure Computing

Commonly, DW development methodologies, paying little attention to the problem of data quality and completeness. One of the common mistakes made during the planning of a data warehousing project is to assume that data quality will be addressed during ...

Comments

Information & Contributors

Information

Published In

ACM SIGMIS Database: the DATABASE for Advances in Information Systems Volume 18, Issue 3

March 1987

36 pages

ISSN:0095-0033

EISSN:1532-0936

DOI:10.1145/27544

Editor:
James C. Wetherbe

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 March 1987

Published in SIGMIS Volume 18, Issue 3

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

22
Total Citations
View Citations
428
Total Downloads

Downloads (Last 12 months)32
Downloads (Last 6 weeks)5

Reflects downloads up to 11 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

El-ghafar REl-Bastawissy ANasr EGheith M(2021)An Effective Entity Resolution Approach for Big DataInternational Journal of Innovative Technology and Exploring Engineering10.35940/ijitee.K9503.0910112110:11(100-112)Online publication date: 30-Sep-2021
https://doi.org/10.35940/ijitee.K9503.09101121
Gallivan M(2019)Author Highlights for the Past 35 YearsACM SIGMIS Database: the DATABASE for Advances in Information Systems10.1145/3312576.331258650:1(54-76)Online publication date: 12-Feb-2019
https://dl.acm.org/doi/10.1145/3312576.3312586
Hermans FSedee BPinzger MDeursen ANotkin DCheng BPohl K(2013)Data clone detection and visualization in spreadsheetsProceedings of the 2013 International Conference on Software Engineering10.5555/2486788.2486827(292-301)Online publication date: 18-May-2013
https://dl.acm.org/doi/10.5555/2486788.2486827
Hermans FSedee BPinzger Mvan Deursen A(2013)Data clone detection and visualization in spreadsheets2013 35th International Conference on Software Engineering (ICSE)10.1109/ICSE.2013.6606575(292-301)Online publication date: May-2013
https://doi.org/10.1109/ICSE.2013.6606575
Gelman I(2010)Setting priorities for data accuracy improvements in satisficing decision-making scenariosDecision Support Systems10.1016/j.dss.2009.11.00148:4(507-520)Online publication date: 1-Mar-2010
https://dl.acm.org/doi/10.1016/j.dss.2009.11.001
Xu HHorn Nord JDaryl Nord GLin B(2003)Key issues of accounting information quality management: Australian case studiesIndustrial Management & Data Systems10.1108/02635570310489160103:7(461-470)Online publication date: Oct-2003
https://doi.org/10.1108/02635570310489160
Xu HHorn Nord JBrown NDaryl Nord G(2002)Data quality issues in implementing an ERPIndustrial Management & Data Systems10.1108/02635570210414668102:1(47-58)Online publication date: 1-Feb-2002
https://doi.org/10.1108/02635570210414668
Hongjiang Xu (2001)Key issues of accounting information quality management an Australian case study2001 International Conferences on Info-Tech and Info-Net. Proceedings (Cat. No.01EX479)10.1109/ICII.2001.983046(120-133)Online publication date: 2001
https://doi.org/10.1109/ICII.2001.983046
Teo TLee-Partridge J(2001)Effects of error factors and prior incremental practice on spreadsheet error detection: an experimental studyOmega10.1016/S0305-0483(01)00037-829:5(445-456)Online publication date: Oct-2001
https://doi.org/10.1016/S0305-0483(01)00037-8
Klein B(2001)Detecting errors in data: clarification of the impact of base rate expectations and incentivesOmega10.1016/S0305-0483(01)00029-929:5(391-404)Online publication date: Oct-2001
https://doi.org/10.1016/S0305-0483(01)00029-9
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Index Terms

Recommendations

Can big data improve firm decision quality? The role of data quality and data diagnosticity

Measuring Manufacturing Test Data Analysis Quality

Towards Data Quality into the Data Warehouse Development

Comments

Information

Published In

Publisher

Publication History

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Get Access

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations