After you have added the Analysis ToolPak to your Excel software, you will find it on the Data tab. Click on Data and then Data Analysis. You can now complete a number of advanced data analysis tasks ...

Add the Data Analysis ToolPak to Excel Excel’s Data Analysis ToolPak allows you to perform many advanced data analytics functions. Here’s how to enable it.

Use Data Analysis Toolpak: Excel’s Data Analysis Toolpak offers a built-in histogram tool that can simplify the process. Make sure to enable it from the Add-ins menu.