Real Statistics Release 4.8

I am pleased to announce Release 4.8 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2007, 2010, 2013 and 2016 (Windows version) environments.

The spreadsheets for all the examples used on the Real Statistics website are available for free download (Download Examples Workbooks) are being updated for compatibility with the new release. These spreadsheets are contained in four Excel files (i.e. workbooks): Examples Workbook Part 1, Examples Workbook Part 2, Multivariate Examples and Time Series Workbook. See Workbook Examples for a description of which examples are contained in which files.

Release 4.8 contains the following new features:

Shapely-Owen Decomposition

Adds the following new array function:

SHAPELY(Rx, Ry) = a column range which gives the Shapely-Owen decomposition of R-square for the linear regression of Rx (which contains the x data values) on Ry (which contains the y data values).

This decomposition shows the relative contribution of each of the independent variables to the regression model.

Box-Cox Transformation

Adds the following new functions which carry out Box-Cox transformations

BOXCOX(R1, λ): array function which returns a range containing the Box-Cox transformation of the data in range R1 using the given lambda value. If the lambda argument is omitted, then the transformation which best normalizes the data in R1 is used, based on maximizing the log-likelihood function.

BOXCOXLL(R1, λ) = log likelihood function of the Box-Cox transformation of the data in R1 using the given lambda value

BOXCOXLambda(R1) = the value of lambda which maximizes the log likelihood function of the Box-Cox transformation of the data in R1

New Support for the Multivariate Normal Distribution

Adds the following new functions

BNORMSDIST(x, y, r, cum) = the cdf of the standard bivariate normal distribution at x and y with correlation coefficient r if cum = TRUE and the pdf if cum = FALSE

BNORMDIST(x1, x2, m1, m2, s1, s2, r, cum) = the cdf of the standard bivariate normal distribution at at x1 and x2 with means m1 and m2, standard deviations s1 and s2 and correlation coefficient r if cum = TRUE and the pdf if cum = FALSE

MNORMRAND(Rm, Rc): generates an array containing a random k × 1 vector from a k-dimensional multivariate normal distribution where Rm is the range that contains the k × 1 means vector and Rc is the range that contains the k × k covariance matrix

BNORMRAND(m1, m2, s1, s2, r): generates a random 2 × 1 vector from a bivariate normal distribution with means m1, m2, standard deviations s1, s2 and
correlation coefficient r

These last two functions can be used to generate a random vector which comes from a multivariate normal distribution with the specified parameters.

Mardia’s Test for Multivariate Normality

Adds the following functions that test whether the data in range R1 is drawn from a multivariate normal distribution

MSKEWTEST(R1, lab): Mardia’s skewness test for multivariate normality; returns a column range with the values skewness, chi-square statistic, df and p-value, plus corrected statistic and p-value for small samples

MKURTTEST(R1, lab): Mardia’s kurtosis test for multivariate normality; returns a column range with the values kurtosis, z-statistic and p-value

If lab = TRUE then an extra column of labels is appended to the results (defaults to FALSE).

Changes to the Noncentral Chi-square and F  Distribution Functions

The NCHISQ_DIST, NCHISQ_INV, NCHISQ_NCP, NF_DIST, NF_INV and NF_NCP functions have been revised to improve their accuracy especially for large values of the noncentral parameter. Note that the number of terms in the infinite series approximations has been greatly expanded (default is now 1,000 instead of 80). In addition, you can now specify the level of accuracy via a precision argument (default is .000000001).

The same changes have been made to the power and sample size functions REG_POWER, REG_SIZE, CHISQ_POWERCHISQ_SIZE, ANOVA1_POWER, and ANOVA1_SIZE.

The various functions that support the noncentral t distribution and the corresponding power and sample size  functions have not changed, except that the default number of terms in the infinite series has been increased from 80 to 120.

These changes are also reflected in the corresponding Power and Sample Size data analysis tools.

Minor Enhancements and Bug Fixes

  • Fixes a bug in the KCORREL function
  • Added some new arguments to the Mahalanobis distance squared function MDISTSq
This entry was posted in Announcement, New Release. Bookmark the permalink.

9 Responses to Real Statistics Release 4.8

  1. Diane Berry says:

    Does the BoxCox work for the MAC?

  2. Apreciado Dr. Buenos días, no se como aplicara la transformación de Box Cox con Rela Statistics, o por lo menos determinar el lamda, para transformar los datos, por favor podría dar un ejemplo?.
    Este estadístico no se encuentra dentro del menú del paquete Real Statistics?, solo se encuentra como función?
    Dear Dr. Good morning, I would like apply Cox transformation Box with Real Statistics, or at least determine the lamda, to transform the data, please could you give an example ?.
    This statistic is not found within the package Statistics menu Real ?, only found as a function?

    • Charles says:

      I am planning to add the Box-Cox Transformation description to the website today. This will show you how to determine the value of lambda to best transform the data.

  3. Dr Muchas gracias por su execlente labor incondicional

    Dr Thak You very much, by your excelent labour

  4. Rich says:

    Hi, Charles

    Wondered if you might include the new arguments for the updated MdistSq function in the release notes?

    Also, in looking up other references for using the new R-square decomposition feature you have added…I see different spelling – Shapley.


    • Charles says:


      2. Yes, I have misspelled Shapley. This will be corrected in the next software release. Thanks for identifying this mistake.


    • Charles says:

      There is an error in the revised function and so the new function won’t be available until the next release of the software. You can still use the old functionality though.

Comments are closed.