Real Statistics Release 8.8.1

by
I am pleased to announce the latest bug-fix release, Release 8.8.1, of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2010, 2013, 2016, 2019, 2021, and 365 in both Windows and Mac environments.

Faster Processing Speed

A number of people have noticed that Excel slows down when using the Real Statistics software for Windows, especially when using copy/paste (Ctrl-C / Ctrl-V). It turns out that the help support (via Insert Function fx) for the Real Statistics worksheet functions is causing this degradation.
As a result, I have added a new version of the software XRealStatsX.xlam that is identical to the Windows version of the software, XRealStats.xlam, except that this help facility is omitted. You can still get some help with a Real Statistics worksheet function by entering the name of the function and pressing Ctrl-Shft-a.

New Mac Support

The new XRealStatsX.xlam version of the Real Statistics software described above not only supports Windows users but also Mac users of Excel 365.

Bug Fixes

  • Fixes a bug when the Nonparametric and Two independent sample options (i.e. Mann-Whitney support) on the T-test and Equivalent nonparametric tests data analysis tool are selected. Previously the Exact test resulted in an error.
  • Fixes a bug in the One Factor Anova data analysis tool when one of the Hsu MSB options was chosen. Previously, any additional post-hoc test might overwrite part of the output from the Hsu MSB analysis.

Revised Holt’s Linear Trend with Damping

A new Holt’s Linear Trend with Damping option has been added to the Forecasting data analysis tool. This makes it easier to choose the damping option introduced in Rel 8.8. If the Phi field (containing the damping parameter) is set to zero and one of the optimization options (i.e. not None) is chosen then the data analysis tool will optimize the alpha and beta parameters, as well as the phi parameter.

The phi parameter can take any value between 0 and 1 (excluding 0 and 1), but you can also constrain the lower limit of phi by inserting a value (between 0 and 1) in the Min Phi field.

If instead, you insert a value bigger than 0 and less than 1 in the Phi field, then this value will be used (and the Min Phi field will be ignored). If you also choose one of the optimization options, then only the alpha and beta parameters will be optimized.

New Feature

Adds a new TConvert worksheet function that converts strings of form 3’15” to the equivalent numeric form 195 (i.e. 3 × 60 + 15).