The Real Statistics Resource Pack contains a variety of supplemental functions và data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to lớn perform the statistical analyses described in the rest of this website. 

We now explain how to tải về and install the Real Statistics Resource Pack for use with Excel 2010, 2013, 2016, 2019, 2021 or 365 on Windows. If you are using Excel 2007 click here. If you are using Excel 2003 or a prior version of Excel click here. If you are using Excel for the Macintosh click here.

Bạn đang xem: How to install analysis toolpak in excel for mac and windows

Keep in mind that there are also two versions of Excel, at least for Excel 2010, 2013, 2016, 2019, 2021 & 365, the 32-bit version và the 64-bit version. Most people use the 32-bit version. The Real Statistics Resource Pack works in both versions of Excel.

Download

Real Statistics Resource Pack for Excel 2010, 2013, 2016, 2019, 2021 or 365 for Windows

If you accept the License Agreement, click here on Real Statistics Resource Pack for Excel 2010/2013/2016/2019/2021/365 to download the latest Excel for Windows version of the resource pack that accompanies this trang web (Release 8.2.1). This software is compatible with all Windows releases of Excel from 2010 until the present and is named XRealStats.xlam. After downloading the software make sure that you install the software as described below.

Downloading this resource pack means that you accept the License Agreement.

Note: Because of a change in how Excel processes add-ins issued many months ago, the Real Statistics tệp tin is now labeled XRealStats.xlam instead of RealStats.xlam.

Real Statistics Resource Pack for Excel 2002, 2003 or 2007

If you are using Excel 2007, click here for instructions on how to download and install the Real Statistics Resource Pack.

If you are using Excel 2003 or a prior version of Excel, click here for instructions on how to download and install the Real Statistics Resource Pack.

Real Statistics Resource Pack for Excel 2011, 2016, 2019 or 365 for Mac

If you are using a Macintosh version of Excel, click here for instructions on how to download and install the Real Statistics Resource Pack.

Installation

Before trying lớn install the Real Statistics Resource Pack make sure that Excel’s Solver capability is installed on your computer. Check this as follows:

Open up a blank Excel spreadsheetPress Alt-TI (i.e. Hold down the Alt key & press the T and I keys).On the dialog box that appears make sure that the Solver add-in is checked. If not, kiểm tra it & click on the OK button.If the Solver add-in was not checked you need lớn close the Excel file before proceeding to the next step.

Once you have downloaded the Resource Pack và made sure that Solver is installed, you need lớn install the Real Statistics Real Pack using the following steps:

Move the Resource Pack khổng lồ where you want it located on your computer (see our recommendation below). Caution: once you install the resource pack at a particular location it will be more difficult khổng lồ move it later.Open Excel, but don’t try to open the XRealStats.xlam file that you downloaded earlier.Check the Xrealstats option on the dialog box that appears (see Figure 2) và click the OK button. NOTE: If you have previously activated Realstats you must uncheck the Realstats option.If this option doesn’t appear, click on Browse lớn find & choose the xrealstats.xlam file. Then complete step 4 as described above.

Xem thêm: Download Driver Máy In Canon 1210 Từ Hãng & Hướng Dẫn Cài Đặt

*

While you can place the Real Statistics Resource Pack anywhere on your computer, we recommend that you put the tệp tin in the following folder:

C:Usersuser-nameAppDataRoamingMicrosoftAddIns

where user-name is your user name in Microsoft Windows. Since some of these folders are hidden, you may find it convenient to enable showing hidden folders. E.g., in Windows 10 you can vị this by opening Settings and then type Show Hidden Files & Folders in the search field. Next, kiểm tra on the Show hidden files, folders, and drives option in the dialog box that appears and then click on the OK button.

Installation of Upgrades

Once you have installed the Real Statistics Resource Pack as described above, khổng lồ install a new version of the software you don’t need to repeat these steps. You only need khổng lồ delete the previous version of the resource pack and put the new version of the software in the same location as the previous version.

Troubleshooting

If there is a problem during the installation try one or more of the following:

If Excel is running, close it. Find the tệp tin 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 & might be blocked to help protect this computer”. Next to this message is the Unblock checkbox. Make sure this is checked and press the OK button. Start Excel.Click on Options from the File ribbon & then choose the Trust Center option on the left side. Next click on Trust Center Settings …. Now, click on the Macro Settings option on the left side và make sure that it is Disable all Macros with Notification. Also, click on the Trusted Locations option on the left side & click on the Add New Location… button to địa chỉ the thư mục that contains XRealStats file as a trusted location.Try opening a blank Excel worksheet và press Alt-TI. Uncheck the Xrealstats add-in & close Excel. Now mở cửa a blank Excel worksheet và press Alt-TI. This time kiểm tra the Xrealstats add-in

Most important, remember that Solver must be installed. To kiểm tra this, press Alt-TI và make sure that Solver (as well as Xrealstats) is on the danh mục of add-ins with a checkmark next khổng lồ it.

Real Statistics Functions

Once you have installed the Real Statistics Resource Pack you can use the Real Statistics 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 at the Tools menu of the website (or at Real Statistics Functions, Real Statistics Regression/ANOVA Functions, Real Statistics Multivariate Functions and Real Statistics Time Series Functions).

Real Statistics Data Analysis Tools

You can access the Real Statistics data analysis tools in one of the following ways, as described in Accessing Real Statistics Data Analysis Tools:

By pressing Ctrl-m orBy clicking on an icon on the Add-Ins ribbon orBy clicking on an icon on the Quick Access Toolbar orVia the Macro dialog box

A dialog box will now appear which lists all the available Real Statistics data analysis tools. You need to choose one of the data analysis tools from this list.

A dialog box will then appear as described in Real Statistics Supplemental Data Analysis Tools which enables you lớn specify your input data và choose from available options. You can also access Help to lớn get more information about the selected data analysis tool.

A complete các mục of Real Statistics data analysis tools can be found in Real Statistics Supplemental Data Analysis Tools.

Uninstalling the Real Statistics Resource Pack

Open ExcelPress Alt-TIUncheck the Xrealstats option on the dialog box that appears và click the OK button.Close Excel and delete the file that contains the Real Statistics Resource Pack.