The following is an overview of the new features in Release 8.1.5.
Rectified Normal Distribution
The following worksheet functions have been added to support the rectified normal distribution.
RNORM_DIST(x, μ, σ, cum) = the probability density function value for the rectified normal distribution f(x) when cum = FALSE and the corresponding cumulative distribution function F(x) when cum = TRUE.
RNORM_INV(p, μ, σ) = the value x such that RNORM_DIST(x, μ, σ, TRUE) = p, i.e. inverse of RNORM_DIST(x, μ, σ, TRUE).
Enhancement to Grubbs’ Test data analysis
The Grubbs Test option of the Descriptive Statistics and Normality Testing data analysis tool now performs the Grubbs/ESD test on each column of the input data.
QAT Access
The primary way to access the Real Statistics data analysis tools is by pressing the key sequence Ctrl-m. Windows users can also access these tools is by using the Add-Ins ribbon. You can now access these tools from the Quick Access Toolbar (QAT) in one click.
This is done by downloading the RS_QAT.xlsm file from the QAT Access webpage on the Real Statistics website. This webpage also describes how to customize Excel’s Quick Access Toolbar on your computer to give you access to Real Statistics from the QAT in one click.
Bug Fix
Fixes a bug in the HNORM.DIST function (wrong number of arguments).