Using Spreadsheets to Teach Signal Detection Theory

Signal detection theory (SDT) is a mathematical framework for evaluating the performance of a detection system, which is broadly applicable across many academic and practical domains, including medicine, psychology, statistics and engineering. In this article, I present an interactive spreadsheet th...

Full description

Bibliographic Details
Main Author: Christopher R Fisher
Format: Article
Language:English
Published: McMaster University 2014-01-01
Series:Spreadsheets in Education
Online Access:https://sie.scholasticahq.com/article/4624-using-spreadsheets-to-teach-signal-detection-theory
Description
Summary:Signal detection theory (SDT) is a mathematical framework for evaluating the performance of a detection system, which is broadly applicable across many academic and practical domains, including medicine, psychology, statistics and engineering. In this article, I present an interactive spreadsheet that allows students to systematically explore the function of the two key parameters of SDT: the decision criterion and discriminability. Stimulus distributions and ROC curves update in real time according to user input, thereby providing an intuitive visualization of the SDT parameters. The spreadsheet can be used to find an optimal decision criterion for a given level of discriminability, prior probabilities and payoff matrix. The article includes six problems and suggested answers that instructors may use in the classroom. The article concludes with a discussion of simple adaptions of the spreadsheet for teaching frequentist statistics and testing psychologically based models of detection.
ISSN:1448-6156