Excel Data Analysis Tool Pak

P

Peggy

Why do you not include a Mean Separation Test, like Duncans or Fishers? Your
analysis is incomplete if after I perform an ANOVA I can't do a mean
seperation to find out where my differences lie.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...e-1f6ee212cb6a&dg=microsoft.public.excel.misc
 
B

Bruce Sinclair

Why do you not include a Mean Separation Test, like Duncans or Fishers? Your
analysis is incomplete if after I perform an ANOVA I can't do a mean
seperation to find out where my differences lie.
Click to expand...

Excel is not a statistics package - and neither should it try to be. It
provides a few simple stats functions for data exploration kinds of things.
If you need serious stats, use a stats program :)
 
P

Peggy

Bruce Sinclair said:
Excel is not a statistics package - and neither should it try to be. It
provides a few simple stats functions for data exploration kinds of things.
If you need serious stats, use a stats program :)

I don't consider one or two mean separation tests something that requires an involved stats program. Most stats programs are much more in depth that most people need. The stats package in Excel would be perfect for most analysis if it included a mean separation. As it stands the ANOVA analysis is worthless without it.
Click to expand...
 
B

Bruce Sinclair

involved stats program. Most stats programs are much more in depth that most
people need. The stats package in Excel would be perfect for most analysis if
it included a mean separation. As it stands the ANOVA analysis is worthless
without it.
Click to expand...

That's your opinion, which is fine. Problem is, everyone has their own list
of things that they think are essential. Once you add all those together,
you have SAS, minitab, statistica, genstat or something similar ... not
excel. Excel should stick to what it's good at. :)

Agree that most stats programs have many more features and functions than
most people will ever use - but I also find that with excel. Last thing I
personally need is even more unused functions. :)
 
C

Carl C.

All,
How do I install the Analysis Toolkit??? I have followed the instructions
and it doesn't seem to install???

Many thanks,
clc.
 
M

MartinW

If it wasn't included in your initial Office installation
then you will need to have the original disc and then
you can install it from there.

HTH
Martin
 
M

Mpumi

l agree with you peggy at the same time Bruce may have a valid point. l also
wanted excel to do an ANOVA with replication on a split plot design and still
can't get that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL FUNCTIONS 1
How do a import data from a text file to an excel worksheet 4
please, add the feature that allows us to attach file with our thr 3
distinct count summarize Data for pivoit table 1
Why can't I find my posted questions??? 0
EXCEL 2007 - DATA VALIDATION LIST 2
EXCEL 2007 -INSERT WORK SHEET ICON 2
Email a single Excel worksheet instead of the whole workbook. 2

Top