Software

Arlington, Virginia. July 16, 2009. statistics.com LLC, a provider of online courses in statistics and statistical software publisher, announced the release of Version 4.0 of Resampling Stats for Excel.

Readers of KDNuggets are eligible for a 20% discount by using promo code KDN09

Resampling Stats for Excel is an add-in for Excel for Windows that facilitates bootstrapping, permutation and simulation procedures with data in Excel. The latest release, version 4.0, adds the Bootstrap BCA and the ability to run up to 1,000,000 iterations with hundreds of score cells (Excel 2007). It also offers stratified resampling, custom function iteration, enhanced stratified sampling capabilities, histograms, an enhanced urn feature, and much more.

The basic procedure is simple: Select the data you want to resample, select "resample" or "shuffle" from the Resampling Stats menu, then specify an output range for the resampled data. Calculate a statistic of interest, then select "Repeat & Score" from the Resampling Stats menu. The resampling operation will be repeated thousands (or tens of thousands) of times, and each time the value of your statistic of interest will be recorded. Comes with a 230-page user guide (available online or in print); works with English language versions of Excel for Windows.

New in version 4.0

• Bootstrap BCA
• Up to 1,000,000 iterations for a hundreds of test statistics (the score cell and iteration limits depend on the version of Excel)

• Histogram offers substantial improvements over Excel's (better auto-binning, integer auto-binning, user specified bin widths, user-specified number of bins, option for cumulative display)
• Uses Resampling Stats' random number generator, not Excel's (more information on the random number generator is available at www.resample.com/content/randgen.shtml)
• Facilitates stratified resampling (specify nested stratification variables, resample within rows or columns; also resample within specified matrix ranges)
• Facilitates multivariate case resampling (resample rows or columns as units)
• Multi-stage resampling (use the output of a first stage resample as input for a second-stage resample)
• Save your worksheet resampling parameters so you can open it later and redo the same simulations with a single click (or change score cells, or change number of iterations)
• Iterate formulas to solve difference equations
• Repeat and Score several thousand cells in one simulation (Excel 2007)
• User-created custom functions can be resampled

• Beta
• Binomial
• Exponential
• Gamma
• Geometric
• LogNormal
• Normal
• Pareto
• Poisson
• Uniform integer
• Uniform real
• Weibull

"Resampling Stats 4.0 is a powerful tool for performing significance tests and deriving confidence intervals when your data may not be plentiful or normally distributed, or when you are dealing with a complex or unusual statistic. It's also a great way to investigate and appreciate what statistics is all about!" said Peter Bruce, President of statistics.com

Resample for Excel Version 4.0 can be found at www.resample.com

readers of KDNuggets are eligible for a 20% discount by using promo code KDN09