I am pleased to announce Release 6.6 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 and 365 in both Windows and Mac environments.
The Basics, Distribution 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 several days, the website will be updated for compatibility with the new release.
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 an overview of the new features in Release 6.6.
Kernel Density Estimation (KDE)
A new Kernel Density Estimation data analysis tool has been added which estimates the probability density function (pdf) of a distribution from which some sample has been extracted. This data analysis tool supports the following types of kernels: Gaussian, uniform, triangular, biweight, triweight, trinode, cosine, logistic, sigmoid, Silverman and Epanechnikov.
Cross Correlations
A new Cross Correlations data analysis tool has been added which which calculates the correlation between two sets of data at different lags.
ROC Curve enhancement
The ROC and Classification Table data analysis tool has been enhanced to include a confidence interval for AUC (area under the curve).
Randomized Complete Block Design enhancement
Added a Modified Tukey HSD option to the Randomized Complete Block Design data analysis tool. This option supports the Tukey HSD post-hoc test using pairwise standard errors instead of the omnibus MSE value.
Color Enhancements
The Color Assignment data analysis tool as well as the RGBCode, GetColor, FontColor and FillColor functions have been expanded to support 66 named colors instead of 33.
New Text String Functions
The following two new Real Statistics functions have been added:
TEXT_REVERSE(s): returns a text string with the characters in text string s in reverse order
TEXT_JOIN(delim, ignore_empty, text1, text2, …): concatenates the text strings in text1, text2, … inserting the delimiter delim between entries.
Note that TEXT_JOIN is equivalent to the Excel TEXTJOIN function that was introduced with Excel 2016. The new Real Statistics function may useful to users of Excel 2010 and 2013.
Enhancements to the FirstNonNum function
Until now the FirstNonNum function was defined by
FirstNonNum(R1): displays address (e.g. “B7”) of the first empty or non-numeric cell in range R1 or “None” if R1 does not contain any empty or non-numeric cells
The FirstNonNum(R1, ntype) function now takes an optional second argument which further specifies the type of error checking to be done. ntype can take any of the following values:
| ntype | What the range must only contain to return “None” |
| error | any value that isn’t #N/A, #DIV/0!, etc. |
| blank | any value that isn’t an error value or blank (i.e. empty cell) |
| numeric | numeric values (no error values, blanks or alphabetic characters) |
| non-negative | non-negative numeric values (0, 3 or 3.7 but not -3, -3.7) |
| positive | positive numeric values (3 or 3.7 but not 0, -3, -3.7) |
| integer | integer values (0, 3 or -3, but not 3.7 or -3.7) |
| count | non-negative integers (0, 1, 2, …) |
| positive integer | positive integers (1, 2, 3, …) |
| RGB | valid RGB codes; i.e. any integer from 0 to 256^3 – 1 |
| zero-to-one | numeric values between 0 and 1 (inclusive) |
| zero-one | only 0 or 1 |
The default value for ntype is “numeric”, and so FirstNonNum(R1) is equivalent to FirstNonNum(R1, “numeric”).
Minor enhancements and bug corrections
Dialog boxes for many of the data analysis tools have been revised to correct errors in tab sequencing, tool tips and text in the Help facility. Additional validations have been added, especially to flag when input data is supposed to be numeric, positive, etc. More will be added in the following release.
Also, in dialog boxes where there are two input ranges (e.g. Input X Range and Input Y Range) and where the second range consists of one column, you may optionally omit that range and include it in Input Range X. This was already the case for the Linear Regression and T Test and Non-parametric Equivalents data analysis tools.
Bug Corrections
A bug in the RUNSDIST(r, n1, n2, cum) function has been corrected. This bug only occurred when r = n1 + n2 when n1 = n2 or r = 2m + 1 when n1 ≠ n2 and m = min(n1, n2). This also corrects the RUNSINV and RUNSTEST functions which calls the RUNSDIST function.
Fixed a minor error in the NODUPES function which retained blank entries in some cases but not in others.
Fixed a bug in the Randomized Complete Block Design data analysis tool when there are some missing data elements that incorrectly resulted in a negative MSE value
Other change
The Solving Simultaneous Linear Equations data analysis tool has been moved from the Desc tab to the Misc tab on the main dialog box.