Most statistic analysts use statistical software to analyze collected data. Microsoft Excel also has a tool for analyzing statistical data that simply performs values such as average, data dispersion and standard deviation. It also includes high-performance tests such as the T test, and the calculation of regression and Correlation Coefficient. Microsoft Excel is not designed for statistics analysis, but with the help of tools for analyzing statistics that is inactive by default. It is a second choice and can be used at specific times. We will enable the Data Analysis Toolpak Excel extension and use it to compare and analyze statistical data. In this article How to enable Excel data analysis.
Enabling Excel data analysis
To enable the data analysis tool that prepared in Excel 2016, first click on the File tab, and then select Options from the sidebar. In the Options window, select the left column of the Add-ins.
Now on the right bottom of the page, click Go button next to the Manage field. Note that the drop-down menu has been selected for the Excel Add-ins option and no other option.
In the window that appears, click on the Analysis Toolpak check box, and then click OK. The Analysis Toolpak package contains tools for analyzing and analyzing data.
If you’ve done the steps correctly, a new section will be added to the Data tab. Click Data tab at the top of the Excel window and note that the Analysis section contains the Data Analysis tool at the end of it.
Enabled Add-in is just one of the data analysis extensions for Microsoft Excel. In fact, you can use other extensions to make data analysis, processing, and graphs creating and graphical reports, simple and professional.
If you have enabled the Analysis Toolpak extension in the way we discussed, you do not need to use formulas and calculations using Excel functions. Everything is simple and fast in this way. The way to use for this type of analysis is as follows:
First, in the Data tab at the top, click Data Analysis;
In the Select Analysis type window, select your desired one and click OK.
Choose the range of numbers that you entered by clicking the first cell and dragging to the last cell.
Press the Enter key or click the arrow down in the input selection field.
If you need labels for your data, tick the Labels box you see in the image above.
You can save the output to a new worksheet in Excel or to the current page.
Excellent! You learned How to enable Excel data analysis.