Problems introduced by latest Excel 365 release

In the latest versions of Excel 365, Microsoft has made a change that causes a conflict between Real Statistics and Solver. Since Real Statistics requires the activation of Solver, this is a problem. This issue and its solution is described in detail at: Conflict between Real Statistics and Solver As described on this webpage, I … Read More

Compile Error in Hidden Module

This blog post is intended to try to address the following error message: “Compile error in hidden module: ‘xx’. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application” The usual reason for getting this message is that Solver has not been installed. You can determine whether this … 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

Real Statistics with 64 bit Excel

While most people use the 32 bit version of Excel, there is an important community of users of the 64 bit version of Excel. A number of people have asked the question as to whether the Real Statistics Resource Pack works with the 64 bit version of Excel. The following is an answer to this question … Read More

Real Statistics Rel 4.10

I am pleased to announce Release 4.10 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2007, 2010, 2013 and 2016 (Windows version) environments. I apologize to all you Mac users. I expect to turn my attention to creating a new Mac version of the … Read More

Real Statistics disappears from Addin ribbon

Some of you have reported that Real Statistics disappears from the Add-ins ribbon. What follows is a potential way to eliminate the problem thanks to some research done by Jeff. First of all, this problem is likely due to a security enhancement that Microsoft recently made to Excel which impacts add-ins. The following steps should be … Read More

Quick Update 26 May 2016

I just wanted to let you know about the following updates to the Real Statistics website: The website has now been updated to reflect all the new capabilities introduced in Rel 4.7 and 4.8. I still plan to add a few more pages with proofs of some of the properties and some more technical matters. … Read More

Rel 4.6 Installation

The installation instructions for the new release, Rel 4.6, of the Real Statistics Resource Pack is as follows: 1. Make sure that Excel’s Solver capability is installed on your computer. To check this proceed as follows: (a) open up a blank Excel spreadsheet (b) Press Alt-TI (i.e. hold down the Alt key and press the T … Read More

Important Information about Rel 4.6

Unlike previous releases of the Real Statistics Resource Pack, the latest release, Release 4.6, uses Excel’s Solver capability. This means that you must make sure that the Solver addin is loaded on your computer  You do this by pressing Alt-TI (i.e. hold the Alt key down and press T and I) and making sure that there is … Read More

Suggestion for Excel 2007 Users

A number of Excel 2007 users have run into various problems when installing or running Real Statistics. Here is a suggestion from Cyberpreneur which may be helpful to you “to correct the password problem requires installing the Real Stat addin in proper manner. Copy the downloaded file to /Microsoft Office/Office12/Library/Analysis , then restart excel. Then … Read More