**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 2013 or 2016**

If you accept the License Agreement, click here on Real Statistics Resource Pack for Excel 2013/2016 to download the latest Excel 2013/2016 version of the resource pack that accompanies this website (Release 5.4.2). This software is compatible with Excel 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 2010**

If you accept the License Agreement, click here on Real Statistics Resource Pack for Excel 2010 to download the latest Excel 2010 version of the resource pack that accompanies this website (Release 5.4.2). This software is compatible with Excel 2010 and is named RealStats-2010.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 or 2007**

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.

**Real Statistics Resource Pack for Excel 2011 or 2016 for Mac**

If you are using a Macintosh version of Excel 2011/2016, click here for instructions on how to download and install 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.

**Troubleshooting**

If there is a problem during the installation try one or more of the following:

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

Most important, remember that **Solver** must be installed. To check this, press **Alt-TI** and make sure that Solver (as well as RealStats) is on the list of addins with a check mark next to it.

**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. - Close Excel and delete the file that contains the Real Statistics Resource Pack.

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

very useful

Thanks Rishi.

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

Hi Charles, I get this same error with Excel 2016 and the resource pack installed in the suggested folder. I can see Real Statistics in the Add-in menu in Excel, and I get a pop-up with ctrl-m. However, as Tien notes, I get a compile error when I click “OK.”

Paul,

What do you see when you enter the formula =VER()

Which data analysis tool did you select after pressing Ctrl-m? Do you get a Compile error when you make a different choice? What does the Compile error message say?

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

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.

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

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

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

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

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

Pingback: How To Logistic Regression | Data Analysis with Excel

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

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

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

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

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

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

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

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

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

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?

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

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

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

Thank you very much

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

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

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

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

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

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

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

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

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

Dear Sir,

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

I appreciate.

Ram

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

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

I am using office 2010

You need to first select Multivariate Analyses

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.

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

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

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

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

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! 🙂

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.

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

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

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

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

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

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

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

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

This software will assist in pieces of research analysis

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

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

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

Thanks!

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.

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.

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!

Thanks very much for a very useful pack.

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

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,

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

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

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

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

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

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

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 just wanted to say I have never read such careful, precise instructions for downloading and installing software. Thank you so much!

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 🙂

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

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

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

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,

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 🙁

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

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,

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

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

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

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

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 😀

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

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

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

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

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

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

Good Morning Charles

Does the download work in Excel 2016?

Thank you

David Harris

Yes

I agree to the license agreement

Thank you

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I had the same problem – Add-ins tab not showing in Ribbon in Excel 2016 with window 10

I solved the problem by google the thread

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_winother/add-ins-tab-not-showing-in-ribbon-in-excel-2016/70858ed7-8379-47eb-abdf-ee42fa070ef4

My solution is

right-click the RealStats.xlam file and choose Properties > General, check the Unblock box, and click OK.

George,

Thanks for sharing this.

Charles

Hi,

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

I tried downloading RealStats.xlam and I get the message

Failed – No file

Please help.

Please try again. I just downloaded the file with no problem.

Charles

Hi Charles,

Downloaded the latest 4.13 version. I have not had problems with a download for quite some time. But I had the following occur today.

After removing old version and replacing with new version, and marking the Block indicator on Properties screen, when Excel 2013 starts, an error message arises indicating wrong format of file or corrupt file. The resource package will not load. I do see that the download file is 1.3Mb-ish, and older versions of the resource pack are 2.5Mb-ish. I tried a few download attempts.

I was able to resort to previous version with no problem.

If you or others don’t see the same thing happen…I guess I will look for some other reason.

Regards, Rich

Rich,

Something strange must have happened when you downloaded the file. I just downloaded the file (twice just to make sure) and it downloaded fine. The file size is 2.67M.

Charles

Hi Charles

Thanks for clarifying the filesize. After successfully downloading the Resource Pack using other browsers, I isolated Firefox cache to be a potential problem. Clearing cache allowed the file to download completely. All is well.

Congratulations on delivering yet another release of your free suite of tools.

Regards, Rich

Hi! I had a little trouble with installing the Resource Pack. It’s just that when I check the solver add ins, a pop up saying that they couldn’t find the file or library would appear and followed by a password prompt and my excel would already stopped responding. After that, a pop up would appear saying that the solver add in should be disabled and it needs an update of the solver add in. I have been trying to do the same thing for how many times. I am in deep trouble. Somebody please help me! 🙁

Rash,

Have you followed the instructions on the following Microsoft webpage?

https://support.office.com/en-us/article/Load-the-Solver-Add-in-612926fc-d53b-46b4-872c-e24772f078ca

In particular, note the statement about the error that has been fixed regarding Excel 2016.

Charles

Hi, Charles! I followed the instructions on the link that you sent me and it worked! Thank you very much

Hi, whenever I try to install the resource pack, the message always show that Microsoft Excel has stopped working and excel has experienced a serious problem with real stats. What could be the reason for not being able to install it properly?

Thank you.

Pao,

Are you following the installation instructions on the referenced webpage or are you trying to open the file which you downloaded?

Charles

I was following the installation instructions. I even saved it in the folder location that you recommended but it is still not working.

Pao,

Which version of Excel are you using? Excel 2007? Excel 2011 for Mac?

What operating system are you using? Windows 10?

Charles

Hello Sir,

When I check the real-statistics add ins, a pop up saying that they couldn’t find the file or library would appear and followed by a password prompt. I have been trying to delete and reinstall but that doesnot help.

It is installed and it is there but the same pop-up.

I am in deep trouble. Hope you can help!

Nimisha,

See the following webpage

Password Prompt

Charles

This was not helpful.

Please explain what was not helpful.

Charles

Hi,

I had the same problem even though I have followed the instructions in this page. In my first (and failed) attempt to install the add-in, I have downloaded the RealStats.xlam to the Downloads folder and then made a copy in the suggested folder. Since the add-in is not working as expected, what I did is to delete the copies of RealStats.xlam that I have. Then I downloaded the file directly to the suggested folder (\Users\\AppData\Roaming\Microsoft\AddIns) and followed the installation procedure. Now the add-in seems to work. I hope this helps.

BUMP!

Hi,

I have trouble with installing Real Statistics.

After installation when I try to reach the Add-in I get an error message saying:

Run-time error ‘1004’:

Method ‘MacroOptions’ of object ‘_Application’ failed

I use Windows 7 Ultimate, 64 bit, Excel 2013.

I have checked that Solver is installed and I followed the installation instructions however it seems I am doing something wrong.

Could you help me to find the error?

Thanks in advance!

Agnes,

What do you see when you enter the formula =VER()

You said “After installation when I try to reach the Add-in…” What did you do to reach Add-in?

What happens when you press Ctrl-m

Charles

I downloaded the option for Macs, and found that many of the functions are not available such as the Tukey test for ANOVA. Are there plans for an update for this? Thanks!

Patty,

Yes, I am working on a new Mac release now.

Charles

Hi – I have followed the installation method but I can’t find a way to run the add-in. Ctrl-m doesn’t seem to do anything and there’s nothing on the macros page. When I go to customize the ribbon, the Add-in tab is ticked but I can’t add/remove anything to it and there’s no realstats symbol / word contained in the exploded list. I have found that if I press AltTI then uncheck and re-check the RealStats add-in, then press ok, the Add-in tab and RealStats symbol appear and work. However, if I save and close, when I re-open excel, the tab has gone again and I have to re-do the above to gain access! Any help much appreciated! Thank you

JK,

1. Ctrl-m should work, unless this key combination is being used by some other addin.

2. Regarding RealStats disappearing from the Addins ribbon and related issues, please see the following webpage:

http://www.real-statistics.com/appendix/faqs/disappearing-addins-ribbon/

3. If you choose Macros from the View ribbon and then insert InitStats in the dialog box that appears and then click on the Run button, you will be able to run the Real Statistics data analysis tools. This is not the easiest approach, but it should work.

4. The various Real Statistics functions should be available even if you don’t do any of the above steps. To make sure this capability is working, just enter the formula =VER() in any cell and you should get some information about the Real Statistics release.

Charles

Hello Charles,

First I want to thank you for sharing your tips and your programs it’s very helpfull.

I wanted too make a Jenks natural breaks optimiziation unforntunately it doesn’t work.

I have a tab of 24 columns and 24 ligns so 576 numbers. Maybe there is a limit for that method?

I tried with a smaller tab 8×8 and it works.

Thanks,

Yassine.

Actually it was just a problem of units. Everything works that’s great thanks !

Dr. Charles,

Thank you for your site and tools. You are an inspiration.

John

Hello Charles

I downloaded the RealStats for Excel 2010. The solver is installed and i checked the RealStats box in the add-ins. I need to use =Shapley. I can choose it but excel always ends up to tell me #NAME?. What can I do?

Nina,

Do you get a similar message when you enter the following formula?: VER()

I suggest that you close Excel. Reopen it and try again.

Charles

After installing on Excel v.10 I get a pop up asking for Realstats password. And I cannot close this pop-up. Please help.

Andrew,

See http://www.real-statistics.com/appendix/faqs/password-prompt/

Charles

Thank you for the incredibly useful Add In. I am using it to explore predictors of dropping out of high school.

A question: do you suggest criteria by which to chose either “newton’s method” or “solver”. Are they equally valid, equally established in canonical logistic analysis? Do they essentially yield the same results.

Bob,

They should yield the same result, although in general I would choose Newton’s method.

Charles

Thank you, how kind of you to share your creation.

Dear Charles

I installed your pack on my pc (Excel 2010) using your suggestions step by step.

It did not work and excell gave me this error:

https://msdn.microsoft.com/en-us/library/office/jj543304(v=office.15).aspx

Have you any suggestions?

all my best

Cristiano

Did you use the version of the software for Excel 2010? The file name should be RealStats-2010.

Charles

Hi Charles

yes

I used the version RealStats-2010.

Cristiano,

This type of error appears sometimes for a few users, but I don’t know what causes it. Let me ask you a few questions:

1. What language are you using for Excel (English, Italian, etc.)?

2. What do you see when you enter =VER() in any cell of a spreadsheet?

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

Charles

Dear Charles,

many thanks for the Real Statistics – it’s the best and most comprehensive add-in for Excel I have ever tried.

The only issue I have encountered is related to different user names when working with different computers: I used correlation function on one PC, then copied the file and tried to continue the work on another PC, but I have got #NAME? in many cells, which I solved partly by changing user name in the formula bar manually. While I was not able to do so with the array formulas. I think it should be a simple solution there as the installation directories principally are the same on both PCs: C:\Users\user-name\AppData\Roaming\Microsoft\AddIns.

Thank you very much,

Juozas

Juozas,

If the directories are identical (not just similar), then perhaps you don’t need to do anything special. In any case, the procedure to use is as described on the following webpage:

http://www.real-statistics.com/free-download/examples-installation/

Charles

Thank you, Charles, it helped me, plus I had to enable macros.

Best regards,

Juozas

Charles,

This is amazing! I am an experimental psychology PhD candidate and this has made my life 10000000000x easier. The only question I have is whether or not you intend to add a feature that allows me to perform a correspondence analysis anytime in the near future?

Thanks again,

you’re a life saver.

Brian,

I am very pleased that the Real Statistics software is useful to you. The inspiration for the website and software was the work my wife was doing in psychology and so I am especially pleased when someone in that field likes what I have been doing.

Yes, correspondence analysis is on my list of enhancements. I hope to get to it this year.

Charles

Just want to say thanks for this, and for providing it for free! It’s an awesome resource. Using it for matrix calculations using complex numbers (solving electrical circuit equations).

Jeremie,

Glad to see that the software has been useful to you.

Charles

Are John, Nagao and Sugiura’s Test on app?

Leonardo, sorry but I have not yet implemented this test in the Real Statistics software.

Charles

I just downloaded RealStat.xlam for add-ins instalation on my Excel 2013 followed the steps as shown in http://www.real-statistics.com/free-download/real-statistics-resource-pack/ , but after choosen the add-ins file it required password to continue. How can I get the password, because I tried to find this on the website there is no information about this circumstance.

Nafiek,

See http://www.real-statistics.com/appendix/faqs/password-prompt/

Charles

Dear Charles,

I have 2013 Excel, I tried to download the real pack but it keeps blinking for more than half hour without shown any time horizon when it is going to finish downloading, would you mind send it via email

Thanks

Mohammed,

There must be some problem with your Internet connection. I just downloaded the file and it took about 5 seconds. I suggest that you try again.

Charles

Hi,

I have read a lot about this add-in and I am very excited to use it. However after installation it is asking for “realstats password” ? Can somebody please help me with the password.

Thank You

See Password Prompt

Charles

Thank you for your prompt response Mr.Charles.

The add-in is not visible but I am able to use it by pressing ctrl-m.

Hi Mr. Charles,

I have a problem in using the Real stats, whenever I click ok on the realstats prompt this problem will pop: “Compile error in hidden module…..” What do you think is the problem?

Thanks ahead

Javin,

Here are three potential reasons for this problem:

1. Solver has not been installed. When you choose the Add-Ins option from the Tools menu, do you see RealStats and Solver in the list of addins with a check mark next to them?

2. See Hint 2 at http://www.real-statistics.com/appendix/faqs/disappearing-addin

3. The problem might be with the Trust Center settings. Click on

Optionsfrom theFileribbon and then choose theTrust Centeroption on the left side. Next click onTrust Center Settings …. Next click on theMacro Settingsoption on the left side and make sure that it isDisable all Macros with Notification. Also click on theTrusted Locationsoption on the left side and click on theAdd New Location…button to add RealStats folder as a trusted location.Charles

I solved it already, Thank you Mr. Charles. I just want to inform you that I was tasked to report a statistical software/application and I chose Real Statistics. I will recommend them to use this. Thank you again

Javin,

Thanks for recommending Real Statistics.

Charles

I am trying to download RealStats. I added the solver add-in and analysis took pack to my Excel (2013), however, the RealStats option for add-ins never appears in excel. When I click Browse, the realstats.xlam is not on my computer.

Katherine,

When you press Ctrl-m do you see the Real Statistics menu? When you enter the formula =VER() do you see the Real Statistics version number?

Charles

Neither one of those things happen. When I press ctrl-m, the computer makes that error noise when that doesn’t represent a function. The formula doesn’t work either…

Katherine,

This means that the Real Statistics software has not been installed.

Please follow the installation instructions that are found on the same webpage from which you downloaded the Real Statistics Resource Pack, namely

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

Charles

Hi. Solver is not an option in my Add-Ins menu. I’m using Excel 2010. Is this something I have to download?

Andrew,

Solver is not an option on the Add-Ins ribbon. You can find it on the Data ribbon.

For the purpose of the installation of Real Statistics, you need to press the key sequence Alt-TI. You should see Solver on the list of add-ins. The important thing is that this option have a check mark next to it.

Charle

Hi there. How will i know if I properly installed the real statistics resource pack? can I download and install the 2013/2016 version even if I just have the Excel 2010? is there any difference between the real statistics resource pack 2013/2016 and 2010 versions?

Daniel,

1. If the resource pack is properly installed, you should get a valid output for the formula =VER() and you should be able to press Ctrl-m and use the Descriptive Statistic data analysis tool.

2. I don’t think you will be able to use the 2013/2016 version of Real Statistics with Excel 2010

3. The differences are quite minor. In the 2010 version, the HYPEGEOM_INV and NEGBINOM_INV functions are not supported. Also all the Real Statistics functions are considered to be user-defined functions in Excel’s function help capability.

Charles

When I try to run a test I keep getting the error as follows: “Compile error in hidden module:Alalysis. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click “help” for information on how to correct this error.”

I have Office 2016. I am not computer savvy please help!

Scratch that. I figured it out! I forgot to check the Solver Add-in, that seemed to fix the issue.

Good Day!

Mr Charles Thank you for this site and add-in it’s a great help.

I want to ask you this:

A friend of friend consulted me for her research. She wants to know if there is a significant difference in lead content in water after putting fish scales. For the first experiment she put 100 grams of fish scale, on the second 110 grams and on the third 120 grams. Per experiment she only have 1 observation. Initially I said that there is no statistical treatment for it. Am i correct? or is there a treatment ideal for that? thanks ahead!

Nelson,

With only 3 observations (1 for 100, 110 and 120 gm) you can certainly compare the lead content, but you won’t be able to do anything regarding statistical significance.

Charles

Dear Charles,

Thank you so much for providing this wonderful package! Initially, I had some problems with installation, and perhaps the solution I found may be useful for others. The App Data folder was not visible in my Win10 file explorer. However, by selecting the file in the download folder and then selecting the “Move to ” option, I could navigate to this folder and select the microsoft Addins folder as location. I think you should move the recommendation to right click the file first of all and check “unlock” under properties.

Once again, thank you for sharing this resource with everyone!

Dear Fridtjof,

Thank you for your suggestion.

When you say, “I think you should move the recommendation to right click the file first of all and check ‘unlock’ under properties,” do you mean “remove” this recommendation or “move” it to a more visible place on the website?

Charles

I am awed. Wonderful site and contribution to statistical literacy. Thank you.

Thanks Bernie.

Charles

Charles thank you so much for sharing and explaining this with everyone. Your instructions are straightforward and easy to follow, and the stats package is really fantastic, I use it all the time. It is so good of you to share this.

Best wishes

P.s. and that goes for the rest of the site too!

Lizzy,

Thank you very much. I am very pleased that you are getting value from the website and software.

Charles

Hi Charles, I wanted to let you know that the real-stats tool is very helpful in my everyday work. While working recently on “Time series” calculations for a set of ~20 data points, I observed that whether I check “Simple moving average” or “Weighted moving average”, the tool derives only a simple moving average and the header for the forecast table also reads “Simple moving average” though other parameters like weights that I assigned have been included in the calculation/visible in the output. The MAE/MSE values, though are different across the categories (Simple moving and weighted moving averages). With my limited knowledge, I think this is a bug in the tool. Thank you for looking into this!

Best regards,

Natraj

Hi Natraj,

I have just checked what happens on my computer, and I clearly see that the output from the weighted moving average option is labeled “weighted” and gives different output from the simple moving average option. I don’t know why you would see something different.

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

Charles

Thanks Charles, I have shared the Excel file for your reference

Hi Charles,

I’m really interested by your plugin which seems to be exactly what I’ve been looking for since I started using Excel a long time ago. I’ve just installed the 2010 version onto my computer and the installation seemed to go fine. I restarted Excel and tried it out, but not of the functions (eg. =DPTEST(C6:C16)) are working I just keep getting Excel asking if I typed a name. Could it because I’m using French Excel and the names of the functions are often different (eg. =STDEV is =ECARTYPE)?

I hope I can get this working it would be a great aid to me…

Andrew

Hi Andrew,

The software should work no matter which language for Excel you use, including French. I use the Italian and English versions myself.

If when you enter the formula =VER() you get and error, then the software was not installed or was not installed properly.

When you press Alt-TI you should see RealStats-2010 and Solver on the list of addins with a check mark next to them. If not the software was not installed.

See the webpage where you downloaded the software for the installation instruction. This only takes a couple of minutes, but it does need to be done.

Charles

Hi Charles,

Thanks for your reply. That’s great news that RealStats works on non-english installations of office. I tried =VER() and Excel is asking if I typed a name, so it looks like a bad installation. However, I did follow the instructions to the letter. Alt-TI doesn’t work on my French installation and I’m not sure what the equivalent is, but when I go to file/options/addins/go (or the french equivalent) I get the window and Solver and RealStats2010 are both ticked. This might be the same problem others were having with 2010 64-bit Excel. I’ll try reinstalling and installing on another computer.

Andrew

So I just installed RealStats on another PC. Both are running Windows 7 and Excel 2010 but the one I just installed on is 32-bit Windows. I did exactly the same as the first install and it works. I also tried copying the newly downloaded (and working) RealStats-2010.xlam file to replace the one that isn’t working. That didn’t help either so it may be a 64-bit issue.

I also tried this just in case but no joy:

“The problem might be with the Trust Center settings. Click on Options from the File ribbon and then choose the Trust Center option on the left side. Next click on Trust Center Settings …. Next click on the Macro Settings option on the left side and make sure that it is Disable all Macros with Notification. Also click on the Trusted Locations option on the left side and click on the Add New Location… button to add RealStats folder as a trusted location.”

Andrew,

Some people tell me that RealStats works with 64 bit Excel and others say that it doesn’t. I am sure, however, that it works with 64 bit Windows.

The Trust Center issue has come up with a number of people and I plan to add this as an FAQ on the website.

Thanks for your observations. I appreciate your help.

Charles

I finally figured out the 64-bit install issue! It appears to be a trust issue with the XLAM file itself. Looks like a new Windows “feature” introduced recently…

Try this (either before or after installing):

1. Go to where the RealStats.xlam file is located (see above).

2. Right click on the file, select Properties and look at the bottom for the following: “Security: This file came from another computer and might be blocked to help protect this computer”. There is an Unblock check-box next to this warning.

3. Check the Unblock check-box, close Properties, and the security message disappears.

After doing the above, and opening Excel in the normal way, =ver() and Ctrl-m work as expected. Yea!

I’ve just tried the fix that Kevin suggested in this thread and I can confirm that it works. Thanks a ton for sharing that Kevin. Well played!!!

Pingback: Ohjeita opintojen nopeuttamiseksi – Site Title

Dear Dr. Charles,

Please, to your installation instructions for Excel 2016, add this step. File>Options>Trust Center>Trust Center Settings>Trusted Locations>Add new location>Browse> C:\Users\username\AppData\Roaming\Microsoft\AddIns\>ok.

In fact Excel 2016 refuses to even start-up if you don’t perform the above-mentioned step.

P.S. I have been a big fan of your work since many years, and have introduced real-statistics add-in to my students. However, I was surprised that you don’t write many research articles, which should be really easy for someone like you who understands data analysis so well. I am curious to know what you are doing these days. And by the way congrats on publication of your book on Excel.

An admirer from Pakistan!

Greeting from Italy to someone in Pakistan,

I plan to add the reference to the Trust Center shortly.

I started my career in academia, but until a few years ago I have having largely focused on the networking business, esp. Internet. I am now retired and so have returned to more mathematical pursuits.

Charles

Hi,

I saw the tutorial on Youtube, Logistic Regression Using Excel, trying to follow the process.

However, I cannot see Logistic regression from Add-in, statistic.

The closest one is Multiple Logistic regression, which I believe is not the same thing.

I have Excel 2013 and used Real Statistics Resource Pack for Excel 2013/2016.

George,

It is the option just above Multiple Logistic Regression. It is called Binary Logistic and Probit Regression

Charles

Thank You! I just followed the steps and it works. What a result :). Thank you for this website and all the work involved.

Impressed by the ease of explanations I hope I can learn it fast enough for my thesis.

Thanks, I hope I can use it for my Thesis

Thank You Charles! I just followed the steps and the Real Statistics Add-Ins works. It is great to share such a valuable work.

Pierre Claude, Geoscientest

I’ve loaded and installed the “Real Statistics Resource Pack for Excel 2010”. Then I’ve went through all steps as recommended.

Now I’m trying to use your function and .excel answers that “binom_power” or “benom_size” are not valid.

I assume that I’m missing something either at the installation stage or when using these functions.

Thank you for your help.

Mark,

What do you see when you enter the following formula? VER()

Charles

Downloaded relstats-2010 but is asking for a password. What is the password.

Hello,

Please disregard my comment. Eventually managed to install the pack.

Thank you.

Hi,

Can I use the real statistics pack in my work?

Toyang

Toyang,

You are free to use the Real Statistics pack in your work as long as you adhere to the License Agreement.

Charles

I Agree

Hi- When I try to use the add-in I receive the error “Run-time error ‘1004: Method ‘MacroOptions’ of object’_Application failed. Is there a known fix for this?

Andrew,

I am not familiar with this error.

I suggest that you look at the Troubleshooting section of the webpage http://www.real-statistics.com/free-download/real-statistics-resource-pack/

Charles

trying to load the .xlam i get

Microsoft Visual Basic for Applications

“errors occurred during load”

I have performed the troubleshooting steps

Vas,

I have not seen this error message before. Which version of Excel are you using? I suggest that you download the Real Statistics file again and redo the installation as described on the webpage.

Charles

Hi Charles,

I am using Excel 2016 on windows 10 64 bit fully updated. I have tried several times to make it work. I re-downloaded, unlocked it, tried all the troubleshooting suggestions. It just won’t load. Keep getting the above message.

Vas,

I don’t completely understand what you mean when you say that it won’t load. When you press Alt-TI do you see RealStats and Solver on the list of addins with a check mark next to each of them?

Charles

Charles, i did an online repair of my office installation trying to fix the problem.

When i press Alt-TI i see the RealStats and Solver addins with no check marks next to them. When i check mark, for example, the solver addin only, i get :

“errors occurred during load

‘Microsoft Excel cannot access the file C\Program Files\Microsoft Office\Root\Office16\Library\Solver\Solver.xlam”

When i go to that location the file is there….

I get the same error when i check mark only the RealStats.xlam.

The only Addins with tick marks i have are:

Analysis Toolpack

Analysis Toolpack-VBA

Vas,

If you can’t check the Solver addin then you have some sort of Excel problem. You need to solve this problem before you install the Real Statistics software.

I suggest that you lookup how to install Solver using google search (or some other search engine). I have never encountered this problem before.

Charles

Hello,

I downloaded The Real Statistics Resource Pack to the place mentioned above. However, when I tried to install, clicking on Browse to find and choose the realstats.xlam fileit. Finally, I clicked the OK. It said not finding the file, asking me to input the real state password. What can I do with this problem.

Wendy,

See the following Password Prompt.

Charles

Hello, My name is Ayu. I’m student of Pharmacy in Yogyakarta, Indonesia. Can you help me, i have trouble with installing resource pack Real Stat for my Ms.Excell 2013.

when i’m installing, it needs a password. Can you tell me the password, please?

Ayu,

See Password Prompt.

Charles

Hello,

I am trying to use your tool to produce confidence/prediction interval plots but I am continually being told that I have an “Invalid input range X selected”. From what I can tell, I followed your directions perfectly, the only difference are my actual numbers.

Any idea what’s going on here?

Catharine,

I just tested that data analysis tool and was able to use it without any error.

If you send me an Excel file with your data and tell me what is the address of the range you inserted into Input Range X, I will try to figure out what is causing your problem.

Also, what version of Excel are you using?

Charles

Hello,

I have been attempting to download your resource pack for Real Stats to use the Fleiss’ kappa tool in Excel. I have Excel 2013. The solver add in is checked and it shows up in the add ins as instructed and shows up when I click Alt T-I in Excel but I cannot seem to access the tools in any way (through Control M or trying to add it to the ribbon) in new Excel files. I have tried to open the downloaded “Real Stats” file as well but it does not open. Is there something I am missing? Thank you so much for your assistance.

Sarah,

When you press Alt-TI do you see RealStats on the list of addins? If you see it on the list, then make sure that it has a check mark next to it. If you don’t see it then you need to click on the Browse button to locate where you stored the file that contains the resource pack.

When you have the software properly installed, then Ctrl-m should work. Also the formula =VER() should return am appropriate value.

Charles