Using Microsoft Office Excel 2007 to conduct generalized matching analyses

J Appl Behav Anal. 2009 Winter;42(4):867-75. doi: 10.1901/jaba.2009.42-867.

Abstract

The generalized matching equation is a robust and empirically supported means of analyzing relations between reinforcement and behavior. Unfortunately, no simple task analysis is available to behavior analysts interested in using the matching equation to evaluate data in clinical or applied settings. This technical article presents a task analysis for the use of Microsoft Excel to analyze and plot the generalized matching equation. Using a data-based case example and a step-by-step guide for completing the analysis, these instructions are intended to promote the use of quantitative analyses by researchers with little to no experience in quantitative analyses or the matching law.

Keywords: Microsoft Excel; choice; generalized matching equation; matching law; technology.

MeSH terms

  • Competitive Behavior*
  • Generalization, Psychological*
  • Humans
  • Software*
  • User-Computer Interface*