Written and maintained by CASRAI Editorial Board
Published
On this page
The Real Statistics Resource Pack is a free Excel add-in from real-statistics.com that adds statistical functions and a dialog-based set of data analysis tools to Excel on Windows. You install it by saving an .xlam file, switching it on through File > Options > Add-Ins (or the Alt-TI shortcut), and then opening the tools with Ctrl-m. This guide walks through that route, explains the choice between the two files in the download, shows what the output looks like, and lists the fixes the author publishes when the add-in will not load.
What the Real Statistics add-in is used for in research
Real Statistics extends Excel with functions that work like Excel’s built-in ones, plus tools that open dialog boxes for whole analyses. The author’s download page groups the functions into categories that appear in the add-in’s own Tools menu: distribution functions, non-parametric test functions, descriptive statistics and reformatting functions, regression and ANOVA functions, correlation and reliability functions, multivariate functions, time series functions, missing data functions, probability functions, mathematical functions and Bayesian functions, plus a separate Data Analysis Tools entry.
For a researcher this means analyses that Excel does not offer out of the box, such as non-parametric tests, reliability statistics or multivariate methods, can be run in the same workbook that holds the data. Excel’s own Analysis ToolPak covers a fixed list of tools; Real Statistics is a separate add-in with a wider list, and the two can be used side by side.
How to download and install the add-in
Download the Resource Pack only from the author’s page at real-statistics.com (the link is in the sources below). Downloading either version of the pack means you accept the License Agreement published there. The download page does not state a price, so this guide gives none.
Which Excel versions are supported
The Windows instructions on the download page cover Excel 2010, 2013, 2016, 2019, 2021, 2024 and 365, in both 32-bit and 64-bit builds. Excel 2007, Excel 2003 and earlier, and Excel for Macintosh each have their own separate instruction pages on the same site, so the Windows steps below do not carry over to them unchanged.
Enable Solver first
Solver must be installed and ticked in the Add-Ins list before Real Statistics will work. Press Alt-TI to open the Add-Ins dialog, check Solver Add-in and click OK. If Solver is missing, some Real Statistics features will not run.
XRealStats.xlam or XRealStatsX.xlam?
The download contains two files, and choosing between them is the one real decision in the installation. The first, XRealStats.xlam, adds help for each Real Statistics function in Excel’s Insert Function (fx) dialog; the author notes that it can slow down certain Excel operations. The second, XRealStatsX.xlam, has no function help in the Insert Function dialog and does not cause that slowdown. Only one version should be switched on at a time. The data table below sets the two files side by side.
Step-by-step: install the Resource Pack in Excel for Windows
- Save the downloaded file where you want to keep it. The author recommends C:Usersuser-nameAppDataRoamingMicrosoftAddIns and warns that the file is harder to move later.
- Open Excel without opening the .xlam file itself.
- Choose File > Help | Options > Add-Ins and click Go, or press Alt-TI.
- Check Xrealstats or Xrealstatsx, depending on the file you saved, and click OK. If another Real Statistics version is already checked, uncheck it first.
- If neither name appears in the list, click Browse, select the .xlam file and repeat the previous step.
Upgrade and uninstall
To upgrade, delete the previous file and put the new one in the same location; the add-in does not need to be set up again. To uninstall, open Excel, press Alt-TI, uncheck Xrealstats or Xrealstatsx, click OK, close Excel and delete the file.
Step-by-step: open the tools and run an analysis
Real Statistics functions are typed into cells like built-in functions. The dialog-based tools open in four ways, according to the author: press Ctrl-m, use the Add-Ins ribbon, click an icon on the Quick Access Toolbar, or choose the add-in from the Macro dialog box. Ctrl-m is the quickest, and the steps below use it.
Descriptive statistics and normality
- Enter your data in columns, with a heading above each column if you want labels in the output.
- Press Ctrl-m and choose Descriptive Statistics and Normality.
- Enter the Input Range in the dialog (the author’s worked example uses A5:B18).
- Check Column headings included with data if the first row holds labels.
- Select Descriptive Statistics, and optionally Use exclusive version of quartile, which switches the quartile calculation to Excel’s QUARTILE.EXC.
- Click OK.
For the same task in the built-in tool, see the CASRAI guide to descriptive statistics in Excel.
One-way ANOVA
The author’s ANOVA example starts the same way: press Ctrl-m, choose Analysis of Variance, then Anova: one factor, enter the Input Range (the example uses A3:D11), select the Excel format with column headings option and the ANOVA option, and click OK. The site notes that its newer multipage interface and the original interface differ slightly in the steps, so match the dialog you see to the page you follow. The two-factor tool outputs three descriptive tables plus the ANOVA table. For a ToolPak-based walkthrough and interpretation, see ANOVA in Excel.
Output and how to read it
The descriptive tool returns everything Excel’s own Descriptive Statistics tool returns, and adds the geometric mean (GEOMEAN), harmonic mean (HARMEAN), median absolute deviation (MAD), average absolute deviation (AAD) and interquartile range (IQR). It can process several data sets in one run.
The practical difference from the ToolPak is that Real Statistics writes formulas, not pasted values. In the author’s example, a mean cell contains =AVERAGE(A6:A18), so editing the data in the input range updates the results. The ToolPak’s output is a static table that must be regenerated after the data change. This is useful when a dataset is still being cleaned, but it also means that deleting or moving the input range can break the output cells. If you need a frozen record of results, copy the output and use Paste Special > Values before changing the data.
Read the output as you would any descriptive table: compare the mean and median for skew, use the IQR or MAD where outliers make the standard deviation less informative, and note which quartile method you selected, because QUARTILE.INC and QUARTILE.EXC give different values on small samples. The normality portion of the same tool is the place to look before choosing a parametric test; Excel’s own quartile functions are the basis for that option.
Troubleshooting
The author’s download page lists these fixes for an add-in that does not load or does not run.
- Unblock the file. Right-click the .xlam file, choose Properties, and on the General tab check Unblock.
- Allow macros from the folder. In Excel’s Trust Center, under Macro Settings choose Disable all Macros with Notification, then add the folder under Trusted Locations with Add New Location.
- Toggle the add-in. If it is not loading, uncheck it in the Alt-TI list, close Excel, reopen Excel and check it again.
- Confirm Solver. Solver must be installed and checked in the same list.
- Run-time error 424 (Object required). The author maintains a separate FAQ entry for this message, linked from the download page.
Free alternatives
If the add-in does not suit your Excel version or platform, other free tools cover the same ground. The table summarises what each tool’s own site states; the CASRAI guide to free statistical software compares them in more depth, and there is a separate entry on jamovi.
| Tool | How you work with it | What its site states about access |
|---|---|---|
| R | Scripting language and environment for statistical computing and graphics | Distributed from CRAN; runs on UNIX-like systems, Windows and macOS |
| jamovi | Free and open statistical spreadsheet | Desktop (installed once, works offline) or Cloud (runs in the browser) |
| JASP | Graphical interface with classical and Bayesian forms of standard analyses | Downloads for Windows, macOS and Linux; released under the GNU Affero GPL v3 |
R is explained in the CASRAI guide to the R statistical programming language.
Frequently asked questions
Is the Real Statistics add-in the same as the Analysis ToolPak?
No. The Analysis ToolPak is Microsoft’s add-in; Real Statistics is a separate add-in from real-statistics.com. Both appear in the Excel Add-Ins list and can be enabled together. Real Statistics writes live formulas into its output, while the ToolPak produces static tables.
Which Excel versions does it support?
On Windows, Excel 2010, 2013, 2016, 2019, 2021, 2024 and 365, in 32-bit and 64-bit. Excel 2007, Excel 2003 and Mac have separate instructions on the author’s site.
What is the shortcut to open the Real Statistics tools?
Ctrl-m. The tools can also be opened from the Add-Ins ribbon, a Quick Access Toolbar icon or the Macro dialog box.
Which file should I choose, XRealStats.xlam or XRealStatsX.xlam?
Choose XRealStats.xlam if you want function help in the Insert Function dialog and accept that it can slow some Excel operations; choose XRealStatsX.xlam if you do not need that help and want to avoid the slowdown.
Why does Real Statistics not appear after I install it?
Check that Solver is installed, unblock the file in its Properties, set the Trust Center macro setting and trusted location described above, and toggle the add-in off and on in the Alt-TI list with Excel closed and reopened in between.
Sources
- Real Statistics Resource Pack (download, installation and troubleshooting), real-statistics.com, read 2026-11-16
- Descriptive Statistics Tools, real-statistics.com, read 2026-11-16
- ANOVA tools (one-factor and two-factor), real-statistics.com, read 2026-11-16
- jamovi download page, jamovi.org, read 2026-11-16
- JASP download page, jasp-stats.org, read 2026-11-16
- R for Windows (CRAN), r-project.org, read 2026-11-16
Data: XRealStats.xlam and XRealStatsX.xlam compared
Side-by-side comparison of the two add-in files in the Real Statistics Resource Pack for Excel on Windows, compiled from the author's download and installation page.
Period covered: 2026.
| Attribute | XRealStats.xlam | XRealStatsX.xlam |
|---|---|---|
| Function help in Insert Function (fx) dialog | Yes | No |
| Can slow down certain Excel operations | Yes, per the author | No |
| Name to check in the Alt-TI Add-Ins list | Xrealstats | Xrealstatsx |
| Supported Windows Excel versions | 2010, 2013, 2016, 2019, 2021, 2024, 365 | 2010, 2013, 2016, 2019, 2021, 2024, 365 |
Sources
- Real Statistics Resource Pack (accessed 2026-11-16)
Compiled by CASRAI from the sources above. Free to reuse under CC BY 4.0 with attribution.







