EXCEL ADD-INS

[JO...@officeformac.com]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

How do I get the ADD-Ins for excel for doing analysis such as regression?

[Bob Greenblatt]

On 4/9/08 9:20 AM, in article ee97e...@webcrossing.caR9absDaxw,
"JO...@officeformac.com" <JO...@officeformac.com> wrote:

Currently, they are unavailable as most add-ins were developed using VBA
which is unsupported in Excel 2008. However, all the functions in the
Analysis tool Pack for Excel 2004 re present as native functions in 2008.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

[JO...@officeformac.com]

> On 4/9/08 9:20 AM, in article ee97e...@webcrossing.caR9absDaxw,

> "JO...@officeformac.com" wrote:
>
> &gt; Version: 2008
> &gt; Operating System: Mac OS X 10.5 (Leopard)
> &gt; Processor: intel
> &gt;
> &gt; How do I get the ADD-Ins for excel for doing analysis such as regression?

> Currently, they are unavailable as most add-ins were developed using VBA
> which is unsupported in Excel 2008. However, all the functions in the
> Analysis tool Pack for Excel 2004 re present as native functions in 2008.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
>

> I am sorry but this is not correct. The regression tool allowed for multiple independent variables. What is in Excel 2008 is only the very limited ability to fit a a trend line. This a MAJOR failure. When can I expect a macro to do regression analysis.

[Bob Greenblatt]

On 4/9/08 10:42 AM, in article ee97...@webcrossing.caR9absDaxw,
"JO...@officeformac.com" <JO...@officeformac.com> wrote:

We are just users like you. I have no idea when (or even if) you can expect
a solution. Try googling oatbran to see if any of their solutions will work.

[JE McGimpsey]

In article <ee97...@webcrossing.caR9absDaxw>, JO...@officeformac.com
wrote:

> > > Currently, they are unavailable as most add-ins were developed
> > > using VBA which is unsupported in Excel 2008. However, all the
> > > functions in the Analysis tool Pack for Excel 2004 re present as
> > > native functions in 2008.
> >

> > I am sorry but this is not correct. The regression tool allowed for
> > multiple independent variables. What is in Excel 2008 is only the very
> > limited ability to fit a a trend line. This a MAJOR failure. When can I
> > expect a macro to do regression analysis.

It *IS* correct. The regression tool is NOT a function.

The tool is a wizard that of course doesn't work now since VBA was
removed. But the wizard is only a shortcut for using LINEST(), which
handles multiple regression with up to 16 variables.

LINEST() still works fine in XL08. So no macro is strictly necessary -
though it's obviously less convenient.

[Jaques Alberto Bensussan]

> How do I get the ADD-Ins for 2008 excel for doing analysis such as regression with Hypothesis Tests, as t, F, available for 2004 Excel?

[Bob Greenblatt]

On 4/21/08 1:50 PM, in article ee97...@webcrossing.caR9absDaxw, "Jaques
Alberto Bensussan" <bens...@terra.com.br> wrote:

>> How do I get the ADD-Ins for 2008 excel for doing analysis such as regression
>> with Hypothesis Tests, as t, F, available for 2004 Excel?

The short answer is you can't. Excel 2008 does not support VBA, so the
Analysis tool Pack used with Excel 2004 will not work. However, all the
functions available in the 2004 ATP are now built in functions in Excel
2008. However, the analysis wizards are not available, but you can
accomplish the same thing with several steps. Not as convenient, but it
works.

[GregWhy]

> On 4/21/08 1:50 PM, in article ee97...@webcrossing.caR9absDaxw, "Jaques

> Alberto Bensussan" wrote:
>
> >> How do I get the ADD-Ins for 2008 excel for doing analysis such as regression
> >> with Hypothesis Tests, as t, F, available for 2004 Excel?
> The short answer is you can't. Excel 2008 does not support VBA, so the
> Analysis tool Pack used with Excel 2004 will not work. However, all the
> functions available in the 2004 ATP are now built in functions in Excel
> 2008. However, the analysis wizards are not available, but you can
> accomplish the same thing with several steps. Not as convenient, but it
> works.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom
>
>

Histograms are also apparently gone, which I use quite regularly. Is there a simple way to do them in Excel 2008? If not, I have to go back to Excel 2004. :frown:

[Bob Greenblatt]

On 4/22/08 8:25 AM, in article ee97...@webcrossing.caR9absDaxw, "GregWhy"
<ga...@cornell.edu> wrote:

Try this:
http://www.coventry.ac.uk/ec/~nhunt/oatbran/

[JE McGimpsey]

In article <ee97...@webcrossing.caR9absDaxw>,
GregWhy <ga...@cornell.edu> wrote:

> Histograms are also apparently gone, which I use quite regularly. Is there a
> simple way to do them in Excel 2008? If not, I have to go back to Excel 2004.
> :frown:

See the histogram sheet at

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

[Douglas Clarke]

I supossed when you make a new Office, It must be simplier than de preview one. The use of regression with the ADD-Ins in the analysis tool pack was easier with the Excel 2004. It can be possible than I can "acomplish the same thing with several steps. Not as convenient but It works" with Excel 2008, if only a week ago I could do It easier with Excel 2004. Do I really have to go back to Excel 2004?

[Bob Greenblatt]

On 4/30/08 12:02 AM, in article ee97...@webcrossing.caR9absDaxw, "Douglas
Clarke" <pam_c...@hotmail.com> wrote:

Unfortunately, the Analysis Tool Pack was removed from Office 2008 because
it is based on VBA. As you noted, all the ATP functions have been
incorporated directly in Excel 2008, but the ATP wizards have not. You will
have to decide for yourself whether or not to continue with Excel 2008, or
return to Excel 2004. Realize, however, that both can be installed and used
at the same time with no problems.