Related Experiment Video
Updated: Aug 9, 2026

Focal Ca2+ Transient Detection in Smooth Muscle
Published on: June 29, 2009
Spreadsheet signal detection
1Department of Psychology, University of Florida, Gainesville 32611, USA. sorkin@psych.ufl.edu
Abstract:
A number of studies in perception, attention, and memory employ signal detection theory (SDT) to assess the accuracy of an observer's detection or discrimination performance. Some of the problems that students have with understanding and using SDT are associated with the calculations needed to obtain SDT parameters and predictions. All of these calculations, plus the simulation of SDT processes, can be performed using a spreadsheet application program, such as Excel or Quattro Pro. This paper offers a short tutorial on how to use a spreadsheet program to increase your students' knowledge and understanding of SDT.
Related Concept Videos
Signal and System
Classification of Signals
A continuous-time signal holds a value at every instant in time, representing information seamlessly. In contrast, a discrete-time signal holds values only at specific moments, often denoted as x(n), where...
Even and Odd Signals
Overview of Microsoft Excel as a Data Analysis Tool
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Microsoft Excel: Regression Analysis
To perform regression...

