Real Statistics Resource Pack

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 use with Excel 2010, 2013 or 2016 (Windows). If you are using Excel 2007 click here. If you are using Excel 2003 or a prior version of Excel click here. If you are using Excel for the Macintosh click here.

Keep in mind that there are also two versions of Excel, at least for Excel 2010, 2013 or 2016, the 32 bit version and the 64 bit version. Most people use the 32 bit version. The Real Statistics Resource Pack is known to works only with the 32 bit version.

Download

Real Statistics Resource Pack for Excel 2010, 2013 or 2016

If you accept the License Agreement, click here on Real Statistics Resource Pack for Excel 2010/2013/2016 to download the latest Excel 2010/2013/2016 version of the resource pack that accompanies this website (Release 4.11). This software is compatible with Excel 2010, 2013 and 2016 and is named RealStats.xlam. After downloading the software make sure that you install the software as described below.

Free Download Resource Pack

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

Real Statistics Resource Pack for Excel 2002, 2003, 2007 or 2011 (Mac)

If you are using Excel 2007, click here for instructions on how to download and install the Real Statistics Resource Pack.

If you are using Excel 2003 or a prior version of Excel, click here for instructions on how to download and install the Real Statistics Resource Pack.

If you are using a Macintosh version of Excel, click here for instructions on how to download and install a beta version of the Real Statistics Resource Pack.

Installation

Before trying to install the Real Statistics Resource Pack make sure that Excel’s Solver capability is installed on your computer. Check this as follows:

  1. Open up a blank Excel spreadsheet
  2. Press Alt-TI (i.e. hold down the Alt key and press the T and I keys).
  3. On the dialog box that appears make sure that the Solver addin is checked. If not, check it and click on the OK button.
  4. If the Solver addin was not checked you need to close the Excel file before proceeding to the next step.

Once you have downloaded the Resource Pack and made sure that Solver is installed, you need to install the Real Statistics Real Pack 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.xlam file that you downloaded earlier.
  3. Select File > Help|Options > Add-Ins and click on the Go button at the bottom of the window (see Figure 1). Alternatively you can simple press Alt-TI (i.e. hold the Alt key down and simultaneously press T followed by I) and the dialog box shown in Figure 2 will appear.

    Add-in dialog box

    Figure 1 – Add-ins dialog box 1

  4. Check the Realstats option on the dialog box that appears (see Figure 2) and click the OK button.
  5. If this option doesn’t appear, click on Browse to find and choose the realstats.xlam file. Then complete step 4 as described above.
Add-in selection

Figure 2 – Add-ins dialog box 2

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:\Users\user-name\AppData\Roaming\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. E.g., in Window 7 you can do this by opening the Control Panel, clicking Appearance and Personalization, and then clicking Folder Options and then clicking the View tab. Now in the Advanced settings, click Show hidden files, folders, and drives, and then click OK.

Installation of Upgrades

Once you have installed the Real Statistics Resource Pack as described above, to install a new version of the software you don’t need to repeat these steps. You only need to delete the previous version of the resource pack and put the new version of the software in the same location as the previous version.

Real Statistics Functions

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

Real Statistics Data Analysis Tools

You can access the Real Statistics data analysis tools in one of the following ways, as described in Accessing Real Statistics Data Analysis Tools:

  • By pressing Ctrl-m or
  • By clicking on an icon on the Add-Ins ribbon or
  • By clicking on an icon on the Quick Access Toolbar or
  • Via the Macro dialog box

A dialog box will now appear which lists all the available Real Statistics 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 Real Statistics 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.

406 Responses to Real Statistics Resource Pack

  1. Thomas C says:

    I love the idea of this, however I am only able to find the TRIMMEAN function through typing a normal excel string. Any ideas of why the other functions are not available?

    TIA

    • Charles says:

      Thomas,
      TRIMMEAN is a standard Excel function and so you will find it by typing a normal Excel string. You should also be able to do this with any of the Real Statistics functions provided you are using a version of Excel after Excel 2007. For Excel 2007, the functions are there and so you can use them, but they won’t appear as you type them.
      Charles

  2. Elizabeth Figueroa says:

    There is a window that is asking me for RealStats password. There is a password?

  3. ram s. says:

    Dear Charles
    i am facing this problem while opening the realstat.
    “compile error in hidden module: descriptor regression”
    please suggest

    • Charles says:

      When you press Alt-TI do you see RealStats and Solver on the list of add-ins with check marks next to them?
      What do you see when you enter =VER() into any cell?
      Charles

      • ram s. says:

        I SEE THIS; 4.11 Excel 2010/2013/2016
        WHEN TYPE =VER()

        • Charles says:

          When you press Alt-TI do you see RealStats and Solver on the list of add-ins with check marks next to them?

          • ram s. says:

            Yes, I checked the option it is marked. When I go to Add-In ribbon and click Real Statistics than a dialog box open and shows “compile error in hidden module: descriptor regression”.
            please suggest

          • Charles says:

            I understand from your response that when you press Alt-TI you see both RealStats and Solver in the list of add-ins with check marks next to both of them.
            Do you get the same compile error message when you press Ctrl-m ?
            What version of Excel are you using?
            Is the language English?
            Charles

  4. Ed says:

    Hi Charles,

    I just downloaded the Real Statistics Resource Pack (Release 4.11). I have Windows and a 32-bit version of Excel. Unfortunately, I keep getting the notice “Compile error in hidden module: logistic regression”. Do you have any suggestions on how to fix this?

    Thank you in advance!

    • Charles says:

      Ed,
      Is Excel’s Solver installed? To check, press Alt-TI and see whether Solver and RealStats are on the list with check marks next to them.
      Charles

  5. Scott says:

    Will this be made available for the 64 Bit version of Excel 2013?

    • Charles says:

      Scott,
      This is a potential future enhancement.
      Charles

      • Scott says:

        Thanks Charles.

        These functions look incredibly useful so it would be good to be able to use this on a 64bit version of Excel.

        I am running it on an old computer at the moment, but will check periodically to see if this is added as my 64 bit machine is much faster!

        Thanks for this.

        Scott

      • Matthijs Berends says:

        Dear Charles,

        I would really like a 64-bit version too, as I don’t have a 32-bit version. I’m a VBA-coder myself, and always use a snippet like this as declaration (it allows IFs and THENs, don’t remove the #):
        #If VBA7 And Win64 Then
        Public Declare PtrSafe Function MessageBeep Lib “user32” (ByVal wType As Long) As Long
        #Else
        Public Declare Function MessageBeep Lib “user32” (ByVal wType As Long) As Long
        #End If

        I hope you’ll implement this. You website is incredibly useful for a PhD-student like me (microbiological epidemiology).

        Greetings from The Netherlands,

        Matthijs Berends

        • Charles says:

          Matthijs,
          I would be happy to provide a 64 bit version, but don’t know how to do it and am unclear how much work is involved. If all I need to do is replace every function declaration as you described, then perhaps I could do it,but I have a feeling that there is a lot more work involved.
          Charles

  6. Michy says:

    Thank you so much, Charles for sharing this tips. Your tips really help me a lot for my assignment. I need a data analysis tool to help me analyse data for my assignment, however, it is very troublesome to download the SPSS or Eviews. I’ve struggling with my assignment for few days. Fortunately, i saw your website and your tips.
    Thank you Thank You 😀

  7. Jonathan says:

    I installed the add-in and the functions show up. However, I only get results in one cell. For example, descstats() only produces one result which a cell with the text “count” and nothing else in adjacent cells. The same thing happens with other functions.

  8. Jorge Camacho S says:

    Dear Dr Zaiontz

    I install the last version (4.11) and it works fine, but when I close the excel workbook and open a new one, the real statistics add in did not appear on addin menu. I tried again opening the workbook as administrator, and the addin did not appear on menu.

  9. Andrea Ferrigno says:

    Dear Dr Zaiontz,

    Time ago I found a book entitled “Statistics for terrified biologists” by Elmut van Emden. Since I am a biologist and I was terrified, I starded to read it. My terror was amplified by that book and I made no progress.

    I was hopeless when I found your web site, and it was like finding a treasure! It’s not only the software, that’s simple and useful, it’s the rest of your website too, “an incredible wast of time”, if you think like a big company manager. “That’s academic mentality at its best, this Dr. Zaiontz must be a professor, and he must be very passionate about his work”, I thought. Imagine my surprise when I googled you. A manager! LOL. It’s incredibly generous, all this time didecated to share your knowledge and help others. Thank you.

    That was years ago. In the meantime I started “loving” statistics and learned to use R, as I needed some analysis not covered by your software (linear mixed models for repeated measures), but I kept suggesting your website to my terrified biology students, until now: we updated our lab PCs and they have all the 64-bit Excel version!
    Don’t you have in mind a 64-bit compatible version of your add-in?
    If you don’t, I’m going to take back the old PCs from the garbage!
    Con sincero affetto,
    Andrea

    • Charles says:

      Andrea,

      I am very gratified by your very kind comments. It is nice to hear that my website is like finding a treasure.
      Yes, I was a manager, but I have been a teacher as well.
      I am updating the website and software all the time, and hope to add some of the capabilities that you find useful from R.

      I don’t have any immediate plans to release a 64-bit Excel compatible version of the software since I haven’t yet received too many requests for it.

      Charles

  10. Juan Carlos Palacios Cívico says:

    Hi,

    Thanks a lot for this great post. I have followed all the steps that are described above, however in one of these steps I am asked to provide a RealStats Password but I don’t know how can I get a valid password.

    Could you please help me?
    Thanks

    • Charles says:

      Juan Carlos,

      First of all, you never need to provide a password to use the software. You should also never try to open the file containing the Real Statistics addin that you downloaded from the website.

      To avoid the password message, I suggest that you do the following:

      1. Open a new Excel spreadsheet (don’t try to open the Real Statistics file)
      2. Press the Alt-TI key combination.
      3. Make sure that you find Solver on the list of Excel addins and make sure that there is a check mark next to the Solver entry.
      4. Quit Excel
      5. Open a new Excel spreadsheet
      6. Press the Alt-TI key combination again
      7. Click on the Browse button and find the file where you have stored the Real Statistics addin and then click the OK button.
      8. This should bring up the list of Excel addins again. Make sure that RealStats appears on this list with a check mark next to it.
      9. Press the OK button.

      Charles

  11. Amy says:

    Charles,
    Thanks for this resource. It has been quite useful. I have been running a binary logistic regression at work. Everything has been fine except when I close and reopen the file, the “Add-ins” tab disappears and I have to redownload a new version. Now it is not letting me run it at all. It keeps coming up with an error message saying the error commonly occurs when the code is incompatible with the version, platform or architecture. But nothing has changed since the last time I ran it. Any ideas?

    Thanks!

    • Charles says:

      Amy,
      Have you read the blog on what to do about Real Statistics disappearing from the Addins ribbon? See Blogs.
      This may help. If not, please tell me which version of Excel you are using and what is the output from the =VER() function?
      Charles

  12. Adrian says:

    Hi Charles,

    First I want to thank you for the shared material.

    I wish to install the package and pressing “ALT + T + I” I do not get any results. Surely it is because I have the version in Spanish and that combination does not apply. Could you guide me to do?

    Regards

    Adrian (from Argentine)

    • Charles says:

      Hi Adrian,
      As described on the referenced webpage, you can do the following instead:
      Select File > Help|Options > Add-Ins and click on the Go button at the bottom of the window (see Figure 1 from referenced webpage).
      Charles

  13. C. Olsen says:

    Hi,

    Thank you for a great tool.
    how do I reference the Real statistics resource pack in a scientific article?

  14. Mohamed says:

    Dear Charles,

    Thank you very much for this new release 4.9. it is fantastic.
    Do you plan to translate in fine this huge work in French ?

    Mohamed

  15. Ram says:

    Hi Charles,

    Sure i am using MS excel 2013 prof plus 64bit. But instead of row 2500 x 12 column using row 250 x 12 column for five classes. it is working fine on my system.

    Ram

    • Charles says:

      Ram,
      That is great news. Thanks for telling us that Real Statistics is working with the 64 bit version of Excel.
      Charles

  16. Ram says:

    Hi,
    I am using data have row 2501 and column 13 entries having 5classes, starting from 0to 4 classes. I want to uses these data for Multinomial logistic regression analysis in one go, but while doing analysis receives error “Run-time error no 1004.. Application defined or object defined error”.

    Using win 7 64bit os,
    MS office 2013 64bit.

    Kindly suggest any solution.

    • Charles says:

      Ram,
      Are you sure that you are using a 64 bit version of Excel? I had understood that the Real Statistics software (as well as many Excel addins) doesn’t work in the 64 bit version of Excel.
      Charles

    • Charles says:

      Ram,
      If you send me an Excel file with your data I will try to figure out what is going wrong. You can find my email address at Contact Us.
      Charles

  17. Dan S says:

    Hello, I recently installed the resource pack for Excel 2010,2013 or 2016 b/c I needed to run some binary logistic regression tests for work. I have Excel 2010 and Windows 7 on my computer. When I ran the program for binary logistic regression it loads for about three minutes but then I received an error message reading “compile error in hidden module: logistic regression.” I am not sure what to do about this so I uninstalled and reinstalled the program and the same problem occurred. Please let me know if there is a solution you know of. Thanks

    • Charles says:

      Dan,
      If you send me an Excel file with your data and calculations I will try to figure out what is going on. You can find my email address at Contact Us.
      Charles

  18. Tanya Thwaite says:

    Hello Charles,

    I have downloaded the ‘Real Statistics Resource Pack for Excel 2010, 2013 or 2016’ and I am using Excel 2016 32-bit version on Windows 10. When I press Alt+T+I, I can see that solver and realstats are both ticked, yet the Add-ins tab is not showing up on the ribbon. To make it appear, I need to un-tick and then re-tick realstats, but as soon as I exit excel and then re-open, Add-in tab has gone again. Is there a solution to make the Add-in tab stay there permanently?

    Thanks,
    Tanya

  19. dnc says:

    I just wanted to say I have never read such careful, precise instructions for downloading and installing software. Thank you so much!

  20. Susan says:

    Hello:
    I have successfully downloaded the Real Statistics Pack for Excel 2016 and using a MacBook Air OSX El Capitan latest version. When I attempt to perform a logistic regression and while watching the YouTube tutorial all the features work except when I attempt to run the data. Once I press ‘ok’, screen says “compile error in hidden library module.” Do you know what is the error and how to correct it?

    Thank you.

  21. Giacomo Diaz says:

    I’m using Excel 2010 64-bit under Windows 64-bit. I installed the latest version of Real Statistics, carefully following all indications but I was unable to run Real Statistics. Invariably I got the same error message: “Invalid data in input window…”. On the other hand, I didn’t find in this site any warning about the incompatibility of Real Statistics with Excel 64 bit. Is that true?
    I had to reinstall an older version 3.1.2, which works properly.

    • Charles says:

      Giacomo,
      I have never tried to run Real Statistics with Excel 64 bit, but it is not surprising that it doesn’t since from what I understand most addins need to be tweaked to work with the 64 bit version of Excel.
      I will add a warning about this shortly.
      Charles

  22. Jose says:

    Dear Professor,

    It is possible, in any new realease to write what are the new?
    If you have time to this.

    Thanks for this great addin.
    Jose

  23. safiya says:

    hello
    am having a trouble in downloading the software. Each time I check the solver ad in excel, the excel stops working and asking me to disable the option.

    Regards,
    Safiya

    • Charles says:

      Safiya,
      Solver is a standard Excel capability. I don’t know why you would receive such an error message when you check the Solver addin. This should have nothing do with using or not using the real Statistics addin. Just to be sure I suggest that you make sure that the Real Statistics addin in not checked. Then close Excel and restart it. Then check the Solver addin, close Excel and restart it. Finally, find and check RealStats (as described on the webpage from where you downloaded the Real Statistics Resource Pack).
      Charles

  24. Tom says:

    RealStats.xlam won’t load when I check the add-in box. I get the error:

    Microsoft Excel cannot access the file ‘C:\Users\username\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’. There are several possible reasons:

    *the file name or path does not exist.
    *the file is being used by another program.
    *the workbook you are trying to save has the same name as a currently open workbook.

    Please help.

    • Charles says:

      You need to specify the path where you actually placed the Real Statistics file. It is unlikely you placed the file at the path that you specified above. Perhaps you placed the file at C:\Users\tom\AppData\Roaming\Microsoft\AddIns\RealStats.xlam
      Charles

      • thomas meier says:

        Thanks for replying so quickly!

        The actual path is:
        C:\Users\a1c0czz\AppData\Roaming\Microsoft\AddIns\RealStats.xlam

        a1c0czz is my corporate username. I don’t know why but I put username as a place holder.

        I can see the add-in on the add-ins list and when I select Go I can see RealStats and check box but when I check the box, it gives me the error above.

        Could it be a company IT security policy that is preventing me from adding Add-Ins?

        Thanks for your help.

        Regards,

        Tom

        • Charles says:

          Tom,
          Is Solver also checked. It is important that this is checked as well.
          I can’t comment about whether the problem could be related to your company’s IT policy.
          Charles

    • Jess says:

      i have the same problem with you, you must re-download real statistics and replace the old with the new 😀 *seriously

  25. Shannon says:

    Hi all – I have been using the RealStats add-in for months and over the past week, am now getting an error when I run Jenks Natural Breaks that reads:

    Compile error in hidden module: Cluster.

    Has anyone else experienced this and if so, how did you resolve? Thanks.

    • Charles says:

      Shannon,
      If you send me an Excel file with your data, I will try to figure out why you are getting this error message. You can send the file to the email address shown at Contact Us.
      Charles

  26. Johnny says:

    Hi, I installed the package in Excel 2013 64bits but the time series option don’t appear after a Ctrl-m. After Regression appears Reliability. You know way?

    Thanks

    • Charles says:

      Hi Johnny,
      That is strange. Are you using the latest release, Rel 4.8? You can check this, by entering the formula =VER(). When you do, you should see “4.8…”
      If you don’t see this, then I suggest that you reinstall the Real Statistics Resource Pack.
      Charles

    • Charles says:

      Johnny,
      One other thing. Are you sure that you are running the 64 bit version of Excel 2103 and not the 64 bit version of Windows?
      Charles

  27. Muizz says:

    hi,

    im using excel 2013, is it possible to run this add in on excell 2013?
    because i always get error notification “can’t find project or library” and always asking for password.
    do you have any solution?

    • Charles says:

      Muizz,
      Yes, I use the addin in Excel 2013 all the time and you don’t need a password. The important thing is that you must install the addin as described on the webpage from which you downloaded the addin.
      Charles

    • Den says:

      Yes, I ran into the same problem Muizz. I did the following to resolve this issue, which I think Charles alludes to lower in the comments section.
      You should activate the Solver Add-in and Analysis ToolPak before you attempt to activate the the RealStats add-in.

  28. Joos says:

    Hi,
    I succeeded in installing everything, but now my solver is bugging. When I press alt-TI, the Solver is not checked. When I check it, Excel gives an error and shuts down. Is there a way to solve this?
    Joos

  29. Daniel Norden says:

    Hej Charles,

    Super helpful application you have built. However I have an issue, can you tell me why when I try to use a binary logistic regression and I have marked the data area then when I try to click OK it keeps saying “Alpha must be a number between 0 and .5” even thought I haven’t touched the alpha field. Afterwards when I try to change the 0.05 number in the alpha window the message reappears. I have the english version installed however I am from Denmark so I do not know if this is the problem.

    Yours sincerely

    Daniel

    Can you help me

    • Charles says:

      Daniel,
      The problem is probably related to use of a comma vs. a period to represent decimals. I suggest that you fill in the field with 0,05
      If this doesn’t work, then fill in the field with 0.05 (even if this is what was originally in the field, for some reason you may need to manually write the value instead of using the default).
      Charles

      • Daniel Norden says:

        Hey Charles,

        I have tried this solution it just keeps saying Alpha must be between 0 and 0.5. I cannot even write 0, which should not cause a problem on either the English og the American version. I will try an change my Excel to American and se if it makes a difference.

        /Daniel

  30. Caio Guzzo says:

    Hi, Charles. Yesterday I made a question to you, but today I have another one.
    In Agronomic Fields, imagine we have this situation: I have made a Trial with randomized blocks, then I made an analysis between blocks and noticed that there was no difference between them. So, could I analyze this Experiment as a completely randomized one?
    I am saying this because, as you know, when I do not use Block design I increase the Degrees of Freedom of the Residuals, and, many times I can see higher differences between the treatments.
    Now, talking about the randomization, I have this doubt because I do not know if the probability of sorting plots in block and the plots being homogeny distributed would be the same of sorting these same plots in a completely randomized way.
    I appreciate your time and patience again, and thank you so much.

    • Charles says:

      Caio,
      Which tool are you using to perform the analysis?
      If you send me an Excel file with your data and analyses, I will try to figure out what is going on.
      I plan to add some additional support for randomized complete block design and split-plot design to the next release of the software.
      Charles

  31. Quynh Trang says:

    Thanks very much for a very useful pack.

  32. Rob Firmin says:

    Sorry. Because the Excel Data Analysis Regression option places the Y range first and you place X first, I relied on habit to input in the same order. The inversion on the dialog box made me cause the error!

  33. Rob Firmin says:

    Excel 13.
    Solver activated.
    Multiple regression error message: Input Y must have exactly one column.
    But this is multiple regression, so of course I have multiple columns of Y. The error message makes no sense to me–what am I doing incorrectly?
    Do I need to Solver.xlam?
    Thank you.

  34. Manoj says:

    I have been using Real statistics tool for over 10 days now, Until today I haven’t faced any issues with the tool and it worked like a gem, recently I am facing issues when I am trying to run, I am given an error pop up stating the code is incompatible with the data, version, or architechture

    • Charles says:

      A possible reason for this is that Excel’s Solver needs to be installed before you install the Real Statistics Resource Pack.
      To check to see if Solver has been installed, press Alt-TI and see if it appears on the list of addins with a check mark next to it.
      Which version of Excel are you using? Which data analysis tool produced the error?
      Charles

      • Manoj says:

        I was using logistic regression and I am using Excel 2016,
        Solver was installed before Real Statistics Resource Pack, I tried with another system, this time excel 2013, I started getting the same compiler error after 4 or 5 operations.

  35. Jay says:

    Ah, I realized what I was doing wrong. Apologies for taking up a post.

    Thanks!

  36. Jay says:

    Thank you so much for sharing your add-ins! Unfortunately, after downloading the resources pack, I do not see the binary regression in the list. It jumps from “Correlation (one-sample)” to “Regression”. Is there something I am doing wrong?

  37. Luana Camila Nardez says:

    Hello,
    I installed it and when I try to use any formula it shows an error message, saying that the code of the plataform is incompatible with this app.
    Do you know what should I do?

    • Charles says:

      Luana Camilla,
      The usual reason for this is that the addin wasn’t installed properly. These instructions are listed on the the referenced webpage. In particular, you need to make sure that Excel’s Solver is installed before you try to install Real Statistics Resource Pack.
      To check to see which addins are installed press Alt-TI and see which have a check mark next to them.
      Charles

  38. Prosper Lutala says:

    This software will assist in pieces of research analysis

  39. Will Goebel says:

    Hi Charles,

    I’ve downloaded the Resource Pack and completed the installation instructions. I now see the Real Statistics option when I click Add-Ins on my toolbar, but if I type the first few letters of a supplementary function into a cell, it does not suggest the function as it does with standard Excel functions. Are you aware of any installation scenario that results in the appearance of the Real Statistics option in the Add-Ins ribbon but does not enable the supplementary functions? If so, any insight on how I can approach this issue?

    Thanks so much!

    • Charles says:

      Will,
      Unfortunately, Excel does not support this capability for non-Excel defined functions. Instead, you need to type the equal symbol followed by the name of the function and then press Alt-a to get similar information. In any case, the functions are enabled and can be used in Excel. E.g., try using =VER()
      Charles

  40. Alex says:

    Hi Charles

    Thank you for offering this convenient software.

    It is really useful for my regression analysis.

    By the way, whenever I try to install real-stat in my computer, it deosn’t work and “compile error : we can’t find the project or library” is coming up. How can I solve this problem? my excel version is 2013. so I downloaded real-stat for 2013

    • Charles says:

      Alex,
      The usual reason for receiving this message is that the software has been downloaded but not installed properly. When you press Alt-TI in Excel do you see RealStats on the list of Excel addins? If not then, you have not installed the software (see instructions on the webpage from which you downloaded the Real Statistics file).
      Assuming that you have installed the software properly, what you see when you use the formula =VER()?
      Charles

  41. Shreya says:

    R1 2573 R 2= 15955

    n1=32 n2=16032 160

    u1=3075 u2=2045

    ALPHA=0.05

    Please tell if values are significant or not? Cant read the z table.

  42. Piero says:

    Dear Charles,
    I am using Excel 2013 64bit version and I wish to upgrade from Real Statistics resource pack ver 3.8 (that always worked fine with this Excel version) to version 4.7.
    So I simply replaced the .xlam file in the C:\Users\user-name\AppData\Roaming\Microsoft\AddIns directory.

    But now Excel crashes when I try to start it.
    I found that to avoid Excel to crash with the new .xlam file, I need to disable in Excel the Solver Add-In. In fact, if I disable it, Excel works, but, for instance, trying to use some functions like FISHERTEST I have the error: “Compile error in hidden module: Fisher”.
    I never get this kind of error with 3.8 version.

    Thank you for your help

    Best Regards
    Piero

    • Charles says:

      Dear Piero,
      The software definitely works with a 64 bit version of Windows, but it probably doesn’t work with a 64 bit version of Excel.
      In any case, to get the Real Statistics Resource to work, you must first make sure that the Solver add-in is enabled. Only then can you install the Real Statistics add-in (as described on the webpage from which you downloaded the add-in).
      Charles

      • Piero says:

        Dear Charles,

        this is exactly what I did. But while everything works fine with Real Statistics version 3.8, my Excel 2013 crashes if I try to use the version 4.7 with the Solver add-in enabled.
        Just to be sure, my Solver add-is the file solver.xlam
        C:\Program Files\Microsoft Office 15\root\office15\Library\SOLVER directory
        23/03/2015, so maybe there could be a problem with this particular Solver release.

        Thank you again for your support.
        Best Regards
        Piero

        • Charles says:

          Dear Piero,
          I can’t think of any reason why Excel would crash if you are using version 4.7. Regarding Solver, the important thing is that when you press Alt-TI you find that Solver is checked. It may also matter that Solver is installed before the Real Statistics add-in. I assume that you don’t have two versions of Real Statistics active at the same time (i.e. RealStats 3.8 and RealStats 4.7 are not both checked in the list of add-ins). The only thing I can think of is that you remove all versions of Real Statistics and reinstall version 4.7.
          Charles

          • Piero says:

            Dear Charles,
            I followed carefully your instructions, that is, I performed what is called a “clean install”, and now finally also version 4.7 works!

            So thank you again for your help

            Best Regards
            Piero

          • Charles says:

            Piero,
            That is good to hear. I am glad that I could be of help.
            Charles

      • Lynette Connelly says:

        HELP Charles,
        I have to run a two-sample t-test comparing batting averages with MLB, AL vs NL top 50 players. How do I determine which test to use? Paired two sample for means, assuming equal variances or unequal? I am confused. Thanks for any help.

        • Charles says:

          Lynette,

          If you want to compare the batting averages for players in the AL vs NL, then the two sample t test seems like a good choice.
          If the variances for each sample are more or less equal, then you can use the equal variances version of the t test; otherwise the unequal variances version. If you are not sure, then I suggest that you use the unequal variances version since the results will be similar even if the variances are equal.

          You do need to make sure that the assumptions for the t test are met. See the following webpage for more details
          t distribution

          Charles

  43. Lucas Lund says:

    Hello Charles,

    I have been trying to use the binary Logistic Regression to predict whether a loan will be defaulted based on past data of different characteristics.
    The data was downloaded from a lending website. When running the regression excel gives an error (#VALUES) for all our coefficients. Any idea why this is happening? I will be happy to send you the data if you need more information.

    Please save me.

    • Charles says:

      Hello Lucas,
      Most likely this means that the model doesn’t converge to a solution. This means that the logistic regression model is not a good fit for your data.
      Just to be sure, I suggest that you use the Solver option to see if it too doesn’t converge to a solution.
      You can send me your data and I will check if this is the problem.
      Charles

      • Amit Kumar Gupta says:

        I am getting a same error (#VALUE!), however when I ran logistics regression with same data on R studio, I am getting the coefficients.

        Please help.

        • Charles says:

          Amit,
          If you send me an Excel file with your data, I will try to figure out what is going on.
          Charles

  44. Peng Wang says:

    Thanks a lot for sharing the great sources!

    I have problems running it on my microsoft 2013. The message says that it is not compatible with 64-bit software. I’ll try a different computer.

    • Charles says:

      Peng,
      The software definitely works with a 64 bit version of Windows, but it probably doesn’t work with a 64 bit version of Excel.
      Charles

  45. Tom Lutzow says:

    My Excel version (2010) has not been able to load the Real Statistics add-on. The message says that my version does not recognize the .xlsm tag.

    • Charles says:

      Tom,

      This is strange on two counts:
      1. The file you downloaded is not an .xlsm file
      2. Excel 2010 does recognize .xlsm files

      You may be getting this messaging because you are trying to open (or in some way modify) the file containing the Real Statistics Resource Pack. You should not try to open this file or modify it. You need to follow the installation instructions on the referenced webpage.

      Charles

      • Tom Lutzow says:

        Hi Charles,
        I now downloaded that file as an .xlam (add-in) file and was able to connect, but I don’t see “logistic regression” as a option on the list.
        Tom

        • Tom Lutzow says:

          Hi Again,
          I see now that it’s a subset of “regression” and then listed as “multinomial logistic regression”.
          Tom

          • Tom Lutzow says:

            Yet Again,
            I can reach the function through “Ctrl M” but cannot reach the function through the ribbon at the right of the top bar. Any reason?

          • Charles says:

            Tom,
            Are you referring to the Add-Ins ribbon?
            Charles

  46. Fel says:

    Hello,
    Is there a 64-bit option available for the real statistics add-in?
    Thanks.

  47. Andrew Chatham says:

    Hi Charles- Thanks for making this available, much appreciated. Not sure if you’ve gotten this question before, but I’m comparing regression results of a multiple linear regression vs a weighted linear regression. I’m using the same exact data for both regressions. On my simple multiple linear regression I’m producing an R^2 of 0.86 vs when I assign exponentially decreasing weights for my weighted linear regression, the R^2 jumps to .997.

    This seems to be coming from the way the Regression Sum of Squares and Total Sum of Squares is being calculated in the weighted regression , resulting in an extremely small Residual Sum of Squares. The Total SS formula in your normal regression output is DEVSQ(Dependent Variable Series) vs the formula being used in the weighted linear regression is SUMPRODUCT(Dependent Variable Series^2,Weights). I’m having trouble seeing how assigning exponentially decreasing weights all of a sudden makes the model as a whole that much better. Just curious if you had any ideas.

    • Charles says:

      Andrew,
      I do see the pattern that you are speaking about, but I haven’t thought much about the reason for this happening.
      Charles

      • Andrew Chatham says:

        Thanks Charles, looking more into it, I think part of this is stemming from the formula for the Total Sum of Squares in the weighted regression. Why is the formula just the sum product of the dependent variable ^2 and the weights? Don’t we also need to include the deviations from the mean somewhere in that formula? I’d think it’d be the sum of each deviation from the mean multiplied by each individual weight.

        • Andrew Chatham says:

          And to go further on this I think I found the exact formulas to use for the Regression Sum of Squares and Total Sum of Squares so you get to R^2 that make sense on the weighted regression.

          For instance, as a simple example imagine you have your dependent variable in cells A3:A5, your independent variable is in cells B3:B5, and your weights are in cells C3:C5. The intercept and beta coefficient were output in cells B45:B46.

          I believe for the Regression Sum of Squares formula it should be:
          SUMPRODUCT(C3:C5,(MMULT(DESIGN(B3:B5),B45:B46)-AVERAGE(A3:A5))^2)

          Currently your formula is SUMPRODUCT(C3:C5,MMULT(DESIGN(B3:B5),B45:B46)^2), essentially yours is missing the deviation from the mean of the dependent variable.

          Similarly for the Total Sum of Squares formula I believe the formula should be:
          SUMPRODUCT(((A3:A5)-AVERAGE(A3:A5))^2,C3:C5)

          Your formula is currently:
          =SUMPRODUCT(A3:A5^2,C3:C5)
          Again missing the portion where you take the deviation from the mean.

          Would love to hear your thoughts on this.

          Thanks,
          Andrew

  48. sam says:

    Can you explain how to generate : Gamma, Tau-b and tau-c (and other measures of association) using this add-in for mac?

    Other software generates this information for non-parametric tests, such as chi-squared tests. Real-Stats seems to only generate cramers-v stat in these tests.

    Thanks!

    • Charles says:

      The software supports many different types of measures of association, including Kendall’s rank correlation coefficient tau-a and tau-b (KCORREL), Pearson’s correlation (CORREL) and Spearman’s correlation (SCORREL). Also see Correlation data analysis tool.
      Charles

  49. Rodrigo says:

    Dear Charles,

    I’d like your advise to solve a problem with the “Jenks Natural Breaks”. When I use it in a small data matrix (10×10), the results are fine but when I try to do the same with a 588×588 matrix, the results shows only the message #VALUE! (I am using Excel 2010 and all my data is numeric…). What should I do?

    P.S.: Thank you very much for making this add-in available for us.

    Best Regards,

    Rodrigo.

    • Charles says:

      Rodrigo,
      A 588 x 588 matrix has 345,744 cells. I believe that my current implementation is limited to a little over 65,000 cells.
      If you send me an Excel file with your data, I will try to figure out how to handle the larger size input.
      You can find my email address at Contact Us.
      Charles

  50. Pingback: Some Assembly Required » Blog Archive » Support page for GDC16 “TLDR statistics”

  51. Saket says:

    Dear Charles
    I installed realstat for eVectors ans eigenvalues but it returns only one value for whole matrix. Moreover, both the values are same. Please advise the guideline.
    Saket

    • Charles says:

      Dear Saket,

      I would need to see your data to comment. If you send me an Excel file with your data I will try to figure out what is going on. Click on Contact Us for my email address.

      Note that eVECTORS is an array function and so you need to highlight a range of cells and press Ctrl-Shift-Enter to get all the values. See Array Functions and Values to get more information about how you use array functions.

      Charles

  52. Al says:

    Charles,

    Thank you for coding this resource pack. It is tremendously helpful.

    I upgraded to Office 2016 and to the latest release of Real Statistics (prior to now, I had been using the one released in November 2015). I have been getting a lot of messages that begin with “Compile error in hidden module: …” (where … can be AnovaAnalysis, frmAnova2post, etc). How can I fix this?

    • Charles says:

      Al,
      Are you using the latest release, i.e. Rel 4.6, which I issued on May 11? You can check this by entering the formula =VER() in any cell.
      If so, one possible problem is that you need to make sure that Excel’s Solver is installed. You do this by pressing Alt-TI and making sure that there is a check mark next to Solver.
      Charles

      • Matthew says:

        I’m having this same problem. Everything downloaded/installed correctly, shows up in the add-ins list, using the 4.6, and the Solver is checked as well. Still getting “compile error in hidden module: Analysis” (specifically when I tried to run a t-test, not sure about other functions). On a new Mac Pro, using excel 2016. Any suggestions greatly appreciated! Thanks!
        Matt

  53. Rahul says:

    Dear Charles
    Thanks a lot for making the resources available for everyone to use.
    I have a very simple 4 sample model . I need to estimate the coefficient. My data is as follows
    x y
    1 1
    2 1
    3 0
    1 1
    y is the mode choice and x is the travel time for a simple logit with utility of form V= beta*time. I ran the LogitCoeff but I get no values. All I see is #VALUE on the output. Can you advise?
    Thanks for your time

    • Charles says:

      Rahul,
      The model doesn’t converge to a solution. This is not so unusual with such a limited amount of data. Note, however, that if you replace the last y value by 0 you will get a solution.
      Charles

  54. Abdel-Razzak says:

    Dear Charles

    I tried to install the Real Statistics Source. Download, then copy it and save in the suggested directory : C:\Users\user-name\AppData\Roaming\Microsoft\AddIns.

    When I tried to install as explained; it gives the message : “Can’t Find Project or Library” ;
    then when I click on OK; I had the Username question message,
    then whent I click on CANCEL for the Username question , the message disappear but the Add-In appears at the EXCELL panel.

    then when I tried to use some of the Add-In functions; it gives me the measssage ” “Compile Error in Hidden Module : “Name of teh function”.

    Can you help?

    Thank you

    • Charles says:

      I am not sure what the problem that you are encountering is, but if you are using Excel 2007, then another user (Cyberpreneur) suggests that you install the software in the following directory instead: /Microsoft Office/Office12/Library/Analysis.

      If you are having problems with both approaches, then I suggest that you delete any previous version of the software and start over by putting the software anywhere you like.

      Charles

      • Yuriy M says:

        First of all thanks Charles for outstanding library, really impressive fit.

        Then, I had both “can’t find project or library”, password, and “compilation error in hidden module” errors. These are related to missing Service Pack.

        I updated to Service Pack 3, by downloading from microsoft website and installing, and the add-in works without problems.

        Hope this helps downloaders.

        • Charles says:

          Yuriy,
          Thanks very much for sharing this with me. I will pass it on to anyone who has these sorts of problems in the future.
          Charles

  55. Greg says:

    This is a great package, and nicely put together. Quick question: is this addon approved by microsoft and/or validated for use by the FDA?

    • Charles says:

      Thanks Greg. The addon has not been approved by Microsoft nor have I tried to get approval from Microsoft. I assume that you are joking about the FDA.
      Charles

  56. Matt says:

    Hi Charles!
    I have Excel 2013. I have installed the ‘RealStats.xlam’ add-in as described; however, Excel doesn’t recognize any of the functions. The program is saved in:
    C:\Users\mconverse85\AppData\Roaming\Microsoft\AddIns\RealStats.xlam
    Excel shows that ‘RealStats’ is an “Active Application Add-in” referencing the same location as above
    I have tried the following functions
    =LEVENE(N5:P11) where N5:P11 is my data formatted as ‘General’
    =MEAN(N5:P11)
    =VER()
    These functions even show up as options when I start typing them into the cell, but they always return a “#NAME?” (excel error: The formula contains unrecognized text)
    Any advice?

    • Charles says:

      Matt,
      When you press Alt-TI do you see the add-in RealStats in the list with a check mark next to it? If not then the add-in was not installed correctly.
      Charles

  57. Lihua says:

    Hello, I have download the file (RealStats.xlam). But every time I try to open it and click “enable Macros”, there always be an ‘ unexpected error’. I don’t know what’s wrong with my computer.

    Lihua

    • Charles says:

      Hello Lihua,
      You should not try to open the file that you downloaded.
      Instead you need to install it as described on the referenced webpage and then open a new Excel file (not the one you downloaded). The installation process tells the new Excel file where to look for the software in the downloaded file.
      Charles

  58. Joe Horwath says:

    Am trying to down load the real-statistics-resource-pack using my Apple iPad – am trying to upload it to Drop box – whereas the file RealStats.xlam shows up on Dropbox – (2.1 Mb) its not working with Excel – does not show up under the Add-on Icon – as the file may be empty / pls. Suggest a way to permit operating Real-Statistics on the Apple iPad . Thx Charles

    • Charles says:

      Joe,
      Real Statistics requires VBA, but I don’t believe that the iPAD version of Excel supports VBA, and so you probably can’t use the software on your iPAD. You can use it on a Mac or Windows computer.
      Charles

  59. Dejan says:

    Hello Charles,
    I’ve installed the Real statistics Excel add-ins for Excel 2010 in order to perform cluster analysis (k- means).
    Unfortunately this option was not on the list.
    Please advise how do I add this calculation too.

    Regards

  60. Anna says:

    Hi Charles,
    My Real Statistics add-in keeps disappearing from my Excel program (in Office 2016 for Windows 10). I tried re-downloading it, which worked once, but today I’ve tried re-downloading and reinstalling it several times and failed. What happens is that it doesn’t seem to show up in the Add-ins options in the menu. What should I do about this?
    Many thanks, love the program.

    • Charles says:

      Anna,

      Glad you like the program.

      It sounds like the Real Statistics doesn’t disappear, only that access to the program via the Add-in ribbon disappears. I’m not sure why this is happening, but something similar happened with Excel 2013. The following blog explained what to do in this case.

      http://www.real-statistics.com/disappearing-add-ins-ribbon/

      Remember you can always access the Real Statistics data analysis tools by pressing Ctrl-m (even if access disappears from the Add-In ribbon).

      Charles

  61. Jules Gilbert says:

    Hello Charles,

    Yes, this binomial stuff has all kinds of applications. And thank you!, for contributing your time and effort to write this.

    I intend to download your Excel materials, I assume conversion to C isn’t difficult.

    If it’s not confidential could you post a few remarks about what you do and why you published this material.

  62. Quiet says:

    dear

    it was successfully installed and run well, but after i close the excel 2013, a pop up “password” appear, how to solve this issue, i knew it’s a free software

    • Charles says:

      To try to figure out what is happening, please answer the following questions:
      1. What do you see when you enter the formula =VER() in any spreadsheet cell?
      2. When you press Alt-TI do you see RealStats on the list with a check mark next to it? If not the program was not installed corrected and you need to click on the Browse button to locate where you stored the file you downloaded containing the Real Statistics software.
      Charles

      • Mike M says:

        I am having the same issue. After closing Excel 2013 it is prompting me for a password. I checked the version (4.4.2) and the program is clicked with a check mark when I check Alt-TI.

        • Charles says:

          Mike,
          Are you prompted for a password when you open an empty Excel file?
          Charles

          • Mike M says:

            Not when I open it. But I closed all excel files and the prompt is still there even after I close all the files and when I reopen them. I can still use Excel with the prompt in the background…I just can’t get rid of the prompt. And of course I’ve tried the obvious password combinations “password” “realstats” “1234” “0000” nothing has worked.

      • Michelle Araújo says:

        Charles,

        When I tried to install the same pop up “password” appear. When I enter the formula =VER() in anyspreadsheet cell, I see 4.6 EXCEL 2007.

        • Charles says:

          Michelle,
          The latest version of the software uses Solver. You might be getting this message because you have not activated Excel’s Solver capability. My suggestion is to check whether the Solver tab appears on the right side of the Data ribbon in Excel. If not, then press Alt-TI and make sure that Solver is checked in the dialog box that appears. Once you have done this, close Excel and reopen it. Hopefully the password message no longer appears.
          Charles

  63. Christian S says:

    I have followed your instructions several times as have tried older versions of the file but always receive the same

    Can’t find project or library

    message. I am using a new mac and excel 2016.

    Regards

    Chris

    • Charles says:

      Christian,

      I have not tested the Real Statistics software as yet with Excel 2016 for the Mac. I have read that there are lots of problems with VBA (which is required for Real Statistics) for Excel 2016 with the Mac, but I don’t know whether these are impacting the Real Statistics software.

      Can anyone else comment on this?

      Charles

  64. Chi says:

    Hi, Charles!

    I can’t seem to find cluster analysis, NOR multivariate analysis in the choices. I’m using Excel for Mac.

    Thanks!

  65. Freda Kate D. Samuel says:

    Thanks Sir Charles for this wonderful software. I am a student currently taking up MA Applied Statistics here in the Philippines and I am really interested in learning the tools. Hope I could ask later regarding several topics. Currently I am trying to learn multiple regression and correlation using matrices but we have to do it manually. I might as well use the software just to countercheck my answers. Thanks again and God speed.

  66. Silom Jamulitrat says:

    I installed RealStats.xlam to Microsoft Excel 2016. After finish the final step, there was a massage window “Microsoft Visual Basic for Applications” saying “Permission denied” and “Automation error” ” Unspecified error”
    How to correct this error

    Silom

    • Charles says:

      Others have told me that the software works without problems with Excel 2016. Most of the time when someone gets this type of error message it means that the software was downloaded but not installed properly (so that Excel recognizes the software as an add-in). If you press Alt-TI when in Excel and don’t see RealsStats on the list with a check mark next to it, then the software wasn’t installed properly. Another problem is that the user tries to open the RealStats.xlam file; you don’t need to open this file nor should you try to.
      Charles

  67. Brian says:

    I installed RealStats, but I don’t see cluster analysis as an option? Did I miss something?
    Thanks,
    Brian

  68. Andre Forte says:

    Hello Charles,

    I have been using your wonderful tool and I appreciate it very much, thank you. I have noticed that you regularly update the toolpack as the version number keeps increasing. Do you have some sort of tracking of what changes from one version to the next?

    Thanks again,

    Andre

  69. Germain Pozo says:

    Buenas Tardes, mi nombre es Germain Pozo, Supervisor de Soporte IT, en la Universidad Adolfo Ibáñez en Santiago de Chile, les escribo puesto que nos han solicitado instalar la aplicación para uso académico en uno de nuestros laboratorios, y necesitamos puedan ayudarnos a saber si esta solicitud puede llevarse a cabo sin problemas de licenciamiento.

    Atento a sus comentarios, saludos cordiales,


    Germain Pozo
    Supervisor de Soporte IT
    Encargado de Adquisiciones Hardware y Software IT
    Gerencia de Tecnologías de Información
    Universidad Adolfo Ibáñez
    Mesa de Servicio: mesadeservicio@uai.cl
    Email: gpozo@uai.cl
    Teléfono: (56-2) 331 18 00 – 331 13 90
    Conócenos e Infórmate de Nuestros Servicios en: http://webti.uai.cl

    • Charles says:

      Germain,
      You need to tell me more about how you want to use the software in your labs so that I can help you determine whether what you want to do is permitted under the license agreement.
      Charles

  70. Jake says:

    Charles,

    I am looking to use the winsorize function for a large data set (100k+) and it seems it is only able to work with around 63k data points. Is there any way to get around that? I was going to look at it in the Visual Basic Editor, but it requires a password.

    Thanks,
    Jake

    • Charles says:

      Jake,

      The WINSORIZE function is restricted to about 65,500 data points. You can use ordinary Excel to create a similar outcome. Suppose that the data is contained in the range A1:A200000 and you want to winsorize based on a value p (as for the WINSORIZE formula). Follow the following steps:

      Step 1: Place the formula =INT(COUNT(A1:A200000)*p/2) in cell E1

      Step 2: Place the formula =SMALL(A1:A200000, E1) in cell D1 and =LARGE(A1:A200000, E1) in cell D2. Cells D1 and D2 will contain the lower and upper cutoff values.

      Step 3: Place the formula =IF(A1D$2,D$2,A1)) in cell B1.

      Step 4: Highlight the range B1:B200000 and press Ctrl-D. Range B1:B200000 now contains the same data as A1:A200000 except that the smallest and largest values have been replaced by the cutoff values.

      Some cautions. I haven’t tried to perform these steps myself and so I may have made an error. Also, this approach will handle ties in a way that is different from what you desire.

  71. Felix says:

    Hi there —

    Just downloaded and installed the latest version, but clustering and factor aren’t showing up in the options. Any ideas? Thanks in advance!

    Cheers
    Felix

    • Charles says:

      I don’t understand the problem. Just select the Factor Analysis or Cluster Analysis option (by clicking on the radio button) and click on the OK button. This will bring up another dialog box which you need to fill in as described in the webpage corresponding to that analysis.
      Charles

  72. Pete says:

    Hello there,

    First off, this is a very nice tool. I am having some issues with the binary logistic regression package. Specifically, I am trying to train the data on a subset then test the accuracy on the remaining data. However, as the values are exported as an array function, I don’t see how I can ascertain the unstandardized B coefficients. Any help would be appreciated.

    Pete

  73. Justin says:

    Hello – first of all, thanks for making this available on excel. Really glad to see this excel version.

    However, when i run this on my data set, i get this “Run time error 6: Overflow”. Was wondering if ther’s a the tool has a limit on the number of predictors that can be used/ the number of records for regression? The dataset i’m currently using have the following characteristics:
    – Number of records: 158623 with 467 churned records
    – Predictor: 1. Birth Year; 2. Payment menthod (4 dummy category); 3. Education (3 dummy category) = 8 predictors

    Are there any issues on this? Help much appreciated!

    Regards,
    Justin

    • Justin says:

      When i was trying to reduce the number of predictors to just education (x3)and birth year – what i get is “Run-time error 5 – Invalide procedure call or arguement”.

      Not sure if there’s any issue with my excel…

    • Charles says:

      Justin,

      If you are using multiple linear regression, then until the latest release you were limited to 64 predictors. This limit was increased in the latest release of the software, but in any case 8 predictors should not be a problem. I just ran a model with 11 predictors and over 160,000 records and it all worked fine.

      The software won’t work with when any of the data is non-numeric (except the column headings). If the “churn records” contain blanks or non-numeric values, then these have to be eliminated before running the regression. In any case, this would not result in the error message that you received.

      If you send me an Excel spreadsheet with your data I can try to figure out what has gone wrong. You can find my email address at Contact Us.

      Charles

  74. Kay Ford says:

    Charles,

    Thanks for creating this website for us. I downloaded the Excel 2013 Real Stats pack and the worksheets popped up on my computer. However, I am lost at how to save it in the app data folder that you suggested. I went ahead and saved it to my desktop. Then I went to Excel, Ad-ins, and under “Active Ad-ins” I saw my Analysis ToolPack and VBA version but not the RealStats. Please help! I am not that tech savvy.

    Thanks,
    Kay

    • Charles says:

      Kay,
      Press Alt-TI (i.e. hold the Alt key down and press the T key followed by the I key). Click on the Browse button and find where you stored the RealStats file and then click the OK button. The RealStats file will now be checked in the list of add-ins.
      Charles

  75. Carlo says:

    After installation I get about 35 times the message “Could not load some objects because they are not available on this machine.”

    I’m running Office 2013 of a Windows 7 64-bit machine.

    I’ve discovered this problem is related to previously having Office 2010 on my machine which some time ago received a flawed Security Update. In this Security Update a newer version of mscomctl.ocx (v2.1) was installed, but the reference to the old v2.0 wasn’t removed.
    After applying the fix from https://support.microsoft.com/kb/2597986
    the number of those error messages went down to 3.

    Repeating the process from the above KB manually for the file comctl32.ocx fixed those last 3 errors.

    • Charles says:

      Carlo,
      Does this mean that you are able to use the Real Statistics software now?
      Charles

      • Jennie says:

        Hi, I am using office 2010. The same error “Could not load some objects because they are not available on this machine.” is coming up and I am unable to use realstat. How do I solve this?

        • Charles says:

          Jennie,
          Have you followed the specific Installation instructions that are listed on the referenced webpage? If you enter the formula =VER() in any cell in any Excel spreadsheet, what result do you see?
          Charles

  76. Carlo says:

    For the installation location there is an easier notation. The hidden directories make it sometimes difficult to find. Instead of installing to:
    C:\Users\user-name\AppData\Roaming\Microsoft\AddIns
    try entering the following name in Explorer
    %APPDATA%\Roaming\Microsoft\AddIns

    • Charles says:

      Carlo,

      Thank you very much for suggesting this approach. This simplifies things quite a lot.

      On my computer (Windows 8.1), I get an error message if I enter %APPDATA%\Roaming\Microsoft\AddIns. But %APPDATA%\Microsoft\AddIns works perfectly.

      Charles

  77. Gagan says:

    I do not see cluster analysis option in the available selections.
    I am using office 2010

  78. Hooman says:

    Hi. Hope you`ll have a good day.
    I just wanted to thank you for your example`s and the pack you made available for download. You help`ed me a lot at my project for Statistical methods unit at the university and I referenced your site in my project because I used some of your examples in my project. I hope would not make a problem.
    Best regards
    Hooman Jafari.

    • Charles says:

      Hooman,
      I am pleased that you have found the site useful. Thanks for referencing the site in your project.
      Charles

  79. Ramasubramanian says:

    Dear Sir,

    This Add-Ins utility is a great service to the users. Thanks a lot and keep it up.
    I appreciate.

    Ram

  80. sera says:

    hello. i have installed the add-on but in the table of contents i dont see cluster analysis

    why?
    i can see all the other functions

    thanks

    • Charles says:

      First select Multivariate Analyses. Cluster Analysis will be one of the choices on the dialog box that then appears.
      Charles

  81. Orcel Mouanda says:

    Bonjour,

    j’ai téléchargé le pack real statistics avec succès, je tiens à vous en remercié pour cet outil d’analyse indispensable.

    Encore une fois mercu

  82. Rebecca says:

    Hi, I was directed to download this resource pack to be able to use the logistic regression feature. However, after downloading it and enabling the addon, I do not see the option for logistic regression? I have watched videos of people successfully using this add-in, but cannot figure out what is different that I am doing.

    Here is a screenshot of all of the options it gives me: http://puu.sh/hQ6BZ/e38b0f4897.png

    Thanks so much,
    Rebecca

    • Rebecca says:

      Nevermind, it is just under the blanket “Regression” option. Sorry for my confusion! I guess this is an updated version from the ones in the videos I have seen.

      Thanks for the add-in! If only I knew the difference between binary logistic regression and multinomial logistic regression…

      • Charles says:

        Rebecca,

        I am in the process of updating the website to explain the recent change to the software whereby the Logistic Regression data analysis tool is now under the Regression tool.

        To understand the difference between binary and multinomial logistic regression, please see the Multinomial Logistic Regression webpage.

        Charles

  83. John Lawson says:

    Thanks. The real statistics resource pack is very useful. Do you have any plans to an add in package for a public domain spreadsheet like Libre Office?

    • Charles says:

      John,
      I have no immediate plans to support Libre Office. To do so would require two things: (1) the package supports VBA and (2) there are enough people who request this support.
      Charles

  84. Pi-Sheng Deng says:

    I downloaded and successfully installed the Resource Pack for Excel 2013. My add-in also displayed Real Statistics in the group. However, when I came back to access Real Statistics the next day, I could not see it in the Add-in group. Could you please advise? Thanks a lot!

    • Charles says:

      I just found out what is probably going on. The problem is how Excel 2013 handles add-ins. I will try to address this in the next release of the software, but for now if this happens do the following:

      (1) press Alt-TI and unclick the Analysis ToolPak and click on the OK button.
      (2) Close Excel and reopen Excel (I am not sure this step is necessary).
      (3) Press Alt-TI, click the Analysis ToolPak and click on the OK button.

      Charles

  85. Hi
    I have downloaded the real stats pakage but it is asking me the password? what should i do now??

    • Charles says:

      The usual reason for this message is that you have downloaded the software but not installed it. You never need to supply a password.

      To install the software, press Alt-TI (i.e. hold the Alt key down and press the T and I keys). You will see the Add-Ins dialog box. Click on the Browse button and search for the Real Statistics software at location where you downloaded the file to. When you find it you need to click on the OK button. The Add-Ins dialog box should reappear, but this time the RealStats selection should appear in the list and should be checked (if not check it). Now click on the OK button and you are done. You should be able to use the software.

      Charles

  86. Preeti says:

    I was trying to download and install realstat resource pack for MS 2007. I followed the procedure suggested on your website. When I finished adding on the resource pack using Excel Options>Add-Ins and tried to use matrix operations, for every function it is suggesting “compile error in hidden formula module : frmMatrix”

    Please advise

    Regards
    Preeti

    • Charles says:

      Unfortunately, I don’t know what is causing this. The vast majority of people have no problems getting the software to work with Excel 2007, 2010, 2011 or 2013, but some people are running into this problem. Are you running the software in English?
      Charles

  87. andrea vironda says:

    hello charles
    do you have any version of this pack regarding openoffice calc 4.1.1?

    • Charles says:

      Andrea,
      No I don’t have a version for calc 4.4.1. You are the first person to ask about this. I understand that calc 4.4.1 has a limited VBA-like capability, but it will take some work to get the Real Statistics Resource Pack to work there.
      Charles

  88. Azfer Saeed says:

    Hi Charles,

    Thank you very much for this add-in! I installed the add-in correctly and have validated it by doing an analysis for a frequency table and I know it works because I did not get any compile errors. My question, however, is about how to launch it. You have mentioned 4 options. I was wondering if you have heard from others about not seeing the Real Statistics option in the Add-In Ribbon. I have a faulty Ctrl key so sometimes it does not work.

    Regards,
    Azfer

    • Charles says:

      Azfer,
      Actually so far no one has mentioned this problem, but I now see that Add-in Ribbon is not visible on my computer using Excel 2013 (while it is visible on another computer using Excel 2010). I’ll try to look into to this.
      Charles

      • Azfer Saeed says:

        Charles,

        Thank you very much for looking into it. You are correct about the Add-in Ribbon not being visible on Excel 2013. I apologize for not giving you details about my environment.

        Regards,
        Azfer

  89. Urvashi Bhattacharyya says:

    Dear Dr. Charles,

    This is a fantastic tool to use. Thank you so much for creating it and making it available for free.
    I have 4 groups, each with a sample size of 9. The observation in each group is a mean of populations (of different N). I will use Tukey HSD for comparison. (Hope I am right).

    I will be referencing your work on my paper. How should I refer it (e.g. “significant differences derived using Real Statistics Tool Set Add In for Excel” )?

    Thanks a ton again!

    • Charles says:

      I am very pleased to read that you appreciate the tools that I have created. You can reference the software or website as described on the webpage Citation.
      Charles

  90. J. Marcos Jurado says:

    Thank you very much

  91. grishem says:

    I can’t believe this is free. Thank you so much for sharing. I plan to use this so I can rapidly vary my input data and immediately see results in PCA output without having to go back and forth to minitab.

  92. Mohamed says:

    Dear Charles,
    Thank you for your quick reply.

    I wait with impatience for your futur enhancements about the analysis of data from designed experiments.

    Thnks for all
    Mohamed

  93. Mohamed says:

    Hi Charles !
    Congratulations for your « Real Statistics Using Excel ». I already use it in my job (agriculture research).
    I wish Your « Real Statistics Using Excel » includes also the analysis of data from designed experiments ( as cross-over, latin square, split plot, response surface designs, etc.).
    Is it possible ?
    Thanks for all
    Mohamed from Mauritania

    • Charles says:

      Mohamed,
      Thanks for your support. I already have response surface design on my list of possible future enhancements. I will add the others to the enhancement list.
      Charles

  94. Joel Dubow says:

    Well I just wrote a little while ago about difficulties getting RealStatistics to show up on the Add ins tool bar menu. Well, I have two computers, a lap top and a Desktop. Both run Windows 7 Enterprise and Office 2013 enterprise. On the laptop I was able to install RealStatistics and the two Examples workbooks, but couldn’t get the menu button to show up. The program worked through pressing ctrl-M. On the desktop the Menu item showed up immediately. Who knows? I did all the same stuff. Maybe Real Statistics suffers from claustrophobia and hides on laptops?

  95. William Agurto says:

    Charles:

    There’s a little bug in Real Statistics 3.7: when I open an Excel file (in Office 2013), after Real Statistics has been installed, Excel shows a VBA error message: “Run-time error ‘5’: Invalid procedure call or argument”. Although the problem can be solved closing the message, it’s not normal to get that one when opening an Excel file.
    I haven’t try to install the add-in in my another CPU (that has Office 2010), so I’m not sure if the problem is present in Office 2010 also. I will prove it tonight.
    The problema is not present in the prior version of Real Statistics (3.6.2).
    Please, take a look at the VBA code..

    Tnahk you.

    William Agurto.

    • William Agurto says:

      Charles:

      I confirmed that the error message is only present for Excel 2013. Real Statistics 3.7 runs OK in Excel 2010.

      Thank you.

      William Agurto

      • Charles says:

        William,
        Thanks for the update. Based on this, perhaps I should create separate versions of the software for Excel 2010 and Excel 2013.
        Charles

  96. Rajvi says:

    I have downloaded your resource pack but when i have installed it through add ins, Error message shown “Project cannot be found” and after that it requires password.Please give me the solutions.

    • Charles says:

      Rajvi,
      People who get this type of message are usually trying to open the Real Statistic Resource Pack file. You should never open this file, nor do you need to.
      If you have already installed the Real Statistics Resource Pack, then simply open a blank Excel file and use the Real Statistics functions just like any other Excel functions and access the data analysis tools by pressing Ctrl-m.
      If you have not yet installed the Real Statistics Resource Pack, then open a blank Excel file (not the file you downloaded) and follow the instructions on the referenced webpage.
      Charles

  97. David Mukungu says:

    I have downloaded the Real Statistics Resource Pack but can get it installed because the file cannot open for me to proceed with its installation. I am using Microsoft Office Excel Plus 2013. I have updated the antivirus as required for certain corrupt files but that still hasn’t helped.
    I request for some advise.
    David

    • Charles says:

      David,
      You don’t need to open the file to install it. In fact, you should not open it ever. Open Excel (or any Excel document except the the Real Statistics Resource Pack), press Alt-TI and then continue as described in the instructions on the referenced webpage.
      Charles

    • Charles says:

      David,
      You should not open the file! Follow the instruction after opening a blank Excel file.
      Charles

  98. Ben says:

    Hi,

    I have a problem with the DIAGONAL() and REVERSE() functions and performing other matrix operations.

    Say I have a list A1:A3
    I can find DIAGONAL(REVERSE(A1:A3)) and excel returns the correct 3×3 matrix

    However if I then try and multiply this by another matrix by say
    MMULT(B1:D3, DIAGONAL(REVERSE(A1:A3))) i get an #N/A error
    However if I compute the DIAGONAL(REVERSE part first then use MMULT on this it works.
    This makes the REVERSE function essentially useless in matrix operations.

    • Charles says:

      Ben,

      You are correct. I haven’t always made sure that the Real Statistics array functions can call another function or be called by another function. I developed most functions to be used standalone, although periodically I look into this issue and modify some of the functions so that they behave properly in conjunction with other functions.

      There is an additional complication with the REVERSE function. The REVERSE function not only reverses the order of the elements in a range, but it also puts those elements in an array potentially of a different shape. This causes problems.

      I’ll look into the issues again, particularly DIAGONAL which was meant to be used with other functions.

      Charles
      Charles

      • Ben says:

        ok thank you.

        I havent experienced any issues with DIAGONAL() which appears to work fine with other matrix operations. It is just REVERSE that doesn’t perform well.

        • Charles says:

          Ben,
          I have added a new function called REV to the Real Statistics Resource Pack. You should be able to use it instead of REVERSE.
          Charles

  99. Deyan says:

    Hi Charles,
    Thank you very much! The problem is solved!
    I should chanage the “.” with “,” in the boxes for cutoff and alpha but when I em in Bulgarian keyboard register.
    Again your software is great!
    Thausand thanks and very good luck!
    Deyan

    • Charles says:

      Deyan,
      Great to hear that it works. The decimal symbol tends to cause problems from one language to another.
      Charles

  100. Deyan says:

    Charles,
    I tried to repeat the example from: https://www.youtube.com/watch?v=EKRjDurXau0&feature=youtu.be
    and used popular data set from:
    https://www.kaggle.com/c/titanic-gettingStarted/data?train.csv
    whit the restrictions mentioned in the video.
    Deyan

    • Charles says:

      Deyan,

      As described on the You Tube video, you need to perform the following steps on the data before you can run Real Statistics’ Logistics Regression data analysis tool:

      1. Place Survived, the dependent variable, in the last column
      2. Transform all alphanumeric variables into numeric variables or eliminate them. You can make Sex and Embark numeric by using the approach shown on the You Tubes video or you can use the Real Statistics’ CATCODE array function. The Name, Ticket and Cabin variables are alphanumeric and should probably be eliminated.
      3. You need to do something about any missing data. The only numeric variable in the example that has missing data is the Age variable. You have some choices about what to do. The video chose to replace all missing data by the average of all the age data. Other choices are described on the webpage Handling Missing Data. You can probably use one of the simple approaches described on the webpage Traditional Approaches for Handling Missing Data.

      The person who did the video was able to use the Real Statistics tool to perform the logistic regression on the resulting data set.

      Charles

      • Deyan says:

        Charles,
        Thank you for the advice, but I actually have done this steps exactly like you describe them. I’m very familiar with missing value analysis and data preprocessing. I think that the problem comes somewhere from the communication of my Excel 2010 (specific options) and your software. I used a specific version (3.6.2.) but translated in Bulgarian. I suggest that problem comes from that specificity. From my first contact to your software till now I tried different data sets. Even I organised an online experiment yesterday and collect new data but the results are similar. All time when I have run logit regression I got this error. I got no problems with other analysis from the list (… this I’ve check) just with logit. Do you have an experience with such problems.
        Deyan

        • Charles says:

          Deyan,
          I am not seeing this error message on my computer running Excel 2010, but I am not running a Bulgarian version of Excel. Since the error message you are getting is related to a type mismatch, I would have thought that this would not be language related.
          Are you getting partial results? Perhaps you are seeing headings or some of the output when you get the error. If you can give me more information about this, perhaps I can figure out where in the software the problem occurs.
          In any case, it would be helpful if you can send me a spreadsheet with your data (after you have resolved any missing data and have done the data preprocessing). Perhaps I can duplicate the error if I have the exact data input that you are using.
          Charles

          • Deyan says:

            Hi Charles,
            I sent you my spreadsheet to czaiontz@gmail.com.
            Thanks in advace,
            Deyan

          • Charles says:

            Hi Deyan,
            I looked at the spreadsheet you sent me and I can see that the problem is in the value for alpha. The Bulgarian version of the software doesn’t like the format of the value used in the input field. If you used the default value of .05, I suggest that you re-enter it to make sure that the software recognizes it properly. I am not sure whether you need to enter it as .05 or as ,05. You should try both possibilities to see which one works.
            Charles

  101. Deyan says:

    Dear Mr. Zaionts,
    your software is fantastic. I found it when I looking for logit reg. tools with Excell. But when I run the logistic regression on Excell 10, I got an error:
    “A run time error has occured. The analysis tool will be aborted. Type mismatch”.
    Can you advise me how to solve the problem?
    Thanks in advance,
    Deyan

  102. Bismark says:

    Hi,
    it appears the Mac version of the package is not updated with Fischer test. please can it be updated for Mac users?
    thanks

    • Charles says:

      Are you referring to Fisher’s Exact Test (substitute for Chi-square test)? You should be able to use the FISHERTEST function (not data analysis tool) on the Mac.
      Charles

  103. John Rattham says:

    By any chance is there a copy of the Real Statistics Resource Pack available for Office 365?

    • Charles says:

      John,
      I understood that Office 365 operates in two modes: desktop and web. The desktop mode supports VBA and so the Real Statistics Resource Pack should work. The web mode doesn’t support VBA and so the Real Statistics software won’t work.
      If anyone else has any experience using the Real Statistics software in Office 365, please let us know.
      Charles

      • Charlotte says:

        Hello, I’m using Office 365 and it downloaded successfully and I can perform analyses using the add-ins function. However, I have been trying to use the Slopetest array and the formula affects only one output cell, so I cannot see the entire table and I have not been able to figure out something around this so far. Perhaps I am doing something wrong?

        • Charles says:

          Charlotte,

          SlopesTest is not one of the Real Statistics data analysis tools. It is a worksheet function. For a complete list of functions and data analysis tools, see the Tools menu on the home page of the Real Statistics website.

          To get more information about the SlopesTest function see the webpage
          SlopesTest

          Charles

  104. Pingback: How To Logistic Regression | Data Analysis with Excel

  105. knut Foshaug says:

    I seem to be haveing problems with the eigenvector and eigenvalue methods.
    by entering :
    -1 2 2
    2 2 -1
    2 -1 2
    Which should give the eigenvalues 3,-3 with 3 as a second order root.
    But the eValue(mat) gives me 1 and 2 .. ?
    I cannot see where the problem lies.. Can you help ?

    • Charles says:

      Knut,
      Assuming that the matrix is located in range A1:C3, when I use the array formula =eVALUES(A1:C3) I get the eigenvalues
      4.464101615 -2.464101615 1
      which seem to be correct. I’m not sure where you got the figures in your comment.
      Charles

    • Charles says:

      Knut,
      I can’t find any record that I responded to you. Sorry for the delay, but I seemed to have overlooked your comment. In any case I calculate the eigenvalues for

      -1 2 2
      2 2 -1
      2 -1 2

      to be 1, -2.464, 4.464 (rounded off to 3 digits). I don’t see where you got the values 3, -3, 3. If you check, det(A-cI) = 0 for my values of c, but not for your values of c.

      Charles

  106. Mark Kennedy says:

    I installed the resource pak while it was still in my download folder (oops!). I’ve since moved it to the recommended folder and tried to reinstall it, but whenever I open excel it still looks for your package in the downloads folder. How do I get excel to stop doing this and just look for the file where I’ve stored it? (i.e., C:\Users\user-name\AppData\Roaming\Microsoft\AddIns

    • Charles says:

      Mark,
      I think the following approach will work. Let me know if you have any problems.
      1. Make a copy of the Resource Pack and put it where you want it to go.
      2. Delete the Resource Pack from the your download folder
      3. Press Alt-TI
      4. Click on the file name which contains the Resource Pack in the download folder location
      5. You should receive an error message requesting that this file be deleted from the list. Say yes.
      Now you should be able to install the Resource Pack where you want.
      Charles

      • Mark Kennedy says:

        Dear Charles,
        I’m sorry, but what is Alt-TI? Tools? (there is no I command). I’ve deleted the Resource Pack from the download folder location. Excel still opens with this error window: “C:/Users/…/RealStats.xlam could not be found. Always looking in the downloads folder. Very frustrating.
        — Mark

        • Charles says:

          Mark,
          Alt-TI means hold the Alt key down and type a T followed by an I. This will bring up a dialog box.
          Tools is the Tools menu in some versions of Excel.
          Charles

          • Mark Kennedy says:

            Whoo-Hoo! I think that did it. After I deleted the file from the list, I had to close Excel. Then I reopened it and installed the addin without a problem. Thanks.

          • Charles says:

            Mark, that is good to hear. Congratulations on getting it to work.
            Charles

  107. stefan says:

    I downloaded the pack for excel 2010/ 2013 several times. When I try to use some of the statistical analysis in data analysis tools and it gives me the same error as I read somewhere in the comments
    Run-time error “424” object required
    Could be from my MS office?

    • Charles says:

      Stefan,
      It is probably not your version of MS Office (unless you are running the 64 bit version of Excel, which is not so likely). The most common problem is that the software has not been installed properly. You need to follow the installation instructions on the referenced webpage. If you have done this correctly, when you enter the formula =VER() in any worksheet cell you should see the version number of the software (something like 3.6.2). Please let me know whether you see this.
      Charles

      • stefan says:

        Hi Charles, Yes, when i enter =ver() i receive exactly 3.2.6.
        I wil try to re-install it again.

      • stefan says:

        Well I re-installed it twice more and the same rum-time error occurs. The installation process do not seem so complicated, i made it several times. Perhaps the error is due to a basic problem in the MS office or the windows. I,m running W7 ulitmate 32-bit.

        • Charles says:

          Stefan,
          Since you see the release number when you enter the =VER() formula, it looks like you have installed the software correctly. Can you tell me which data analysis tools produce the error and which data analysis tools don’t produce the error. Also which version of Excel are you using?
          Charles

          • stefan says:

            Charles,
            solved! The problem was in my computer. Probably I had some issues with the windows. So after re-installation of the windows, and downloading the real.stat. file again it worked fine. Thank you for the responsiveness. Also thank you for sharing this product.
            Stefan

          • Charles says:

            Stefan,
            Good to hear that you got it working.
            Charles

  108. Dear Mr. Zaionts,

    your software is awsome. I suggest one way to make it even more demonstrative and user-friendly.

    I am a scientist using statistics as an empirical tool in my forest research, but I am also a father trying to sell and teach statistics to my kids. I have e.g. tried to demonstrate the binomial distribution to them. In your Examples Workbook, sheet Binomial 1, you have data and a graph with FIXED data. This does not really has a simulation value. I have just changed a few things and the graph started to “move”:
    D1 contains “n” as a label
    E1 now contains 20, but this should be able to be changed say between 10 and 100
    F1 contains “p (any number between 0 and 1)” as a label
    G1 contains any value of p
    H1 contains the value of 100*p
    I have inserted a Scroll Bar (Developer, Insert) with settings: minimum value 0, maximum value 100, increment 1, cell reference H1.
    You of course also need to adjust the formulas to not use fixed numbers but to use the variable numbers in H1 (and possibly E1, although this requires changing the structure).
    With these setting the user can very quickly set very different values and see what happens if the values are changes.

    Similar developments could be done in many other worksheets.

    I am suggesting this to you for your consideration. (I wonder what your opinion on this may be.)

    Thanks for making this wonderful software freely available.

    Best regards,

    Zoltan

    • Charles says:

      Zoitan,
      This is an excellent idea. I did something similar when I was trying to explain queueing theory via simulation to my students. I will try to add something along the lines you suggested in the future. Thanks for your suggestion and thanks for your kind remarks about the Real Statistics software.
      Charles

  109. Mark Farrell says:

    You have a very helpful website, and it sounds like you have a nice product as well. I genuinely appreciate that, and the effort you put forth. But I’m a little confused on why you’d be offering these add-ons for free, and what exactly the VBA code contains within the add-on.

    • Charles says:

      Mark,
      My original objective was to create an educational website along with a free version of statistics software that could be used by everyone without having to spend a lot of money (which is why I chose Excel as the platform). I am pleased that over time my objective is being realized. The add-in is indeed a product, but I am satisfied that people can use it for free.
      I plan to release a couple of books to accompany the website. These books are optional, but I will ask people to pay a small fee for them.
      Charles

  110. Adamu says:

    i finish the installation process and try to open the RealStats.xlam but finds it difficult to do so. it open up the RealStats.xlam application blank page with a pop up dialog box that reads… excel found unreadable contents in ‘RealStats.xlam’ so please help me

    Please Sir If u can also send to me the Real Statistics Examples Workbooks via my e-mail address.

  111. William Agurto says:

    Charles:

    Something has changed in Real Statistics 3.5, 3.5.1 and 3.5.2 . It seems like there are some problems with the VBA code in that versions related to the number of bits (32 or 64, as Stephen Druley reported), the Excel version (2013), or the Windows version:
    1. When you press the “Help” button in any of the interface windows of Real Statistics Analysis Tool (versions 3.5, 3.5.1 and 3.5.2), Excel shows a message related to a “compilation error in hidden module: frmXXX” (for example, frmTTest). Excel indicates that this error usually occurs when the VBA code is not compatible with the version, the platform or architecture of application. The problem is general: it appears in all the options (Descriptive Statistics, T Tests, Analysis of Variance, Statistical Power and Sample Size, and so on).
    2. That problem is also related with the “comma” error appearing in the interface windows of Real Statistics Analysis Tool (versions 3.5, 3.5.1 and 3.5.2) in the alfa box (appears “0,05” instead of “0.05”). That problem was reported for me in a prior message as a Kolmogorov-Smirnov function (KS2TEST) problem, but the problem is general: it appears in all the options (Descriptive Statistics, T Tests, Analysis of Variance, Statistical Power and Sample Size, and so on).
    3. That problem is not present in prior versions of Real Statistics (3.4 and before versions runs properly), so I suppose that the problem is probably related to a change of your software. Have you change your Microsoft Office version to 2013 recently, or your Windows system? I supposed that because I have not changed my Microsoft Office version (2010) or my Windows system (Windows 7). I have not changed my Excel options either (they are the same since 1 year ago aprox).
    4. Today I ran Real Statistics 3.4, 3.3.1, 3.3, and they worked properly (obviously, without bug corrections that you have tried to apply in Real Statistics 3.5, related to some Real Statistics functions): There are no problems with the “comma” in alfa box, or in the “help” button in any of the interface windows in all the options (Descriptive Statistics, T Tests, Analysis of Variance, Statistical Power and Sample Size, and so on).
    5. In spite of that, if users correct the “comma” error in interface Windows, it seems Real Statistics 3.5, 3.5.1 and 3.5.2 get the correct results, but the “help” button is not running.
    6. Personally I prefer not to work with Microsoft Excel 2013, because it has produced some problems at my work place (for example: Solver Add-in is in German language; Data Analysis is in Spanish; some personal-developed add-ins can’t run in that version of Excel, but they run properly in 2010 version).

    I hope you can use this information to correct the bugs. Probably the origin is the use of the VBA environment in Excel 2013 instead of Excel 2010.

    Thank you.

    William Agurto.

    • Charles says:

      William,
      This is quite strange. I am still using Windows 7 and Excel 2010 (32 bit version) as before. I haven’t made any major changes in the design, except to add new features and to explicitly define the defaults for alpha to be .05 (the comma issue). I haven’t changed how I handle the Help button. BTW, release 3.5.2 is to correct a bug in resampling for correlation.
      Charles

    • Charles says:

      William,
      I made a minor change that I hope has resolved the problem, but I am not sure since I didn’t see the problem on my computer previously. Please let me know if this problem has gone away with the Rel 3.6 which is now available for download.
      Charles

      • William Agurto says:

        Charles:

        Real Statistics 3.6 runs OK, without errors in VBA code or “help” button reported by Excel (although “comma bug” in alfa value persists; but it isn’t important: user can modify it before or after get the results).

        PD: The “comma bug” is not present in Office 2013.

        Thank you very much.

        William Agurto.

  112. Stephen Druley says:

    Dear Dr. Charles Zaiontz,

    Glad to see that you are enjoying the world and that it’s limits are not just the state lines of Indiana. I attended Goshen College in Goshen Indiana and Purdue as well. I am just wondering if your statistical add-in is compatible with Excel 2010 64 bit.
    I am so impressed with your work and how you have articulated the mathematical treatise behind it.
    Wishing you and your lovely wife a great year ahead.

    Dr. Stephen Druley

    • Charles says:

      Thank you for your very kind words.
      I am not using any of the capabilities that I know don’t work in Excel 64, but since I have never tested the Real Statstics software on Excel 64 bit, I can’t say for sure whether it functions properly or not.
      Charles

  113. Lei says:

    Dear Charles,

    I looked at the Real-Statistics-Example-Workbook, sheet NCHI2: Power of Goodness of Fit. I wonder how you compute Beta (B11) from NCHISQ_DIST. Would you please help me understand the formula behind it ?

    Thanks,
    Lei

  114. Tien says:

    Dear Charles,

    Thank you so much for creating this heaven for this math-dumb person. I’ve installed the package, but whenever I tried to use the functions, let say Anova with repeated measure, I got this Microsoft Visual Basic pop up saying ” Compile error in hidden module: Analysis” with “OK” and “help” buttons. I clicked “OK” but then nothing happened. I tried another function and the same message appear. Would you tell me what’s wrong and how to fix it? thanks.

    Regards,

    Tien

    • Charles says:

      Tien,
      A number of people have reported this problem with the Excel 2007 version of the software. I plan to release a new version of the software in the next day or two which I hope will resolve this problem.
      Charles

  115. Eduardo Kropnick says:

    Dear Mr. Zaiontz;

    Greetings from Madrid (Spain). Thank you very much for you software and for your website. I find both very useful.

    Only a small suggestion: as far as I know it is not possible to check which version is currently installed. Mabe you can add in the message that appears when clicking on the Help button an identification of the version. That small change will allow to the users of you software to check easily if we are using the latest version available!.

    Thanks,

    • Charles says:

      Eduardo,
      If you enter the formula =VER() in any cell on the spreadsheet you will get the release number of the software being used.
      Charles

  116. Subhadip Chattopadhyay says:

    I am using Windows 7, Office 7 and =ver() is 3.4. I am getting the error “Compile Error in Hidden Module” for all functions. What to do?

    • Charles says:

      By Office 7, I assume that you are referring to Excel 2007. I am running Windows 7 with Excel 2007 on my computer and am not experiencng this problem. I don’t know what is causing the problem on your computer. In any case, I will be issuing a new release of the software in a few days. I hope that you will be able to use this version without problems.
      Charles

  117. It shows” compile error in hidden model analysis”

    • Charles says:

      The usual reasons for this message are

      1. The Real Statistics Resource Pack was downloaded, but not installed properly. Please make sure that you follow the instructions in the referenced webpage to enable Excel to recognize the resource pack as an “add in”. You should see the release number of the resource pack when you enter the formula =VER() in any cell of a worksheet. If not, this is likely to be the problem.

      2. The Windows version of Excel is prior to Excel 2002. The Mac version of Excel is prior to Excel 2011.

      3. The operating system is Windows XP or older.

      Charles

    • Charles says:

      I expect to issue a new release of the software this week. If the approaches that i suggested earlier haven’t resolved this problem, then perhaps the problem is resolved in this new release.
      Charles

  118. Ben Fernandez says:

    Hi Charles,

    Great piece of software, has been easy to use thus far and seems to produce results comparable very costly software packages!
    I am having a problem with factor analysis, I have 40 variables each with about 7k observations, when attempting to run the analysis I am given the error message

    “A run time error has occurred. The analysis tool will be aborted.
    Unable to set the formula array property of the Range class”

    Whats the reason for this, and is there a solution?

    Again, congratulations for such a useful piece of software.

    Thanks,

    • Charles says:

      Ben,
      If you send me a spreadsheet with your analysis I will try to figure out why you are getting this error message.
      Charles

  119. Ngan says:

    Charles,

    I just tried using it to find reliability of my data. But, the line”compile error in hidden module: analysis” appeared, may I know whether any mistake I made here? Thanks.

    • Charles says:

      Ngan,
      In order to try to identify the cause of the problem, I need to ask you the following questions:
      Which versions of Excel and Windows are you using? Which reliability capability are you using (the Reliability data analysis tool or one of the reliability functions)? Are you able to use other Real Statistics data analysis tools and functions?
      Charles

  120. William Allen says:

    Charles,
    I just downloaded in Windows 8.1 Office 2013 and seems to be working fine. I had been holding off watching how the comments above would evolve. Seems grand…
    Please tell me you have some ulterior motive, some profit angle here or you will destroy my cynicism in humanity?
    Seriously, you are to be highly commended for 1) making this product available, 2) responding as patiently as you have to all the comments above, and 3) providing versions for old software that even MS doesn’t support anymore (eg XT).
    Thank you, profoundly,
    William

    • Charles says:

      William,
      No ulterior motives. My objective from the beginning was to create a site for people to learn statistics and gain access to tools without having to pay a lot of money. I am having fun doing this and have learned a lot myself.
      Charles

  121. JeetkumarN says:

    I am using MSO 2007, still i found using Real statistics Excel 2003 (which has a .xla extension instead of an .xlam extension) thankfully it is working but partially.
    When i give some basic command a msg display in middle with wrong incomplete output.
    for example QUARTILE.EXC function giving #Name? may be functions conflicting with existing one or something else.

    “A run time error has occurred. The analysis tool will be aborted. The specified dimension is not valid for the current chart type.”

    even when i use descriptive stats without exclusive version of quartile it is giving error

    “A run time error has occurred. The analysis tool will be aborted. application-defined or object defined error. ”

    Is this tool is not workable with Analysis ToolPak -VBA?. Though same result when i use this exclusively.

    • Charles says:

      The QUARTILE.EXC function is not supported in older versions of Excel. You should avoid using it or any options for the exclusive percentiles or quartiles (especially in the descriptive statistics and boxplots data analysis tools.

      These have been partially corrected in more recent releases of the software.

      Charles

      • ron says:

        Hi there, I got “A run time error has occurred. The analysis tool will be aborted. Application-defined or object-defined error” when I wanted to create a boxplot. My excel is 2010, win xp 32 bit. why?

        • Charles says:

          Ron,

          Not too many people are still using Windows XP and Microsoft no longer supports this version of the operating system. I know that some people have had some similar problems.

          Are you able to use any of the other data analysis tools? What do you see when you enter the formula =VER() in any cell in a worksheet?

          Charles

  122. JeetkumarN says:

    Dear Prof Zaiontz

    Congratulations for the global appreciation for this add-in software. Unfortunately i am still unable to use this. I tried and followed all steps and also tried the basic steps to resolve errors. This blog i found useful but i am not able to crack it.
    I am using Windows XP Office 2007
    downloaded both RealStats.xlam as well as RealStats-2007.xlam
    placed it at
    C:\Documents and Settings\narendra.kumar\Application Data\Microsoft\AddIns
    But find errors

    also i tried replacing them at
    C:\Program Files\Microsoft Office\Office12\Library

    same output
    Errors screen shots are

    Though almost functions working properly i checked but dont know why it is asking for password and VB error that cannot find project or library or compile error in hidden module: Analysis

    Help me out, please
    Thanks and Regards

    KumarN

    • Charles says:

      KumarN,

      The software should work no matter where you place it and you don’t need to supply a password. For example, suppose you place it at

      C:\Documents and Settings\narendra.kumar\Application Data\Microsoft\AddIns

      Next you should press Alt-TI. You will see the Add-Ins dialog box. Click on the Browse button and search for the Real Statistics software at the file location you specified above. When you find it you need to click on the OK button. The Add-Ins dialog box should reappear, but this time the RealStats 2007 selection should appear in the list and should be checked (if not check it). Now click on the OK button and you are done. You should be able to use the software.

      Caution: I have never tested the Excel 2007 version of the software in Windows XP, but the above approach should work.

      Charles

  123. George says:

    Admin;

    I’ve downloaded the office 2013 version, I added it to excel add in and was able to use its commands. When I use the =VER() I received 3.2.1 My issue is I’m unsure if I in fact downloaded the Excel 2013 version or am having another issue for the error I’m receiving while going through the Real-Statistics-Multivariate-Examples are from a link issue:

    Cell reflects: #NAME?

    =’C:\Users\C\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’!COVP(B4:F30)

    Looking at the link it identifies an error:

    Source Type Update Status
    RealStats.xlam Work…. A Error: Source not found

    It must be something simple that I can’t understand.

    Please advise if you can.
    Thanks.

    PS If anyone had this error and corrected I’d greatly appreciate the insight.

    • Charles says:

      George,

      When using a spreadsheet that someone else has prepared which refers to an Excel add-in, you need to tell Excel where that add-in is on your computer. Fortunately you only need to do this once. This is the reason why you are getting error messages and seeing =’C:\Users\C\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’!COVP(B4:F30).

      Please refer to the webpage http://www.real-statistics.com/free-download/examples-installation/ for how to address this.

      Charles

  124. Monica says:

    Hi Admin,
    I like your great add in and wan to use it.
    I downloaded the office 2013 version, I added it to excel add in and was able to use its commands. But I need “correlation” from the menu “ctrl + m”
    I could get to load the correlation screen and input the data but it didn’t respond after clicking “OK” button. then my office froze and stopped and then restarted!
    Please let me know if there is a way to solve this.
    I use: win 7 x64 , MS Office 2013 64bit

    • Charles says:

      Monica,
      I don’t understand what happened. I just retested the Correlation data analysis tool on my PC (Office 2010) and it works fine.
      Let’s see if anyone else having this problem?
      Charles

      Update: One other possibility is that the data was not formatted properly and the software crashed. This should not happen since the software should make sure that even if the input is not properly formatted error messages are given instead, but in any case it is possible that this happened.

      Charles

  125. Keith says:

    A great help. I was looking for a way to calculate eigenvectors. I installed it and had it running working in a few minutes. Thank you!

  126. Andrew says:

    Hello! I accidentally downloaded and rather than saving, opened the file and now it seems that even if I erase the file and try to reinstall the add-in following the correct instructions (Saving as rather than opening etc.), it doesn’t seem to work! Please help!

    • Charles says:

      Andrew,

      I don’t know why this should happen, but here are two suggestions for how to proceed. Hopefully one of these works.

      1. Download the file to your computer and then rename it (say RealStatistics instead of RealStats). Now proceed as described in the instructions using the new name instead of the old name.

      2. Alternatively, delete the RealStats file. Then press Alt-TI and if RealStats appears on the list of add-ins, delete it from the list (you should be prompted to do this since the file no longer exists). Now download the RealStats file and proceed as in the instructions.

      Charles

  127. Sara says:

    What a great resource! One small bug I’m getting: when I select anything option from the Real Statistics window, that Real Stats window will immediately become active again on top of the input window for whichever test I’ve selected, and you can’t dismiss it by hitting cancel or anything. Clicking away to any other program and coming back to excel causes the correct window to appear from the background again and I can finish putting in the information to run the test. It’s easy to get around, but a little annoying. Any ideas on what could be causing this? It’s in Office 2013, the “Professional Plus” edition. Thanks!

    • Charles says:

      Sara,

      I am aware of the problem, but have not had access to Excel 2013 long enough to try and correct it. I plan to purchase Excel 2013 shortly and I should be able to figure out how to address this problem.

      Charles

  128. Eleazerkurzz says:

    Dear sir,
    I have completed all the above mentioned steps on installing this software, but nothing seems to be working . Only a blank Ms-excel sheet appears. Can you please provide me step by step instructions on how to properly install this software so that i may be able to make use of it for my upcoming project work. I am a college student currently taking Statistics as my honors paper and would really appreciate it if this software could help me with my project work.
    thnkyou

    • Charles says:

      You should only see a blank Excel worksheet. You can tell whether the Real Statistics software has been installed by entering the formula =VER() into any cell. If you see the release number (if you are using Excel 2010 or 2013 this will be 2.16.2). You will also see the Real Statistics icon in the Add-Ins ribbon. If you don’t see these, let me know. Also let me know which version of Excel you are using.
      Charles

  129. Martina says:

    Hi,
    thanks for all the resources.
    I have tried to download the RealStats package for Excel 2010, but it appears only as a blank grey sheet without lines and columns, it doesn´t work and I cannot see it in the Add-Ins window in my Excel spreadsheet.

    Thanks for your help.

    • Charles says:

      Hi Martina,

      I just checked and found no problems downloading the RealStats package for Excel 2010.

      The usual problem in these cases is that it is necessary to install the package before you can use it. Installation instructions are quite simple, but necessary. You can find the instructions for doing this on the webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/. Once you complete the installation you may need to close Excel and open it again before you will see the Add-Ins window.

      Let me know if this doesn’t solve the problem.

      Charles

  130. Lahlou says:

    I can not dowload “Real Statistics Resource Pack” for excel 2007/2010. Can you tell me why?

  131. Vinod Jindal says:

    Dear Charles,

    It is amazing that you have made such a wonderful tool available free of charge. In doing so, you have strengthened my belief in the basic goodness of “real” people who know the true meaning of giving.

    With sincere appreciation,

    Vinod Jindal

  132. badih says:

    hi i’m like to try the new of this program . i do not a have a macintoch but the program not work need a password .all the file “.xlam”need a password to open it .

  133. Dan Vicarel says:

    Hi Charles,

    Let me first say, very impressive work! This website has been very educational and your RealStats plug-in is helping me a lot. I hate to ask for more when you are already providing these tools for free, but I’m having issues using your functions within my own VBA macros. Specifically, I would like to call the MANOVA_Pillai(), MANOVA_Wilks(), and MANOVA_Hotel() functions in my code without making a bunch of messy “Range.FormulaR1C1” assignments, but I don’t know what they’re arguments or return values are. The easiest thing would be to see the code for these functions, but I understand if you don’t want to give that out. So could you please provide either that password or an example call to the above functions?

    Thank you so much.

    • Charles says:

      Hi Dan,

      The calls to all the functions are described under the Tools menu. For example the MANOVA_Hotel function is as follows

      Function MANOVA_Hotel(rg As Range) As Variant
      ‘ return a 5 x 1 array with Hotelling’s Trace for MANOVA, df1, df2, F and p-value
      ‘ assumes that the first column of rg consists of identifiers of the independent variables and each of the
      ‘ other columns consists of data for the dependent variables w/o column headings

      Charles

      • Dan Vicarel says:

        Thank you, I hadn’t seen that page. A few things are still confusing me though:
        1) I am trying to call the MANOVA functions within a loop, where a different set of data is being used in each loop iteration. I think the macro will run much faster if I can pass a 2D array to the functions rather than copy new values to a range and pass that range to the function every time. Can your code do this?
        2) I tried assigning the return value of MANOVA_Hotel() to a Variant variable called returnArr in my code, and it successfully gave returnArr a Ubound of 5. However, if I try to access any elements of returnArr (for example MsgBox returnArr(2)) I get a “subscript out of range” error. Can you explain this?

        Thanks again,
        Dan V.

        • Charles says:

          Dan,
          (1) I have implement many of the functions which take a range to accept either a range or a 2D array. Unfortunately the MANOVA functions were implement to accept only a range.
          (2) The return value for MANOVA_Hotel is a Variant which contains a 2D array. UBound(x,1) = 5 as you pointed out, but I believe that you also need to specify the second dimension even though UBound(x,2) = 1. Try using MsgBox returnArr(2,1)) and see if that works.
          Charles

  134. Jeannie says:

    I have noticed that the MAD function is affected by the order of the array of data.
    For example: 25, 75, 100 produces MAD=25; 100, 75, 25 produces MAD=12.5; 100, 25, 75 produces MAD=37.5

    I’m assuming the function requires the data to be sorted in a certain order. I would prefer to not sort the data before calculating. Is there a way to get around this?
    If there is not a work-around, can you advise on the correct method to sort for the function to work correctly?

    Many thanks!

    • Charles says:

      Jeannie,
      The data doesn’t need to be any particular order. There was simply a small error in the software. I have now corrected this error in the latest Excel 2010/2013 version of the software, Release 2.12.1, which is now available for free download. For people who use versions of Excel prior to Excel 2010, I will include this correction in the next full release of the software, Release 2.13, which will be available in a few days. Thanks for identifying this error.
      Charles

  135. James Jihulya says:

    I downloaded the Real Statistical Pack but I can not do anything because of macros being disabled. Please help to enable them because once I enable them there is no response.
    Thanks.

  136. Mike says:

    I was tried to download and install RealStats twice but when I get to the Add-ins available screen, RealStats does not appear, only the Analysis Toolkit, Analysis Toolkit VBA, and Solver Add-in appear. Is there a problem, or have I made some mistake?
    Mike

    • Charles says:

      Mike,
      No mistake. It won’t appear. You need to press on the GO button at the bottom of the Add-ins screen. A dialog box will appear. If you see RealStats on the list then click on the check box and press OK. If not press the Browse button and navigate to where you saved the RealStats file and click on it. RealStats will now appear on the dialog box. Click on the check box next to it and press the OK button. You should now be able to use all the supplemental functions on any spreadsheet just as you would for a normal Excel worksheet function. To access the the data analysis tools press Ctrl-m.
      Charles

  137. Rich says:

    Charles
    I use the inventory of your functions and tools frequently, but find access to the lists a little cumbersome (too many clicks). Is it possible to include more direct access to the inventories of functions and tools, perhaps from the link bar across the top of the pages?
    Thanks, Rich

    • Charles says:

      Rich,
      I have added a Tools sub-menu to the Top menu. Please let me know if this provides the capabilities that you are looking for.
      Charles

  138. I’ve got real-statistics loaded and in the active add-ins area. Is there a user manual I can reference to use the logit and chi square functionality? I can’t find these options (logit and chi sqare) on any of the drop down menus within excel.

    Thanks, K

  139. Max Sass Egebo says:

    Hi Charles, I’d just like to say thank you for making this availble to everybody. I downloaded, instaled and used according to the instruction (Excel 2007) and it worked like a charm. Thanks!
    Max

    • Charles says:

      Hi Max,
      Good to hear. I hope you find the software and website useful. I plan to continue to add new functionality in the future, so stay tuned.
      Charles

  140. Declan says:

    Hi there Charles

    I am using excel 2007 but I have Windows 8 Pro (not sure if that is a problem).

    I will follow your instructions and let you know. 🙂

    Kind regards
    Declan

  141. Declan says:

    Hi there Charles

    I downloaded the latest version but I am getting a Miscrosoft Visual Basic error

    Compile error in hidden module: logistic regression
    Compile error in hidden module: Misc
    Compile error in hidden module: ChiSquare
    Compile error in hidden module: Matrix
    Compile error in hidden module: Regression
    Compile error in hidden module: Lookup
    Compile error in hidden module: Nonparametric

    Please can you help regarding the above.

    Kind regards
    Declan

    • Charles says:

      Declan,
      Are you using Excel 2007?
      Charles

    • Charles says:

      Declan,

      Sorry to see that you are having these problems.

      I created a new version today called Rel 2.9.1. I also have created three versions of this software: one for use with Excel 2010/2013, one for Excel 2007 and one for versions of Excel prior to Excel 2007. Especially if you are using Excel 2007 or prior versions of Excel I suggest that you delete the existing version and download the latest version again.

      If the problem persists please tell me whether you can can enter the formula =VER() and whether you can access any data analysis tools when you press Ctrl-m.

      Charles

  142. Ed W says:

    Hi,

    FYI, I experienced the same issue as Arturo et al on Excel 2007, win 7. I am quite sure that I followed your installation of add-in instructions accurately (did it several times) – there is definitely an issue with the vba program.

    I am a programmer and thought you might be interested in this vb error msg (I can’t paste the image):

    Can’t find project or library

    So it seems in your vb project, you have a reference to a module that ,for some reason, is not found on the windows installations that are having the issue (like mine and Arturo). I have had similar issues before with versions of some of the microsoft libs, but that may be unrelated. Of course the easy way to clearly identify the issue would be to run it with the source on a system where the issue occurs, since vb will immediately highlight the problem lib, but I’m sure you don’t want to give out the source code…

    Best of luck.

  143. David Arnold says:

    Any news on a Mac version for your resource package?

    Thanks.

    David.

  144. Bo Sann says:

    Hello,
    I am a student form Kyoto University. I have downloaded and successfully installed Real Statistics Resources Pack in my computer(windows 7, 64 bit) for Microsoft excel 2007. But the problem is that when I calculated eigenvalues/vectors by using Matrix Operations, there appeared a message box ” Input data range must be square”. I couldn’t understand because my matrix is completely square like 3 rows x 3 columns. Other functions are okay, for example, transpose function. Could you help me why it is happening.
    Best regards,
    Bo Sann

    • Charles says:

      Hello Bo,
      I recently changed the IsSquare(R1) supplemental function and inadvertently introduced an error. I have now corrected this and so the data analysis tool should now work properly. Thanks very much for finding this error.
      Charles

  145. Cyril says:

    Hi,

    I have followed your setup instructions, copied the file in the AddIns folder as you suggested and went through the excel options -> Add-Ins pressed Go, browsed to get the file added in the box and ticked the box and finally pressed OK and it bounces an error message telling me that a reference or a library is not found. I press OK (it’s my only choice with Help options that leads) and then it asks me for a password also.

    I did understand that there is no need for any password, but I tried to follow the instructions you gave already three times without any success and I don’t think I missed something by now as I have read and followed the instructions carefully.
    Do you have any suggestion of what the problem could be?

    • Charles says:

      Hi Cyril,
      I just released a new version of the AddIn. I suggest that you delete the previous version and downloading the latest version. Let me know if you still are unable to install the software. By the way, what release of Excel are you using?
      Charles

      • Cyril says:

        Hi again,

        I’m unable to install the new software, same error message as before. My version of Excel is Excel 2007, a part of Office Professional Plus (12.0. etc)

        I hope it helps.

        • Arturo J Patungan Jr. says:

          Hi Charles,
          I have the same problem with Cyril. I tried to follow step by step instruction on how to install the add-ins but it always lead to the realstat asking for a password.
          Thanks

          Art

        • Charles says:

          Cyril,
          Unfortunately, I don’t know why you are having this problem. Others have been able to successfully install the software. It is not clear to me what is different about your computer configuration that prevents you from completing the installation. Perhaps others readers can offer some suggestions.
          Charles

        • Charles says:

          Cyril,
          I have recently heard from others who are having problems specifically with Excel 2007 as part of Office 2007 Professional. I have also been given the suggestion that upgrading to the latest Office 2007 service pack (namely SP3) can resolve this type of problem, but I have not been able to test it myself.
          Charles

  146. umesh says:

    I tried downloading and adding the addin to the Excel Addin section. It keeps asking me for a password and doesn’t install. Appreciate your help with teh passowrd. I read the other posts on this page in relation to password, but nothing ofmuch help. I followed the steps as explaine dto place the addin in Roaming directory (C:\Users\xxxxxxx\AppData\Roaming\Microsoft\AddIns). But not succeding.

    Appreciate your help.

    Regards,

    Umesh

    • Charles says:

      Unmesh,

      That you are being prompted for a password indicates that you haven’t installed the file correctly. You do not need to supply a password. It is not sufficient to put the file in the correct directory. Please follow the following steps:

      After selecting Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in Excel 2010/2013, it is important that you look for the Go button 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 Browse button on the dialog box.

      Please let me know if this doesn’t work for you.

      Charles

  147. Owen says:

    Resource pack is not opening after downloading. It draws blank.

    Could you please advise what to do?

    Regards

    Owen

    • Charles says:

      Owen,
      The Real Statistics Resource Pack doesn’t self-install. You need to follow the instructions on the website (on the download page) to install it. The process is pretty easy (essentially you are telling Excel that the resource pack is an Excel add-in).
      Charles

  148. Jorge Camacho says:

    Thanks for your tips, I followed your instructions step by step but at the end I can not find where is the pack available. Other add-ins, MegaStat for example, are available after installation, on Add-Ins menu in the top ribbon of Excel or Data Analysis add in is located on Data menu after installation, but I do not know where is RealStatistics available after installation.

    Thanks again for your tips

    Jorge

  149. Jorge Camacho says:

    I downloaded the pack and install the add in but the add in did no appear on Add Ins. I am using MS Office 360 on Windows 8.1 64 bits OS. Any hel will be appreciated.

    Jorge

    • Charles says:

      Hi Jorge,

      The pack won’t necessarily appear in the list of add-ins. You will need to add it to the list. Usually the approach is as follows:

      1. Move the Resource Pack file to where you want it located on your computer (see our recommendation on the website). Caution: once you install the resource pack at a particular location it will be more difficult to move it later.
      2. Select Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in Excel 2010/2013, and click on the Go button at the bottom of the window.
      3. Check the Realstats option on the dialog box that appears and click the OK button.
      4. If this option doesn’t appear, click on Browse to find and choose the realstats.xlam file. Then complete step 2 as described above.

      I hope this helps. Sometimes (but not usually) after performing the above steps you will need to close Excel and then reopen it again.

      Charles

  150. Zflan says:

    Hi
    Just downloaded a few days ago to finish up some research and it works great. I have the windows version. I’d suggest to tell people to move the file to where they want it before loading it into excel through their add-ins though. I did mine while it was still in the downloads folder and when I moved it, it was a mess to get it working again, well at least for someone like me. My husband whipped it up in less than 3 minutes. Just a reminder in the set-up may be helpful for other non-savvy people looking for a easy, simple way to get some stats done.
    Thanks for making it!

    • Charles says:

      Zflan,
      I am about to put out a new release (Release 2.3). I will update the website based on your suggestion when I do so.
      Charles

  151. Max Sharratt says:

    great resource but when I click on the link for the Xcel2003 version it automatically opens a text file of hyroglyphics altho with extension .xla. I´ve saved it as is but why don´t I have the option to download the xla filke

    • Charles says:

      Sorry Max,
      The Resource Pack was designed and tested for Excel 2007, 2010 and 2013. I had hoped that by saving the Resource Pack as an .xla file it would work with Excel 2003, but as I cautioned on the website it has not been tested. This is because I haven’t had access to Excel 2003. I may have found Excel 2003 software now and so will try to address this issue.
      Charles

  152. EMM says:

    Hello,
    I’ve downloaded the Real Stats Resource Pack and now I’m trying to install it- when I go to Add-Ins in excel, there is no Realstats option in the dialog box, nor is there a Browse function to find the realstats file… how can I find it and install?

    Thank you.

    • Charles says:

      Hi EMM,
      After selecting Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in Excel 2010/2013, it is important that you look for the Go button 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. This dialog box will have a Browse button. Please let me know if this doesn’t work for you.
      Charles

      • EMM says:

        got it, thank you- now, it appears that the Fisher exact test is not one of the functions included in resource pack? elsewhere on your website it’s stated that the fisher exact test function is included, but I cannot find it among the list of functions when I open real stats. I’ve also tried just entering the function directly in the cell (=FISHERTEST(desired range, number of tails)), but it did not work… please advise.

        Thank you

        • Charles says:

          EMM,

          I just tested the function and found that =FISHERTEST(R1,t) works fine on my computer. When you say it didn’t work, what message did you receive?

          If you receive the message #NAME? then Excel didn’t recognize this function. In this case, please check to see whether any of the other functions work in the Real Statistics Resource Pack work. E.g. try =VER().

          If you receive the message #VALUE! then the FISHERTEST function is included in the resource pack, but there is some other problem. Likely problems are the inclusion of non-numeric data in the data range or that the range you specified is not 2 x 2.

          Please let me know which message you receive. Also which version of Excel are you using? (2003? 2007? 2010? 2013?). I hope this helps.

          Charles

          • EMM says:

            Other functions work ( I tested the chi square function). when I try the fisher test function, I get #VALUE?- I am selecting only the 2×2 table for my data range, it is definitely only numeric data. I have the 2007 version of excel.

  153. EM Dube says:

    Hi Charles. For an hour and a few minutes I have been unseccussfully struggling to download Real Statistics Resource Pack following the provided link. Somewhere along the line I am being asked for my phone number. Is that part of the conditions? And thanks for the Logistic regression tutorial in EXCEL, I needed that badly as my current research is based on Logistic Regression. Please help.

    • Charles says:

      EM,
      I don’t know why you have experienced so many problems. You should not be asked for a telephone number. I have just checked and was able to download the resource pack without any problems. I will contact you directly to help you solve the problem.
      Charles

  154. Francisco Abecasis says:

    Hi Charles

    I have just downloaded the resource pack and it works perfectly.

    Thank you very much for your site and tools.

    Best regards

    Francisco Abecasis, MD

  155. Nárcio says:

    I real download the package but i could´t install due to password not available. Please, How can i make it aavailable.

  156. Avi Wes says:

    Thank you for the tutorial. However RealStats add-in requires a password. Can you please provide the password?

    Thanks,

    • Charles says:

      Hi Avi,
      You don’t need a password to use the RealStats add-in. Just follow the Installation instructions written on this webpage and you will be able to use all the supplemental functions and data analysis tools without a password.
      Charles

  157. Rich says:

    After using a few of the functions in the toolkit, I saved a spreadsheet to Microsoft Skydrive account. When trying to open on Skydrive or after downloading the same file, was prompted for links that the error message indicated should be found on the Skydrive account. It seemed to be looking for the resource kit, but not finding it on the skydrive. So the spreadsheet would not open cleanly.

    Any ideas? Or just don’t use or save to the cloud service.

    Do you believe there would be similar issues with links, if sharing a spreadsheet between multiple computers that have the resource kit located in different folders on each of the computers?

    Thanks, Rich

    • admin says:

      Hi Rich,
      I am not familiar with Skydrive, but to try to answer your question I just opened Excel under Skydrive. It looks like the full version of Excel is not supported in Skydrive. In particular I don’t see any way to link to Add-Ins.
      Charles

  158. Dr. Surendra Wadikar says:

    DEAR SIR,

    I AM A DOCTOR FROM INDIA AND I NEED YOUR HELP FOR MY RESEARCH. I TRIED TO LOOK FOR THE FREE DOWNLOAD REAL STATISTICS RESOURCE PACK LINK BUT DID NOT FIND IT ON YOUR WEB SITE ANYWHERE. KINDLY MAIL ME THE LINK. I ALSO TRIED TO CLICK ON REAL STATISTICS RESOURCES FREE DOWNLOAD ICON BUT COULD NOT DOWNLOAD. PLEASE HELP.

    DR.WADIKAR

  159. Donald McDonald says:

    July 14, 2013
    I am a professor at University of California, San Francisco. Your add-in for Excel looks incredibly powerful and useful for my research, but does it work with the Macintosh version of Excel 2011? Your description of the installation seems to apply to the Windows version of Excel.

    I downloaded and copied RealStats.xlam to the Add-in folder of Office 2011. When I started Excel and then opened Tools > Add-ins, I got an error message that a data file was not found and then was requested to enter a password.

    Your guidance would be appreciated.

    Thank you,

    Donald McDonald
    Professor

    • admin says:

      The current version only works with Windows versions of Excel. I will take a look at the Macintosh version after the summer.

      Charles

      • Kieran says:

        Hi, has there been any progress developing an Office for Mac 2011 or iWorks Numbers equivalent?

        • Charles says:

          Kieran,

          No progress yet on the Mac 2011 version. The main reason for this is that I don’t have a Mac and haven’t been able to get my hands on one. Once I do, I will create a mac version.

          Since Mac’s iWorks Numbers doesn’t support the Excel programming language I don’t have any plans to provide a version for that environment.

          I have just located a PC running Excel 2003 and so I will soon try to get out a version of the software for that environment.
          Sorry, but eventually I intend to get a Mac version out there.

          Charles

  160. David says:

    Hi,

    I tried downloading the add-in softwarefor Excel but the link does not seem to work. Is the software still available and if so, can you please check the link and/or send me a new way to download the data.

    Thanks,
    David

    • admin says:

      Hello David,

      I am sorry to read that you were unable to download the Real Statistics using Excel software.

      I just checked and saw that I was able to download the software without any problem. The link appears on the webpage

      http://www.real-statistics.com/free-download/real-statistics-resource-pack/

      Once you are on that webpage you will need to click on the link marked

      Real Statistics Resource Pack

      to get the download.

      Please let me know if you are still having problems. I hope you enjoy using the software.

      I plan to release an new version of the Real Statistics Resource Pack in the next week or two.

      Charles Zaiontz

Leave a Reply

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