Stat Tools

Question

Hello,

I am having trouble find my Stat Tools in my Excel? I have added the Analysis Tool Pack, but I still don't see it. Please, I need assistance.

Thank you,

Richard Roman

Answer 1

If the Analysis ToolPak has been installed, the Data Analysis icon will appear on the far right of the Data ribbon.

Answer 2

Hello Richard,

There's a picture below to help orient you. If you still can't find it, make sure that you used the proper steps to add it.

1. Open Excel, go to File, Options, Add-ins.
2. Click on/select Analysis Toolpak.
3. Go down to Manage: Excel add-ins, and click on "Go...".
4. Check the box next to Analysis Toolpak, then click on OK.

Hope that helps.

Answer 3

Hello,

Yes, I have done that but I still don't see the Stat Tools. In my understanding, I thought I would see the Stat Tools on my ribbon area if I did the steps below? Is there something that I am not doing?

Thank you,

Richard Roman

Hello Richard,

There's a picture below to help orient you. If you still can't find it, make sure that you used the proper steps to add it.

1. Open Excel, go to File, Options, Add-ins.
2. Click on/select Analysis Toolpak.
3. Go down to Manage: Excel add-ins, and click on "Go...".
4. Check the box next to Analysis Toolpak, then click on OK.

Hope that helps.

Answer 4

Hi Richard,

Do you have the "Analysis" box on your "Data" tab as indicated in the picture above? If so, you just need to click where it says "Data Analysis" and your statistics tools will show.

If not, can you post a picture of the Data tab on your PC?