Click on one of the icons below for a free download of any of the following files.
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.
Real Statistics Examples Workbooks: 14 Excel workbooks can be downloaded for free. These contain worksheets that implement the various tests and analyses described in the rest of this website.
Quick Access Toolbar (QAT): One way to access the Real Statistics data analysis tools is via the QAT. To accomplish this you need to download a file named RS_QAT.xlsm. Click here to download this file and obtain instructions on how to access the data analysis tools via the QAT.
Hi Charles
Unable to download. Getting this message:
Sorry, we couldn’t open ‘https://real-statistics.com/wp-content/uploads/2019/07/RealStats.xlam’
You are not supposed to open this file. Instead, you need to install the software as described on this webpage.
Charles
Hi, I´m trying to open the complement Real Statistics but it ask me a password. Is it weird, isn´t it? Thanks in advance
Hello Maria,
See Password Prompt
Charles
@Maria, Did you get it figured out?
I’m having the same issue and ‘see password prompt’ didn’t help.
Hello Charles,
I am trying to install Real Statistics in order to carry out a 2X7 Fisher’s exact Test. I have Microsoft Office 7. However, despite trying out all the troubleshooting options that you have suggested, the moment I select Real Stats add in (after ALT TI), Microsoft office stops working.
What do you think is the issue?
Do you recommend any alternatives?
Thank you.
Hello Pavitra,
Which version of Excel are you using?
After pressing Alt-TI do you see Solver on the list of add-ins with a check mark next to it? You need to make sure that Solver is installed before installing Real Statistics.
Charles
Dr. Zaiontz,
Is this software available for Mac OS 10.14+
Eric,
Yes, it should work with this OS release.
Charles
Outstanding product Charles! Much thanks.
Just that when I choose classes upwards of 3, it takes a long time. I got 4 to work, by leaving the computer on for about 30 minutes. It freezes, and then gives me the output after 30 mins. And when I tried 5, it stays frozen even after 2 hours.
Trying to figure out what the issue could be.
Hello Roey,
Glad that you like Real Statistics.
Which capability are you referring to when you talk about the long run times? How big is your data set?
Charles
Hi,
I’ve installed release 6.2 and I keep getting “run-time error ‘424’ object required” whenever I try to use the add-in. I’ve gone through all of the fixes you recommended for other problems but nothing seems to fix this one. I’ve uninstalled and reinstalled the add-in a few times and that doesn’t work either. Any advice?
Thanks,
Matt
Hello Matthew,
I suggest that you try the following>
1. Download the 6.2 release of the Real Statistics software.
2. Rename the file. E.g. rename the file RealStatsX.
3. Install the Real Statistics software by pressing Alt-TI and clicking on the Browse button to find the RealStatsX file.
Charles
Dear Charles,
just successfully installed your add inn,
I was looking for Kaplan Meier,
where can I find it?
Thanks,
Johan.
Hello Johan,
It is in the Survival Analysis data analysis tool, which can be found in the Reg tab (after pressing Ctrl-m).
Charles
Dear ! how are you ?
I need to download multiple regression analysis software , work with Excel. But I couln’t find it and was difficult to download it, please help me.
Hello Muluken,
The standard Excel version of the multiple regression data analysis tool can be found in Excel’s Analysis ToolPak. This may already be installed in Excel; to check this go to the Data ribbon and see whether the Data Analysis option is visible. If this is not visible, then from the File ribbon click on Options, on the left side of the display. Next click on Add-Ins and then select Analysis ToolPak.
If, instead, you are trying to use the Real Statistics version of the multiple regression data analysis tool, then go to
https://real-statistics.com/free-download/real-statistics-resource-pack/
Charles
Hi Charles,
I have click most of the download link but it failed to download. It says No file.
Regards,
Hello Baskoro,
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’ve downloaded the pack but I could not see the cronbach as an option for reliability procedures.
Look under internal consistency reliability (assuming that you are using a recent release for Excel 2007, 2010, 2011, 2013, 2016, 2019, 365).
Charles
Hello, I’ve downloaded and was successful in opening the RealStats add-on in Excel, and looking at the tool. However upon trying to then access PowerPivot in order to create a pivot table I noticed my PowerPivot tab within the ribbon was missing. I’ve described my steps below, and have an IT resource I will be asking for assistance, but was curious if anyone has encountered this issue.
Scenario:
-I downloaded RealStat.
-Opened Excel but could not see the Add-on option available in “Options”, and it also requested a security password.
-I went to the RealStat file location and “unblocked” the file.
-I was then able to add-on RealStat in Excel, enable Macros, and open up the GUI.
-I then encountered an issue with PowerPivot not appearing from my Ribbon.
-I toggled PowerPivot off then on, and it reappeared in my ribbon.
-I attempted to add a datatable to PowerPivot but it encountered an issue.
-I closed Excel, opened it, and PowerPivot was missing from the ribbon again.
-I assumed it was my recent addition of RealStats causing this issue so I toggled the RealStat addon “off” then “on” again.
-When trying to use RealStat it then gave me the similar error of asking for a security password, I went back into my add-on folder to unblock the document but it was already unblocked….
-I’m not unable to use RealStat, or PowerPivot.
Hello Nate,
No one has reported a problem similar to the one that you are having with PowerPivot. I don[t know whether the problem is caused by RealStat or not.
Regarding the specific problem you are having with Real Statistics, if Real Statistics doesn’t appear on the ribbon, all you have to do is press the key combination Ctrl-Shft-m and it will reappear on the Add-in ribbon. Even when Real Statistics doesn’t appear on the ribbon, you can always access it by pressing the key combination Ctrl-m
Charles
Hi Charles,
Thank you for the confirmation, I just removed the downloaded document, restarted the computer, re-applied document and both PowerPivot and RealStats now are working fine. I probably had a hanging session. Thank you!
Hi Nate, that is good to hear.
Charles
How did you unblock the file, i have the same request of password
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.
Charles
Hi Charles.
Easily the best Excel based statistics shareware/freeware add-in out there!
How do we know from the real stats menu what version are we running?
If not, is it going to be easy to add the version info in the menu interface?
Thanks!
Budana
Hi Budana,
Thank you for your very kind remarks. I am pleased that you are benefitting from the software.
To find out what version you are using insert the formula =VER() in any cell in the spreadsheet.
Charles
Thank you very much for making this available! It helped out a lot while doing analysis of simulation results.
Hi,
I am trying to download the Design of Experiments template(s), but when I hit FREE DOWNLOAD, it does nothing.
Regards,
John
Hi John,
Choose Examples Workbooks from the Free Download menu. Then download the Anova Part 2 workbook.
Charles
Dear Charles, happy new year!
I have a simple question: ¿Can I install RealStats on a free software spreadsheet, like libre office? One of my students ask me about this.
Best Regards
Jorge
Jorge,
Probably not, since these open source spreadsheet programs probably don’t support VBA.
Charles
Really great tool. Thanks for it.
Question: which reference handbook do you recommend to me to refine my knowledge of statistics?
Bernard,
There are so many books on statistics that it is hard to name just one. It depends on your current level of knowledge, your field (economics, medicine, psychology, marketing, biology, agriculture, etc.) and the types of topics you are interested in. The textbook by Howell (see Bibliography) is one that I particularly like, which focuses on statistics for psychology.
Charles
Dear Dr. Zaiontz:
Thank you so much for making this wonder set of statistical tools accessible. I work for a small non profit whose mission is to improve instruction in elementary and middle school mathematics classrooms around the country. Part of my role is to support school districts and schools in their program evaluation efforts. Your Real Statistics Resource Pack makes basic program evaluation much more accessible since most districts already have access to Excel. Your work is making a difference! Thank you.
Sincerely,
Pam Tabor
Research and Evaluation Specialist
US Math Recovery Council
Pam,
Thank you very much for your comment. I am very pleased that I could help you and your school districts.
Charles
Hello
I am doing Binary Logistic Regression on my data using the Package.
The resulted classification table, coefficient are clear,
but I don’t know how to read those covariance matrix and other technical result.
Do you have a manual which explains all about this.
Thank you.
Watz,
The Real Statistics website explains all of this. See the following webpage:
https://real-statistics.com/logistic-regression/
The following webpages describe the covariance matrix:
https://real-statistics.com/correlation/multiple-correlation/
https://real-statistics.com/multiple-regression/least-squares-method-multiple-regression/
Charles
Dear Charles,
Thank you very much.
It is really helpful.
Watz
You mention “books that will contain information that is similar to what you find in the website.[..] expected to be available in early 2017.” I’ve acquired your book “Statistics Using Excel Succinctly” but it seems to be older, and it doesn’t mention your website or tools. Is this book what you refer to, or will there be a forthcoming book to serve as a companion guide to your software itself?
Brian,
No this is not the book that I was referring to. Sorry, but that book has been delayed. I expect to publish the book in September/October of this year. Thanks for your interest and stay tuned.
Charles
Hi Charles, I’m really interested in buying your book too, would you be so kind to put a glaring pop-up or something similar in your Home Page to alert us about the possibility to putchase it? Thank you very much and again congratulations!
Riccardo,
Thank you for your interest. The book has not yet been published. Unfortunately, it keeps getting delayed. When it is released later this year, I will will use some sort of alert.
Charles
Thank you Dr. for this easy to use and all-encompassing excel add-in for data analysis. God bless you real good.
I am having problems running this program. I can access the main test page, but any time I try to run a test I get the error message “Compile error in hidden module”, thoughts?
I have 5.6 Excel 2013/2016
Kevin,
The usual reason is that Excel’s Solver has not been installed or activated.
When you press Alt-TI do you see RealStat and Solver on the list of addins with check marks next to them?
Charles
I am having the same problem as Kevin. Installation appears to be correct, but a password is requested and canceling that dialogue box allows me to begin an analysis. However, I always get the same error: “compile error in hidden module.”
I uninstalled the software and then installed the older Mac version. The older version is running fine. My OS is 10.12. Is there a bug in the new version?
Richard,
The usual problem is that Solver is not activated. When you select AddIns from the Tool menu, do you see Solver on the list of addins with a check mark next to it?
Charles
Found a fix for this installation problem– don’t install/add RealStats as an add-in under the Tools menu within Excel.
Simply open Excel, and then open the file ‘RealStats-Mac-2011.xlam’ wherever you saved it on your hard-drive.
The program then works great, and doesn’t produce the prompt for a password or the error message.
**You most likely have to already have Solver installed under Add-ins before doing this.**
Rob,
Thanks for sharing this.
I tried it on my Mac and it worked. The only problem is that I didn’t see the file listed on the on the list of addins, but it worked anyway.
I also tried it on my Windows computer. Once again, it worked, but again I didn’t see the file on the list of addins when I pressed Alt-TI.
Charles
Dear Charles Zaiontz,
thank you so much for RealStats-Ressource-Pack. I like using it nearly every day, it makes Excel so much more useful, and all that for null money.
I wish all the best for you, human people like you are rare these times.
Joachim,
Glad that you find the software useful.
Charles
Does Real Statistics for Excel work for Office 365 for the Mac?
Dennis,
Yes, as long as Office 365 runs on your computer.
Charles
I click on download, and it just opens a new copy of the web page.
Brynn,
I just tried it and it goes to a different webpage, namely https://real-statistics.com/real-statistics-resource-pack/
Charles
Dear sir,
Goodafternoon,
I downloaded year new updated RealStats.xlam software for 2013/2016. I installed in my computer. But this software has to be installed time and again for every file. RealStats.xlam works for only one time. Why??
Your old version software did not give me this type of trouble. Please, tell me any solution for new updated RealStats.xlam software for 2013/2016.
Gautam,
Please explain what you mean by “this software has to be installed time and again for every file.” What do you mean by “every file” since there is only one file realstats.xlam? Also what do you mean by having to install “time and again”? Are you saying that when you close Excel and then reopen it, =VER() and Ctrl-m no longer work? If so, this is strange.
Charles
Hello Sir,
Thank you for your site, very useful.
I’m also encountering compatibility issues. I’m running in Windows 10 (64bit) and have recently updated to the Fall Creators Update. It’s my first time to try your real stat add-in though, so I have no comparison with the other versions of Windows 10. I’m using Excel 2016.
I was able to install the add-in just fine. Solver add-in is also installed. But when I try to use any of your functions, KCORREL for example an error appears:
“Compile error in hidden module: Correlation.
This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.”
With the add-in installed, I encounter “Automation Error” pop-up everytime I open the Excel.
I also did the troubleshooting instructions mentioned but didn’t work.
Thank you!
Do you also get this error message when you enter the following formula? =VER()
It sounds like you have done all the right things, but I don’t have any experience with the Fall Creators Update to know whether it is causing the problem.
Charles
Hi Charles,
I found out that it’s the solver add-in that’s causing the error. I’ve seen many people raised that issue over the internet but has yet to be resolved. Anyway I was able to run your add-in on a different machine.
However, I was getting the KCORREL for 2 columns (18,000 rows). It was able to compute for the kcorrel, but when I invert the order of the columns, say KCORREL(B,A) instead of KCORREL(A,B), I get #VALUE as the result. Shouldn’t it be somewhat commutative, I mean not order-specific? So I am expecting the same result when I do KCORREL(A,B) and KCORREL(B,A).
Thanks a lot!
1. When you say that Solver is causing the error, do you mean that Solver was not installed (and checked in the list of addins)?
2. Yes, KCORREL(A,B) and KCORREL(B,A) should yield the same result. If you send me an Excel file with your data, I will try to figure out what is going wrong.
Charles
Hi Charles,
I am encountering the same problem. The “Automation Error” dialogue box pop-up every time.
Have you solved the problem already?
Hi Liz,
I don’t recall anyone reporting getting an Automation Error, although it may have happened to others. I have never gotten this error message myself. When I googled “Automation error exception occurred excel” I saw a number of strange causes, but nothing that helped me address the issue.
What version of Excel are you using? Have you tried all the Troubleshooting steps?
Charles
Dear Dr Zaiontz:
One of my students updated windows 10 using Fall Creators Update. Apparently there is a compatibility issue with the last version of Real Statistics. Do you have any info on this?
Thanks in advance for your help
Jorge
Hello Jorge,
Thanks for the heads-up. So far I haven’t heard of any compatibility issues specifically related to the Fall Creators Update, but various issues have been appearing over the course of the last few months which may be related. I have just added a Troubleshooting section on the webpages from where people download the Real Statistics software that explains how to deal with these issues. I will make the required changes as I learn more.
Charles
Thank you!
Hai Dr. Charles;
I hope you are well.
I sure you would help me, where I have a statistical problem as follow:
I have 2 populations, 1st is a health providers at 2 hospitals (supervisory staff) with total sample size of (328 person) and the 2nd population is the in-patient at the same 2 hospitals with total sample size of (540 pts.). 2 surveys was used to collect the data, one survey for each population, the 1st one (with 68 questions) for the 1st population used to measure the level of using Six Sigma Methodology (DMAIC) at 2 hospitals, and 2nd one (with 36 questions) for the 2nd population that used to measure the level of patient’s satisfaction under light of using Six Sigma Methodology (DMAIC) at the same 2 hospitals. Both surveys has the same 5 dimensions (DMAIC) with same Likert Scale (5 scale), the data was collected at the same times. There are difference in questions no. between the 2 surveys, but there are (13) similar questions in every survey.
N.B: The surveyed (male and female) pts are from several ward (medical, surgery and obstetric wards), also most of health provider (male and female) are from these wards.
I need to find the effect or association (correlation) between the level of using Six Sigma Methodology (DMAIC) as (X variable) and the level of patient’s satisfaction under light of using Six Sigma Methodology (DMAIC) as (Y variable) using the data that collected as mentioned above. So I do the following:
1. Assuming that, level of pt. satisfaction is the Y variable, so I fixed every pt.’s case score (average mean for every dimension and total mean score), then we have 540 pts. with (6 scores for every one).
2. Also I assuming that, level of Using Six Sigma Methodology (DMAIC) is the X variable, then I measure the score for every health provider case (total of 328 person), so I have 6 scores for every one (average mean for every 5 dimensions and total mean score).
3. Using bootstrapping technique to generate random samples form the scores of health provider cases that every random sample contain (10) cases of them together which starting with a certain generated no. and calculate the scores, then return back the cases for the origin samples.
4. Repeat previous step (3) starting with a new generated no. to be sure not repeat the same generated random sample.
5. With step (3) and (4), using bootstrap, so we have (1000) random samples for each (540) pt. cases.
6. From the previous steps we will calculate the correlation between (X) and (Y).
My question is that: Is this procedure right to calculate the association between X and Y?, if Yes, which test can I used to perform it?, if No, How to do this right?.
Or I must measure the overall level of using Six Sigma Methodology as will as the pt.’s satisfaction in each ward of hospital alone then match them and do the bootstrap, or do it by gender in every ward then match them as:
Overall score of female (Health provider) in surgery ward (X variable), attach with overall score of female (inpatients) in surgery ward (Y variable).
And overall score of male (Health provider) in surgery ward (X variable), attach with overall score of male (inpatients) in surgery ward (Y variable).
Also the medical and other ward the same as previous.
I’m looking for your kind answer.
best regards;
Amer,
It looks like you have a very important research to undertake and your approach may be a good one to follow. I am happy to answer specific questions (with a limited number of complications), but I don’t have the time necessary to really understand the details of the scenario that you are describing.
Charles
it request password. where do i get it?
See Password Prompt
Charles
FOR MANY YEARS AGO IAM LOOKING FOR SOME LIKE THIS BY CHANCES I FIND IT HOPE THAT TO FIT WITH MY REQUEST
Ciuldnt find SUrvival Analysis option in the mac version?
Shruthi,
This capability is not currently supported on the Mac version. I am working on a new version for the Mac that should be available sometime in June.This version will include Survival Analysis.
Charles
Thank you very much, this is life saving.
Hello,
Does it works with office 365?
Yes
Dear Sir, I ve attempted to use the real stats for both 2013 and 2016
for 2013- i cant get pass the installation and for excel 2016, it requires a password?
Anne,
See https://real-statistics.com/appendix/faqs/password-prompt/
Charles
Hello, can use it for my excel 2016?
Anne,
Yes for Excel 2016 for Windows. Soon for the Mac.
Charles
Dear Sir
Thank you for a very useful site!
However, I am unable to use the Realstat add-in due to the lack of 64-bit version. How is your implementation going?
Best regards
Anders
Anders,
Sorry, but I am not currently working on a 64 bit version. This is on my list of future enhancements, but so far the demand hasn’t been high enough that I have prioritized this enhancement over others.
Charles
I would use the 64 bit version as well if that becomes a reality.
Michael,
It is a reality. See Blog.
Charles
Hi there,
Please can you tell me how to do a PROBIT regression analysis to determine the detection limit of the method I am testing. Which function in Real Stats can do this.
Thanks so much
Anita
Anita,
The Real Statistics Resource pack doesn’t yet support Probit regression. It is similar to logistic regression. I expect to add this capability shortly.
Charles
I have placed xlam file at D:\Users\sahuja\AppData\Roaming\Microsoft\AddIns. Some of references in Examples-Part-1, Part-2 don’t seem to resolve. Like I am seeing #NAME? in cov sheet where its showing =’D:\Users\sahuja\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’!COVARP(B4:B11,C4:C11). Several other sheets work fine. Please help.
Sanjeev,
You can use Excel’s Replace capability to replace all instances of =D:\Users\sahuja\AppData\Roaming\Microsoft\AddIns\RealStats.xlam’! by =
See https://real-statistics.com/free-download/examples-installation/ for more details.
Charles
Thanks for the Response. I have replaced as suggested in entire workbook still problem persists. For eg the formula bar on clicking the cell with #Name? shows =RESHAPE(A5:C8). I tried to copy the Input range from somewhere else in sheet and write corresponding output formula in other cell but still its giving #Name?.I am using Excel 2013.
To me it looks to issue in loading of RealStats.xlam functions as when I click the cell with #Name? it shows =RESHAPE(A5:C8) in formula bar and now select Insert Function, the function popup shows the name RESHAPE with parameters but below it writes undefined.
I have one observation through ‘Show Calculation Steps’ on selecting the call displaying #Name?, for eg: In Reformat sheet, I select cell with =RESHAPE(A5:C8) in formula bar, and now when I see ‘Show Calculation Steps’ it references Reformat!$E$5 and in this execution it gives #Name?(A5:C8)
May be this info might be helpful in diagnosing the issue?
Sanjeev,
What do you see when you enter the formula =VER() in any blank cell?
Charles
On entering =VER(), getting #NAME?. On checking with ‘Show Calculation Steps’ it references Reformat!$P$17 (Cell number).
Sanjeev,
In this case, the Real Statistics add-in has not been installed or has not been installed correctly.
You need to download and install the Real Statistics Resource Pack before you can use the examples workbooks. See the following webpage:
https://real-statistics.com/free-download/real-statistics-resource-pack/
Charles
Hi,
Although I can download the Real Statistics Resource Pack License, I cannot download the Real Statistics Resource Pack itself – I just get a blank window! I’m using Excel 2013 in Windows 10.
Please advise.
Thank you in advance – much appreciated.
Regards
Roy,
I am not sure what sort of difficulty you are having, but I just downloaded the software without any problems. See
https://real-statistics.com/free-download/real-statistics-resource-pack/
Charles
Sorry to bother you about this simple question:
Does the table presented in Sheet TOC0 of Real-Statistics-Multivariate-Examples.xlsx
represent 120 student ratings of 9 traits or criteria for only ONE professor?
The corresponding web page states “…observed data for each of these (9) variables.”
(Beyond that, Professor Zaiontz deserves a Nobel Prize for these outstanding tools.)
Roland,
I guess you are referring to the data for Principal Component Analysis or Factor Analysis.
The ratings aren’t for any specific professor or professors, but for the students’ ideal professor.
Thanks for your kind words about me.
Charles
Thanks Prof for sharing. I am really enjoy your detail explanation.
Great software but after downloading the latest version it seems to not have the Scheirer-Ray-Hare Test as detailed in your blog post:
https://real-statistics.com/two-way-anova/scheirer-ray-hare-test/
the two way ANOVA options has only the first four options listed in the above link and not the SRH test? Has the test been removed?
Even the help only lists the four test options.
Thanks.
Bryan,
The latest version has seven options. The help lists all seven options.
Charles
Bryan,
Are you using Release 4.11? You can check by using the formula =VER(). The latest version has seven options for the Two Factor ANOVA data analysis tool.
Charles
No, I am not it turns out, I have 3.2.2 but then I downloaded it directly from the above links maybe ten minutes before I posted the message.
Bryan.
Re-downloaded it and now all is good.
Thanks again.
Bryan,
That was probably the version for Mac, which does not yet contain the test that you are looking for.
Charles