Select ‘Excel add-ins’ and then click on ‘Go’ button. Window named ‘Add-Ins available’ will open. Here check the checkbox for ‘Analysis ToolPak’ and complete the process by clicking on ‘Ok’. After enabling, go to the ‘Data’ tab, click on ‘Analysis’ group under it. Here you will find the ‘Data Analysis’ command.Where can I find the data analysis tool?
Open the Excel sheet and click the Tools menu and go to the Excel Add-ins. Now you will see the box named Add-ins available box. Now select the analysis tool pack checkbox and press ok.