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 a file with the 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:
- 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.
- Open Excel, but don’t try to open the realstats-2003.xla or realstats-2002.xla file that you downloaded earlier.
- From the Tools menu choose Add-Ins (alternatively you can press Alt-TI).
- Check the Realstats option on the dialog box that appears and click the OK button.
- 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.
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 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 Data Analysis Tools.
Uninstalling the Real Statistics Resource Pack
- Open Excel
- Press Alt-TI
- Uncheck the Realstats option on the dialog box that appears and click the OK button
- Close Excel and delete the file that contains the Real Statistics Resource Pack.
What bit should i opt. 32bit or 64. Compile Error in hidden module is appearing. Please advice
Fahad,
What do you see when you enter the formula =VER() in any cell?
What data analysis tool are you usingwhen you get the compile error message?
Charles
Hello,
I cannot seem to get past the security error: Microsoft has block macros from running because the source of this file is untrusted, disable macros.
I have adjusted trust center options. Any other suggestions?
Thanks,
Daniel O.
Hello Daniel,
The only approach I am familiar with is the one described in the Troubleshooting section on the following webpage
https://www.real-statistics.com/free-download/real-statistics-resource-pack/
This seems to work for others.
Charles
do you some functions for graphs used for proficienty testing in a materials lab?
Particularly those required for homogeneity study as per International Harmonized protocol
Sanjay,
I am not familiar with the International Harmonized Protocol, and so am unable to answer your question.
Charles
In Office 2010, it asks for a password while installing.
Best wishes!
Ivan,
You don’t need to supply a password. See https://real-statistics.com/appendix/faqs/password-prompt/
Also please download the Office 2010 version of the software rather than the version for Excel 2002 or 2003.
Charles
Thank You for program. (2003 SP3). I look how it may be used in VBA.
Is it correct that ONLY by putting the computed matrix to the scheet and getting results into a VBA array also from the sheet?
I have tried
P = Application.WorksheetFunction.eVECTORS(Range(“A9:C11”))
but it does not work with this syntaxis, while “eVECTORS” is shown for thece cells in the sheet.
Ivan,
See the following webpage for how to call Real Statistics functions from VBA:
Calls from VBA
Charles
Hi Charles, Thank you very much. I get an error message: ‘Compile error in hidden module: misc’. Best wishes, Chris
This is most unusual. Usually the =VER() formula will work even when other features don’t. Perhaps you need to install the latest patches for Excel 2003. Alternatively, try using the Excel 2002 version of the Real Statistics software.
Charles
Hi Charles, Thanks for the message. I’ve upgraded my Office, and Realstats is working like a dream. It’s a splendid package! Kind regards, Chris
Good to hear.
Charles
Please can you help? I’m using Excel 2003. Installing RealStats-2003, Ifind the package in my ‘Add-ins’ list, but can’t access is using ctrl-m, and it doesn’t appear in the Tools menu. Pressing ctrl-m gives me an ‘automation error’ message. thank you very much.
What do you see when you enter the following formula in a spreadsheet?
=VER()
Charles
Thanks very much for this and all your wonderful work on this site.
Sir, I tried downloading the real stats for my excel 2013, but it is saying “not compatible”. How can you help me, please?
Kenny,
For your browser the Real Statistics file that you are trying to download is a file, just like any other. getting a “not compatible” message seems very strange, but this is generated by your browser or Windows and shouldn’t be related to Real Statistics.
If you are getting this message during the installation process, then please provide more details so that I can understand better the situation.
Charles
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?
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
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
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
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.
Ruggero,
I agree that this is a problem. Do you have any suggestions as to how to make this easier from the reader?
Charles
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.
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
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
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
Ok, I understand because I have Slovakian version. Thank you very much.
Veve
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
Dear Charles,
THANK YOU!!!!! I love it. I wish every application was this simple. You made my month!
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,
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
Charles,
Sure, i forwarded the links to them and ask them to read the agreement before downloading as well. Again, thank you very much
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))”
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 https://real-statistics.com/free-download/examples-installation/.
Charles
got it, have a nice day
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
Hello Herve,
Thanks very much for this observation. I hope this helps Shäfer and John and others.
Charles
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.
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
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
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
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
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
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
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
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À
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
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.