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.3). 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.3). 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.
i have data set 290 (Questionnaire response). I have one independent variable, two mediating variables, and one dependent variable. Please let me know what is Durbin Watson value acceptable for this data set.
See Autocorrelation
Charles
Dear Charles,
Thank you for developing such useful tools and making them available. I was happy to find your Excel extension package since I need to estimate some logistic regressions. However I am receiving the following error, when trying to install it:
“Compile error in hidden module: Matrix”
Any suggestion on how to move forward will be appreciated.
Best regards,
Monica.
Hello Monica,
See Compile Error Message.
Charles
I followed your instruction but excel requires me to provide Realstat password. What is it?
Password Prompt
Charles
Is it still Charles? It doesn’t work 🙁
Pauline,
Please describe further what doesn’t work and what error messages or other indications have you received.
Charles
the password Charles is invalid
See Password Prompt
Charles
Hello Charles,
I have the same problem. I´m not able to use the functions. If I enter the formula =VER() in any cell, I get : 5.11 Excel2007. I need the ARIMAX Modell and it doesn´t work. Could you help me?
Lisa
Hello Lisa,
Since Microsoft no longer supports Excel 2007, I decided to freeze enhancements to the Excel 2007 version of Real Statistics. I am still supporting it, but I am not adding new capabilities. ARIMAX support is available for versions of Excel after Excel 2007.
Charles
Hello,
I recently followed the instructions and downloaded the resource pack for Excel 2019 (64-bit version). The pack is installed as an add-in, but I’m still not able to use the functions – I get a #NAME? error when I try to do so. What is going on here? Any help would be greatly appreciated.
Hello Sam,
What do you see when you enter the formula =VER() in any cell?
Charles
Gd day Charles
I ve tried to use RealStats for Wilcoxon calculations on paired samples…
I have some troubles to finalize the calculation as my French version of Excel is not recognizing some functions : SRDIST, SRINV, SRANK, SRTEST ?
Do you have an equivalence for French language… ?
Hello Alain,
Unless there are some standard Excel functions with these names in the French language they should work also in a French version of Excel.
What do you see when you enter the formula =VER() in any cell?
Charles
I am having difficulty, getting Gwet AC1 and Gwet AC2 to work, I looked at the example work book and found that it was not working having the same problem. I get either a “Value or Name” response in the table. Can you recommend or identify what I am doing incorrectly.
John
Hello John,
If you email an Excel file with your data and results I will try to figure out what is going wrong.
Charles
Hello,
I have a problem with “Basic Forecasting” in the Mac. It says “Compilation error in hidden module: “Forecast””. What do i have to do?
I have Excel 2016.
Thank you.
See https://real-statistics.com/appendix/faqs/compile-error-in-hidden-module/
Charles
Hello,
I’ve downloaded the XRealStats but I cannot get it to show up as an add-in on excel. I went through your trouble shooting steps and added a new trusted location with he folder that holds the file but still it doesn;t show up in Add-ins when I open excel.
What else can I try?
Thanks
Hello Hana,
Do you get the Real Statistics menu when you use the key sequence Ctrl-m ?
Does Real Statistics appear on the Add-Ins ribbon when you press the key sequence Ctrl-Shft-m ?
Charles
Good Morning.
You are giving the error message “Runtime Error ‘424’ ” object is required. Has anyone been through this? I’m with excel 2010 32bits
When did you get this error message? During installation? When using a specific data analysis tool? If so, which one?
What do you see when you enter the formula =VER() in any cell?
Charles
Sorry Charles but I think you book is really unstable.I’ve wasted a whole day today trying your tool on windows and mac for a logistic regression. Both failed always getting the compile error. I have followed your installation guide for Mac and windows to the T. I even got round the password nightmare. It worked once in the Mac but wouldn’t let me save the results, when I reinstalled again…compile error. What a nightmare…going to do it the old way
I am very sorry about this. The tool has been used by a great many people over the course of the past 7 years without these sorts of problems. I don’t know why you are having so much trouble. In any case, if you email me an Excel file with your data, I will try to identify why you are having this problem and send you the correct analysis.
Charles
Why my computer say Project locked and ask for the password?
See Password Prompt
Charles
Hi Charles,
I’m curious if you’ve seen any issues that freeze excel upon trying to open the menu from the ribbon? My steps to repro are as follows:
1. open excel and go to add-in tab on top navigation bar
2. click on real-statistics-data analysis tools and observe the modal doesn’t pop up
3. click on real-statistics-data analysis tools again and observe the modal does show up
4. select any function from the modal and click “OK”
5. see that excel has frozen. need to go to task manager to kill it
i am running windows7 os and excel 2013. i just noticed the problem with the old resource pack (RealStats.xlam) so i tried to switch to the newest and it doesn’t seem to have solved my problem. I’ve been using this for about 3 years now and have had no issues like this before so it’s pretty weird.
Any help or incite is greatly appreciated.
Thank you!
Hi Kevin,
I have not seen this problem before. The program size has been getting larger over time as I add more features. I wonder whether this has something to do with the problem. One way to check is to use the Mac version of the software. It should also work with Excel 2013 and Windows 7, but it has less code (since it lacks some of the help facilities). Also note that you don’t have to use Real Statistics from the ribbon and can access it using the key sequence Ctrl-m.
Charles
Thanks for the quick reply, Charles. Yeah the Ctrl-m gets the menu up on the first try, but then when I select a real stats function and click “ok” I get back into the state where I need to kill the excel process. It’s weird because it seems like excel freezes, but it doesn’t say anything about it become unresponsive. I honestly think it may be a bug in excel and not with real stats. I’m going to try a few things and I will keep you posted.
Also I tried putting the mac .xlam file there too and it didn’t work so I don’t think it’s an issue with the size of it.
Kevin
Hi I have just switched to a new machine and am having great difficulty installing real statistics.
The directory C:\Users\user-name\AppData\Roaming\Microsoft\AddIns didn’t exist so I tried creating the subdirectory “AddIns”, downloaded your file to that location, added the new location in Trust Center but there was no sign of the new add-in.
I then discovered that Solver was located in the following directory.
C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Excel_[….]\Office 16\Library\SOLVER\SOLVER.XLAM
Datapak has a very similar-lookinglocation.
Having gained access to the WindowsApps subdirectory (no mean feat for a non-expert), I tried to save the XLAM file in a similar location but I was denied permission to do this.
I would appreciate any help here! Thanks in advance.
You should be able to save the Real Statistics software almost anywhere. I am issuing anew release in about 2 hours. I suggest that you install that release.
Charles
Hello Charles,
I just noticed that Xrealstats I installed successfully in Excel of office 365 in my window 10 pc, is no longer working. When I type “=ver()”, in a cell I get #name error message, when I type “CTRL+m” , I see no result.
Thanks for the good works you’re doing.
Cyke
Hello Cyke,
This is strange. I don’t know why it would be working and then stop working.
I suggest that you press the key sequence Alt-TI and see if Xrealstats is on the list of add-ins. If it is there without a check mark, then you will need to add the check mark. If not you will need to press the Browse button to locate the the Xrealstats file.
Charles
I am being unable to install this tool to my computer for excel 2019.
Hello Jesus,
Are you using Windows or the Mac? What sort of error message do you get? If not, how do you know that it hasn’t been installed? What do you see when you enter the formula =VER() in any cell in a spreadsheet?
Charles
Dear Charles
Thanks again for this wonderful tool. After download and install the last version, when I tried =Ver(), I get Ver 6.5 instead Ver 6.6. I remember a similar issue in a previous version, that you fixed easily.
Best regards
Jorge Camacho
Dear Jorge,
Please try again. I inadvertently left the old release. You should be able to download the new version now. Sorry about this.
Charles
ctrl-m Histograms
any data
Never-ending loop of “Random Number Generation – The type of distribution is required. Entry must be an integer between 1 and 7.”
Also happens with
ctrl-m Config
Unclick use multipage menu, ok
Never-ending loop of “Random Number Generation – The type of distribution is required. Entry must be an integer between 1 and 7.”
I get this error window regardless what I try!
I usually have to kill Excel and any other open work in Excel.
Excel 2019 64 bit new download of XRealStats.xlam 4.1MB.
Kevin,
Are you saying that when you used the Real Statistics Histograms data analysis tool, the Excel Random Number Generation dialog box pops up and won’t go away? About how many times did you try to kill the Random Number Generation dialog box before giving up?
Charles
Yes. I stopped after pressing “OK” 30 times in the “i Random Number Generation – The type of distribution is required. Entry must be an integer between 1 and 7.”
I am in the workbook ‘Real-Statistics-Examples-Distributions.xlsx’ and copied in your Weibull data (n=12) into ‘Normal 1’!R4:R15 as the data to use as input.
irritating since it crashes Excel.
Dear Charles,
Thanks for such a great work and sharing it so openly.
I have found a problem using RealStats with Office365: The copy paste gets very slow. I mean, if i press Ctrl+C, Excel freezes for a couple of seconds, showing a loading wheel.
I have isolated the problem and it only happens when RealStats is enabled. If i disable RealStats, Excel goes back to working as usual.
Any idea of what can i do to fix this?
Greetings from Perú
Hello Hugo,
Good to hear from someone from Peru.
This is not good. I have not seen this problem before. What sort of computer processor do you have and how much RAM memory does your computer have?
Charles
Charles, try
Application.PrintCommunication = False
… anything to do with the printer
Application.PrintCommunication = True
Kevin,
Are you saying that this problem is related to some sort of print capability?
How do you know whether this change will work?
Charles
Hello, Charles.
Sorry for the late reply.
I’m using realstats along office 365 on a laptop. It has a Ryzen 5 processor and 12 Gb of RAM.
Thanks again for your effort.
Hi, Thanks for all you do.
FYI – I am getting a VBA error when I try to use XRealStats. The message is “Compile error in hidden module: AnovaAnalysis. This error commonly occurs when the code is incompatible with the version, platform, or architecture of this application. ” It seems to pop up for every function I try to use from the CTRL- M dialog.
I am running the very latest 64-bit O365 Excel (16.0.11929.20234) on 64-bit Win 10 Enterprise. I downloaded the latest “Real Statistics” and installed it this morning.
8/25/2019
Hello Clifford,
See Compile Error in Hidden Module.
Charles
Greetings appreciated Dr. Charles Zaiontz, it is an excellent work of yours, continue to reap success and again thanks for your valuable contribution to the academic and scientific community, Omar Cevallos – Ecuador
Hello, and thank you for making this add-in freely available. Much appreciated. A question, though, have you considered creating an equivalent add-in/extension for LibreOffice Calc?
Kind regards,
John
Hello John,
Thanks for your kind remarks.
You are the first person who has inquired about a LibreOffice Calc version. Unless there is more interest, the added benefits probably doesn’t justify the amount of work that would be required.
Charles
Can you provide version for LibreOffice
Real Statistics requires VBA support, but LibreOffice doesn’t provide VBA support.
Charles
A LibreOffice Calc version would be great!
Hi Charles,
I keep getting XRealStats.Xlam contained a virus and was deleted.
Any ideas?
Ross
Hello Ross,
I just scanned the file for viruses and found none.
Charles
Hello,
Trying to use the Real Statistics Add-in on my computer, but every time I try to run any of the tools or functions, I get massive arrays of “VALUE?” errors. Any idea why this is happening?
Would greatly appreciate some input.
Thanks.
Hello Will,
When you enter the formula =VER() in any cell, what do you see?
If you are getting an error value, this would mean that you haven’t yet installed the Real Statistics Add-in. Installation instructions are given on this webpage.
Charles
Will loading the toolpack, its prompting for password. do i need a password to install the package?
See Password Prompt
Charles
I saw the site said the Resource Pack has the LASSO Regression in it. However I have run the addin and I don’t see it anywhere. I see ones like Ridge though. What am I missing?
Hello Steven,
There isn’t a LASSO data analysis tool yet. There is a LASSOCoeff function though. See
https://real-statistics.com/multiple-regression/ridge-and-lasso-regression/lasso-regression/
Charles
Dear Charles,
Many thanks for helping many people with statistical analysis by guiding and suggesting to perform data analysis.
I would appreciate your suggestions for the below data analysis..
I have tested germination of a species at one temperature in growth chamber under light/dark and continuous darkness. I gave GA treatment and check the germination in light dark- with GA and without GA .
I would appreciate your suggestions for ANOVA analysis..using Real Stats programme. I will install it today and i agree the licence agreement. Many thanks!
The data looks like below- i just made up for making it easier to understand..
Plant species Treatment Photoperiod Replicates Germination %
Species A Pretreatment with GA Light 1 45
Species A Pretreatment with GA Light 2 20
Species A Pretreatment with GA Light 3 35
Species A Pretreatment with GA Light 4 60
Species A Pretreatment with GA Dark 1 25
Species A Pretreatment with GA Dark 2 20
Species A Pretreatment with GA Dark 3 15
Species A Pretreatment with GA Dark 4 10
Species A Pretreatment without GA Light 1 40
Species A Pretreatment without GA Light 2 30
Species A Pretreatment without GA Light 3 25
Species A Pretreatment without GA Light 4 30
Species A Pretreatment without GA Dark 1 25
Species A Pretreatment without GA Dark 2 18
Species A Pretreatment without GA Dark 3 15
Species A Pretreatment without GA Dark 4 35
Hello Bhagwati,
This depends on what hypothesis or hypotheses you want to test.
Charles
Hi Charles,
The aim is to evaluate the effect of GA on germination under two photoperiod i.e. light/drak & complete darkness
We test the hypothesis that response of the species to GA is related to photoperiod conditions.
See previous response.
Charles
Research question is – Is there a difference in germination between GA treatment and without GA treatment in light and darkness.
Many thanks for your kind help.
Hello Bhagwati,
If I understand correctly, you have a fixed GA Treatment factor with two levels (GA and no GA) and Lighting with three levels (Light, Dark, Complete Darkness). I believe that for each of the 2 x 3 = 6 combinations you have 4 replications. The dependent variable is % of germination. Two test whether there are significant differences for each factor and the interactions, you can use Two Factor ANOVA with replication.
This is my understanding, but I also see that you may also have two other factors: Species (only A is listed) and Treatment (you only have pretreatment list). Please explain whether these are factors in your analysis. You don-t seem to include any analysis of these in the hypothesis that you want to test.
Charles
Many Thanks Charles.
I used Two way ANOVA with G% as dependent variable and GA and Photoperiod as predictors. It works..
Cheers!
since i am young in the field of statistics analysis. Having undergone confusion with spss/sas/stats i am no where left with destinations. even trie to read so many website related to statistics book.
if you can attached me the real statistics pack with complete resources guiding me would be very thankful at this email:tsheringtobgyel.cst@rub.edu.bt. I am using microsoft excel 10. I am located in a remote place where internet services break down.
i tried when internet services was running but lots of confusion and do not download even.
Hello Tshering Tobgyel,
Have you read the License Agreement and do you accept it?
I need your confirmation before I can send you the file.
Charles
Hello,
First of all Thank you for such a great program!
I just got a new computer and now I have the problem that the Add-In isn’t showing after I close the Excel Spreadsheet and then open a new one. There’s a tick on the “RealStats” Box in my AddIn Options but it isn’t showing RealStats until I unticked the box, closed Excel, opened Excel and ticked the box again. Do you know why this could be?
Hi Verena,
See the following webpage for how to resolve this problem.
https://real-statistics.com/appendix/faqs/disappearing-addins-ribbon/
Charles
Hey Charles,
Thank you for the quick reply. Sadly it isn’t working, as the Ctrl+M/ Ctrl+Shift+M isn’t working unless the AddIn Ribbon is actually shown. Also the Macro Dialog Box doesn’t work either.
Thanks!
Hello Verena,
What do you see when you enter the formula =VER() into any cell?
Charles
Hello Charles,
It says “#NAME?”.
Verena
Hello Verena,
This means that Real Statistics was bot installed. You need to follow the Installation Instructions on the webpage from which you downloaded the software.
Charles
Hello Charles
Many thanks for this amazing resource pack. It is extremely useful.
One issue faced by me is when I open my Excel file which has Real Statistics functions on some other PC , the links are not updated after changing the source directory where Real Statistics is installed. I get “#name?” in all the cells containing Real Statistics functions. Then I have to manually change every cell removing the directory reference to the old computer .
Request advice if any quicker method to update links.
Thanks
Nandip
Hello Nandip,
See Installation Instructions on the following webpage:
https://real-statistics.com/free-download/real-statistics-examples-workbook/
Charles
hi , this is such a great tool. I have tried to look up the mann-kendall test among the functions available in the time-series tabs. could you help with the location / instructions of use aside from the ones available in: https://real-statistics.com/time-series-analysis/time-series-miscellaneous/mann-kendall-test/. regards
Hello Alvin,
Thank you for your kind words.
MKTEST is not currently included in the data analysis tools. Instead it can be used as for any other Excel array function>
MKTEST(R1, lab, tails, alpha): returns a column array with the values S, s.e., z-stat, p-value and trend.
Charles
Dear Charles,
Congratulation for this wonderful tool.
I am using and during attempting one Kaplan-Meier curve there is the following message:
“Column 2 of input Range 1 must have at least one 1 (failure)”
Could you help me to solve this?
Thank you so much!
Hello Jose,
If you send me an Excel file with your data and you explain what values you used in the data analysis tool or function, I will try to figure out why you are getting this message.
Charles
Hi,
Firstly, excellent work. Following your instruction, I got a dialog box “cant project or library”. Have I miss something?
Thanks,
Ken
Ken,
It doesn’t sound like the software was installed. When you press Alt-TI do you see RealStats and Solver on the list of add-ins with a check mark next to each of them?
Charles
I have been using the Realstats for a few years now and its excellent.
Just recently, I am getting an error:
Microsoft Visual Basic for application
Compile error in hidden module: Analysis
This error commonly occurs when code is incompatible with the version, platform, or architecture of the application.
I have just downloaded the most recent pack and replaced my earlier file. Still does not work. What should I do?
Hi Mukul,
See the following webpage:
Compile Error
Since you are simply replacing the old file containing the Real Statistics software with a new file presumably containing a new release of the Real Statistics software, I don’t know why you would get such an error message.
Charles
Its working now. However, sharing the issue for benefit of others:
I found that the Solver option was not ticked. So I tried to enable the add-in. However, it would not work and still kept on giving me the error that solver was giving problems and I should disable it.
Based on some feedback that I saw on the net, I repaired Microsoft Office. Still did not work.
Finally, I disabled the real statistics add in –> enabled solver add in –> re-enabled Real statistics add-in and it worked.
Sometimes the sequence of operations is what can solve the problem
Thanks for sharing this Mukul.
Charles
Based on your trouble shooting I need to “unblock” the file to get it to show up on the analyse ribbon. When I try this it says I need to get permission of the administrator (that’s me). I click continue and then get the following message.
Error applying attributes
An error occurred applying attributes to the file:
C:\Users\user-name\AppData\Roaming\Microsoft\AddIns
An assertion failure has occurred
Any ideas how to solve this?
Hi James,
I have never seen this error before. Perhaps the following webpage can help
https://www.stellarinfo.com/blog/resolve-windows-cannot-access-specified-device-path-file-error-windows-system/
Charles
I downloaded the .xlam file and when I try to run it in Excel, I get the following error: “Excel cannot open the file ‘RealStats.xlam’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.” Can anyone let me know how to resolve this error?
Marc,
Please look at the Troubleshooting section on this webpage.
I just downloaded the file and did not get this message.
Charles
Yes, I downloaded file by Explorer and it finally worked, but when I tried to install it the same problem appeared. It’s like our excel doesn’t know .xlam file.
Good evening,
I tried to download Real Statistics Resource Pack for Excel 2010/2013/2016/2019/365, because my version of Excel is 2013, but it says “No file”. What should I do now? Are there any other options?
Thank you
Maria
Hello Maria,
I don’t know why you were unable to download the latest version of the software. I just tried to download it and had no problems. I suggest that you try again. If you are still having problems, please let me know.
Charles
I had the same issue and I tried a browser other than Chrome and it worked. I used Firefox…
Marc,
I have just tried with Chrome and Edge and both worked.
Charles
Dear Charles
I am a statistics beginner, and I find your Real Statistics website and the software pack you developed so useful; I had discovered the website last year and downloaded the Real Statistics Resource Pack in the Autumn of 2018. I have been using it without any problems.
Today, I am trying to download the latest release, version 6.1. However, I am getting the same message, ‘Failed – No file’, John Le Roux reported on 13 April 2019. Unlike John Le Roux’ version of Excel, my version of Excel is Excel 2016 (version 16), 32-bit. The Windows 10 Pro version is 1803. I tried the download your software both on my PC and my laptop. On both occasions, I get the message ‘Failed – No file’.
I do hope I will be able to resolve this issue: I love to keep on learning. (By the way, you say there will be a book available—I tried to search for it, but could not find it.) Thank you for the amazing resources, Pavla.
Hello Pavla,
I am pleased that you are getting value from the website and software.
I don’t know why you were unable to download the latest version of the software. I just tried to download it and had no problems. I suggest that you try again. If you are still having problems, please let me know.
Charles
hello , I ‘m having the same problem every time I try to download it what should I do?
Hello Ichraf,
Earlier today another user, Marc, sent a comment that he had trouble downloading the file using the Chrome browser, but was successful using Firefox.
I just downloaded the file without any problems using Chrome and also using Edge.
I suggest that you try downloading again, but let me know if you are still having this problem.
Charles
i dont have that problem anymore thank you but when i try to work with it it says it requires a username
Dear Charles
Thank you very much for your response. When I contacted you initially, I did try several browsers (Google Chrome, Internet Explorer and Edge), none of them worked. Today, however, I tried my preferred browser, Google Chrome, again, and, lo-and-behold, no problem. Maybe, I should have been more patient originally … Well, all is well, and thank you again for your concern, Pavla.
Hi Pavla,
Glad to see that you were able to download the file. I don’t know why you had this problem. Usually this is a browser problem, but I don’t really know for sure.
Charles
I simply want to thank you! The multivariate functions are very clear and to the point, I have wanted for my data analysis work on spectroscopic data processing prep work.
Hello Berns,
Thanks for your feedback and glad I could help.
Charles
Thanks for this amazing gift. That’s simply genius!!!
Thanks for your help. It was useful to apply in a sensory shelf life study of beans.
Very greatful!!
Ana
When I try to run Logistical Regression, I get an error message
Compile Error in hidden module Logisticregression.
See Compile Error in Hidden Module
Charles
Hi Charles
I got a 2010 version. I tried to download the package but it say ” Failed – No file”
Please help
Hello John,
I no longer have a separate version of the software for Excel 2010. You can use the main version since it now supports Excel 2010, 2013, 2016, 2019 and 365 for Windows.
Charles
Hi Charles,
Thanks for adding Cliff’s Delta!
Erik
Dear Charles
I downloaded version 6.1 and install it, following all your instructions. Installation run well, but when I type =Ver(), the response is 6.0.4…
I delete the previous version and install the new one and got the same message.
Best regards
Jorge
Dear Jorge,
I suggest that you press Ctrl-Shft-m.
If this doesn’t work, press Alt-TI, uncheck RealStats and click on the OK button. Now press Alt-TI again, check RealStats and click on the OK button.
Charles
Dear Charles
I tried all tips that you suggested without success. Additionally, I uninstall the program and delete the xlam file from my computer and restart my pc. Then download the xlam again from your site, unblocked it, and configure the trust center as explained on this page and install it as usually. Installation runs fine but when I ask for =Ver(), appears 6.0.4 instead 6.1.
Thanks for any tip
Jorge
Dear Jorge,
This is my fault. I forgot to change the release number from 6.0.4 to 6.1. I create a new version yesterday. If you download it now, you should get release 6.1. I apologize for this silly error on my part.
Charles
Dear Charles, thanks a lot for your support
Best regards
Jorge
I agree
Great! thanks for the tool!
Dear Charles
I have downloaded RealStats software and it is asking me the password? Could you please help me?
See Password Prompt
Charles
Hello,
I am using Microsoft Excel 2016 Professional Plus.
Whenever I try to install this add-ins. It says automation error.
I’ve followed the procedures of troubleshooting available on your site, but I couldn’t install it. It also says that the code may be incompatible.
By the way, I’ve downloaded the 2016 version of realstat for windows.
Please help me.
Hello,
Lots of other people have installed the software using Excel 2016 without getting this error. I am not sure what is causing the error. Can you provide additional info as to when you are getting the error message?
Hopeful long you didn’t try to install the software by double clicking on it. This could result in various types of problems.
Charles
Hello Charles!
Thank you for the great tool.
I don’t really know what happened after I changed computers, but the add-in doesn’t work on my new laptop. I have installed and uninstalled it several times following the trobleshooting section, but it always says the addin cannot be installed and closes the excel file.
Can you help me solve it?
Hello Flavia,
Without more info it is hard for me to resolve the problem, but I have one approach that might work. Download the Excel file containing the RealStats.xlam file. Now rename the file to say RealStats2.xlam (the actual name used doesn’t really matter) and then install as described on the website, namely press Alt-TI (if using Windows) and then click on the Browse button to find the file you just renamed. Make sure that both RealStats and Solver are both on the list of add-ins with a check mark next to them. Once this is done press Ctrl-m
Note that this renaming is only necessary if you already have a version of Real Statistics installed and Excel is confused as to where to find the file that contains the software.
Whatever else you do, don’t double click on the file that contains the Real Statistics software.
Charles
Hey,
I installed the real stats add-in but after restarting my computer fisher’s exact test doesn’t seem to be working. Thoughts? Is there a troubleshooting page?
Thanks!
Hi Brendan,
There is a Troubleshooting section on this webpage. What is causing the problem really depends on what you mean by “…doesn’t seem to be working”. What sort of error messages are you seeing?
Charles