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/comm...lic.excel.misc

In article , ?B?UGVnZ3k=?= wrote:
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.

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 :)

"Bruce Sinclair" wrote:

In article , ?B?UGVnZ3k=?= wrote:
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.

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.

In article , ?B?UGVnZ3k=?= wrote:
"Bruce Sinclair" wrote:

In article ,
?B?UGVnZ3k=?= wrote:
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.

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.

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. :)

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

Many thanks,
clc.



"Peggy" wrote:

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/comm...lic.excel.misc

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


"Carl C." wrote in message
...
All,
How do I install the Analysis Toolkit??? I have followed the instructions
and it doesn't seem to install???

Many thanks,
clc.



"Peggy" wrote:

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/comm...lic.excel.misc

Test
"Carl C." wrote in message
...
All,
How do I install the Analysis Toolkit??? I have followed the instructions
and it doesn't seem to install???

Many thanks,
clc.



"Peggy" wrote:

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/comm...lic.excel.misc

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.

"Peggy" wrote:

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/comm...lic.excel.misc

I agree

"Peggy" wrote:

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/comm...lic.excel.misc