Real Statistics Release 6.3

I am pleased to announce Release 6.3 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, 365 in Windows and Mac environments.

The Basics, Distribution, Non-parametric, Regression 1, Multivariate and Time Series examples workbooks have also been revised for compatibility with the new release. These are available for free download at Download Examples Workbooks.

Over the course of the next few days, the website will be updated for compatibility with the new releases.

If you are getting value from the Real Statistics website or software, I would appreciate your donations to help offset the costs of the website by going to Please Donate.

The following is a review of the new features in Release 6.3.

Skellam Distribution

Added the SKELLAM_DIST function which is defined as

SKELLAM_DIST(x, mean1, mean2, cum) = the pdf value of the Skellam distribution that compares two Poisson distributions with means mean1 and mean2 at x when cum = FALSE and the cdf value at x when cum = TRUE.

This function is useful when comparing two variables that follow a Poisson distribution. It is especially useful in determining whether one sports team is able to beat the point-spread when playing against another team.

McNemar-Bowker Test

The following new functions have been added to conduct the McNemar-Bowker test, which determines whether a square matrix is symmetric. It is also an extension of the McNemar’s test.

BOWKER(R1, std) = the McNemar-Bowker statistic for the data in R1

MBTEST(R1, std) = the p-value of the McNemar-Bowker test for the data in R1.

The data for this test can be formatted in either of two ways:

  • standard format (std = TRUE): consists of three columns where the first two column identify the independent variables and the third column specifies the frequencies
  • contingency table format (std = FALSE, default): consists of a square contingency table without headings

PRESS Function

Added the PRESS(Rx, Ry, con) function which calculates the predicted residual sum of squares value (PRESS) for multiple linear regression.

ARIMAX Enhancement

Improves the forecasting capability of the ARIMAX data analysis tool by allowing the user to specify the future X values used to create a forecast.

Delete Row

Added the DELROW function which is defined as:

DELROW(R1, k): returns an array identical to R1 except that the kth row is removed.

Bug Fixes

  • Fixed a bug in the NextPrime function which produced an error only for the formula =NextPrime(3)
  • Fixed a bug in the PredRSquare function which caused an erroneous result
  • Fixed a bug in the RegCV function which output an error value
  • Improved the formatting of many of the dialog boxes for the data analysis tools on the Mac

Charles