- If you're into detailed data analysis…there's a new tool pack here in Excel 2016…for the Mac that we're going to explore right now.…It is an add in,…it's installed automatically with Excel,…but you need to enable it.…And here's how we do that.…We're gonna go up to the Tools menu…down to Add-Ins…and that's where you're going to find…the Analysis ToolPak.…Just click the check box…and click Okay.…Now when you go to the Data tab…what you'll see at the very end of the ribbon here…is the Data Analysis button.…

This is done by selecting Office Button > Excel Options > Add-Ins in Excel 2007 or File > Help|Options > Add-Ins in Excel 2010/2013, and clicking the Go button at the bottom of the window. Next you select the Analysis ToolPak option on the dialog box that appears and click the OK button. You will then be able to access the data analysis tools.

Excel Analysis Toolpak Not Showing

Download Analysis Toolpak Excel 2016

It's not there by default…until you enable the add in.…So all we need to do to get…detail data analysis is to click this button.…Notice I'm on the Purchases by Product tab here,…give it a click,…and you'll see a number of different tools.…Quite a long list, actually.…Correlations, Histograms, Moving Averages, Samplings.…I'm gonna go to one that will give us…Descriptive Statistics, give that a click…and click Okay.…

Excel Use Analysis Toolpak

Now I get to choose our Input Range,…I'm gonna click the icon on the right hand side…so I can come into my sheet,…