This website provides you with a free download of the Real Statistics Resource Pack, which contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it much easier for you to perform the statistical analyses described in the rest of this website.
To use these supplemental capabilities, you must first install the Real Statistics Resource Pack. You do this by clicking on Free Download. Once you have downloaded the resource pack from this site, you need to install it using the following steps:
- Select Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in versions of Excel starting with Excel 2010, and click on the Go button at the bottom of the window.
- Check the XRealstats or XRealstatsX option in the dialog box that appears, and click the OK button.
- If neither of these options appears, click on Browse to find and choose the Xrealstats.xlam or XrealstasX.xlam file. Then complete step 2 as described above.
Real Statistics worksheet functions
You can use the Real Statistics worksheet 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 Real Statistics Supplemental Functions.
Real Statistics data analysis tools
You can access the Real Statistics data analysis tools by pressing Ctrl-m. A menu of tools will then appear (similar to that of Figure 1 of Excel Data Analysis Tools). Alternatively, you can access the data analysis tools menu from the Quick Access Toolbar as described in Accessing Supplemental Tools.
The main difference with the Excel Toolpak is that the Output Range defaults to the active cell in the worksheet, although it can be changed to any other location in that worksheet. The Output Range must be on the same worksheet as the Input Range, although if the Output Range field is empty, then the output will be displayed on a new worksheet in the same workbook (similar to the New Worksheet Ply described in Figure 2 of Excel Data Analysis Tools).
You can also click on the Help button to get more information about how to fill in the dialog box. A complete list of supplemental data analysis tools can be found in Real Statistics Data Analysis Tools.
Real Statistics Examples Workbooks
Accompanying this website are several Excel workbooks consisting of worksheets that implement the various tests and analyses described in the rest of this website. These workbooks can be downloaded by clicking on the Examples Workbooks link that appears on each web page.
Hello
Thank you for this excellent source for learning. It is a unique tools make learning better and faster.
I want to ask if functions you use, for example ACF function in AR section did you create as modules if so is there a way I can see the formula that makes this function. (As example I am asking generally for other non Microsoft functions used in spreadsheets)
Regads
Hakan
Hello Hakan,
See https://real-statistics.com/time-series-analysis/stochastic-processes/autocorrelation-function/
Charles