I am pleased to announce Release 7.1 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.
Over the course of the next several days, the website will be updated for compatibility with the new release, as well as the Distributions and Time Series examples workbooks.
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 7.1:
Proportion Tests
Two new data analysis tools have been added: a One-sample Proportion Test and a Two-sample Proportion Test. These can be found on the Misc tab.
For the one-sample proportion test, a new array function, PropCI, has also been added that calculates the lower and upper limits of a 1-alpha confidence interval based on the Wald interval, Wilson score binomial interval, Clopper-Pearson exact binomial interval or Agresti-Coull interval.
Heteroskedasticity Tests
A new Breusch-Pagan and White Tests data analysis tool has been added to the Reg tab that conducts the Breusch-Pagan Test and White Test to detect heteroskedasticity.
In addition, the following functions have been added:
- BPagStat: calculates the Breusch-Pagan test statistic
- BPagTest: calculates the p-value of the Breusch-Pagan test
- WhiteStat: calculates the White test statistic
- WhiteTest: calculates the p-value of the White test
Changes to the Main Menu
The following imputation data analysis tools have been moved from the Misc tab to the Corr tab:
- Multiple Imputation (MI)
- Full Infomation Max Log-Likelihood (FIML)
- EM for Missing Multivariate Normal Data
The Binary Logistic and Probit Regression data analysis tool has been renamed
- Logistic and Probit Regression
This has been done because quite a few people have been unable to locate the tool.
Tolerance Interval
In Release 6.0 the TOLERANCE_NORM function was added to calculate a tolerance interval for normally distributed data. We now add the following new functions that calculate a non-parametric tolerance interval for data that is not necessarily normally distributed:
TOLERANCE_LOWER: the lower limit of a tolerance interval
TOLERANCE_UPPER: the upper limit of a tolerance interval
TOLERANCE_SIZE: minimum sample size required to calculate a non-parametric tolerance interval
Cliff’s Delta Enhancements
The CLIFF_DELTA function has been enhanced to return not only Cliff’s delta statistic but also the standard error and lower and upper limits of the 1-alpha confidence interval.
Moving Average Enhancements
The Simple Moving Average and Weighted Moving Average options of the Basic Forecasting data analysis tools have been enhanced with the addition of standard error estimates and prediction intervals.
Odds Ratio Function
A new Real Statistics array function ODDS_RATIO has been added that calculates the odds ratio of a 2 × 2 contingency table along with the lower and upper limits of a 1-alpha confidence interval.
New functions for compatibility with Excel 365
To provide better support for dynamic arrays, a capability that has recently been introduced in Excel 365, some existing functions have been enhanced (ESD and OUTLIERS). In addition, some new functions have been added that are similar to an existing function (e.g. REVERSES, SHUFFLES, RANDOMIZES, ExtractsUnique and SortsUnique)
Bug Fixes
- The p-value for the Scheffe post-hoc test was calculated incorrectly. This has now been fixed.
- The p-value for the Nemenyi post-hoc test after Friedman’s test was calculated incorrectly. This has now been fixed.
- A number of labels on the various Statistical Power and Sample Size data analysis tool dialog boxes were truncated, especially on the Mac version of the software. This has now been corrected.
- Corrects an error in the FREQ_REFORMAT function and Histogram data analysis tool where the last element in the frequency table is not completely shown in the output.
Thanks Doc