**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:

- 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 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**

- 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.

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

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.

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

Installationinstructions 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 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

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 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 http://www.real-statistics.com/free-download/examples-installation/.

Charles

got it, have a nice day

Dear Charles,

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

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

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,

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

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

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

Thanks very much for this and all your wonderful work on this site.

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

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

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

In Office 2010, it asks for a password while installing.

Best wishes!

Ivan,

You don’t need to supply a password. See http://www.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

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