I am pleased to announce Release 3.1 of the Real Statistics Resource Pack. The new release is available for free download (Download Resource Pack) and is compatible with Excel 2007, 2010 and 2013. I plan to make a Macintosh compatible version available later today or tomorrow.
The Real Statistics Examples Workbook has been updated to reflect the new release. You can also download this file for free (Download Examples). The website is being updated to reflect the new features. These changes will be available over the course of the next day or two.
This release mostly completes new features introduced in Rel 3.0, including the following:
Enhanced functions:
The following are now array functions with added output:
SCORREL(R1, R2, lab, tails, alpha): in addition to calculating Spearman’s correlation coefficient (rho), this statistic is tested for the null hypothesis rho = 0 using a t test and the t-stat and p-value of the test are returned. If lab = TRUE then a column of labels are added to the output.
ICC(R1, class, type, lab, alpha): outputs a column range consisting of the intraclass correlation coefficient ICC(class, type) of R1, plus the lower and upper bound of the 1 – alpha confidence interval of ICC. The default values are class = 2, type = 1, lab = FALSE and alpha = .05.
The following function remains an ordinary (i.e. non-array) function:
CRONALPHA(R1, k) = Cronbach’s alpha for the data in range R1 if k = 0 (default) and Cronbach’s alpha with kth item (i.e. column) removed if k > 0
The following two functions, which provide the critical values and p-values for the Mann-Whitney tests for small samples have improved accuracy (since table lookup is now implemented for alpha = .005 and .20, two-tailed and alpha = .01 and .10, one-tailed)
MCRIT(n1, n2, alpha, tails) = critical value of the Mann-Whitney test for samples of size n1 and n2.
MPROB(x, n1, n2, tails, iter) = p-value of the Mann-Whitney test for samples of size n1 and n2.
Enhancements to the data analysis tools:
The Correlation data analysis tool has been enhanced to output the t-test and p-value for Spearman’s correlation coefficient
The Reliability data analysis tool has been enhanced to provide a confidence interval for the intraclass correlation coefficient (ICC)
New functions:
The following are new array functions:
COUNTCOL(R1): outputs a row range with the counts of each of the columns in R1
MEANCOL(R1): outputs a row range with the means of each of the columns in R1
VARCOL(R1): outputs a row range with the sample variances of each of the columns in R1
STDEVCOL(R1): outputs a row range with the sample standard deviations of each of the columns in R1
CALPHA(R1): outputs a row range of Cronbach’s alphas for the items in R1 with one item (i.e. column) from R1 removed
Bug fixes:
- Corrected the p-value in the KAPPA function.
- Corrected error checking in the Fleiss’s kappa option of the Reliability data analysis tool.
- Corrected a couple of errors on the Intraclass correlation webpage
Charles