Click on an icon below for a free download of either of the following files.

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

**Real Statistics Examples Workbooks**: two Excel workbooks can be downloaded for free, which contain worksheets that implement the various tests and analyses described in the rest of this website. One file covers univariate tests and the other multivariate tests

**Real Statistics Analysis using Excel book**: Shortly you will be able to purchase two books which contain the same information that you find in the website. One will cover univariate statistics and the other multivariate statistics.

I have downloaded the resource pack, but it won’t let me add it in as an add-in. It keeps saying RealStats.xlam is not a valid add-in. Any ideas? I am running Office 2003 so perhaps that is the problem?

Roger,

The Real Statistics Resource Pack add-in should operate correctly with Excel 2007, 2010 and 2013. I have not tested it with Excel versions before Excel 2007. In particular the file extension of the add-in that is supplied is .xlam. The file extension for Excel 2003 add-ins is .xla. In the next couple of days I will try to to save the Real Statistics Resource Pack add-in in the older .xla format. If so I will put this version on the website for downloading. I would appreciate it if you would then tell me if this version works on your computer.

Charles

Update(29 Aug 2013). You can now download the Excel 97/2003 version of the Real Statistics Resource Pack from webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/. Please let me know whether it works on your computer.This looks like a very good thing for me who still runs Excel 2003. I would like to try this out, but where on the page is the link to the .XLA file?

Cheers

Robert

Robert,

I am trying to get an .XLA version running now. I hope to have this available later this week.

Charles

Robert,

I added the .XLA version of the software earlier this month. Have you been able to download it? Is it working properly?

Charles

Charles, I downloaded the package, but when I went to customize my ribbon, I could not find the macro.

John,

Unfortunately this is a common problem. I don’t have a solution yet. For now simply press

Ctrl-mto access the Real Statistics data analysis tools. This works fine.Charles

Hi Charles,

This is a wonderful add-on and am enjoying using it for teaching postgrads online . Have a window that keeps asking for a password though. Can’t seem to get rid of it…

/steve

Hi Steve,

Pleased to read that you are using the software to teach postgraduate students.

I don’t know why you would receive a window requesting the password. The only reason I can think of for this happening is if you try to open the add-in. In that case you would certainly receive a request for the password. As you have seen you can use the software without needing a password.

In any case it is not great to keep being badgered for a password. Perhaps I can figure out how to get rid of the request. Which version of Excel are you using? Can you send me a screen capture of the window that asks for the password (using the PrntSrn key or Window’s Snipping Tool)?

Charles

Dear Charles:

I downloaded the last version of the Pack, ver 2.6, but the Ver() function output is still 2.5. Any comments?

Best regards,

Jorge

Hi Charles,

I downloaded the last version of the Pack, but when I loaded it into Excel 2013, and used it via Ctrl+M, I met with a popup window that keeps asking for a password too.

Jianguo

Hi Jianguo,

It is not sufficient to download the software. You also need to install the software. You do not need a password to do this. Please follow the following steps:

To install the software select

Office Button > Excel Options > Add-Insin Excel 2007 orFile > Help|Options > Add-Insin Excel 2010/2013, it is important that you look for theGobutton at the bottom of the window. You need to click on this button.Once you do this you should be presented with a dialog box as described in the instructions. If you have already put the Real Statistics Resource Pack file in the appropriate add-in directory you should see its name on the list shown, in which case you need to make sure that the file is checked. If not, you will need to search for it by pressing the

Browsebutton on the dialog box.Please let me know if this doesn’t work for you.

Charles

Hi Charles,

I have downloaded and installed the software follwing the steps as you told me, and I can open the function window via Ctrl+M to analysis my data. But, when I close the function window, a popup window that keeps asking for a password still appeared in the screen, and I can only close it after clicking the mouse twenty times. I don’t know why.

Jianguo

I need to have EXCEL SOFTWARE BECAUSE THE ONE IN COMPUTER DOES ONLY FOR LINEAR MODEL.I NEED REAL STATISTICS RESOURCES.

THANKS.

LINUS

Linus,

Were you able to download the Real Statistics Resource Pack?

Charles

Hi Charles,

Just wanted to thank you for this add-in, its a major help!

Hi Charles,

It seems you had created a wonderful add-in application, unfortunately I am not able to use it.

I had installed the add-in as per instruction in my Excel 2013, but not able to see the Realstata add-in in the ADD-IN ribbon. So my question is where to find the Realstats add-in after installation to use it?

Please suggest.

CK

Hi,

Once the Add-in dialog box is displayed (e.g. by pressing Alt-TI) if realstats is not displayed, click on the Browse button and select the file containing the software that you downloaded from the website. You should now see realstats on the Add-in dialog box. Check the box to the left of realstats and you should be in business. Let me know if this works.

Charles

Hi Charles,

Actually I had already installed the application successfully and it’s displayed in the Add-in dialogue box.. Options–>Add-in–> Active Application Add-in–> Realstats. Till here installation is completed.

Now my problem is where to find that add-in to solve the calculation? I am not able to see the Realstats under Add-in ribbon on the spreadsheet.

Thank you!

CK

Hi,

To access the data analysis tools just press Ctrl-m. To access the supplemental functions just type them into the worksheets just like a regular Excel function. A list of the data analysis tools can be found at http://www.real-statistics.com/excel-capabilities/supplemental-data-analysis-tools/. A list of the functions can be found at http://www.real-statistics.com/excel-capabilities/supplemental-functions/.

Charles

WOW.. Now I can use it…Thanks you very much…

Hopely I will get the result of Fleiss Kappa

Haewon,

Just use the formula KAPPA.

Charles

Can I use your Real Statistics Using Excel with Excel for Mac on my Mac Pro?

Tony,

There is a version of the Real Statistics Resource Pack designed for the Mac. You can download it for free at http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/. It has been tested with Excel 2011 for the Mac.

Charles

Sir

I have installed Realstats on my computer- excel add in as step wise.

But I can’t add it on Excel worksheet just like other tool pack -Data -analysis, Solver In.

Anybody plz help me

Cheers

bishnu

Vishnu,

The easiest way to access the data analysis tools is to press Ctrl-m.

The following webpage explain how to get access to the data analysis tools from a ribbon/menu, but this approach doesn’t seem to work for most people. I still need to fix it.

http://www.real-statistics.com/excel-capabilities/supplemental-data-analysis-tools/accessing-supplemental-data-analysis-tools/

Charles

Been continuously asked about RealStat password. Help!

I have OS Win8

Cathrine,

You don’t need to supply a password. This request usually means that you are trying to open the file containing the Real Statistics Resource Pack. You shouldn’t do this.

What you need to do is

installthe file, i.e. make sure that Excel recognizes the file as an add-in containing software. To do this follow the Installation instructions on the webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/.Charles

Pingback: Release 2.17 of the Real Statistics Resource Pack | Real Statistics Using Excel

Pingback: Rel 3.0 Real Statistics Add-in | Real Statistics Using Excel

Dear Charles,

I have successfully downloaded the software, and the functions appear in excel, they don’t seem to work. Can you help me with this problem?

Sincerely,

David Fuzes

David,

Can you give me some examples of functions that don’t work? Please provide the name of the function and the arguments used. Do some functions work and other don’t? What happens when you use the function =VER()

Charles

Thanks for making it available for our use. it is very useful and simple.

Many thanks for this software help! Definitely comes in handy with my position!!

Currently working on my BA, first time doing empirical research and it’s a real help using your website. However, I downloaded your Real Statistics Resource Pack but keep running into error messages. I installed it and can open the console via Strg + m. However, if I try to actually active the formulas (e.g. the correlation matrix) I always receive an error saying (roughly, it’s in German):

2Compiler error in the module: frmMatrix

This error generally occurs if code is not compatible with the used version, platform or architecture.”

I’m using Office 365 Home, if that matters. Any idea what might be the issue?

Jakob,

I don’t know what is causing this problem. I know that some other people have experienced similiar problems, but the software seems to run fine for most people.

Do use see the version number when you enter =VER() in any cell in a worksheet? (if not the installation was not performed correctly) Are you by any chance running the 64 bit version of Excel? (select File > Help to find out) Are you able to get the software working on some other computer?

Charles

The =VER() command works, showing me Version 3.5.2. I’m using the 32bit Excel, so that can’t be it. I don’t have another machine available currently to test your last question.

Sorry, there’s no option to edit a post: I’m also being asked (sometimes) to enter a password and if I activate/deactivate the AddIn I receive an error message saying something like:

Microsoft Visual Basic for Applications

“Project or library not found.”

Jakob,

You should never need to enter a password. Since the formula =VER() works properly I am very surprised to see that you are getting a message to enter a password.

I have just put a new version of the software online (Release 3.6). I suggest that you delete the software from your computer and install the latest version. Let’s see whether this eliminates the problem.

Charles

Use the above email address! The first given had a misprint!

Hi Bernhard,

The fact that you are seeing some tables for non-parametric tests indicates that the download was successful. You now need to inform Excel that the download is what is called an “add-in” file. You do this by following the Installation instructions on page http://www.real-statistics.com/free-download/real-statistics-resource-pack/. Please let me know if you have any troubles performing the three steps indicated.

Charles