Posted by
Richard Ristow on
Dec 03, 2010; 9:26pm
URL: http://spssx-discussion.165.s1.nabble.com/test-on-means-for-subgroups-vs-total-tp3278152p3291606.html
At 04:45 AM 11/24/2010, Alexandra Chirilov wrote:
>Could you help me with an excel which perform test on means for
>subgroups vs. total?
None of the standard tests compare subgroups with the total; they
compare non-overlapping subgroups with each other.
The general term for comparing subgroup means is 'analysis of
variance' ('ANOVA'). There are many variations on ANOVA, but the
place to start is with a simple one-way ANOVA, unless there's reason
in your study to do otherwise. (A still better place to start is to
get advice from someone who knows the statistical methods and the
details of your study, who can tell what methods would be appropriate.)
If you want to do this in Excel, the main advice you'll get here is,
don't. Lots of people do statistical analysis in Excel, but the
general professional opinion is that Excel isn't very good for that,
and there are many risks in using it.
If you have SPSS, and can load your data into SPSS, from the menus try
Analyze > Compare Means > One-Way ANOVA
You *must* have someone statistically knowledgeable help you to
understand the results. You can also post SPSS and statistical
questions here, though there's no substitute for someone you can talk
with face to face.
-Best of luck,
Richard Ristow
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD