I am pleased to announce Release 9.7.5 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, 2021, 2024, and 365 Windows and Mac environments.
The website will be updated in the next few days to reflect the changes in this release.
I want to thank everyone who made suggestions or identified errors. Your help continues to improve the utility and accuracy of Real Statistics.
I also want to express my appreciation to all of you who have donated to Real Statistics. These donations help offset the costs of maintaining the website. If you are getting value from the Real Statistic website or software, I would appreciate your donation by going to Please Donate.
The following is an overview of the new features in Release 9.7.5.
New LOESS Regression data analysis tool
The LOESS Regression data analysis tool has been added to the Reg tab of the main menu.
In addition, the LOESS worksheet function has been revised to support both deg = 1 and deg = 2. It also outputs a chart with the results of the regression.
New Two Samples Test data analysis tool
A new data analysis tool has been added that peforms the Trim Means t Test, Yuen-Welch’s t Test, and Fligner-Policello non-parametric test. This tool can be found on the Misc tab of the main menu.
New Trends and Change Point Test data analysis tool
Adds the (Pettitt) Change Point and Cox-Stuart tests to the data analysis tool that supports the Mann-Kendall and Sen’s Slope tests. This analysis tool is also renamed Trend and Change Point Tests.
A Pettitt’s Test worksheet function has also been added that supports a commonly used version of the test with an approximate p-value.
Bug Fix
- Fixed a bug in the Brunner-Munzel data analysis tool when the data is in standard (stacked) format.
- Tweaked some of the dialog boxes