Real Statistics Resource Pack

The Real Statistics Resource Pack contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website. 

We now explain how to download and install the Real Statistics Resource Pack for use with Excel 2010, 2013, 2016, 2019, 2021, 2024 or 365 on Windows. If you are using Excel 2007 click here. If you are using Excel 2003 or a prior version of Excel click here. Finally, if you are using Excel for the Macintosh click here.

Keep in mind that there are also two versions of Excel, at least for Excel 2010, 2013, 2016, 2019, 2021, 2024 and 365, the 32-bit version and the 64-bit version. Most people use the 32-bit version. The Real Statistics Resource Pack works in both versions of Excel.

Download

Real Statistics Resource Pack for Excel 2010, 2013, 2016, 2019, 2021 or 365 for Windows

Two versions of the software are available. The first provides help support (via Insert Function fx) for Real Statistics worksheet functions but can slow down certain Excel operations. The second version omits this support but does not degrade Excel operations.

Both versions of the software are compatible with all Windows releases of Excel from 2010 until the present. After downloading the software make sure that you install the software as described below.

Downloading either resource pack means that you accept the License Agreement.

Real Statistics Resource Pack for Excel 2002, 2003 or 2007

If you are using Excel 2007, click here for instructions on how to download and install the Real Statistics Resource Pack.

If you are using Excel 2003 or a prior version of Excel, click here for instructions on how to download and install the Real Statistics Resource Pack.

Real Statistics Resource Pack for Excel 2011, 2016, 2019, 2024 or 365 for Mac

If you are using a Macintosh version of Excel, click here for instructions on how to download and install the Real Statistics Resource Pack.

Solver Installation

Before trying to install the Real Statistics Resource Pack make sure that Excel’s Solver is installed on your computer. You can check this as follows:

  1. Open up a blank Excel spreadsheet
  2. Press Alt-TI (i.e. hold down the Alt key and press the T and I keys).
  3. On the dialog box that appears make sure that the Solver add-in is checked. If not, check it and click on the OK button.
  4. If the Solver add-in was not checked you need to close the Excel file before proceeding to the Real Statistics installation.

You can also accomplish step #2 by selecting Developer > Add-ins|Excel Add-ins.

Real Statistics Installation

Once you have downloaded the Resource Pack and made sure that Solver is installed, you need to install the Real Statistics Real Pack using the following steps:

  1. Move the Resource Pack to where you want it located on your computer (see our recommendation below). Caution: Once you install the resource pack at a particular location it will be more difficult to move it later.
  2. Open Excel, but don’t try to open the XRealStats.xlam or XRealStatsX.xlam file that you downloaded earlier.
  3. Select File > Help|Options > Add-Ins and click on the Go button at the bottom of the window (see Figure 1). Alternatively, you can simply press Alt-TI (i.e. hold the Alt key down and simultaneously press T followed by I) and the dialog box shown in Figure 2 will appear.

    Add-in dialog box
    Figure 1 – Add-Ins dialog box 1
  4. Check the Xrealstats or Xrealstatsx option on the dialog box that appears (see Figure 2) and click the OK button. NOTE: If you have previously activated a different version of the Real Statistics software you must uncheck the option corresponding to that version.
  5. If this option doesn’t appear, click on Browse to locate and then choose the xrealstats.xlam or xrealstatsx.xlam file. Then complete step 4 as described above.
Add-Ins dialog box
Figure 2 – Add-Ins dialog box 2

Where to place the Real Statistics Resource Pack

While you can place the Real Statistics Resource Pack anywhere on your computer, we recommend that you put the file in the following folder:

C:\Users\user-name\AppData\Roaming\Microsoft\AddIns

where user-name is your username in Microsoft Windows. Since some of these folders are hidden, you may find it convenient to enable showing hidden folders. For example, in Windows 10 or 11 you can do this by opening Settings and then typing Show Hidden Files and Folders in the search field. Next, check on the Show hidden files, folders, and drives option in the dialog box that appears, and then click on the OK button.

Installation of Upgrades

Once you have installed the Real Statistics Resource Pack as described above, to install a new version of the software you don’t need to repeat these steps. You only need to delete the previous version of the resource pack and put the new version of the software in the same location as the previous version.

Troubleshooting

If there is a problem during the installation try one or more of the following:

  1. If Excel is running, close it. Find the file with the Real Statistics add-in. Right-click on the file and click on the Properties option from the menu that appears. Towards the bottom of the General tab of the Properties window, you will see the security message “This file came from another computer and might be blocked to help protect this computer”. Next to this message is the Unblock checkbox. Make sure this is checked and press the OK button. Start Excel.
  2. Click on Options from the File ribbon and then choose the Trust Center option on the left side. Next, click on Trust Center Settings …. Now, click on the Macro Settings option on the left side and make sure that it is Disable all Macros with Notification. Also, click on the Trusted Locations option on the left side and click on the Add New Location… button to add the folder that contains the XRealStats or XRealStatsX file as a trusted location.
  3. Try opening a blank Excel worksheet and press Alt-TI. Uncheck the Xrealstats add-in and close Excel. Now open a blank Excel worksheet and press Alt-TI. This time check the Xrealstats add-in

Most importantly, remember that Solver must be installed. To check this, press Alt-TI and make sure that Solver (as well as Xrealstats or Xrealstatsx) is on the list of add-ins with a checkmark next to it.

Real Statistics Functions

Once you have installed the Real Statistics Resource Pack you can use the Real Statistics functions in the same way as you use the built-in worksheet functions supplied with Excel. These functions are described throughout the rest of this website. A complete list of these functions can be found on the Tools menu of the website (or at Real Statistics Software Capabilities).

Real Statistics Data Analysis Tools

You can access the Real Statistics data analysis tools in one of the following ways, as described in Accessing Real Statistics Data Analysis Tools:

  • By pressing Ctrl-m or
  • Clicking on an icon on the Add-Ins ribbon or
  • Clicking on an icon on the Quick Access Toolbar or
  • Via the Macro dialog box

A dialog box will now appear that lists all the available Real Statistics data analysis tools.  You need to choose one of the data analysis tools from this list.

A dialog box will then appear as described in Real Statistics Data Analysis Tools which enables you to specify your input data and choose from available options. You can also access Help to get more information about the selected data analysis tool.

A complete list of Real Statistics data analysis tools can be found in Real Statistics Data Analysis Tools.

Uninstalling the Real Statistics Resource Pack

  1. Open Excel
  2. Press Alt-TI
  3. Uncheck the Xrealstats or Xrealstatsx option on the dialog box that appears and click the OK button.
  4. Close Excel and delete the file that contains the Real Statistics Resource Pack.

1,241 thoughts on “Real Statistics Resource Pack”

  2. Hi Charles. Where can I download the release 9.6 of Real Statistics Resource Pack? It is only avaliable the release 9.4.5.

    Reply

    • Hello David,
      Actually Rel 9.6 should be Rel 9.5, but in any case it hasn’t been released yet. I plan to issue this release this month, probably within 2 weeks.
      Charles

      Reply

  3. For anyone suffering with “This file is not supported in protected view”, this isn’t an Excel thing, but a Windows thing. Downloaded files have an extra property that flags them for security checks. Just go to where you’ve downloaded/moved the file, right click it > properties. It will show a window with filename, dates, etc, the bottom line is Attributes, and the very last one is about security (as of May 2025 it still is), read it (“this file came from another computer” or similar text) and check the box to unblock. Now you can open excel again and activate the add-in.

    Reply

Leave a Comment