The Use of Influence Diagrams in the Design of Spreadsheet Models: an experimental study

The spreadsheet is one of the most commonly used personal computer applications. Many studies have shown that a very high percentage of spreadsheet models contain serious errors. The use of influence diagrams, which are a visual representation of the relationships among the variables in a problem, t...

Full description

Bibliographic Details
Main Author: Peter O'Donnell
Format: Article
Language:English
Published: Australasian Association for Information Systems 2001-11-01
Series:Australasian Journal of Information Systems
Subjects:
Online Access:http://journal.acs.org.au/index.php/ajis/article/view/230
Description
Summary:The spreadsheet is one of the most commonly used personal computer applications. Many studies have shown that a very high percentage of spreadsheet models contain serious errors. The use of influence diagrams, which are a visual representation of the relationships among the variables in a problem, to plan the development of a spreadsheet model may reduce the likelihood of the spreadsheet model containing an error. This paper describes an experimental study that tests whether the use of influence diagrams improves spreadsheet modelling practice. The results of the study suggests that influence diagrams do help users to better understand problems, and as a result reduce the likelihood of omitting important variables from spreadsheet models.
ISSN:1449-8618
1449-8618