Real Statistics Rel 5.9.1 for Mac

A new bug-fix release of the Real Statistics Resource Pack for the Mac, Rel 5.9.1, is now available. This release provides the following for users of Excel 2011, 2016 or 2019 for the Mac: An error in the QCRIT function has been fixed The dialog box for many of the data analysis tools have been … Read More

Real Statistics Release 5.9

I am pleased to announce Release 5.9 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2013, 2016 (Windows and Mac) and 2019 (Windows and Mac) environments. The examples workbooks have been updated for compatibility with the new release. New versions of the … Read More

Real Statistics Release 5.8

I am pleased to announce Release 5.8 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2013 and 2016 (Windows) environments. Release 5.8 will be available for Excel 2011 and Excel 2016 for Mac in about a week. The examples workbooks have been … Read More

Error in MWDIST Function

I have discovered an error in the new MWDIST(x, n, tails) function. This error only occurs rarely; in particular when C(n+1, 2) is even and x = C(n+1,2)/2. In such cases, MWDIST(x, n, 2) > 1.0 and MWDIST(x, n, 1) > 0.5. The fix is simple: when tails = 2, then simply subtract the value output … Read More

Release 5.7 for Mac

The latest release of the Real Statistics Resource Pack, Release 5.7, is now available for the Mac (Excel 2011 and Excel 2016). It was previously released for the Windows environment (Excel 2007, 2010, 2013 and 2016). The Real Statistics website has now been updated for compatibility with Rel 5.7. Charles

Real Statistics Release 5.7

I am pleased to announce Release 5.7 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2013 and 2016 (Windows) environments. Release 5.7 will be available for Excel 2011 and Excel 2016 for Mac in about a week. The Real Statistics 1B and … Read More

Real Statistics Release 5.6

I am pleased to announce Release 5.6 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2013 and 2016 (Windows) environments. Release 5.6 will be available for Excel 2011 and Excel 2016 for Mac by tomorrow. The various examples workbooks have … Read More

Real Statistics Release 5.5

I am pleased to announce Release 5.5 of the Real Statistics Resource Pack. The new release is now available for free download at Download Resource Pack for Excel 2007, 2010, 2011, 2013 and 2016 (Windows and Mac version) environments. The various examples workbooks have also been updated for compatibility with the new release. The Real Statistics website will … Read More

Release 5.4.2

A new release of the Real Statistics software was issued yesterday which is probably only relevant to a few users. The new release, Rel 5.4.2, contains the following changes: Improves the accuracy of Mauchly’s test for sphericity, i.e. the MauchlyTest function Corrects a bug in the benard parameter of the regression approach to fitting data … Read More

Release 5.4.1

My apologies, but there was an error in the NT_DIST function in the new release, Release 5.4, which also caused errors in the NT_NCP, NT_INV, T1_POWER, T2_POWER, T1_SIZE and T2_SIZE functions, as well as the Statistical Power and Sample Size data analysis tool for the t test options. This error only occurred for certain combinations … Read More