Excel 2008: Analysis Add-in?

[Mike Middleton]

teacher -

You can use worksheet functions in simple formulas to obtain all of the
intermediate calculations: COUNT, AVERAGE, STDEV, SQRT, TINV, TDIST, etc.

For example, if the value of the hypothesized mean is in cell A1 and the
data is in a range "Data" on the worksheet, the t-statistic is
=(AVERAGE(Data)-A1)/(STDEV(Data)/SQRT(COUNT(Data)))

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

 

[silvia mdl]

Why is the Analysis tool pak add-ins is not included in office 2008

 

[Phillip Jones]

Because it use VBA to work and MS ripped VBA out of the Mac version
because it would have delayed the roll out of Office for Mac By about
another two to three years or more.

So to get a product out they opted to leave it out. And then too the
decision was based on the belief that Mac users don't use Macros and VBA.

Unfortunately they didn't take into account nor even consider consulting
the College and University scene.

They didn't expect Colleges and Universities doing such complex stuff on
a Lowly program such as Excel

Why is the Analysis tool pak add-ins is not included in office 2008

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Carl Witthoft]

Because it use VBA to work and MS ripped VBA out of the Mac version
because it would have delayed the roll out of Office for Mac By about
another two to three years or more.

So to get a product out they opted to leave it out. And then too the
decision was based on the belief that Mac users don't use Macros and VBA.

Unfortunately they didn't take into account nor even consider consulting
the College and University scene.

They didn't expect Colleges and Universities doing such complex stuff on
a Lowly program such as Excel

Ok, so I'm an idiot to respond to this extremely old and over-discussed
threadset, but:

Most or all the college kids I know in the sciences are using Matlab or
Mathematica to do their work (or R). If your science dept is pushing
Excel, change schools.

 

[JoeEFR]

Note that the part of the Analysis Toolpak that didn't make it to XL08

was the wizards (e.g., the functions were incorporated into XL so no
add-in was needed). The wizards used XL functions (except the poorly
implemented Random Number Generator), so their results can be obtained
using those functions. See

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

for some pre-made workbooks.

How nice for those people whose data fits the model the oatbran folks have chosen. I'm a teacher an used Excel 2004 for generating histograms of grades for classes of 200 students. It was immensely convenient. The oatbran histogram doesn't work for me because I have gaps -- both in the data (missing items) and in the series (not all values are obtained by some student or other). This was the primary thing I was using Excel for and now I will have to go back to 2004.

I really object to the hype that tells all the wonderful new features being added and not telling all the wonderful old features being deleted. (I did know that VB was being removed but I never imagined that they would not recreate the Analysis Pak features.)