Load and Activate the Analysis ToolPak in MS Excel 2016
Data analysis tools is available in MS Excel for Statistical Analysis.
To install Data Analysis Toolpak in MS Excel 2016, follow the steps described here.
First Click the File tab, click Options.
Then click the Add-Ins category.
Locate the Manage box,appearing at the bottom of Add-ins window. To download Analysis ToolPak, in the Manage box, select Excel Add-ins and then click Go.
In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.
Click Yes to install Analysis ToolPak, If you are prompted that the Analysis ToolPak is not currently installed on your system.
Once the Analysis ToolPak is installed in your System then under the DATA tab in the menu, Data Analysis button will be dispalyed.
On clicking the Data Analysis button, Data Analysis window with statistical tools will be prompted.
No comments:
Post a Comment