FAQs

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 should I do if the Addins ribbon does not appear?
  3. Is there anything that I can do if Real Statistics disappears from the Addins ribbon?
  4. Does the Real Statistics Resource Pack work on a 64 bit version of Excel?
  5. What should I do when I receive an error message after inserting a valid Alpha value on a dialog box?
  6. How do I use a comma as the decimal symbol?
  7. What to do when I receive an error message stating that I can’t run Real Statistics and Solver at the same time?
  8. What should I do if I receive an error message that begins “Compile error in hidden module …”?
  9. How do I increase the size of a dialog box on the Mac?

Additional FAQs will be added as necessary.

63 thoughts on “FAQs”

  1. Hello Charles,

    Thanks for sharing the vba tool .

    Could you offer some materials or webs for vba programming with some examples? I want to create a small tool like yours for non-programmers in the company.

    Best regards.
    Wen

    Reply

      • Hey Charles,
        I am getting the following error whenever I try to run Logistic regression.

        A run time error has occurred. The analysis tool will be aborted.
        Type mismatch

        Reply

          • Hello Charles,

            I’m receiving the same error as Hamza. Were you able to find a solution to this issue? Happy to send data if necessary. Thanks.

          • Hello Devon,
            Yes, please send me an Excel file with your data so that I can figure out what is happening. Also, are you using Windows or the Mac?
            Charles

          • Hi Charles,

            I have been having this same issue while trying to run the multiple imputation. Any assistance would be greatly appreciated.

            Regards

            Warwick

  2. Curious to know if there is functionality to run a ‘Chow Test’ (rendering that test statistic and associated p-value). Thx!

    Reply

  3. I am having problems with Logistic regression, it says “a run time error has ocurred” no matter what data I use

    Reply

    • Hello Fernando,
      What do you see when you enter the formula =VER() in any cell?
      If you email me an Excel file with your data I will try to figure out what is going wrong.
      Charles

      Reply

    • Hello Fernando,

      I have the same type of problem for about a month. Before, logistic regression worked perfectly for me. We have tested in my company on 3 different computers with different versions of Excel 365 and in any case we get the same error…(a run time error has occurred, types do not match). We have also tried with two different versions of Real-Statistics and we get the same problem.

      If anyone knows how to fix it I would greatly appreciate it.

      Carlos

      Reply

      • By the way, if it helps you, if I check the “Show item by item details in output” box, it has returned correct results. Previously I didn’t need to do this. If I uncheck this box it gives me the same error again. It may be a way to solve this situation while i´m waiting to know why this happens

        Reply

        • Carlos,
          Can you email me an Excel workbook with your data so I can see whether I can duplicate the problem? Are you using the Mac or Windows?
          Sorry if I have already asked you these questions previously.
          Charles

          Reply

          • Good afternoon,

            I have sent you the email again (with attached data) that I sent you on 02/07/2022.

            I use Windows as operating system.

            Thank you very much again.

  4. Hi Charles! i just wanted to know why the Excel 2007 keeps crashing whenever I try adding the Realstats 2007 ,but when I tried adding the realstats 2003 , it did work. will I encounter any problem while using different versionof realstats for the microsoft 2007?

    Thank you.

    Reply

    • Hi,
      Sorry that you were not able to get Realstats 2007 to work. Here are some suggestions.

      A. Solver must be installed. To check this, press Alt-TI and make sure that Solver (as well as Realstats-2007) is on the list of add-ins with a checkmark next to it.

      B. It is important that Realstats-2007 be installed as described on the website. You should not double-click on the Realstats-2007 file to install it. This will cause all sorts of problems.

      C. Try the following which didn’t use to be necessary for Excel 2007, but perhaps is necessary now:

      1. If Excel is running, close it. Find the file with the Real Statistics add-in. Right-click on the file and click on the Properties option from the menu that appears. Towards the bottom of the General tab of the Properties window you will see the security message “This file came from another computer and might be blocked to help protect this computer”. Next to this message is the Unblock checkbox. Make sure this is checked and press the OK button. Start Excel.
      2. Click on Options (which I believe is accessible from the Office button next to the HOme ribbon in Excel 2007) and then choose the Trust Center option on the left side. Next click on Trust Center Settings …. Next, click on the Macro Settings option on the left side and make sure that it is Disable all Macros with Notification. Also, click on the Trusted Locations option on the left side and click on the Add New Location… button to add the folder that contains RealStats-2007 file as a trusted location.
      3. Try opening a blank Excel worksheet and press Alt-TI. Uncheck the Realstats-2007 add-in and close Excel. Now open a blank Excel worksheet and press Alt-TI. This time check the Realstats-2007 add-in.

      Charles

      Reply

  5. Hello, I used the Cliff_Delta function and it worked perfectly the first time. I wanted to use it again, and I don’t know why I can’t make it work again. I can’t figure out if I’m missing a step. Can you help me please?

    Reply

    • Hello Mariela,
      Are you getting an error message? If so, what is the error message or error value?
      If you email me an Excel file with your data and results, I will try to figure out what went wrong.
      Charles

      Reply

  6. Hello Professor Charles Zaiontz, I am calculating the Passing-Bablok regression line for some data, to compare the effectiveness of two drugs on the ability to reduce the blood concentration of phosphorus in chronic kidney patients. I used the entire scheme found on “Real-Statistics-Examples-Regression-1” in the PB section since the number of data in his example coincides with the number of my data. Well, as regards the calculation of the coefficients “b”, “a”, “b-low”, “b-up”, “a-low” and “a-up”, the results obtained coincide with the calculation performed by the “PBRegCoeff” instructions. The calculations, however, diverge when I must test the linearity: if I use the “PBTEST” instruction, the calculation is performed well, but if I use the instructions contained in the columns from “AC” to “AQ” the calculation does not match.
    Can you help me?

    Reply

    • Hello Roberto,
      There is an error in the PBTEST which will be corrected in the next release of the Real Statistics software. This release, Rel 7.7, will be issued this week.
      Thank you for identifying the error and please let me know whether the new release solves the problem that you are having.
      Charles

      Reply

  7. Hello. I have been using real statistics for logistic regression but it is showing runtime error again and again “Unable to set the horizontal alignment property of the range class”. What’s the reason and how may I fix this issue?

    Honey

    Reply

  10. Hi,

    Recognizing that your inspiration was to create a tool that had the capacity for statistical analysis than SPSS which is widely used in the field of Social Science. Real Statistics is equally viable for statistical analysis in the field of Marine Ecology/Earth Science?

    Reply

    • Hello Marie,
      I am not knowledgeable enough to know whether Real Statistics handles all statistical analyses for Marine Ecology and Earth Science, but it certainly will provide quite a few useful capabilities. Are there some capabilities that would be useful for you?
      Charles

      Reply

    • Hi Piero,
      For access to the functions and data analysis tools in Other Mathematical Topics, you download the Real Statistics software at
      Real Statistics Download
      To access the examples spreadsheets on this topic you need to download one or two of the workbooks from
      Examples Workbooks
      I believe most of the examples can be found on the Time Series examples workbook.
      Charles

      Reply

  12. Hi Charles,
    I love this tool, hugely helpful. I was wondering if you could explain to me how to arrange my data to do a signed rank test. It is similar to the Example 1 for the MANOVA https://real-statistics.com/multivariate-statistics/multivariate-analysis-of-variance-manova/manova-basic-concepts/. I have 4 different types of “scanner” (soil in Example 1) and I have 6 different variables (yield, water, herbicide in example 1) I measure, from 20 different samples of each scanner. I want to see if the average value of each of these scanners is ranked in the same order for each of the 6 variables. Hope that makes sense?

    Reply

    • Hello Anna,
      The signed rank test is used with two variables, whereas you have 6 variables, and so the signed rank test doesn’t seem appropriate.
      If you started with a MANOVA test then you need to perform one of the post hoc tests as described on the Real Statistics website. Are you comparing the order of the dependent variables or the independent variables?
      Charles

      Reply

  13. I have downloaded real stats twice and it only showing real stats as an add in the dialogue box but on ticking one of the real stats options, it is not showing add-ins as an option in the ribbon above. And it is also showing a message that excel has stopped working because of real stats. Please help me out so that I can use this add-in feature.

    Reply

  14. Hello:

    I really enjoy you program. It makes it so much easier to understand statistics!
    One question: do you have plans to publish all your formulas and how to use them in a .pdf format?

    I would really be very helpful! I would gladly pay for it.

    Thanks

    Reply

    • Hello Victor,
      I plan to publish an ebook with this sort of information. For now, you can get some of this from the Tools menu on the website.
      Charles

      Reply

  15. I have the 365 excel version. How can I access the download? The download instructions aren’t currently working for me. Thanks

    Reply

  16. Hi Charles!

    I’m afraid that your download page doesn’t work. I tried to download the add-in but I just get a small file without extension instead the add-in. Could you check it?
    Thanks,

    David

    Reply

    • Hello David,
      I just downloaded the last version for Excel 2010/2013/2016/2019/365 (Windows) two minutes ago it worked perfectly.
      Please try again, but let me know if you are still having problems (or if you are trying to download the software for a different version of Excel).
      Charles

      Reply

  18. Hi Charles,

    Thanks for this excellent set of tools. I am having trouble figuring out how to use Real Statistics functions in Visual Basic. Specifically I would like to use eVectors(). The eVector function works when entered into cells on a worksheet, but when I try to use it in a VB macro I get a compile error that says the function is not defined. I am using Windows 10 and Office 365.

    Reply

  19. Thank you very much for the resources you offer, they have been very useful for me. I have a doubt, to validate a test by judges where I use a scale of 0-100% for each item, can I use the Kendall W? or should I use something else?
    Thank you

    Reply

  20. Hello,
    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:
    https://msdn.microsoft.com/en-us/VBA/Language-Reference-VBA/articles/compile-error-in-hidden-modulemodule-name
    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,

    Reply

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

    Reply

  22. 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:
    https://support.microsoft.com/en-us/help/159794/xl97-cannot-programmatically-close-referenced-workbook

    Reply

    • Jean,
      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?
      Charles

      Reply

      • Charles,
        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:
        https://kb.uwstout.edu/page.php?id=63468

        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.

        Reply

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

    C:\Users\user-name\AppData\Roaming\Microsoft\AddIns

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

    Many thanks
    Phil

    Reply

    • Phil,
      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.
      Charles

      Reply

Leave a Comment