Date:         Wed, 21 Feb 2007 14:40:01 -0600
Reply-To:     "Beadle, ViAnn" <viann@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Beadle, ViAnn" <viann@spss.com>
Subject:      Re: Data cleanup with 5% trimmed mean
Comments: To: Brian Moore <bmoore@worldatwork.org>
In-Reply-To:  A<6C01A852608309408AD59AFBFF5DD51A0594CC0C@aca_exchange.worldatwork.org>
Content-Type: text/plain; charset="us-ascii"

Did you try split file, splitting on v2?

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Brian Moore
Sent: Wednesday, February 21, 2007 1:31 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Data cleanup with 5% trimmed mean

Hi all-

How can I include the 5% trimmed mean (accessible in the GUI thru -->explore
commend as a standard statistic) of a variable (V1) as a new variable split
by another (V2).  I'm using V15, but without python programmability
installed.

Thanks,
Brian

Data list list /v1 (f8.0)  v2 (f8.0).
Begin Data
55      1
88      1
75      1
67      1
89      1
96      1
71      1
23      1
93      1
81      1
35      1
82      1
2       1
40      1
56      1
9       1
34      1
4       1
53      1
65      1
68      1
38      1
79      1
88      1
5       1
39      1
50      1
650     2
675     2
888     2
100000  2
500     2
999     2
2459    2
8269    2
5601    2
369     2
2175    2
1892    2
1872    2
4686    2
7239    2
9709    2
5419    2
1678    2
8696    2
2431    2
1486    2
8533    2
2182    2
6858    2
8727    2
5536    2
End Data.