Frequently asked questions:

  1. I am trying to use the Real Statistics software, but it prompts me for a password. What should I do?
  2. What to do if the Addins ribbon does not appear?
  3. What to do if Real Statistics disappears from the Addins ribbon?
  4. Does the Real Statistics Resource Pack work on a 64 bit version of Excel?

Additional FAQs will be added as necessary.

12 Responses to FAQs

  1. Phil M says:

    Hi Charles

    First of all could I say that I think it is brilliant that you have made a resource like this available on the web – ultimately this can only contribute to spreading the use of stats and evidence-based reasoning into our societies (and boy do we need that).

    My question is about installing RealStats on Windows 10 – the folder structure is not the same as


    Should I create these folders or go down a different route? Meanwhile I have just installed Excel 2016.

    Many thanks

    • Charles says:

      Glad that you appreciate the Real Statistics website and software. I had hoped to make such tools more readily available.
      You can place RealStats anywhere that you like. You don’t have to use the folder structure that I suggested.

  2. karnan says:

    shall work real-statistics tool work online without using my desktop excel?

  3. Jean says:

    Hi Charles

    As soon as I open Excel 2010 from main menu (no active woksheet), I receive the following message:
    This workbook is currently referenced by another workbook and connot be closed.

    As a work around I “deactivate” your workbook “RealStats-2010.xlam” in Add-Ins with
    File > Options > click Add-Ins > click RealStats-2010 > Manage: Excel Add-Ins > Go > uncheck RealStats-2010 > Close Excel

    When I reopen Excel the message is gone. As soon as I “reactivate” RealStats-2010, the message reappears.

    Can you verify this next link please:

    • Charles says:

      I have not seen this error before and can’t understand why the message would appear since I don’t believe that the program is closing a workbook.
      When you say that you “open Excel 2010 from main menu (no active woksheet)” is this equivalent to double clicking on the Excel icon? I am not completely sure that I understand when this error occurs.
      In any case, do you get this error when you try to open an Excel workbook?

      • Jean says:

        Answer to question #1: Yes it is equivalent to double clicking on the Excel icon. Answer to question #2: No wookbook involved. Just starting Excel.

        The problem and the solution is well explained here:

        In my case, I had to apply the solution/fix twice before it woks. And as always, I posted my question here after the first try. At the moment of writing my initial question, the problem was still there. I was under the impression that a closing statement in one of your macros was involved. After the second try of the fix, the problem was definitely gone. I hope this can help others.

        • Charles says:

          Thanks for sharing your experience with others.
          I understand from your comment that the problem is now gone. If not, please let me know.

  4. chintan says:

    Charles, you have a wonderful site – Indeed very helpful.

    I’m curious to know why the standard deviation of sample(n) = Std Dev of Population divided by sqrt(n) – I mean what’s the rationale?

    Also, without replacement – the error estimate is sqrt (N-n)/Sqrt(N-1) – Seems a bit absurd – Has anyone considered the reasons / rationale? Most often than not, error est will always be around .99. I dont understand the logic of all this really.

  5. Monica says:

    I am excited to use this software. I am attempting to perform an Intraclass Correlation Coefficient. I have my data entered into an excel spreadsheet but when I attempt to run any function from the Add-In menu, I receive the following message:
    “Compile error in hidden module: frmAnova2.
    This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click “Help” for more information on how to correct this error.”
    When I click help, it leads me to this page:
    If you happen to have come across this error previously and can help me figure out how to solve it, I would be very grateful!
    Thank you very much,

Leave a Reply

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