Data Analysis

[Guest]

I am attempting to add-in the analysis toolpak for excel. I have tried twice
and it isn't working. I need this for regression analyses more intricate
than just trendlines. I have closed and reopened the program. It should be
appearing under the Data header in my toolbar and it isn't. I followed the
steps suggested in the "help" window.
Thanks to anyone who can help me,
SDS

 

[Mike Middleton]

SDS -

In Excel 2007, the item "Data Analysis" should appear in the Analysis
section of the Data ribbon.

In Excel 2003 and earlier, the item "Data Analysis" should appear in the
Tools menu.

Which version of Excel are you using?

Please provide more details about what you are doing (mouse clicks and
menus) and what is happening or not happening.

For example, in Excel 2007, in the "Load the Analysis ToolPak" help screen,
are you able to complete the first four steps?

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Niek Otten]

<It should be appearing under the Data header >

No, It's under the Tools header. In my case, it's the last line

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



|I am attempting to add-in the analysis toolpak for excel. I have tried twice
| and it isn't working. I need this for regression analyses more intricate
| than just trendlines. I have closed and reopened the program. It should be
| appearing under the Data header in my toolbar and it isn't. I followed the
| steps suggested in the "help" window.
| Thanks to anyone who can help me,
| SDS

 

[Guest]

That is the problem. I have Excel 2003, I have attempted (with no error
messages occurring) to install the Analysis toolpak and it is not showing up
under Tools, Data or any other header. I followed the steps in the Add-In
procedure to a "t" and it is just not showing up....
Thanks for everyones time.

SDS

 

[Niek Otten]

Activating the ATP requires two steps: 1. Installing, 2. activating

Usually installing is part of the process of installing Excel, so it just requires activating:

Tools>Addins, check Analysis Toolpak

If you don't see the choice of Analysis Toolpak, you'll have to re-install Excel, including the ATP

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|
|
| That is the problem. I have Excel 2003, I have attempted (with no error
| messages occurring) to install the Analysis toolpak and it is not showing up
| under Tools, Data or any other header. I followed the steps in the Add-In
| procedure to a "t" and it is just not showing up....
| Thanks for everyones time.
|
| SDS
|
| "Niek Otten" wrote:
|
| > <It should be appearing under the Data header >
| >
| > No, It's under the Tools header. In my case, it's the last line
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| >
| > |I am attempting to add-in the analysis toolpak for excel. I have tried twice
| > | and it isn't working. I need this for regression analyses more intricate
| > | than just trendlines. I have closed and reopened the program. It should be
| > | appearing under the Data header in my toolbar and it isn't. I followed the
| > | steps suggested in the "help" window.
| > | Thanks to anyone who can help me,
| > | SDS
| >
| >
| >