Psychometric Toolbox


Psychometric Toolbox


The Psychometric Toolbox (PT) is a user-friendly, non-commercial program mainly intended to be used for instructional purposes in introductory courses of educational and psychological measurement, psychometrics and statistics. The PT program is organized in six main groups of functions:

  1. Data preprocessor -> descriptive analyses, data transformations and creation of sub-tests.
  2. Guttman scaling -> item analysis and individual scoring based on Guttman's model.
  3. Classical Item Analysis -> CTT-based item analysis and reliability estimation.
  4. Item Factor Analysis -> FA-Based Item Analysis and omega reliability estimation.
  5. Scoring and Norming -> linear and nonlinear score transformations and normative tables.
  6. Item Response Theory-Basic analysis -> item calibration and test scoring based on the one and two parameter logistic models.
  7. Scoring Multiple-Choice Tests -> item and option analysis and test scoring in multiple-choice measures.

Because they have been designed for instructional use, these functions are intended to (a) be very easy to use, (b) provide clear and well explained results, and (c) make use of graphical displays whenever possible. Apart from its wide scope, the PT is quite versatile and implements features that are not usually found in programs of this type. Thus, the preprocessing function allows the user to replace missing values, perform split-half test partitions, randomly split the sample for cross-validation purposes, perform Jackknife re-sampling, build sub-scales at the user specifications and create automatically parallel forms. The item factor analysis computes the omega coefficient with its confidence intervals and displays one and two canonical solutions in order to detect violations of unidimensionality. The Scoring and Norming program provides confidence intervals for the transformed scores, percentile bands and creates the test normative table based on the user’s specifications.

The program is written in VBA Excel code. So, to run the PT you need to have VBA language installed on your computer. This language is included in Microsoft Office Professional.

The development of PT was supported by a grant from the Spanish Ministerio de Ciencia, Innovación y Universidades (PSI2017-82307-P), and a grant from Rovira I Virgili University-ICE (A03/17).

Download the Psychometric Toolbox

Download User's guide

* If you use the package, would you be so kind as to cite it as:

Ferrando, P. J., Masip-Cabrera, A., Navarro-Gonzalez, D., & Lorenzo-Seva, U. (2017). The Psychometric Toolbox: an Excel package for use in measurement and psychometrics courses. Psicologica, 38(2), 395-398.

To download the above referred paper, please click here.


Pere Joan Ferrando Piera
Antonio Masip Cabrera
David Navarro González
Urbano Lorenzo Seva

Departament de Psicologia
Universitat Rovira i Virgili
Tarragona (Spain)
February, 2023