A dialog box will appear similar to that shown in Figure 3.

Select File > Options|Quick Access Toolbar.

This approach is available for Windows users. Access to the Real Statistics main menu is then available by clicking on an icon on the QAT. You can also access the Real Statistics data analysis tools via the Quick Access Toolbar (QAT), which is shown in the upper left-hand corner of Figure 1 of Excel User Interface. We now describe two approaches for setting up this capability.

Press Ctrl-m and choose the Restore Real Statistics on Add-Ins Ribbon option.To do this press the Alt-F8 key sequence, enter the RSRibbon macro name (on the Macro dialog box) and press the Run button. You now have the following three new approaches when Real Statistics disappears from the Add-Ins ribbon (or more commonly when the Add-Ins ribbon itself disappears): If Real Statistics disappears from the Add-Ins ribbon, or more commonly when the Add-Ins ribbon itself disappears, you can take any one of the following actions: This will display the same dialog box as shown in Figure 1.įigure 2 – Accessing data analysis tools via the Add-Ins ribbon

To access these tools, select Add-Ins > Menu Commands|Real Statistics > Data Analysis Tools as shown in the upper left-hand side of Figure 2. When you install the Real Statistics Resource Pack on your computer, a menu item is added to Excel’s Add-Ins ribbon that provides access to the Real Statistics data analysis tools. To enable Ctrl-m, repeat the same sequence of steps except that you need to insert EnableToolsShortcut as the macro name. Next insert the macro name DisableToolsShortcut in the Macro dialog box that appears and press the Run button. To disable Ctrl-m, press Alt-F8 (or select View > Macros|Macros). In this case, you will need to use choose Real Statistics Data Analysis Tools from the Add-Ins ribbon to display this dialog box. This is the easiest approach since it can be done in all versions of Excel (Windows and Mac) no matter which Excel ribbon is active.įigure 1 – Data analysis tools dialog box (main menu)įor those of you who use the keyboard shortcut Ctrl-m for some other purpose, you can disable Crtl-m from being used as a way to display the dialog box for Real Statistics data analysis tools. You can access the dialog box which lets you choose one of the Real Statistics data analysis tools by pressing Ctrl-m. The first approach is also available for the Mac. On this webpage, we present a number of ways for accessing the Real Statistics data analysis tools in the Windows environment.

Stattools for excel 2013 free download