I am pleased to announce Release 9.8 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.
I would like to thank everyone who made suggestions or identified errors in the website or software. Your help has improved 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.8.
Principal Component Analysis
Adds a new Principal Component Analysis data analysis tool and the PCFull and PCScore Excel worksheet functions.
Click here for more details.
Factor Analysis Enhancement
Adds a new FAScore worksheet function that translates the original data into the data for the latent factors defined by a factor analysis model.
Click here for more details.
Box-Cox Enhancements
Adds Hawkins-Weisberg option to the BOXCOX, BOXCOXLL, and BOXCOXLambda worksheet functions.
Finally, this release adds a Box-Cox Transformation data analysis tool.
Click here for more details.
Boschloo’s Exact Test
Adds the Boschloo exact test support via the BOSCHLOO worksheet function.
Click here for more details.
2 × 2 Contingency Table Testing
Adds a new 2 × 2 Contingency Table Testing data analysis tool. This tool outputs the Fisher and Boschloo exact tests for 2 × 2 contingency tables as well as information about the odds ratio.
Click here for more details.
Cohen’s h Effect Size
Adds a new COHENH worksheet function that calculates Cohen’s h for the difference between two proportions. Click here for more details.
This function also calculates Cohen’s h effect size for a 2 × 2 contingency table. Click here for more details.
Two-dimensional sequence functions
Adds new SEQ2S and SEQ2X worksheet functions. These functions output a two-dimensional array with pairs of sequences of numbers (similar to the existing one-dimensional SEQ and SEQUENCE functions).
Click here for more details.
Complex Number Enhancements
Adds new complex number functions, including CI (= i), various trig functions, and zw, where both z and w can take complex values. CSQRT(z) = √z = z1/2 is also supported. Furthermore, additional arguments are supported for the CEXP, CLN, CMULT, and CDIV functions.
Click here for more details.
Arc Length Capability
Adds a new ARCLENGTH worksheet function that calculates the length of a curve y = f(x) between two limits x = a and x = b. This can be used to estimate the perimeter of geometric shapes such as an ellipse.
Click here for more details.