Frequently asked questions:

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

Additional FAQs will be added as necessary.

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

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

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

Karnan,

It will work provided you can install the software. I believe this is not the case for some online uses.

Charles

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

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

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.

Jean,

Thanks for sharing your experience with others.

I understand from your comment that the problem is now gone. If not, please let me know.

Charles

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.

Glad you find the website to be helpful.

Standard deviation of the

sample meanis the standard deviation of population divided by sqrt(n). Seehttp://www.real-statistics.com/sampling-distributions/basic-concepts-sampling-distributions/

This is not the same thing as the standard deviation of a sample is the std deviation of the population divided by sqrt(n).

Why do you think that the sqrt (N-n)/Sqrt(N-1) formula is absurd? The error estimate is only small (I presume by .99 you meant .01) when the population is large; when the population is small the difference can be noticeable.

Charles

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,

Monica,

This message usually comes up when Solver has not been installed. In any case, please look at the

Troubleshootingsection on the following webpage:http://www.real-statistics.com/free-download/real-statistics-resource-pack/

Charles