PopTools is a versatile add-in for PC versions of Microsoft Excel (97, 2000 or XP) that facilitates analysis of matrix population models and simulation of stochastic processes. It was originally written to analyse ecological models, but has much broader application. It has been used for studies of population dynamics, financial modelling, calculation of bootstrap and resampling statistics, and can be used for preparing spreadsheet templates for teaching statistics. The demonstration pages on this site show how it can be used for analysis of population projection matrices and for doing randomisation tests. A help file and several demonstration files are included in the installation.

When installed, PopTools adds a new menu item to Excel's main menu (see the slightly outdated screenshot), and also adds over a hundred new worksheet functions. The routines include array formulas for matrix decompositions (Cholesky, QR, singular values, LU), eigenanalysis (eigenvalues and real eigenvectors of square matrices) and formulas for generation of random variables (eg, Normal, binomial, gamma, exponential, Poisson, logNormal). Many of these functions depend on Jean DeBord's TPMath library - a Pascal numerical library - which has been compiled into a DLL accessed via Excel.

Also included in PopTools are routines for iterating spreadsheets. These make it possible to run Monte Carlo simulations, conduct randomisation tests (including the Mantel test) and calculate bootstrap statistics. Some facilities are available for function minimisation and parameter estimation using maximum likelihood techniques, and there are a number of auditing and other tools that the author finds useful in his everyday work.

PopTools requires no programming knowledge, but to fully utilise the package you need some knowledge of matrix algebra, and some understanding of probability and statistics. It is therefore most suitable for those who have done some undergraduate statistics.

PopTools is free for non-commercial use, and can be downloaded here. For contact and further background information, see About PopTools. You can view a screenshot here. Also on this site, you can download Raster, a program for the analysis of videographic data from remote sensing platforms.

visits since April 2000.