Welcome to the InfoSci Platform
Reference Hub10
Spreadsheet Error Types and Their Prevalence in a Healthcare Context

Spreadsheet Error Types and Their Prevalence in a Healthcare Context

Elaine Dobell, Sebastian Herold, Jim Buckley
Copyright: © 2018 |Volume: 30 |Issue: 2 |Pages: 23
ISSN: 1546-2234|EISSN: 1546-5012|EISBN13: 9781522542216|DOI: 10.4018/JOEUC.2018040102
Cite Article Cite Article

MLA

Dobell, Elaine, et al. "Spreadsheet Error Types and Their Prevalence in a Healthcare Context." JOEUC vol.30, no.2 2018: pp.20-42. http://doi.org/10.4018/JOEUC.2018040102

APA

Dobell, E., Herold, S., & Buckley, J. (2018). Spreadsheet Error Types and Their Prevalence in a Healthcare Context. Journal of Organizational and End User Computing (JOEUC), 30(2), 20-42. http://doi.org/10.4018/JOEUC.2018040102

Chicago

Dobell, Elaine, Sebastian Herold, and Jim Buckley. "Spreadsheet Error Types and Their Prevalence in a Healthcare Context," Journal of Organizational and End User Computing (JOEUC) 30, no.2: 20-42. http://doi.org/10.4018/JOEUC.2018040102

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Spreadsheets are commonly used to inform decision making across many business sectors, despite the fact that research performed in the financial sector has shown that they are quite error-prone. However, few studies have investigated spreadsheet errors and their impact in other domains, like the healthcare sector. This article derives a lifecycle-stage classification scheme of spreadsheet error types based on an aggregation of, and extension of, existing classifications. Based on these classifications, a case study is then presented, performed to investigate the prevalence of these spreadsheet error types in an Irish healthcare setting. Results reveal that more than 90% of the spreadsheets studied contained ‘bottom-line' errors and the average cell-error rate was 13%. There was also a correlation between increased perceived impact of the spreadsheets and the number of errors identified. Recommendations from this research include providing spreadsheet training and guidelines for developers and users, and systematically managing and auditing spreadsheet development and use.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.