I have just issued Release 6.0.2 for Excel 2010, 2013, 2016, 2019 and 365 environments.
This release fixes a bug from Rel 6.0 that appears when using the following functions as well as the Cochran-Mantel-Haenszel Test data analysis tool.
CMHTEST, WOOLFTEST, EM_CHISQ_TEST, MauchlyTest, JNSTEST
NCHISQ_DIST, NCHISQ_INV, NCHISQ_NCP, CHISQ_POWER
Sorry for the inconvenience that this bug may have caused some of you.
Charles
I thought I had successfully installed version 6.02 (for Excel 2010 Windows version). However, the ver() function is still obstinately reporting “5.9 Excel 2013/2016/2019”
Where is the problem?
Jonathan,
Press Alt-TI and uncheck the file containing the 5.9 version. Then click on the Browse button to locate the file where you stored the 6.02 version and make sure that there is a check mark next to this file in the Add-ins list.
If Excel is still confused, then I suggest that first you rename the file that conatins the 6.0.2 version (e.g. RealStats6.xlam). Now the above approach should work since Excel won’t get confused between the two versions (since they have different names). Real Statistics will work file even when you change the name of the file.
Charles