Excel 2007 Analysis Toolpak

Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.

Hi,

What about Formulas tab, More Functions?

Cheers
Andy

Neal Stoughton wrote:
> Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
> I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Not there. I was specifically interested in the data analysis/regression
where it computes the slope/intercept and a whole host of other related
statistics.

I guess I should have waited to install the update until after the day I
have to do a public presentation!

"Andy Pope" wrote:

> Hi,
>
> What about Formulas tab, More Functions?
>
> Cheers
> Andy
>
> Neal Stoughton wrote:
> > Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
> > I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.
> >
> >
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

Many (all?) functions from ATP have become worksheet functions, but the
regression tool in ATP is not a function. All output of the ATP regression
tool is either given by or is easily computed from the output of the LINEST
worksheet function.

Jerry

"Neal Stoughton" wrote:

> Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
> I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.

It's at the end of the Formulas tab.

--
Jim
"Neal Stoughton" <Neal Stoughton@discussions.microsoft.com> wrote in message
news:3A47E96A-A012-4BF5-9B7E-398EBCDE430E@microsoft.com...
| Not there. I was specifically interested in the data analysis/regression
| where it computes the slope/intercept and a whole host of other related
| statistics.
|
| I guess I should have waited to install the update until after the day I
| have to do a public presentation!
|
| "Andy Pope" wrote:
|
| > Hi,
| >
| > What about Formulas tab, More Functions?
| >
| > Cheers
| > Andy
| >
| > Neal Stoughton wrote:
| > > Where are the data analysis functions of the Analysis Toolpak in Excel
2007?
| > > I cannot find them anywhere? Not in the Data tab, not in the Formulas
tab.
| > >
| > >
| >
| > --
| >
| > Andy Pope, Microsoft MVP - Excel
| > http://www.andypope.info
| >

No its not there unless you enable the "add in" via that new circular button
on the top left of the menu. Finally I figured that out after a lot of
trials and tribulations. It is buried in a further menu as well. How they
expect people to figure out this stuff is beyond me.

"Jim Rech" wrote:

> It's at the end of the Formulas tab.
>
> --
> Jim
> "Neal Stoughton" <Neal Stoughton@discussions.microsoft.com> wrote in message
> news:3A47E96A-A012-4BF5-9B7E-398EBCDE430E@microsoft.com...
> | Not there. I was specifically interested in the data analysis/regression
> | where it computes the slope/intercept and a whole host of other related
> | statistics.
> |
> | I guess I should have waited to install the update until after the day I
> | have to do a public presentation!
> |
> | "Andy Pope" wrote:
> |
> | > Hi,
> | >
> | > What about Formulas tab, More Functions?
> | >
> | > Cheers
> | > Andy
> | >
> | > Neal Stoughton wrote:
> | > > Where are the data analysis functions of the Analysis Toolpak in Excel
> 2007?
> | > > I cannot find them anywhere? Not in the Data tab, not in the Formulas
> tab.
> | > >
> | > >
> | >
> | > --
> | >
> | > Andy Pope, Microsoft MVP - Excel
> | > http://www.andypope.info
> | >
>
>
>

That is most definitely not true. There are a whole host of statistics and
significance levels that are done by the regression tool that would have to
be constructed manually using multiple functions.

"Jerry W. Lewis" wrote:

> Many (all?) functions from ATP have become worksheet functions, but the
> regression tool in ATP is not a function. All output of the ATP regression
> tool is either given by or is easily computed from the output of the LINEST
> worksheet function.
>
> Jerry
>
> "Neal Stoughton" wrote:
>
> > Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
> > I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.

LINEST is the calculation engine for the ATP regression tool. Results
identically match those produced from LINEST in the same version. Results
differ between Excel 2003 and earlier versions in exactly the same way that
LINEST results differ, even though ATP was not updated in 2003.

If you will indicate the regression tool items that you do not know how to
calculate from LINEST, perhaps I can enlighten you.

Jerry

"Neal Stoughton" wrote:

> That is most definitely not true. There are a whole host of statistics and
> significance levels that are done by the regression tool that would have to
> be constructed manually using multiple functions.
>
> "Jerry W. Lewis" wrote:
>
> > Many (all?) functions from ATP have become worksheet functions, but the
> > regression tool in ATP is not a function. All output of the ATP regression
> > tool is either given by or is easily computed from the output of the LINEST
> > worksheet function.
> >
> > Jerry
> >
> > "Neal Stoughton" wrote:
> >
> > > Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
> > > I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.