Real Statistics Resource Pack for older versions of Excel

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 Excel 2003 and Excel 2002. We are not sure whether these work for even older versions of Excel. 

Download

If you accept the License Agreement, then

Click here on Real Statistics Resource Pack 2003 to download the latest version of the resource pack for Excel 2003 (Release 3.0).

Click here on Real Statistics Resource Pack 2002 to download the latest version of the resource pack for Excel 2002 (Release 3.0).

The resource pack takes the form of file with extension .xla (instead of the .xlam file used with Excel 2007/2010/2013/2016).

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

Installation

Once you have downloaded the Resource Pack, you need to install it 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 realstats-2003.xla or realstats-2002.xla file that you downloaded earlier.
  3. From the Tools menu choose Add-Ins (alternatively you can press Alt-TI).
  4. Check the Realstats option on the dialog box that appears and click the OK button.
  5. If this option doesn’t appear, click on Browse to find and choose the realstats.xla file that you downloaded earlier. Then complete step 3 as described above.

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:\Documents and Settings\user-name\Application Data\Microsoft\AddIns

where user-name is your user name in Microsoft Windows. Since some of these folders are hidden, you may find it convenient to enable showing hidden folders.

Real Statistics Functions

Once you have installed the Real Statistics Resource Pack you can use the supplemental 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 in Real Statistics Supplemental Functions and Real Statistics Multivariate Functions.

Real Statistics Data Analysis Tools

You can access the supplemental data analysis tools by pressing Ctrl-m or by clicking on the Real Statistics menu which is automatically added to Excel. A dialog box will appear which lists all the available supplemental 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 Supplemental 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 supplemental data analysis tools can be found in Real Statistics Supplemental Data Analysis Tools.

Uninstalling the Real Statistics Resource Pack

  1. Open Excel
  2. Press Alt-TI
  3. Uncheck the Realstats option on the dialog box that appears and click the OK button

33 Responses to Real Statistics Resource Pack for older versions of Excel

  1. Janet says:

    Stunning product – thank you. But I keep getting a data-input error that I am not entering a valid range of data. I have 60+ points in a row and would like to run some statistics on them. I highlight all and see what looks to be a valid entry…but as soon as I click ‘okay’ I get an error message. Am using the 2003 version. Tried it for a QQ plot, for example. What am I missing here?

    • Charles says:

      Janet,
      I’m not sure what the problem is. Are you getting the same error if you place the 60+ points in a column?
      You can do this by copying the range and then use the Paste Transpose option.
      Charkes

  2. Tony says:

    Hi Charles,

    Thanks for your great tool. I had downloaded and installed the tool for Excel 2003. I found there was no ANCOVA or Analysis of covariance in the dialogue box. Is it due to the old version? Thank you for your help.

    Best regards,

    Tony

    • Charles says:

      Tony,
      Yes, it is due to the old version. I may issue one last release for Excel 2003 when I issue the next release of the software for Excel 2007/2010/2013/2016.
      Charles

  3. Ruggero says:

    Thanks for the tutorial and for the toolbox
    I have not already tried to use the functions but I trust that them will work
    One suggestion… Normally one do the things while he read but in this web site is mandatory to read everything before act because some important suggestions are not displayed immediately and you have to scroll at the end. an example is the suggested folder for the installation.

    • Charles says:

      Ruggero,
      I agree that this is a problem. Do you have any suggestions as to how to make this easier from the reader?
      Charles

  4. veve sladka says:

    Hi Charles.
    I have installed Real Statistics following instructions into Excel 2007 and I want to use it on Example 1, but there is “Compile error hidden module: AnovaAnalysis” error. What should I do?
    Thanks.

    • Charles says:

      What do you see when you enter the formula =VER() in any cell in an Excel worksheet? Which data analysis tool or formula are you using when you get this error message?
      Charles

      • veve sladka says:

        I see “3.8.1 Excel 2007”. I have downloaded correct version (RealStats-2007.xlam). I am using Three factor Anova, but it appeared also in every other analysis I tried.
        Veve

        • Charles says:

          I don’t know what is causing the problem. I am not seeing this problem on my version of Excel. I suggest that you try to install the Excel 2003 version of the software and see whether you get the same error. I have not tested the Real Statistics software with all the various languages that Excel is written in and sometimes this causes a problem (if for example you are running a Slovakian version of Excel)
          Charles

          • veve sladka says:

            Ok, I understand because I have Slovakian version. Thank you very much.
            Veve

          • Charles says:

            I am not sure that the problem is that you have a Slovakian version of Excel. The Real Statistics software seems to work fine with many languages (English, French, German, Italian, etc.), but it is possible that some problem is related to language. In any case, I suggest that you try to see if a different version of the software works on your computer (the Excel 2003 version or even the Mac version).
            Charles

  5. Fridtjof Lund-Johansen says:

    Dear Charles,

    THANK YOU!!!!! I love it. I wish every application was this simple. You made my month!

  6. Daniel says:

    Hi Dr. Charles Zaiontz,
    I found your add-ins much helpful as my supplier use not much Minitab but Excel2003. I read through the software agreement before downloading the add-ins, it looks there is no restriction to application in biz.
    Just want to say thank you,

    • Charles says:

      Daniel,

      You can use the software as part of your business activities (consulting, teaching, etc.), but you can’t sell the software or distribute it without permission. You can recommend that someone use the software, but they would have to download it from my site. You can provide a link to my site for this purpose if you like.

      You also can’t include or embed the software in some other product that you sell or distribute.

      Charles

      • Daniel says:

        Charles,
        Sure, i forwarded the links to them and ask them to read the agreement before downloading as well. Again, thank you very much

      • Daniel says:

        Hi Charles,
        A problem we encoutered is, when user B open an excel file in which user A embeded a function containing your “CONFIDENCE_T”, the entire function looks much longer, in fact the entire address was there. If we edit the cell and press enter then excel prompt to locate Realstats.xlam. It only continue to work if we delete the address. Is this because of versions of Realstats (note, user B used 2010 addins and provided the xls file he edited to user A who use 2003), or just because of different location/address of the Realstats in the disk? I attach in the bottom the function which user B saw.
        Thanks in advance,

        “=AVERAGE(D8:D57)-‘C:\Users\320004736\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’!CONFIDENCE_T(0.05,D60,COUNT(D8:D57))”

        • Charles says:

          Daniel,
          This is normal. When user B sees the version of the function created by A he also sees the complete file address of user’s B’s version of the Real Statistics add-in.
          It is quite simple to fix this. When user B opens the Excel file containing the new function for the first time, he/she will be prompted with a message such as “This workbook contains links to other data sources” (namely the file where user A stores his/her version of the Real Statistics add-in). User B then needs to tell Excel where to find his/her version of the Real Statistics add-in. This is done as explained in http://www.real-statistics.com/free-download/examples-installation/.
          Charles

  7. Herve says:

    Hello Charles

    I met the same problem than Shäfer and John by using Mozilla firefox.
    In fact it is a problem of browser.
    I used Chrome and no problem to download the file.

    Herve

  8. John says:

    Hi Charles,
    I am getting the same problem. I click on the link higher up on this page (below the ‘Download’ sub-title) to start the download and I get a browser screen full of the same characters Dirk saw.

    • Charles says:

      John,
      I am about to release a new version of the Real Statistics Resource Pack for older versions of Excel. Let’s see whether the problem goes away.
      Charles

    • Charles says:

      John,
      Which version of Excel are you using? Earlier today I released a new version of the Real Statistics Resource Pack for Excel 2002 and Excel 2003. Do you still see this problem when using the new version of the software?
      Charles

    • Charles says:

      John,
      Herve has made the following suggestion which may be helpful to you.
      Charles

      Hello Charles

      I met the same problem than Shäfer and John by using Mozilla firefox.
      In fact it is a problem of browser.
      I used Chrome and no problem to download the file.

      Herve

  9. Schäfer says:

    Hi Charles,

    thank’s for your reply in at once – I didn’t expect such prompt reply ;-);
    meanwhile I read several of your topics and explanations on statitsics: they excellent! and, as you mentioned in the very beginning: you stay in the environment of EXCEL and see what is going on; I’m fascinated! Explaining statistical analysis to colaborators (also using EXCEL) becomes so much easier… Thank you so much for your efforts!
    but concerning your query:
    immediatly upon clicking the link “… clicking here on Real Statistics Resource Pack 97/2003 to…” a new window opens and this ‘stange creen display’ play opens;
    Do you have an tip?
    Thank’s
    Dirk

    • Charles says:

      Dirk,

      The important thing is to follow the Installation instructions on the referenced page after you have downloaded the file. Once you have done this I don’t know why you would receive such a strange screen display. Not too many people are using the Real Statistics Resource Pack with Excel 97/2003 and so I don’t know if anyone else is having a similar problem, although no one else has said that they are having this problem.

      If possible it would be good to try to install the Real Statistics Resource Pack on a newer version of Excel and see if you have the same problem.

      Charles

    • Charles says:

      Dirk,
      Yesterday I released a new version of the Real Statistics Resource Pack for Excel 2002 and Excel 2003. Do you still see this problem when using the new version of the software? Are you using one of these versions of Excel? Perhaps the problem appears with an older version of Excel than Excel 2002.
      Charles

    • Charles says:

      Dirk,
      Herve made the following comment which can perhaps be helpful to you.
      Charles

      Hello Charles

      I met the same problem than Shäfer and John by using Mozilla firefox.
      In fact it is a problem of browser.
      I used Chrome and no problem to download the file.

      Herve

  10. Schäfer says:

    Hi Charles,
    I am using EXCEL 2003 SP3;
    unfortunately I could not download the package by the link “Real Statistics Resource Pack 97/2003” or “Real Statistics Resource Pack for older versions”;
    instead the following superfluous screen apears (excerpt see below):
    please could you give me some advice?

    best regards
    Dirk

    ÐÏࡱá����������������>��þÿ ������������ ���¾���������´�����þÿÿÿ����é��€���ã���d��ì��f��«��$��%��&�����O��Ç����ñ��p��q��~��æ�� ��û ��ì��ò��ä��w
    ��ü��â��æ�� ����“��»��ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ����€���4�����-��€btnOKput˜��Ô���Click here to perform this data analysis tool�����|�å ����€���8�����€S��€refInputÀ

    • Charles says:

      Hi Dirk,
      I just downloaded the software myself without any problems. Are you getting the strange screen display while the software file is downloading? Or are you getting the screen when you try to use the software?
      Charles

    • MD Moore says:

      Hello All,

      I received the same characters when I tried the link for the 2003 .xla file while using Mozilla Firefox as my browser. When I switched to Internet Explorer I received a popup window that did allow me to save the file rather than open it in the browser.

      My suggestion to anyone who gets the .xla file to open in their browser rather than a download dialoge box would be to try a different browser like IE.

      Hope this helps.

  11. Magdi Ragheb says:

    A good useful tool specially for teaching and manipulating data in intermediate and secondary schools. Thanks a lot.

Leave a Reply

Your email address will not be published. Required fields are marked *