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.
On this webpage, we describe how to download and install the Real Statistics Resource Pack for the Mac.
Download
If you accept the License Agreement, click on one of the following options to download the appropriate version of the Real Statistics resource pack for Excel on the Mac:
- Click here on Real Statistics Resource Pack for Mac 2016/2019/2021/2024/365 to download the latest version (Release 9.6.1) of the resource pack for Excel 2016, 2019, 2021, 2024, or 365 for the Mac.
- Click here on Real Statistics Resource Pack for Mac 2011 to download the latest version (Release 5.11) of the resource pack for Excel 2011 for the Mac.
Downloading this resource pack means that you accept the License Agreement.
Installation
Once you have downloaded the Resource Pack, you need to install it using the following steps.
- Move the Resource Pack to where you want it located on your computer. 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-mac.xlam or realstats-mac-2011.xlam file that you downloaded earlier.
- From the Tools menu choose Add-Ins.
- Make sure that the Solver option is checked on the dialog box that appears.
- Check the XRealstats-Mac (or Realstats-Mac-2011) option on the dialog box that appears and click the OK button.
- If the XRealstats-Mac (or Realstats-Mac-2011) option doesn’t appear, click on Browse to find and choose the XRealStats-Mac.xlam (or RealStats-Mac-2011.xlam) file that you downloaded earlier. Then complete step 5 as described above.
Real Statistics Functions
Once you have installed the Real Statistics Resource Pack you can use the supplemental functions in the same way as you use the built-in worksheet functions supplied with Excel. These functions are described throughout the rest of this website. A complete list of these functions can be found in the Tools menu of the website.
Real Statistics Data Analysis Tools
To use the data analysis tools enter Control-m (i.e. control key + m) or click on the Real Statistics menu.
The descriptions of how to use the Real Statistics functions and data analysis tools apply to the Mac version of the software, although sometimes with minor modifications especially as described in Mac User Interface.
Uninstalling the Real Statistics Resource Pack
- Open Excel, but don’t try to open the XRealStats-Mac.xlam or RealStats-Mac-2011.xlam file that you downloaded earlier.
- From the Tools menu choose Add-Ins.
- Uncheck the XRealStats-Mac or RealStats-Mac-2011 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 installed and opened using Control+M on my Mac(M1 Chip). It is not showing check boxes when I select any test, say Regression. I can’t check uncheck whether I need Durbin Watson Test or not.
Hello Sujal,
1. This seems to be a problem that Mac users have identified in many contexts, not just with Real Statistics. You can get more information by using the search “checkmark not displayed on the Mac”. In particular, the following links may be helpful:
https://github.com/fontforge/fontforge/issues/5463
https://learn.microsoft.com/en-us/answers/questions/5110017/checkboxes-in-word-2021-for-mac-not-working
2. In any case, for Real Statistics you can still click on the text next to where the checkmarks should be. This will turn on and off the checkmark. Unfortunately, you won’t be able to tell for certain whether a particular option is on or off.
3. I will look into this issue and see whether I can overcome this Mac bug, at least for Real Statistics.
Charles
Hello Sujal,
The other person who has experienced this problem has now informed me that he has updateed his Mac to macOS 26.1 (the latest version released by Apple) and his version of Excel was also updated. Now everything works as expected and the checkboxes are now visible.
Charles
Thanks for this great tool. I am looking at the Real Statistics options but I do not see the Tukey Kramer test. Is it here?
Hello Shae,
It is there. It is an option on the One Factor Anova data analysis tool (from the Anova tab), although it is labeled Tukey HSD.
The Tukey-Kramer test is also an option for other versions of Anova.
Charles
I’m using a Macbook Air, running on Tahoe 26.0.1, Apple M2 chip, and 8GB of memory, and am having issues running some tests. To date, I’m experiencing issues with lagging and waiting for results when I try to run the Mann-Whitney test and Fisher’s Exact test. Is there a reason why it’s lagging?
Also, is there a way to make the Real Statistics menu font size larger? The only workaround that I could find on Google was option+command+=, which isn’t helpful when I’m trying to highlight data (I’m finding myself zooming in and out, more so because the font size in the Real Statistics menu box is so small. Any other workarounds?
Hello Kauahi,
1. The Mann-Whitney Test should be very fast unless you enable Include Simulation. In this case, a lot of calculations are required and so it will take some time to produce the results. Similarly, Fisher’s Exact Test will be slow if the number of rows + columns is high or the sum of the counts is hight.
2. I agree. The dialog boxes are very small, but this is how Microsoft implemented dialog boxes on the Mac. The only solution is described at
https://real-statistics.com/appendix/faqs/enlarge-dialog-box-on-mac/
Charles
I accept license agreement
wel done
Hello,
My real stats analysis tool pack is downloaded onto my Mac Excel and shows in my Analysis Tools but when I try to see if I can access it in “Add-ins” it does not show up.
Could you please let me know what I can do ?
Thank you
Hello Dania,
To access the Real Statistics analysis tools, you need to use the key sequence Ctrl-m since there is no way to access these tools from the Add-ins ribbon. This approach is only supported in the Windows version of the software.
Charles
By ‘’’This approach..’’’ I understand that you do explicitly mean ‘”to access these tools from the Add-ins ribbon.’’’ and use Mac users just need to use the Ctrl-m step. THANKS for this package so I can do frequency weighted statistics for wind / gust speed data!
John
Yes, John, that is correct.
Charles
Me parece que es un complemento ideal para el análisis estadístico de datos, facilita mucho el análisis de información.
good