Skip to main content
Numerical Computing for Third-Order Power Method Polynomials (Excel)
  • Todd C. Headrick, Southern Illinois University Carbondale

Published in the Journal of Modern Applied Statistical Methods, 2006, Vol. 5, No. 2, pp. 567-574.

Publication Date
The power method polynomial transformation is a popular procedure used for simulating univariate and multivariate non-normal distributions. It requires software that solves simultaneous nonlinear equations. Potential users of the power method may not have access to commercial software packages (e.g., Mathematica, Fortran). Therefore, algorithms are presented in the more commonly available Excel 2003 spreadsheets. The algorithms solve for (I) coefficients for polynom ials of order three, (2) intermediate correlations and Cholesky factorizations for multivariate data generation, and (3) the values of skew and kurtosis for determining if a transformation will produce a valid power method probability density function (pdt).
Citation Information
Todd C. Headrick. "Numerical Computing for Third-Order Power Method Polynomials (Excel)" (2006)
Available at: