'Paleontological Institute at The University of Kansas'
Abstract
These Excel spreadsheets automatically score up to 1000 participants’ responses obtained from the 21- and 27-item Kirby Monetary Choice Questionnaires (MCQ) and provide several descriptive and statistical measures including k values, consistency scores, proportion scores, correlations, and more. We recommend using Microsoft Excel 2010 or newer when opening this file.The 21- and 27-item Monetary Choice Questionnaires (MCQ; Kirby & Marakovic, 1996; Kirby, Petry, & Bickel, 1999) are among the most popular tools to assess discounting as evidenced by 346 citations for the 21-item MCQ and 909 citations for the 27-item MCQ (www.scholar.google.com). Notwithstanding the immense success of these questionnaires, scoring and deriving discount rates are often times complicated (Myerson, Baumann, & Green, 2014) and time consuming. Therefore, these Excel-based tools were created to automatically score responses obtained using both versions of the MCQ. These automated calculators provide several discount rates (overall k, small, medium, large, and composite k), log and natural log transformations of discount rates, consistency scores, and proportion (% Larger Later) measures for individuals. Summary statistics for group comparisons include mean, standard deviation, and standard error of the mean for the aforementioned measures as well as Pearson product-moment correlations between magnitudes. For questions/comments, please contact Brent Kaplan ([email protected]) or Derek Reed ([email protected])