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 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 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 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,212 thoughts on “Real Statistics Resource Pack”

  1. Hi I’m trying to do a multiple regression analysis on a dataset that has a independent variable with a maximum value (it’s a 0-100 range). I’m a student and just starting so wondering if theres anything simple I can do to account for this, or if I’m better off just capping my projected values. It’s not for anything major just a marketing game.

    Reply
  2. Hi Charles,

    I just wanted to say how fantastic this statistics add-in is. I needed something (free) that my students could use for a practical statistics course. Your RealStats worked a treat and meant that they could do proper analyses with a relatively small learning curve.

    I would recommend it to all who need to do data analysis and don’t want to invest in commercial products.

    Many thanks.

    Dave

    Reply
  3. Hi.
    Charles
    I highly appreciate the work that you have done.
    I have downloaded this resource file to download folder and opened it before installation. I installed this from the same location. Now this add in appearing in the add ins menu. However when I close excel file each time , the addin gets removed from my excel file and I have to browse the add in from resource file location everytime. I tried to remove it many times and reinstall it from other locations also. But could not succeed to bring the Add in on the menubar. Can you help me to install and add this Add in to excel menubar properly
    Thanks & Regards

    Reply
  4. Hi, I installed the Xrealstats for my office 2019 in windows 10. Still, none of the Xrealstats functions is discoverable as other normal functions are. I tried even after restarting. Is there anything else to do?

    Reply
  5. I am wondering why MissingFreq, MissingPatterns, ImputeSimple commands are not working in Windows Excel 2016. It works perfectly fine in Mac.
    Can you troubleshoot that for me?
    Thank you.

    Reply
    • May,
      I just tried the ImputeSimple function and it works on my computer.
      What sort of message do you get that the function is not working? Do you get an error value?
      Is Real Statistics installed on your Windows computer? What do you see when you enter the formula =VER() in any cell?
      Charles

      Reply
  6. Hi Charles,

    This is an awesome pack you have here and sharing this resource for free. I really appreciate it. Keep up the good work. I use the time series package.

    Any idea why ARIMAX does not seem to work. Is there anything I’m missing out.

    ARIMA and SARIMA work perfectly fine and I particularly like the added ‘Solver’ functionality to optimize the parameters.

    Reply
    • Hi Ken,
      Can you specify what doesn’t work with the ARIMAX data analysis tool?
      If you email me an Excel file with your data I will try to figure out why it doesn’t work.
      Charles

      Reply
      • The forecast that is generated look more like differences between two consecutive time periods. The time series data I have are all positive numbers, however, I got a mix of negative and positive numbers as forecast from ARIMAX which is not supposed to be. I wish I could share the data, sadly I am not able to share the data.

        In addition, I tried to record macro in excel 2016 to automate certain forecast daily but I couldn’t get excel to do it. Is there a way round this. I appreciate your feedback.

        Reply
          • ARIMAX is giving me negative forecasts for a non-negative time series data. I tried it on another data, I got the same thing: negative forecasts. The forecasts I get from both trials do not appear to match the level of the time series data. For example, my daily data ranges from $26M to $38M but ARIMAX gave forecasts of $1M, $3M, -$2M (negative number), $500k, etc. on all days. I did not get a single daily forecast of up $26M. These forecasts do not reflect my data.

          • Hello Ken,
            It does look like something is going wrong, but I need to see some data before I am able to identify where the problem is. If you can send me an Excel file with data that displays this problem, I will try to figure out what is going wrong. You don’t need to send me the real data, just some data that produce these sort of results.
            Charles

  7. Thank you for this wonderful free resource!
    For some reason, XReatStats never shows up in my Add-Ins Available Box. I followed the download instructions. Any thoughts?

    Reply
  8. Hello! I downloaded file Xrealstats and successfully installed in my MS Excel. However, I tried to use some functions like finding the Q critical for tukey it is not working. There is no error in the installation or any remark except that “A value is not available to the formula or function”. Kindly help me please.

    Reply
  9. Hello Charles,
    and thank you for the wonderful statistical resources that you are making available for free.
    I have downloaded the Real Statistics Resource Pack, and installed it following your recommendations (I saved the file in the C:\Users\user-name\AppData\Roaming\Microsoft\AddIns folder). However, every time I restart Excel, the pack is not loaded any more and nothing happens if I click CTRL+M. I always have to press ALT+TI, locate the pack again in Browse, and click “OK” when Excel asks me if I want to re-load the pack). Any suggestion on how I can prevent this from happening?
    Thanks,
    Enrico

    Reply
  10. Hello Charles, I am writing to thank you. I have recently returned to graduate school and am recovering from statistical traumas of undergrad many years ago. I appreciate your website and the open source work you have done to utilize the computational power of Excel rather than needing a specific stats program. Your example tables were particularly helpful to understand how to set-up the Spearman’s Rank Correlation I needed to run. Keep up the great work!

    Reply
  11. Dear Charles
    I downloaded Real Statistics Resource Pack from April/2020 and drawed successfully Histogram with normal curve by this software. But now, I just draw again, this software is failed with notification as follows: “compile error in hidden module: frmHist. This error commontly occurs when code incompatible with this version, platform or architecture of this application. Click “Help” for information on how to correct this error…”.

    Please explain this problem. Thanks you so much for your help!

    Reply
  12. It is an issue of trust. You need to install in C:\Program Files\Microsoft Office\root\Office16\Library or another trusted location. If the add-in is not trusted ether by location or signature it will not load and =Ver() will not work because the add-in did not load. It doesn’t matter what Options >> Add-ins states.

    Reply
  13. Hi Dr
    After installation xrealstats in Excel 2019, when I close Excel and open it again add-ins tab and xrealstats no long exist.
    please help me

    Reply
  14. Hi

    I had downloaded Real Statistics Resource Pack.

    When I go about adding it in excel it is showing me the following error.

    “Cant find project or library”

    Please advice ?

    regards

    Reply
  15. Dear Mr. Charles,
    First of all, I would like to tell you that your web, blog, applications are fantastic and so useful.
    I recently uploaded it and started using it and I am still learning about it. What it is happening is after I create any workbook and use the applications, it runs and gives me the results, however anytime I save them and I re open them or a new workbook, the Add-ins “disappears” from the ribbon and I must start from file>options> etc …
    Could you please give me a hand with this? or is it what is suppose to happen,

    Looking forward to hearing from you.

    Regards,

    Yorcar

    Reply
  16. Hi, I installed the pack, and wanted to use the Factor analysis to do PCA. However the input range is invalid.

    I have metals in my columns and sample points in my rows. I have selected the columns, inclusion of headings, and I didn’t put anything else.

    How can do PCA with the add-in?

    Best regards
    Marta

    Reply
  17. Dear Dr. Zaiontz,
    Thank you so much for your time and effort to create such a useful website and Excel tool!
    Please help me with a problem I cannot solve:
    I installed the Resource Pack ver. 7.0.6 under Excel 2010.
    I try to use the module “Statistical Power and Sample Size” – Cronbach’s alpha.
    When I input “Cron Alpha 0” = 0,7 and e.g. “Cron Alpha 1” = 0,9, I get the error message “Cron Alpha 1 must be a number between -1 and 1 not equal to Cron Alpha 0”.
    A similar error message also appears in other modules, e.g. ICC.
    Also, I have to manually change alpha’s default decimal dot to a coma elsewhere in the Resource Pack, otherwise I get the message “Alpha must be a number between 0 and .5”.
    Thank you in advance!
    Svetoslav

    Reply
  18. Hello, dear Sr.
    While running Real Estate I get an Error 424: Object required.
    What can I do?
    MS Office 2013 Run in Win 10.
    Sincerely, I’m José Orozco, a student of university in México.
    When entering the formule =VER() I see #¿NOMBRE?
    Any help would be greatly appreciated.

    Reply
  19. Hi Charles
    I just downloaded your Resource Pack but I was wondering if I will be able to install it on my italian version of Excel 2016 or if this will cause me troubles.
    What is your own opinion?
    All the best.
    Lorenzo

    Reply
  20. Hi Charles
    I apologize if someone has already addressed this topic.
    I just wanted to comment that the ‘Alt-TI’ key combination does not work, at least in Office 2010. To get to the Excel Add-Ins window the full sequence is:
    File menu > Options > Add-Ins > Excel Add-Ins > Go… (as you explain later at some point during the Installation instructions). There must be a different key combination than Alt-TI.
    Best,
    Carlo

    Reply
    • Thanks Carlo. Alt-TI does work for the English-language version of Excel 2010. This is probably not the case if you are using the Italian version of Excel.
      Charles

      Reply
  21. hello charles
    I am using excel 2007 version,,have been trying from many days to install realstat2007 ,,but couldn’t
    To help you, I have ticked solver,,have done all the troubleshoot solution mentioned,,but couldnt get it started,,everytime its saying that this file is corrupted and this file extension doesnt support this file format

    please help me out,,i am a student,,wanted to learn analytics

    Reply
  22. Dear professor,

    I really thank you for the site and the software that you made and especially for the support and the maintenance.

    My question is the following, I want to download your software but to have no problem for the installation and especially to take advantage of the latest developments in your software, which version do you recommend (2003, 2007, …, 2016 )?

    Thank you so much.

    Reply
  23. Dear Charles,

    I wonder how to cite this valuable pack in, for instance, research articles and dissertations.

    All the best,
    Félix.

    Reply
  24. Hi Charles,

    I followed the installation guide for realstats and i can see it in the active application add ins list however i cannot seem to get it to work. When i type in =VER() i get #NAME? in the cell. I also can’t seem to access the add in through any of the methods (ctrl-m, add ins ribbon, QAT, or macros). I put it in the recommended folder on my PC and made that location trusted to excel as well but still no luck..
    I’ve also uninstalled and reinstalled the entire thing twice with no luck.. do you have any idea why it might not be working?

    Reply
    • The fact that you get #NAME? when you enter =VER() means that the software hasn’t been installed.
      When you press the key sequence AL-TI do you see Solver and XRealStats on the list of add-ins with checkmarks next to them? If not you need to click on the Browse button to locate the file containing the Real Statistics software (as described in the Installation instructions).
      Charles

      Reply
      • Hi Charles,
        It must have not finished installation for one reason or another, but when i reopened excel a few hours later it was all up and running correctly. Thank you very much for this software, and for replying to my above comment. This has made working on my thesis so much easier! I will be sure to cite the software in my finished piece 🙂

        Reply
  25. Dear Charles,

    Thanks again for your wonderful add in. After version 7.0 installation I got a response to =ver() that say Ver 6.8

    Best regards,

    Jorge Camacho

    Reply
  26. I downloaded the XRealStats.xlam file but my system added an .xlsx extension. I deleted the .xlsx and left .xlam as the extension. The file appears as an option in the Add-In dialog box but I get an error message pop-up:
    “Excel cannot open the file XRealStats.xlam because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

    Reply
  27. I am having problems downing loading XRealStats on my PC. When I click to download, Real Statistics Resource Pack for Excel 2010, 2013, 2016, 2019 or 365 for Windows, Excel file downloads and I still don’t see the XRealStats. Please advise.

    Reply
  28. hello Sir,
    i have a problem in Running Time series analysis. the problem is “Compile error Hidden Module ” how can i solve this problem

    Reply
  29. Hello,
    I’ve a problem using the plugin. I installed the plugin following the instructions. Immediately after activating the xrealstats add-on, the “Additional Components” tab becomes visible in the ribbon bar of Excel and within it I can select Real Statistic and use the plugin functions. However, the next time I restart Excel, the “Additional Components” tab disappears and I cannot longer use the plugin. Afterwards by deactivating the plugin and reactivating it, the tab becomes visible again, but the next time Excel is restarted the tab disappears again. I tried to install the plugin on 2 different pc with 2 different office version (2016, 2019) but the problem is the same. Could you help me? Many thanks.

    Reply
  30. got it loaded and working … 🙂

    But I had a heck of a time finding these installation instructions. I suggest adding this page’s link to the “Free Download” page and to your home page (and wherever the download link appears).

    But wow, good. I wrestled with SPSS for a year. It’s very sophisticated and elegant but a lot of tech overhead, especially for people who don’t do hard-core stats.

    So this add-in is looking good.

    Reply
  31. Oh my heavens. I spent roughly 6 hours today trying to get my ridge regression to work in r. I found this while searching for yet more help, and within 15 minutes of downloading and installing it, I had a beautiful report. I cannot thank you enough for developing this tool!!

    Reply
  32. Hello,

    While running Realstat I get an Error 424: Object required.
    What can I do?

    Win 10/MS Office 365.

    Sincerely, Johan arts

    Reply
    • Hello Johan,
      Which data analysis tool were you using? What do you see when you enter the formula =VER() in any cell?
      If you email me an Excel file with your data and any output that was generated, I will try to figure out what went wrong.
      Charles

      Reply
      • Hello Charles,

        When entering the formule =VER() I see
        6.7 Excel2010/2013/2016/2019/365Windows
        Before reinstalling Win 10 last week Realstat worked perfectly.

        Reply
        • Johan,
          Are you receiving the error message for all data analysis tools or just the one you referred to in your previous comment?
          If only for one data analysis tool, then I suggest that you send me an Excel file as stated in my previous response.
          Charles

          Reply
          • Hello Johan,
            This is strange. I was expecting that this message related to some data analysis tools but not others.
            Have you looked at the Troubleshooting section of the webpage? There may be something that changed when you made your recent change.
            Charles

Leave a Comment