Forum Discussion

Copper Contributor

Nov 18, 2017

Solved

Analysis Toolpak add-in

I have tried following the steps below to install the Analysis ToolPak onto my Excel. Click the File tab, click Options, and then click the Add-Ins category. If you're using Excel 2007, click...

BI & Data Analysis

excel

Bharat Anand
Sep 06, 2018
Thanks Smitty!

SamVT

Copper Contributor

Aug 26, 2019

I am trying to download the Analysis ToolPak. I got to word/file/add-ins but the option to choose Analysis ToolPak is not an option. I read to choose browser and search for it but there is alsono browser on link. Not sure what to do and my assignment is due today. Your help would be greatly appreciated Smitty Smith

Smitty Smith

Former Employee

Aug 26, 2019

SamVT It's an Excel add-in. 😉

Following up on your PM, here's a link to how to create a Histogram once you have it installed: https://support.office.com/en-us/article/Use-the-Analysis-ToolPak-to-perform-complex-data-analysis-6C67CCF0-F4A9-487C-8DEC-BDB5A2CEFAB6

dprusso
Copper Contributor
Dec 03, 2019
Smitty Smith I'm using excel 16.31 (ms365) on a Mac, and when I don't see the Analysis Tookpak anywhere in the add-in's menu. And when I search for it it doesn't find it anywhere either.
- Smitty Smith
  Former Employee
  Dec 03, 2019
  dprusso For Mac, go to Tools > Excel add-ins > Analysis ToolPak. It will then show up on the Data tab as a button labeled Data Analysis.