Real Statistics Release 8.2 | Real Statistics Using Excel

I am pleased to announce Release 8.2 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.

This release focuses on the word game Wordle and provides a strategy for how to maximize your chances of solving the game in 3 guesses or less. In fact, using this approach you have a probability close to 60% of achieving this goal. See Wordle Winning Strategy for more details.

The following is an overview of the new features in Release 8.2.

Wordle

The following new worksheet functions are now supported.

PatternId, SPattern, PatternCount, BestGuess2, and Guesses3

See Real Statistics Support for Wordle for more details about these functions.

Anderson-Darling support for the Laplace distribution

The Anderson-Darling goodness of fit test now supports the Laplace distribution. This means that the dist argument in the ADCRIT, ADPROB, and ADTEST functions can now take the value “laplace” or 10.

When using the ADCRIT(n, alpha, dist, k, interp) function, you must specify the sample size with a value n ≥ 10; the k argument can take any value since it is not used.

When using the ADPROB(x, dist, k, iter, interp, txt) function, the k argument is the sample size and it must take a value ≥ 10. The p-value that is returned by this function will be between .01 and .25. If txt = FALSE (default), then values smaller than .01 will be returned as 0 and values larger than .25 will be returned as 1. If txt = TRUE, then values smaller than .01 will be returned as “<.01” and values larger than .25 will be returned as “>.25”.

This increase in functionality is also reflected in the Goodness of Fit data analysis tool. You can now select the Laplace distribution option when you select the One-sample Anderson-Darling test option of this data analysis tool.