Skip to main page content
Access keys NCBI Homepage MyNCBI Homepage Main Content Main Navigation
. Summer 2012;45(2):375-86.
doi: 10.1901/jaba.2012.45-375.

A Tutorial on the Use of Excel 2010 and Excel for Mac 2011 for Conducting Delay-Discounting Analyses

Affiliations
Free PMC article

A Tutorial on the Use of Excel 2010 and Excel for Mac 2011 for Conducting Delay-Discounting Analyses

Derek D Reed et al. J Appl Behav Anal. .
Free PMC article

Abstract

In recent years, researchers and practitioners in the behavioral sciences have profited from a growing literature on delay discounting. The purpose of this article is to provide readers with a brief tutorial on how to use Microsoft Office Excel 2010 and Excel for Mac 2011 to analyze discounting data to yield parameters for both the hyperbolic discounting model and area under the curve. This tutorial is intended to encourage the quantitative analysis of behavior in both research and applied settings by readers with relatively little formal training in nonlinear regression.

Keywords: Microsoft Excel; behavioral economics; delay discounting; impulsivity; technology.

Figures

Figure 1
Figure 1
A depiction of how residuals are utilized in nonlinear regression.
Figure 2
Figure 2
Graphical depiction of hypothetical discounting data from the case example. Vertical lines dropped from each data point depict delineation of trapezoids used to calculate AUC. Inset describes the process of calculating the area of each trapezoid (see text for details).
Figure 3
Figure 3
Screen shots depicting how (A) the “MyData” tab, (B) the “Template” tab and (C) Columns A and B of the “Hyperbolic” tab should be formatted.
Figure 4
Figure 4
Screen shot of the Solver Parameters menu window associated with Step 3 of the Using Solver to Perform Nonlinear Regression with the Hyperbolic Model procedures.

Similar articles

See all similar articles

Cited by 9 articles

See all "Cited by" articles

LinkOut - more resources

Feedback