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 (1) coefficients for polynomials 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 (pdf). The Excel files are available at http://www.siu.edu/~epse1/headrick/PowerMethod3rd/ or can be requested from the author at firstname.lastname@example.org.
Headrick, Todd C.
"JMASM24: Numerical Computing for Third-Order Power Method Polynomials (Excel),"
Journal of Modern Applied Statistical Methods: Vol. 5
, Article 30.
Available at: http://digitalcommons.wayne.edu/jmasm/vol5/iss2/30