I am pleased to announce Release 2.7 of the Real Statistics Resource Pack. The new release is available for immediate free download (Download Resource Pack). The Real Statistics Examples Worksheet has also been updated with new examples. You can also download this file for free (Download Examples). The website will be updated over the next few days to reflect the new capabilities.
This release provides the following new functionality:
Three Factor ANOVA data analysis tool – a new data analysis tool which
- Supports two input data formats
- Supports both balanced and unbalanced models (where the group samples are unequal)
- Provides descriptive data
Logistic Regression data analysis tool – the following new features have been added
- Classification table
- Addition of the following metrics: Sensitivity (True Positive Rate), Selectivity, False Positive Rate, Accuracy
- Receiver Operating Characteristic (ROC) Curve
- Ability to change the classification cutoff
- Improved user interface
Two Factor ANOVA data analysis tool – the existing data analysis tool now also supports Anova without replication (simply insert 1 in the # of Rows per Sample field when using the Excel input format)
Weighted Cohen’s Kappa function – a new function WKAPPA has been added which calculates the weighted version of Cohen’s kappa. The website has also been updated to explain this statistic
New reformatting functions – a number of new supplemental functions have been added which make it easier to format data. These include
QSORTRows: sort rows in a range based on the values of one column in the range.
SortRowsUnique: sort the rows in a data range eliminating any duplicates. There are also the related functions: SortRowsCount, SortRowsSum and CountRowsUnique
SelectCols: enables you to create a new data range by selecting any of the columns in an existing data range; the order of the columns can be changed and the rows can optionally be sorted
ExtractUnique: takes a data range and eliminates any duplicates but keeping the original order
I hope that you find the new capabilities useful.
Charles