**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 works in both versions of Excel.

**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.12.1). 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.

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:

- Open up a blank Excel spreadsheet
- Press
**Alt-TI**(i.e. hold down the**Alt**key and press the**T**and**I**keys). - On the dialog box that appears make sure that the Solver addin is checked. If not, check it and click on the
**OK**button. - 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:

- 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. - Open Excel, but
**don’t**try to open the realstats.xlam file that you downloaded earlier. - 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.

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

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**

- Open Excel
- Press
**Alt-TI** - Uncheck the
**Realstats**option on the dialog box that appears and click the**OK**button.

Hi,

I have some problem with real statistic add in, not sure if I am doing anything wrong.

I am trying to generate random numbers from a Poisson distribution. I have successfully installed the package and manage to generate numbers.

I have two problems.

1. I have to reinstall package every time I close and open Excel.

2. I cant reach the Poisson_Inv function from VBA.

Thanks,

Tomas

Tomas,

1. I don’t know why you would need to reinstall the package every time you open Excel.

Can you access the Real Statistics software when you press Ctrl-m?

Are you saying that Real Statistics disappears from the ribbon or that it doesn’t work at all and you need to press Alt-TI each time you open Excel and put a check mark next to the RealStats add-in in the list of add-ins? Or are you doing something else?

2. Can you use the POISSON_INV function in Excel?

If you can do this, but would like to also access it in a VBA program that you are writing, then please look at the following webpage:

Calling Real Statistics Functions in VBA

Charles

Hi,

Thanks for your reply.

1. Nothing happens when I press ctrl+m. Checkbox for Realstats is checked when I press Alt-TI but I cant access any formula, like poisson_inv. I have to browse, reopen the RealStat.xlam and replace the file to get formula to work.

2. Thanks. I can use POISSON_INV after I done above. I will look this up.

Tomas,

Very strange.

Charles

Hi,

Everything works as expected after I added the reference in VBA. Thanks for a great add-in!

Hi Carles,

I am trying to learn the time series forecasting module using your materials. I am using Mac and have downloaded the Real Statistics Resource but it looks like the Mac Version do not contain any time series forecasting functions, correct? Any updates on new mac resource to support that?

Thanks,

Peter

Peter,

The current Mac version of the software doesn’t support the time series capabilities. These are only available on the Windows version.

My problem is that I don’t have a Mac computer and so I need to find someone who will lend me their Mac so that I can test the latest version of the Real Statistics software (including the time series capabilities) on the Mac. As soon as I can get a Mac for testing I will release a new version of the software.

Charles

I’m having issues installing this with recently updating to 32 bit Office 2016 Excel.

After I install the plugin and exit Excel and reopen, it seems to forget the plugin. I have to reinstall it every time I want to use it. It still shows up under the plugins list but none of the functions show up when typing question nor ctrl-m works. Also all my old excel sheets are showing up like this: =’C:\RealStats.xlam’!FRIEDMAN(A4:AB16) which is strange because I installed the plugin in the directory suggested above. Any thoughts?

Jordan,

This seems very strange. I don’t know why Excel would forget the plugin. When you reopen Excel and then press Alt-TI do you see Solver and RealStats on the list of addins with check marks next to them?

Charles

Hi.

I installed the real statistics tool pack and it requires a password.

Is there a password?

Thank you

Miri,

You never need to supply a password to use the Real Statistics Resource Pack.

The usual reason for receiving this message is that the software has been downloaded but not installed. If the software is installed correctly, then when you press Alt-TI you should see RealStats and Solver on the list of add-ins with check marks next to them.

If not, you need to follow the installation instructions which can be found on the same webpage from where you downloaded the file containing the software.

Charles

Thank you for creating this great program.

I’m lecturer from Thailand.

I already downloaded and completely added this program to my MS Excel 2013.

I have plan to suggest my students to use this alternative statistics software.

Thank you again.

Korawin,

Thank you for your kind words and thank you for your support.

Charles

Hi,

I am using Mac 2011 version.

My problem is I couldn’t select the data range. I have to type the cell range manually.

Hopefully, you’ll catch up my problem here.

Thank you so much for your time.

Hi,

Unfortunately, due to limitations in Excel’s implementation of VBA on the Mac, you need to type in the cell range manually. I hope to address this in the future.

Charles

Any chance that RealStats will be included in the Office Add-Ins for Excel Online?

Andrew,

Currently RealStats is implemented using VBA. Unfortunately Excel Online doesn’t support RealStats.

Charles

Thanks for the response, and many thanks for the add-in

Good day Charles,

i really give kudus to you on this very great work.

i have done the downloading and install the software correctly, but whenever am trying to analyse using any of the tools, this is the message that usually comes up “Compile error in hidden module”. mainwhile, my system specification is window 8, 64 bit, and 2007 excel.

Thank you

Adepoju,

The usual reason for this is that Excel’s Solver is not activated.

To make sure, press Alt-TI and make sure that Solver is on the list of addins with a check mark next to it. Ideally Solver should be activated before RealStats is installed.

Charles

I have the same error message, but Solver is activated in Excel. Any other ideas?

Paul,

Which error message are you referring to? Compile error?

When you say that Solver is activated do you mean that when you press Alt-TI you see Solver on the list of addins with a check next to it?

Are you using Excel 2007?

Charles

Charles,

I also have the same error message.

“Compile error in hidden module: frmMatrix.” Solver is activated in my Exel 2013. I am trying to get EigenValues/Vector. So I press Ctrl+M—Select Matrix Operation—select input range—-tick EigenValues/Vector—click ok and I have the error appearing. Any suggestion?

Alessandro,

What do you see when you type the formula =VER() in any cell?

If you send me an Excel file with the matrix for which you are trying to calculate the eigenvalues/vectors I will try to figure out what is going wrong. You can find my email address at Contact Us.

Charles

Last week every thing was working, but today I cannot make real-stats work. I am using excel 2016 and windows 8.1. Is there a compatibility problem?

Also, it is a 64 bit processor

Mark,

I have not made any changes in the past week and so don’t know why the Real Statistics software was working one week ago, but not now. What sort of error message are you getting?

Charles

No error messages, I just cannot see Realstatistics in the Addins section of excel and the control -m does not bring it up either.

Dear C,

OK, I fixed it. I don’t know how, but it is working. Somehow, Excel was not seeing the file, so I reentered it in the addins manager to refresh Excel. We’ll see about tomorrow. Thank you for your kind replies.

— M

I understand the need for the EULA for your work.

If any of these cases occur, would you be willing to publish any Statistical Functions that are Open Source or Public Domain that you may be using separately from your existing solutions?

Jeremy,

I don’t understand what open source functions that you are referring to. I don’t have any open source function. I do, however, explain on the website how I calculate most of the functions in the Real Statistics software.

Charles

Hey,

Thanks so much for this post. This really does seem to provide an excellent variety of tools for Excel! I had no idea you could find a resource pack like this for free! I look forward to testing it out.

Best,

Dennis

Pingback: Paweł Kleka » Jeśli nie SPSS to co? [update]

Thank you very much for your website. I was taking a short course in Data Quality Acceptance that was heavy on hypothesis testing. I had very little experience in this… Through a web search I found your site and used some of the information to follow-along in my course via the Excel worksheets. I passed the course!

Dave,

Thank you for your comment. I am pleased that the Real Statistics website was helpful to you.

Charles

Dear Charles, thanks for make your programm available.

I can´t installa the last version of Real Statistics; I got an error message like:

MS Excel can´t access to file ……RealStats.xlam

Thanks in advance for yyour help

Jorge,

I downloaded the latest version of Real Statistics and everything worked fine. However, that was on my second attempt. On the first attempt only part of the file was downloaded and so Excel wouldn’t recognize it. I don’t know what caused the problem on my first attempt.

In any case, I suggest that you download the file again. The size of the file is about 2.6 MB.

Charles

Hi Charles, I’m trying to install the add-in and a window popped up asking for a RealStats Password! Is this what should happen?

Tom,

You never need to supply a password.

This will only happen if you tried to open the software file or didn’t install it properly as described on the same webpage from which you downloaded the software file.

When you press Alt-TI you should see both Solver and RealStats on the list of Excel addins with check marks next to them. If not, go back and read the installation instructions. Installation only takes a couple of minutes.

Charles

I just wanted to say thank you very much for making these fantastic tools available for everybody. I ma very grateful and appreciative.

Amin,

You are very welcome. I appreciate your comment and am pleased that you like the tools.

Charles

Good Morning Charles

Does the download work in Excel 2016?

Thank you

David Harris

Yes

I agree to the license agreement

Thank you

Hi Charles –

Thank you for putting together this add-in. I am really looking forward to using it for some more complex data analysis. Quick question: Does the Analysis ToolPak add-in have to be installed to use Realstats or just the Solver?

Thanks in advance for the help.

Jordan

Jordan,

As far as I aware, just Solver. Real Statistics does not use the Analysis ToolPak add-in.

Charles

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

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

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

Elizabeth,

You never need to provide a password. Usually when a person receives this message it means that the software was not installed properly. When you press Alt-TI you should see RealStats and Solve on the list of Excel add-ins with a check mark next to them.

Please look at the installation instructions on the following webpage.

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

Charles

Same here. Is there a password?

You don’t need the password. IF you receive this message, then the likely reason is that you haven-t installed the software correctly. Please read the Installation instructions on the referenced webpage.

If you have installed the software correctly, then when you press Alt-TI you will see RealStats and Solver on the list of add-ins with check marks next to them.

Charles

Thank you. As said in the instructions, Solver needs to be installed first and then the Real Statistics resource pack. Now it works.

Jamuna

Dear Charles

i am facing this problem while opening the realstat.

“compile error in hidden module: descriptor regression”

please suggest

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

I SEE THIS; 4.11 Excel 2010/2013/2016

WHEN TYPE =VER()

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

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

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

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!

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

I also get this error. Yes Solver and RealStats are on the list with check marks

Kerry,

I don’t know which comment you are referring to. Jorge’s? If so, then I suggest that you download the resource pack again.

If this is some other error, please let me know which problem you are referring to.

Charles

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

Scott,

This is a potential future enhancement.

Charles

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

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

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

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 😀

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.

Jonathan,

That is because you are using array formulas. You can-t simply press the Enter key when using array formulas. See the following webpage regarding how to use array formulas>

Array Formulas and Functions

Charles

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.

Jorge.

See Blogs, Aug 7 blog.

Charles

Thanks for your response. The security message did not appear, then the problem persist

Jorge

Hi

Sorry, problem is fixed

Thanks again for your support

Jorge

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

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

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

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

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!

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

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)

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

Hi,

Thank you for a great tool.

how do I reference the Real statistics resource pack in a scientific article?

Glad you found it useful. You can find the reference info at

Citations

Charles

the 64 bit excel version cannot work 🙁

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

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

Ram,

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

Charles

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.

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

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

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

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

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

Hello Tanya,

That is very strange. I saw this type of problem over a year ago, but not since then. If I remember correctly, this was not a Real Statistics problem, but an Excel problem which was related to the order in which addins were checked. For more information see http://www.real-statistics.com/disappearing-add-ins-ribbon/ or http://stackoverflow.com/questions/23841184/no-add-in-tab-though-add-in-is-loaded-and-working or google “Ribbon keeps disappearing Excel” or “addin ribbon not showing” or something similar.

Charles

Thanks Charles – I appreciate your reply and I will give those suggestions a try 🙂

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

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.

Susan,

Sorry, but the Real Statistics Pack for Excel 2016 only supports Windows. To use the Real Statistics Pack for the Mac, including Excel 2016, you need to use the Real Statistics Pack for Mac. See

Real Statistics Pack for Mac

Charles

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.

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

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

Jose,

You can find this information in the Blog section.

Charles

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

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

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.

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

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

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

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

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.

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

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

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

Hi,

My version was 4.4…, I updated and worked fine.

Thanks for your attention

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

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?

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

installthe addin as described on the webpage from which you downloaded the addin.Charles

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.

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

Joos,

I suggest that you do the following: Uncheck RealStats and restart Excel. Then check Solver and restart Excel. Finally, check RealStats.

Charles

That worked for me.

Thanks Charles,

Garret

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

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

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

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.

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

Thanks very much for a very useful pack.

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!

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.

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

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

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.

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

Thanks!

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?

Jay,

You need to choose Regression. Binary Logistic Regression is one of the options.

Charles

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?

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

This software will assist in pieces of research analysis

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!

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

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

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

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.

Shreya,

You don’t need to read a table to determine whether you have a significant result. See the following:

http://www.real-statistics.com/non-parametric-tests/mann-whitney-test/

Charles

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

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

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

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

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

Piero,

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

Charles

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.

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

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.

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

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.

Amit,

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

Charles

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.

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

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.

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

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

Hi Again,

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

Tom

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?

Tom,

Are you referring to the Add-Ins ribbon?

Charles

Hello,

Is there a 64-bit option available for the real statistics add-in?

Thanks.

Fel,

I have never tested the software with a 64-bit version of Excel.

Charles

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.

Andrew,

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

Charles

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.

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

Hi Andrew,

That you subtract the mean is correct when you calculate the correlation coefficient (and so R-square), but when you actually work out the matrix calculation, it is not necessary to subtract the mean in cases like this. In fact, this is true in general for multiple regression, even in the case without weights. See the following webpage for details:

http://www.real-statistics.com/multiple-regression/multiple-regression-analysis/multiple-regression-using-matrices/

Charles

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!

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

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.

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

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

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

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

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?

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

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

Matthew,

I doubt that Rel 4.6 will work on a Mac. This release has only been tested on Windows computers. You will need to use the Mac version of the software, which currently is an older release. You can download this release from Real Statistics Resource Pack for Mac.

Charles

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

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

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

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

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.

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

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?

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

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?

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

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

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

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

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

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

Dejan,

You can find it by first choosing Multivariate Analysis

Charles

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.

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

Thanks so much – it’s a mystery, but it works a treat!

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.

Jules,

Please see Author webpage regarding why I decided to publish this material.

Charles

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

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

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.

Mike,

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

Charles

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.

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.

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

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

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

Hi, Charles!

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

Thanks!

I have not added Cluster Analysis to the Mac version yet. You can only find it in the Windows version.

Charles

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.

Freda,

The website also explains how to carry out multiple regression and correlation manually.

Charles

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

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

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

Thanks,

Brian

Choose the Multivariate Analysis option and then the Cluster Analysis option from the resulting dialog box.

Charles

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

Andre,

You can find this in the Blog.

Charles

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

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

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

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.

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

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

Thanks for the prompt response!

So I’m probably being thick… but when I open up the add-in, these are the options I see. Where’s the radio box I’m supposed to tick? Thanks!

Image of options I’m seeing here: http://i.imgur.com/qBd7nQG.png

Felix,

Thanks for sending me the screen shot. That helped. Start by clicking on the Multivariate Analysis option and then clicking on the OK button. Next select one of the option, say Cluster Analysis, and click on the OK button.

Charles

Awesome, thanks! 🙂

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

Pete,

Sorry, but I don’t understand what the problem is. Can you explain it in more detail?

Charles

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

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…

See my previous response.

Charles

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

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

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

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.

Carlo,

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

Charles

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?

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

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

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

You are right. On Windows 7 you should omit the ‘roaming’ part too.

I do not see cluster analysis option in the available selections.

I am using office 2010

You need to first select Multivariate Analyses

Charles

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.

Hooman,

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

Charles

Dear Sir,

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

I appreciate.

Ram

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

First select

Multivariate Analyses.Cluster Analysiswill be one of the choices on the dialog box that then appears.Charles

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

Merci beaucoup.

Charles

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

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…

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

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?

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

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!

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

Hi

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

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

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

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

hello charles

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

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

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

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

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

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!

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

Thank you very much

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.

Thanks for your comment. Good to hear that you found the tool easy to use.

Charles

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

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

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

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?

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.

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

William,

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

Charles

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.

Rajvi,

People who get this type of message are usually trying to open the Real Statistic Resource Pack file. You should

neveropen this file, nor do you need to.If you have already

installedthe 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

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

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

David,

You should

notopen the file! Follow the instruction after opening ablankExcel file.Charles

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.

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

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.

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

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

Deyan,

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

Charles

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

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

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

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

Hi Charles,

I sent you my spreadsheet to czaiontz@gmail.com.

Thanks in advace,

Deyan

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

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

Deyan,

Are you referring to Excel 2010 or Excel version 10 (i.e. Excel 2002)?

Charles

Hi,

I mean Excel 2010.

Deayn

Deyan,

That is strange. I have run the logistic regression tool in Excel 2010 myself without any problems. If you send me your data I will try to understand what went wrong.

Charles

Hi,

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

thanks

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

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

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

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?

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

Pingback: How To Logistic Regression | Data Analysis with Excel

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 ?

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

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

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

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

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

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

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.

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

Charles

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?

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

Hi Charles, Yes, when i enter =ver() i receive exactly 3.2.6.

I wil try to re-install it again.

Sorry my mistake i receive 3.6.2 not 3.2.6

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.

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

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

Stefan,

Good to hear that you got it working.

Charles

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

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

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

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.

You shouldn’t try to open the RealStats.xlam file. Instead you should install it as described on the webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/. Once this is done, you can use Excel normally and it will give you access to the Real Statistics functions and data analysis tools.

Charles

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.

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

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

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.

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

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

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

Lei,

This is explained on the webpage .

Charles

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

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

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,

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

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?

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

It shows” compile error in hidden model analysis”

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

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

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,

Ben,

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

Charles

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.

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

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

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

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.

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

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?

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

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

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 theAdd-Insdialog box. Click on theBrowsebutton and search for the Real Statistics software at the file location you specified above. When you find it you need to click on theOKbutton. TheAdd-Insdialog box should reappear, but this time theRealStats 2007selection should appear in the list and should be checked (if not check it). Now click on theOKbutton 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

I am still unable to find why it is asking for password after following all of above instructions and click on the OK button. after cancelling that password box though Real statistics tab is appearing under the Add-Ins section. now when i try to use it VB error box saying “compile error in hidden module: Analysis”.

no out put so far. help is also not working. after clicking help tab under real statistics section VB error box saying “compile error in hidden module: FrmInput”.

Screen shots are:

http://s36.photobucket.com/user/nstatistics/media/Screenshot-11_20_20147_49_16PM_zps202f4397.jpg.html?filters%5Buser%5D=141974259&filters%5Brecent%5D=1&sort=1&o=2

Unfortunately, I don’t know why you are having this problem. Does the problem persist with the latest version of the software, which I put online on Monday?

One other option is to try to use the version of Real Statistics Resource Pack for Excel 2003 (which has a .xla extension instead of an .xlam extension) and see whether that works.

Charles

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.

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

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

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

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!

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!

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

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!

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

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

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

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.

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

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

Lahlou,

Please help me understand the nature of the problem that you are having.

Did you click on the link to the “Real Statistics Resource Pack” on the http://www.real-statistics.com/free-download/real-statistics-resource-pack/ and the file was not downloaded to your computer?

Or was the file downloaded to your computer but it didn’t work?

Charles

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

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 .

Hi,

You don’t need to “open” the program to use it, and so you don’t need the password. To use the program you must first “install” it. The instructions for doing this are simple and explained on the referenced webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/.

Charles

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.

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

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.

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

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!

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

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.

James,

The usual problem in these cases is that you need to follow the installation instruction on http://www.real-statistics.com/free-download/real-statistics-resource-pack/. You can’t simply open the Resource Pack file. Once you follow the installation instructions you should be able to use all the embedded macros. By the way, just in case this is not the problem you are encountering, which version of Excel are you using?

Charles

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

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

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

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

New Tools drop-down works for me!

Also, saw your posts about new studentized range distribution functions.

Thanks, Rich

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

Kevin,

The data analysis tools for logit and chi-square can be found by pressing Ctrl-m (or alternatively by pressing Alt-F8 and inserting InitStats).

The website describes these capabilities. For chi square see http://www.real-statistics.com/chi-square-and-f-distributions/ and especially http://www.real-statistics.com/chi-square-and-f-distributions/independence-testing/. For logit see http://www.real-statistics.com/logistic-regression/.

There is a brief description of all the data analysis tools at http://www.real-statistics.com/excel-capabilities/supplemental-data-analysis-tools/. All the Real Statistics supplemental functions are described at http://www.real-statistics.com/excel-capabilities/supplemental-functions/.

Charles

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

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

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

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

Declan,

Are you using Excel 2007?

Charles

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

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.

Hi Ed,

I have now created a new version of the software, specifically designed for Excel 2007. You can find it at http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-excel-2007/. Please let me know whether you have been able to download and install it successfully.

Charles

very useful

Thanks Rishi.

Charles

Any news on a Mac version for your resource package?

Thanks.

David.

Hi David,

Unfortunately I am still looking for someone to give me access to a Mac. A friend who has a MAC had a version of Excel but in a language which wasn’t English and so I couldn’t use it. I hope to be able to find a Mac sometime soon.

Charles

David,

I have just released a beta version of the Real Statistics Resource Pack for Mac. It only partially works: it provides access to the supplemental functions, but it does not yet give access to the data analysis tools. For more information, see http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/

Charles

Hi David,

Have you been able to download the latest Mac version of the resource package? Is it working well enough for your needs?

Charles

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

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

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?

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

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.

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

Hi Arturo,

The installation is really quite simple, but unfortunately, I don’t know why you and a few others are having this problem. Most people 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.

In any case, I will improve the explanation of the implementation process. Perhaps this will help. If not, perhaps other readers can offer some suggestions.

Charles

Hi Arturo,

I have now created a new version of the software, specifically designed for Excel 2007. You can find it at http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-excel-2007/.

There is also a new version designed for versions of Excel prior to 2007. You can find this at http://www.real-statistics.com/free-download/real-statistics-resource-pack/resource-pack-excel-2003/

Please let me know whether you have been able to download and install it successfully.

Charles

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

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

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

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-Insin Excel 2007 orFile > Help|Options > Add-Insin Excel 2010/2013, it is important that you look for theGobutton 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

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

Could you please advise what to do?

Regards

Owen

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

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

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

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 buttonat 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

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!

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

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

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

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.

Hi EMM,

After selecting

Office Button > Excel Options > Add-Insin Excel 2007 orFile > Help|Options > Add-Insin Excel 2010/2013, it is important that you look for theGobutton 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

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

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

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.

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.

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

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

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

Marcio,

You don’t need the password to install the package. After downloading the software to your computer, follow the instructions for installing the software as written on the webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/. You will then be able to use the software (without needing the password).

Charles

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

Thanks,

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

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

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

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

Dear Dr. Wadikar,

Go to the page http://www.real-statistics.com/free-download/real-statistics-resource-pack/. Right after the heading Download you should see a link called Real Statistics Resource Pack. Click on that link and the resource pack should download to your computer automatically. This should work, but let me know if you have any problems.

Charles

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

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

Charles

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

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

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

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