Free Download

Click on one of the icons below for a free download of any 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.

Free Download Resource Pack

Real Statistics Examples Workbooks: 14 Excel workbooks can be downloaded for free. These contain worksheets that implement the various tests and analyses described in the rest of this website. 

Free Download Examples Workbook

Quick Access Toolbar (QAT): One way to access the Real Statistics data analysis tools is via the QAT. To accomplish this you need to download a file named RS_QAT.xlsm. Click here to download this file and obtain instructions on how to access the data analysis tools via the QAT.

385 thoughts on “Free Download”

  1. Good morning, I would have a question. When trying to add the realstats-2007 file, a dialog box shows as follows: Excel has encountered a serious problem with realstats-2007. If the message appears many times, disable this add-on and check whether an update is available. Do you want to disable this add-on? I would like to point out that I am using 2007 Microsoft Office, to which it is dedicated. At the same time, system throws out the Solver file from add-ons. Do you have any recommendations what to do in this case? Thank you for your help in advance. Kind regards, Greg.

    Reply

  2. Dear Charles

    I was able to use RealStats to do a MANOVA. Thank you so much. But now when I start Excel it crashes due I think to some problem with the Solver add-in. I never use the Solver add-in other than when I use RealStats. The issue only occurs when Solver and RealStats are enabled on start up of Excel, and dissapears when only RealStats is checked, so I can just check the Solver checkbox when I want to use Realstats and uncheck it afterwards, or just let Excel crash once since the next time I start up Excel, Solver is unchecked. But I report this issue just in case you or anyone else wants to know.

    As usual I am using Japanese Excel (2013) and Solver is called “ソルバー” in two byte Japanese characters, which may well have something to do with it.

    Thanks again!

    Tim

    Reply

    • Dear Timothy,
      This is the first time that I have heard of this problem.
      I changed the name of the Real Statistics file from Realstats.xlam to XRealstats.xlam so that it would load after Solver. I wonder if this is still happening in the Japanese version.
      Charles

      Reply

  3. JÁ INSTALEI O SUPLEMENTO, MAS NÃO CONSIGO FAZER ELE FUNCIONAR, APARECER AS FUNÇÕES NA PLANILHA. ESTOU INSTALANDO NO MAC. VI QUE TBM TEM QUE COLOCAR EM OUTRO LOCAL A EXTENSÃO (DENTRO DE UMA PASTA), MAS TBM NÃO ACHEI ISSO

    Reply

    • Hello Luciana,
      You can place the file containing the Real Statistics add-in almost anywhere. You don’t need to put it in the recommended place.
      What do you see when you place the formula =VER() in any cell?
      Charles

      Reply

  5. Hi Charles,
    I am a Chinese supply chain manager and am very interested in your time series prediction templates and formulas. Can you download the learning and simulation exercises? Please reply. Thank you!

    Reply

  6. Hi Charles,

    I’m on a course which uses your plug-in but I can’t get it to work. Microsoft is disabling for security reasons. I get a message that the file Xrealstats.xlam is untrusted. Any idea how to fix this please?

    Reply

  8. Hello Charles,

    I keep receiving the following error message when trying to open the add-on “This file type is not supported in Protected View.” Please advise me on what I need to do to open the information.

    Reply

  11. Charles, I just deployed this to some student workstations & is it normal to see a pop up for visual basic that says can’t find project or library and a pop up that says project locked – project is unviewable. After saying OK to these pop ups – it seems to work OK but i wanted to ask if something is functionally wrong if you see these pop ups at first login to excel after adding the resource pack add in. Thanks for assistance / advice / expertise.

    Reply

    • Hello Devon,
      I don’t know why this message popped up. The software should work in any case. The “project locked” message just means that the code can’t be changed, which you probably don’t need to do in any case.
      Charles

      Reply

  14. I recently downloaded real statistics and it is a very powerful tool. However, when I use any of the package’s functions, I don’t get the “suggestions” pointing out the function’s arguments. I would like to know of there’s a way to enable this. As a beginner it makes learning the order of arguments a bit easier.

    Reply

  15. Hello Charles, This is a great tool. Thanks a lot. I am looking to use moderation analysis however I am unable to find it under the Reg Tab. Was it removed or renamed to something else? Thank you!

    Regards,
    Hemal

    Reply

    • Hello Hemal,
      Glad that you like the software.
      I see it on the Reg tab on my computer. I am using the latest release, Rel 8.4.
      What release of the Real Statistics software are you using? You can find this out by entering the formula =VER() in any cell.
      Charles

      Reply

  16. Hello Dr. Charles,
    I hope you are doing great. I downloaded and used your RealStats from 2017. It works perfectly. However, I tried to add it to two new PCs, but I couldn’t add it because of the error. I don’t know if the file is not compatible with new Microsoft office version. I hope you can help. By the way, for my previous usage, the file had a conflict with Solver sometimes. I don’t know how to fix it.
    Thank you so much for your supports

    Reply

  17. Dear Dr. Charles,
    Thank you for your develop Real Statistics. We have download and use it well, but we can’t use the OUTLIERS. The output dialogue showed the error named “misc”, we have checked our version of EXCEL and it goes well.
    Pleas help us to check it.

    We are looking forward your reply.
    Thank you very much.

    Reply

    • Hello April,
      I just tried it on my computer and it seems to be working fine.
      If you email me an Excel file with your data and explain the formula (or data analysis tool settings), I will try to figure out why you are getting an error.
      Charles

      Reply

  18. HOLA ESTOY DESCARGE Y AL PARECER FUNCIONA PERO AL MOMENTO DE INGRESAR MIS VARIABLES EN LA OPCION MULTIVAR- FACTOR ANALYSIS-EXTRACT-COMPONENTES PRINCIPALES.
    APARECE UN ERROR QUE DICE QUE NO COINCIDEN LOS TIPOS VOLVI A TRATAR LAS VARIBLES Y CAMBIA LA NOMENCLATURA DE LOS DATOS PERO SIGUE APARECIENDO, MI DUDA Y ESPERO ME PUEDAS AYUDAR ES COMO SOLUCIONAR ESTO.

    TRATE DE DESCARGAR LA VERCION DE 64 BTS TRATANDO DE MANEJARLO COMO UN ERROR DE COMPATIBILIDAD EN LA DESCARGA DE WINDOWS 2016 PERO NO PUEDO ENCONTRAR DONDE LO PUEDO DESCARGAR

    Reply

  19. Hello,
    some 35 years ago I started working with Statistica. It was a fine program. Since I was retired 12 years ago I have been trying to make my own programs for time series analysis, mainly in VBA for Excel but the development of the statistical know how is going much faster then my abillity to make my (working!) programs so I am happy to find the Real Statistic Resource Software Pack and I am going to download it. At least my recent hobby helps me to understand what it is all about. I should have got this knowledge 45 years ago!
    Matija

    Reply

  21. Cuando introduzco mis valores (enteros o decimales) en Imput range me sale el siguiente enunciado “Outlier Multiplier Factor must be a number between 1.0 and 6.0 or blank (default 2.2)” y no me permite calcular lo deseado, que hago? Mi excel es 2019 Windows

    Reply

  22. I successfully loaded the XRealStats add-in. However, when I put in G2:G2168 for Input Range (ARIMA Model and Forecast), I get:

    Invalid input range selected

    G2:G2168 is the data range with time-series data (cyclical, seasonal .. )
    Same error message with Seasonal ARIMA (SARIMA).

    Why? How can I input my data range in column G?

    Reply

  23. Hello, thank you very much for sharing this resource. I downloaded it without problems, but unfortunately the KAPPA DE FLEISS does not appear as a formula. Why will it be?
    Greetings from Chile
    Christina

    Reply

  24. Hola, muchas gracias por compartir este recurso. Lo descargué sin problemas, pero lamentablemente no me aparece el KAPPA DE FLEISS como formula. Porqué sera?
    Saludos desde Chile
    Cristina

    Reply

  25. First thank you for the clear explanation of k-means clustering. I don’t know if this has been addressed in the comments already. I did encounter an issue with a VBA code I wrote. If I start with the same initial Clustering I get exactly the answer you have on your example. But when I start with a different initial clustering then sometimes I get the same answer as your example sometimes a different answer which clusters a couple of data points to a different cluster, these are outliers points so it kind of makes sense that they cloud if the centroid are slightly different.
    I use the RANDARRAY Excel function the assign the initial cluster. I did 11 trials with trial 0 have the initial clustering from the example. The values I get for the ten other trials are (1.25,
    3.00) & (4.00, 1.67 ) 3 times (example values); (1.67, 2.33 )&(4.75, 2.00) 6 times; (1.40, 2.60)& (4.40, 1.80) 1 time. Any insights to why? (I haven’t tried with your file)

    Reply

    • Hello Angel,
      Without seeing your code, I can’t say for sure what is happening, but it is quite likely that you will get different clusterings if the initial cluster assignments change. If you use the Real Statistics data analysis tool, then you should pick the version that has the smallest value in the Error field of the output.
      Charles

      Reply

Leave a Comment