Excel for nguthan.vn 365 Excel for nguthan.vn 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 More...Less

If you need to lớn develop complex statistical or engineering analyses, you can save steps & time by using the Analysis ToolPak. You provide the data và parameters for each analysis, và the tool uses the appropriate statistical or engineering macro functions lớn calculate and display the results in an output table. Some tools generate charts in addition khổng lồ output tables.

Bạn đang xem: Cách mở data analysis trong excel 2010

The data analysis functions can be used on only one worksheet at a time. When you perform data analysis on grouped worksheets, results will appear on the first worksheet và empty formatted tables will appear on the remaining worksheets. To perform data analysis on the remainder of the worksheets, recalculate the analysis tool for each worksheet.


Cliông chồng the File tab, click Options, và then cliông xã the Add-Ins category.

If you"re using Excel 2007, clichồng the nguthan.vn Office Button

, và then click Excel Options

In the Manage box, select Excel Add-ins & then cliông chồng Go.

If you"re using Excel for Mac, in the tệp tin menu go lớn Tools > Excel Add-ins.

In the Add-Ins box, check the Analysis ToolPak kiểm tra box, and then cliông xã OK.

If Analysis ToolPak is not listed in the Add-Ins available box, clichồng Browse to lớn locate it.

If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes lớn install it.

Note: To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you can load the Analysis ToolPak - VBA Add-in the same way that you load the Analysis ToolPak. In the Add-ins available box, select the Analysis ToolPak - VBA check box.


Load the Analysis ToolPak in Excel for Mac

Cliông xã the Tools thực đơn, and then cliông xã Excel Add-ins.

In the Add-Ins available box, select the Analysis ToolPak check box, and then clichồng OK.

If Analysis ToolPak is not listed in the Add-Ins available box, cliông xã Browse to locate it.

If you get a prompt that the Analysis ToolPak is not currently installed on your computer, clichồng Yes khổng lồ install it.

Quit and restart Excel.

Now the Data Analysis commvà is available on the Data tab.

nguthan.vned languages



Chinese (Simplified)


Chinese (Traditional)






French (Canadian)






Norwegian (Bokmål)






Portuguese (Brazil)






Spanish (Mexico)




I can"t find the Analysis ToolPak in Excel for Mac 2011

There are a few third-buổi tiệc nhỏ add-ins that provide Analysis ToolPak functionality for Excel 2011.

Option 1: Download the XLSTAT add-on statistical software for Mac and use it in Excel 2011. XLSTAT contains more than 200 basic & advanced statistical tools that include all of the Analysis ToolPak features.

Select the XLSTAT version that matches your Mac OS và tải về it.

Open the Excel file that contains your data & cliông chồng on the XLSTAT icon khổng lồ launch the XLSTAT toolbar.

For 30 days, you"ll have sầu access khổng lồ all XLSTAT functions. After 30 days you will be able to use the free version that includes the Analysis ToolPak functions, or order one of the more complete solutions of XLSTAT.

Option 2: Download StatPlus:mac LE for không tính phí from AnalystSoft, and then use StatPlus:mac LE with Excel 2011.

You can use StatPlus:mac LE lớn perform many of the functions that were previously available in the Analysis ToolPak, such as regressions, histograms, analysis of variance (ANOVA), và t-tests.

After you have sầu downloaded and installed StatPlus:mac LE, open the workbook that contains the data that you want lớn analyze.

Xem thêm: Cách Lấy Id Facebook Của Người Khác, Công Cụ Lấy Id Facebook Bằng Link

mở cửa StatPlus:mac LE. The functions are located on the StatPlus:mac LE menus.