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, 2016, 2019, 2021 or 365 on Windows. If you are using Excel 2007 click here. If you are using Excel 2003 or a prior version of Excel click here. Finally, 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, 2016, 2019, 2021 and 365, the 32-bit version and the 64-bit version. Most people use the 32-bit version. The Real Statistics Resource Pack works in both versions of Excel.
Download
Real Statistics Resource Pack for Excel 2010, 2013, 2016, 2019, 2021 or 365 for Windows
Two versions of the software are available. The first provides help support (via Insert Function fx) for Real Statistics worksheet functions but can slow down certain Excel operations. The second version omits this support but does not degrade Excel operations.
- Version 1: If you accept the License Agreement, click here on Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/365 with help to download the latest Excel for Windows version of the resource pack that accompanies this website (Release 9.2.2). This version includes worksheet function help support and is named XRealStats.xlam.
- Version 2: If you accept the License Agreement, click here on Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/365 w/o help to download the latest Excel for Windows version of the resource pack that accompanies this website (Release 9.2.2). This version does not include the worksheet function help support and is named XRealStatsX.xlam.
Both versions of the software are compatible with all Windows releases of Excel from 2010 until the present. After downloading the software make sure that you install the software as described below.
Downloading either 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, 2016, 2019 or 365 for Mac
If you are using a Macintosh version of Excel, click here for instructions on how to download and install the Real Statistics Resource Pack.
Solver Installation
Before trying to install the Real Statistics Resource Pack make sure that Excel’s Solver is installed on your computer. You can 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 add-in is checked. If not, check it and click on the OK button.
- If the Solver add-in was not checked you need to close the Excel file before proceeding to the Real Statistics installation.
You can also accomplish step #2 by selecting Developer > Add-ins|Excel Add-ins.
Real Statistics Installation
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 XRealStats.xlam or XRealStatsX.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 simply 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.
Figure 1 – Add-Ins dialog box 1 - Check the Xrealstats or Xrealstatsx option on the dialog box that appears (see Figure 2) and click the OK button. NOTE: If you have previously activated a different version of the Real Statistics software you must uncheck the option corresponding to that version.
- If this option doesn’t appear, click on Browse to locate and then choose the xrealstats.xlam or xrealstatsx.xlam file. Then complete step 4 as described above.
Where to place the Real Statistics Resource Pack
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 username in Microsoft Windows. Since some of these folders are hidden, you may find it convenient to enable showing hidden folders. For example, in Windows 10 or 11 you can do this by opening Settings and then typing Show Hidden Files and Folders in the search field. Next, check on the Show hidden files, folders, and drives option in the dialog box that appears, and then click on the OK button.
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 checkbox. 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 …. Now, 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 the XRealStats or XRealStatsX file as a trusted location.
- Try opening a blank Excel worksheet and press Alt-TI. Uncheck the Xrealstats add-in and close Excel. Now open a blank Excel worksheet and press Alt-TI. This time check the Xrealstats add-in
Most importantly, remember that Solver must be installed. To check this, press Alt-TI and make sure that Solver (as well as Xrealstats or Xrealstatsx) is on the list of add-ins with a checkmark 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 on the Tools menu of the website (or at Real Statistics Software Capabilities).
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
- Clicking on an icon on the Add-Ins ribbon or
- Clicking on an icon on the Quick Access Toolbar or
- Via the Macro dialog box
A dialog box will now appear that 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 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 Data Analysis Tools.
Uninstalling the Real Statistics Resource Pack
- Open Excel
- Press Alt-TI
- Uncheck the Xrealstats or Xrealstatsx 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 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!
Hi Carles,
I am trying to learn the time series forecasting module using your materials. I am using Mac and have downloaded the Real Statistics Resource but it looks like the Mac Version do not contain any time series forecasting functions, correct? Any updates on new mac resource to support that?
Thanks,
Peter
Peter,
The current Mac version of the software doesn’t support the time series capabilities. These are only available on the Windows version.
My problem is that I don’t have a Mac computer and so I need to find someone who will lend me their Mac so that I can test the latest version of the Real Statistics software (including the time series capabilities) on the Mac. As soon as I can get a Mac for testing I will release a new version of the software.
Charles
I’m having issues installing this with recently updating to 32 bit Office 2016 Excel.
After I install the plugin and exit Excel and reopen, it seems to forget the plugin. I have to reinstall it every time I want to use it. It still shows up under the plugins list but none of the functions show up when typing question nor ctrl-m works. Also all my old excel sheets are showing up like this: =’C:\RealStats.xlam’!FRIEDMAN(A4:AB16) which is strange because I installed the plugin in the directory suggested above. Any thoughts?
Jordan,
This seems very strange. I don’t know why Excel would forget the plugin. When you reopen Excel and then press Alt-TI do you see Solver and RealStats on the list of addins with check marks next to them?
Charles
Hi.
I installed the real statistics tool pack and it requires a password.
Is there a password?
Thank you
Miri,
You never need to supply a password to use the Real Statistics Resource Pack.
The usual reason for receiving this message is that the software has been downloaded but not installed. If the software is installed correctly, then when you press Alt-TI you should see RealStats and Solver on the list of add-ins with check marks next to them.
If not, you need to follow the installation instructions which can be found on the same webpage from where you downloaded the file containing the software.
Charles
Thank you for creating this great program.
I’m lecturer from Thailand.
I already downloaded and completely added this program to my MS Excel 2013.
I have plan to suggest my students to use this alternative statistics software.
Thank you again.
Korawin,
Thank you for your kind words and thank you for your support.
Charles
Hi,
I am using Mac 2011 version.
My problem is I couldn’t select the data range. I have to type the cell range manually.
Hopefully, you’ll catch up my problem here.
Thank you so much for your time.
Hi,
Unfortunately, due to limitations in Excel’s implementation of VBA on the Mac, you need to type in the cell range manually. I hope to address this in the future.
Charles
Any chance that RealStats will be included in the Office Add-Ins for Excel Online?
Andrew,
Currently RealStats is implemented using VBA. Unfortunately Excel Online doesn’t support RealStats.
Charles
Thanks for the response, and many thanks for the add-in
Good day Charles,
i really give kudus to you on this very great work.
i have done the downloading and install the software correctly, but whenever am trying to analyse using any of the tools, this is the message that usually comes up “Compile error in hidden module”. mainwhile, my system specification is window 8, 64 bit, and 2007 excel.
Thank you
Adepoju,
The usual reason for this is that Excel’s Solver is not activated.
To make sure, press Alt-TI and make sure that Solver is on the list of addins with a check mark next to it. Ideally Solver should be activated before RealStats is installed.
Charles
I have the same error message, but Solver is activated in Excel. Any other ideas?
Paul,
Which error message are you referring to? Compile error?
When you say that Solver is activated do you mean that when you press Alt-TI you see Solver on the list of addins with a check next to it?
Are you using Excel 2007?
Charles
Charles,
I also have the same error message.
“Compile error in hidden module: frmMatrix.” Solver is activated in my Exel 2013. I am trying to get EigenValues/Vector. So I press Ctrl+M—Select Matrix Operation—select input range—-tick EigenValues/Vector—click ok and I have the error appearing. Any suggestion?
Alessandro,
What do you see when you type the formula =VER() in any cell?
If you send me an Excel file with the matrix for which you are trying to calculate the eigenvalues/vectors I will try to figure out what is going wrong. You can find my email address at Contact Us.
Charles
Last week every thing was working, but today I cannot make real-stats work. I am using excel 2016 and windows 8.1. Is there a compatibility problem?
Also, it is a 64 bit processor
Mark,
I have not made any changes in the past week and so don’t know why the Real Statistics software was working one week ago, but not now. What sort of error message are you getting?
Charles
No error messages, I just cannot see Realstatistics in the Addins section of excel and the control -m does not bring it up either.
Dear C,
OK, I fixed it. I don’t know how, but it is working. Somehow, Excel was not seeing the file, so I reentered it in the addins manager to refresh Excel. We’ll see about tomorrow. Thank you for your kind replies.
— M
I understand the need for the EULA for your work.
If any of these cases occur, would you be willing to publish any Statistical Functions that are Open Source or Public Domain that you may be using separately from your existing solutions?
Jeremy,
I don’t understand what open source functions that you are referring to. I don’t have any open source function. I do, however, explain on the website how I calculate most of the functions in the Real Statistics software.
Charles
Hey,
Thanks so much for this post. This really does seem to provide an excellent variety of tools for Excel! I had no idea you could find a resource pack like this for free! I look forward to testing it out.
Best,
Dennis
Thank you very much for your website. I was taking a short course in Data Quality Acceptance that was heavy on hypothesis testing. I had very little experience in this… Through a web search I found your site and used some of the information to follow-along in my course via the Excel worksheets. I passed the course!
Dave,
Thank you for your comment. I am pleased that the Real Statistics website was helpful to you.
Charles
Dear Charles, thanks for make your programm available.
I can´t installa the last version of Real Statistics; I got an error message like:
MS Excel can´t access to file ……RealStats.xlam
Thanks in advance for yyour help
Jorge,
I downloaded the latest version of Real Statistics and everything worked fine. However, that was on my second attempt. On the first attempt only part of the file was downloaded and so Excel wouldn’t recognize it. I don’t know what caused the problem on my first attempt.
In any case, I suggest that you download the file again. The size of the file is about 2.6 MB.
Charles
Hi Charles, I’m trying to install the add-in and a window popped up asking for a RealStats Password! Is this what should happen?
Tom,
You never need to supply a password.
This will only happen if you tried to open the software file or didn’t install it properly as described on the same webpage from which you downloaded the software file.
When you press Alt-TI you should see both Solver and RealStats on the list of Excel addins with check marks next to them. If not, go back and read the installation instructions. Installation only takes a couple of minutes.
Charles
I just wanted to say thank you very much for making these fantastic tools available for everybody. I ma very grateful and appreciative.
Amin,
You are very welcome. I appreciate your comment and am pleased that you like the tools.
Charles
Good Morning Charles
Does the download work in Excel 2016?
Thank you
David Harris
Yes
I agree to the license agreement
Thank you
Hi Charles –
Thank you for putting together this add-in. I am really looking forward to using it for some more complex data analysis. Quick question: Does the Analysis ToolPak add-in have to be installed to use Realstats or just the Solver?
Thanks in advance for the help.
Jordan
Jordan,
As far as I aware, just Solver. Real Statistics does not use the Analysis ToolPak add-in.
Charles
I love the idea of this, however I am only able to find the TRIMMEAN function through typing a normal excel string. Any ideas of why the other functions are not available?
TIA
Thomas,
TRIMMEAN is a standard Excel function and so you will find it by typing a normal Excel string. You should also be able to do this with any of the Real Statistics functions provided you are using a version of Excel after Excel 2007. For Excel 2007, the functions are there and so you can use them, but they won’t appear as you type them.
Charles
There is a window that is asking me for RealStats password. There is a password?
Elizabeth,
You never need to provide a password. Usually when a person receives this message it means that the software was not installed properly. When you press Alt-TI you should see RealStats and Solve on the list of Excel add-ins with a check mark next to them.
Please look at the installation instructions on the following webpage.
https://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
Hi Charles,
I just downloaded the Real Statistics Resource Pack (Release 4.11). I have Windows and a 32-bit version of Excel. Unfortunately, I keep getting the notice “Compile error in hidden module: logistic regression”. Do you have any suggestions on how to fix this?
Thank you in advance!
Ed,
Is Excel’s Solver installed? To check, press Alt-TI and see whether Solver and RealStats are on the list with check marks next to them.
Charles
I also get this error. Yes Solver and RealStats are on the list with check marks
Kerry,
I don’t know which comment you are referring to. Jorge’s? If so, then I suggest that you download the resource pack again.
If this is some other error, please let me know which problem you are referring to.
Charles
Will this be made available for the 64 Bit version of Excel 2013?
Scott,
This is a potential future enhancement.
Charles
Thanks Charles.
These functions look incredibly useful so it would be good to be able to use this on a 64bit version of Excel.
I am running it on an old computer at the moment, but will check periodically to see if this is added as my 64 bit machine is much faster!
Thanks for this.
Scott
Dear Charles,
I would really like a 64-bit version too, as I don’t have a 32-bit version. I’m a VBA-coder myself, and always use a snippet like this as declaration (it allows IFs and THENs, don’t remove the #):
#If VBA7 And Win64 Then
Public Declare PtrSafe Function MessageBeep Lib “user32” (ByVal wType As Long) As Long
#Else
Public Declare Function MessageBeep Lib “user32” (ByVal wType As Long) As Long
#End If
I hope you’ll implement this. You website is incredibly useful for a PhD-student like me (microbiological epidemiology).
Greetings from The Netherlands,
Matthijs Berends
Matthijs,
I would be happy to provide a 64 bit version, but don’t know how to do it and am unclear how much work is involved. If all I need to do is replace every function declaration as you described, then perhaps I could do it,but I have a feeling that there is a lot more work involved.
Charles
Thank you so much, Charles for sharing this tips. Your tips really help me a lot for my assignment. I need a data analysis tool to help me analyse data for my assignment, however, it is very troublesome to download the SPSS or Eviews. I’ve struggling with my assignment for few days. Fortunately, i saw your website and your tips.
Thank you Thank You 😀
I installed the add-in and the functions show up. However, I only get results in one cell. For example, descstats() only produces one result which a cell with the text “count” and nothing else in adjacent cells. The same thing happens with other functions.
Jonathan,
That is because you are using array formulas. You can-t simply press the Enter key when using array formulas. See the following webpage regarding how to use array formulas>
Array Formulas and Functions
Charles
Dear Dr Zaiontz
I install the last version (4.11) and it works fine, but when I close the excel workbook and open a new one, the real statistics add in did not appear on addin menu. I tried again opening the workbook as administrator, and the addin did not appear on menu.
Jorge.
See Blogs, Aug 7 blog.
Charles
Thanks for your response. The security message did not appear, then the problem persist
Jorge
Hi
Sorry, problem is fixed
Thanks again for your support
Jorge
Dear Dr Zaiontz,
Time ago I found a book entitled “Statistics for terrified biologists” by Elmut van Emden. Since I am a biologist and I was terrified, I starded to read it. My terror was amplified by that book and I made no progress.
I was hopeless when I found your web site, and it was like finding a treasure! It’s not only the software, that’s simple and useful, it’s the rest of your website too, “an incredible wast of time”, if you think like a big company manager. “That’s academic mentality at its best, this Dr. Zaiontz must be a professor, and he must be very passionate about his work”, I thought. Imagine my surprise when I googled you. A manager! LOL. It’s incredibly generous, all this time didecated to share your knowledge and help others. Thank you.
That was years ago. In the meantime I started “loving” statistics and learned to use R, as I needed some analysis not covered by your software (linear mixed models for repeated measures), but I kept suggesting your website to my terrified biology students, until now: we updated our lab PCs and they have all the 64-bit Excel version!
Don’t you have in mind a 64-bit compatible version of your add-in?
If you don’t, I’m going to take back the old PCs from the garbage!
Con sincero affetto,
Andrea
Andrea,
I am very gratified by your very kind comments. It is nice to hear that my website is like finding a treasure.
Yes, I was a manager, but I have been a teacher as well.
I am updating the website and software all the time, and hope to add some of the capabilities that you find useful from R.
I don’t have any immediate plans to release a 64-bit Excel compatible version of the software since I haven’t yet received too many requests for it.
Charles
Hi,
Thanks a lot for this great post. I have followed all the steps that are described above, however in one of these steps I am asked to provide a RealStats Password but I don’t know how can I get a valid password.
Could you please help me?
Thanks
Juan Carlos,
First of all, you never need to provide a password to use the software. You should also never try to open the file containing the Real Statistics addin that you downloaded from the website.
To avoid the password message, I suggest that you do the following:
1. Open a new Excel spreadsheet (don’t try to open the Real Statistics file)
2. Press the Alt-TI key combination.
3. Make sure that you find Solver on the list of Excel addins and make sure that there is a check mark next to the Solver entry.
4. Quit Excel
5. Open a new Excel spreadsheet
6. Press the Alt-TI key combination again
7. Click on the Browse button and find the file where you have stored the Real Statistics addin and then click the OK button.
8. This should bring up the list of Excel addins again. Make sure that RealStats appears on this list with a check mark next to it.
9. Press the OK button.
Charles
Charles,
Thanks for this resource. It has been quite useful. I have been running a binary logistic regression at work. Everything has been fine except when I close and reopen the file, the “Add-ins” tab disappears and I have to redownload a new version. Now it is not letting me run it at all. It keeps coming up with an error message saying the error commonly occurs when the code is incompatible with the version, platform or architecture. But nothing has changed since the last time I ran it. Any ideas?
Thanks!
Amy,
Have you read the blog on what to do about Real Statistics disappearing from the Addins ribbon? See Blogs.
This may help. If not, please tell me which version of Excel you are using and what is the output from the =VER() function?
Charles
Hi Charles,
First I want to thank you for the shared material.
I wish to install the package and pressing “ALT + T + I” I do not get any results. Surely it is because I have the version in Spanish and that combination does not apply. Could you guide me to do?
Regards
Adrian (from Argentine)
Hi Adrian,
As described on the referenced webpage, you can do the following instead:
Select File > Help|Options > Add-Ins and click on the Go button at the bottom of the window (see Figure 1 from referenced webpage).
Charles
Hi,
Thank you for a great tool.
how do I reference the Real statistics resource pack in a scientific article?
Glad you found it useful. You can find the reference info at
Citations
Charles
the 64 bit excel version cannot work 🙁
Dear Charles,
Thank you very much for this new release 4.9. it is fantastic.
Do you plan to translate in fine this huge work in French ?
Mohamed
Hi Charles,
Sure i am using MS excel 2013 prof plus 64bit. But instead of row 2500 x 12 column using row 250 x 12 column for five classes. it is working fine on my system.
Ram
Ram,
That is great news. Thanks for telling us that Real Statistics is working with the 64 bit version of Excel.
Charles
Hi,
I am using data have row 2501 and column 13 entries having 5classes, starting from 0to 4 classes. I want to uses these data for Multinomial logistic regression analysis in one go, but while doing analysis receives error “Run-time error no 1004.. Application defined or object defined error”.
Using win 7 64bit os,
MS office 2013 64bit.
Kindly suggest any solution.
Ram,
Are you sure that you are using a 64 bit version of Excel? I had understood that the Real Statistics software (as well as many Excel addins) doesn’t work in the 64 bit version of Excel.
Charles
Ram,
If you send me an Excel file with your data I will try to figure out what is going wrong. You can find my email address at Contact Us.
Charles
Hello, I recently installed the resource pack for Excel 2010,2013 or 2016 b/c I needed to run some binary logistic regression tests for work. I have Excel 2010 and Windows 7 on my computer. When I ran the program for binary logistic regression it loads for about three minutes but then I received an error message reading “compile error in hidden module: logistic regression.” I am not sure what to do about this so I uninstalled and reinstalled the program and the same problem occurred. Please let me know if there is a solution you know of. Thanks
Dan,
If you send me an Excel file with your data and calculations I will try to figure out what is going on. You can find my email address at Contact Us.
Charles
Hello Charles,
I have downloaded the ‘Real Statistics Resource Pack for Excel 2010, 2013 or 2016’ and I am using Excel 2016 32-bit version on Windows 10. When I press Alt+T+I, I can see that solver and realstats are both ticked, yet the Add-ins tab is not showing up on the ribbon. To make it appear, I need to un-tick and then re-tick realstats, but as soon as I exit excel and then re-open, Add-in tab has gone again. Is there a solution to make the Add-in tab stay there permanently?
Thanks,
Tanya
Hello Tanya,
That is very strange. I saw this type of problem over a year ago, but not since then. If I remember correctly, this was not a Real Statistics problem, but an Excel problem which was related to the order in which addins were checked. For more information see https://real-statistics.com/disappearing-add-ins-ribbon/ or http://stackoverflow.com/questions/23841184/no-add-in-tab-though-add-in-is-loaded-and-working or google “Ribbon keeps disappearing Excel” or “addin ribbon not showing” or something similar.
Charles
Thanks Charles – I appreciate your reply and I will give those suggestions a try 🙂
I just wanted to say I have never read such careful, precise instructions for downloading and installing software. Thank you so much!
Hello:
I have successfully downloaded the Real Statistics Pack for Excel 2016 and using a MacBook Air OSX El Capitan latest version. When I attempt to perform a logistic regression and while watching the YouTube tutorial all the features work except when I attempt to run the data. Once I press ‘ok’, screen says “compile error in hidden library module.” Do you know what is the error and how to correct it?
Thank you.
Susan,
Sorry, but the Real Statistics Pack for Excel 2016 only supports Windows. To use the Real Statistics Pack for the Mac, including Excel 2016, you need to use the Real Statistics Pack for Mac. See
Real Statistics Pack for Mac
Charles
I’m using Excel 2010 64-bit under Windows 64-bit. I installed the latest version of Real Statistics, carefully following all indications but I was unable to run Real Statistics. Invariably I got the same error message: “Invalid data in input window…”. On the other hand, I didn’t find in this site any warning about the incompatibility of Real Statistics with Excel 64 bit. Is that true?
I had to reinstall an older version 3.1.2, which works properly.
Giacomo,
I have never tried to run Real Statistics with Excel 64 bit, but it is not surprising that it doesn’t since from what I understand most addins need to be tweaked to work with the 64 bit version of Excel.
I will add a warning about this shortly.
Charles
Dear Professor,
It is possible, in any new realease to write what are the new?
If you have time to this.
Thanks for this great addin.
Jose
Jose,
You can find this information in the Blog section.
Charles
hello
am having a trouble in downloading the software. Each time I check the solver ad in excel, the excel stops working and asking me to disable the option.
Regards,
Safiya
Safiya,
Solver is a standard Excel capability. I don’t know why you would receive such an error message when you check the Solver addin. This should have nothing do with using or not using the real Statistics addin. Just to be sure I suggest that you make sure that the Real Statistics addin in not checked. Then close Excel and restart it. Then check the Solver addin, close Excel and restart it. Finally, find and check RealStats (as described on the webpage from where you downloaded the Real Statistics Resource Pack).
Charles
RealStats.xlam won’t load when I check the add-in box. I get the error:
Microsoft Excel cannot access the file ‘C:\Users\username\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’. There are several possible reasons:
*the file name or path does not exist.
*the file is being used by another program.
*the workbook you are trying to save has the same name as a currently open workbook.
Please help.
You need to specify the path where you actually placed the Real Statistics file. It is unlikely you placed the file at the path that you specified above. Perhaps you placed the file at C:\Users\tom\AppData\Roaming\Microsoft\AddIns\RealStats.xlam
Charles
Thanks for replying so quickly!
The actual path is:
C:\Users\a1c0czz\AppData\Roaming\Microsoft\AddIns\RealStats.xlam
a1c0czz is my corporate username. I don’t know why but I put username as a place holder.
I can see the add-in on the add-ins list and when I select Go I can see RealStats and check box but when I check the box, it gives me the error above.
Could it be a company IT security policy that is preventing me from adding Add-Ins?
Thanks for your help.
Regards,
Tom
Tom,
Is Solver also checked. It is important that this is checked as well.
I can’t comment about whether the problem could be related to your company’s IT policy.
Charles
i have the same problem with you, you must re-download real statistics and replace the old with the new 😀 *seriously
Hi all – I have been using the RealStats add-in for months and over the past week, am now getting an error when I run Jenks Natural Breaks that reads:
Compile error in hidden module: Cluster.
Has anyone else experienced this and if so, how did you resolve? Thanks.
Shannon,
If you send me an Excel file with your data, I will try to figure out why you are getting this error message. You can send the file to the email address shown at Contact Us.
Charles
Hi, I installed the package in Excel 2013 64bits but the time series option don’t appear after a Ctrl-m. After Regression appears Reliability. You know way?
Thanks
Hi Johnny,
That is strange. Are you using the latest release, Rel 4.8? You can check this, by entering the formula =VER(). When you do, you should see “4.8…”
If you don’t see this, then I suggest that you reinstall the Real Statistics Resource Pack.
Charles
Hi,
My version was 4.4…, I updated and worked fine.
Thanks for your attention
Johnny,
One other thing. Are you sure that you are running the 64 bit version of Excel 2103 and not the 64 bit version of Windows?
Charles
hi,
im using excel 2013, is it possible to run this add in on excell 2013?
because i always get error notification “can’t find project or library” and always asking for password.
do you have any solution?
Muizz,
Yes, I use the addin in Excel 2013 all the time and you don’t need a password. The important thing is that you must install the addin as described on the webpage from which you downloaded the addin.
Charles
Yes, I ran into the same problem Muizz. I did the following to resolve this issue, which I think Charles alludes to lower in the comments section.
You should activate the Solver Add-in and Analysis ToolPak before you attempt to activate the the RealStats add-in.
Hi,
I succeeded in installing everything, but now my solver is bugging. When I press alt-TI, the Solver is not checked. When I check it, Excel gives an error and shuts down. Is there a way to solve this?
Joos
Joos,
I suggest that you do the following: Uncheck RealStats and restart Excel. Then check Solver and restart Excel. Finally, check RealStats.
Charles
That worked for me.
Thanks Charles,
Garret
Hej Charles,
Super helpful application you have built. However I have an issue, can you tell me why when I try to use a binary logistic regression and I have marked the data area then when I try to click OK it keeps saying “Alpha must be a number between 0 and .5” even thought I haven’t touched the alpha field. Afterwards when I try to change the 0.05 number in the alpha window the message reappears. I have the english version installed however I am from Denmark so I do not know if this is the problem.
Yours sincerely
Daniel
Can you help me
Daniel,
The problem is probably related to use of a comma vs. a period to represent decimals. I suggest that you fill in the field with 0,05
If this doesn’t work, then fill in the field with 0.05 (even if this is what was originally in the field, for some reason you may need to manually write the value instead of using the default).
Charles
Hey Charles,
I have tried this solution it just keeps saying Alpha must be between 0 and 0.5. I cannot even write 0, which should not cause a problem on either the English og the American version. I will try an change my Excel to American and se if it makes a difference.
/Daniel
Hi, Charles. Yesterday I made a question to you, but today I have another one.
In Agronomic Fields, imagine we have this situation: I have made a Trial with randomized blocks, then I made an analysis between blocks and noticed that there was no difference between them. So, could I analyze this Experiment as a completely randomized one?
I am saying this because, as you know, when I do not use Block design I increase the Degrees of Freedom of the Residuals, and, many times I can see higher differences between the treatments.
Now, talking about the randomization, I have this doubt because I do not know if the probability of sorting plots in block and the plots being homogeny distributed would be the same of sorting these same plots in a completely randomized way.
I appreciate your time and patience again, and thank you so much.
Caio,
Which tool are you using to perform the analysis?
If you send me an Excel file with your data and analyses, I will try to figure out what is going on.
I plan to add some additional support for randomized complete block design and split-plot design to the next release of the software.
Charles
Thanks very much for a very useful pack.
Sorry. Because the Excel Data Analysis Regression option places the Y range first and you place X first, I relied on habit to input in the same order. The inversion on the dialog box made me cause the error!
Excel 13.
Solver activated.
Multiple regression error message: Input Y must have exactly one column.
But this is multiple regression, so of course I have multiple columns of Y. The error message makes no sense to me–what am I doing incorrectly?
Do I need to Solver.xlam?
Thank you.