| Date: | Wed, 10 Apr 2002 14:37:59 +0100 |
| Reply-To: | "R. Allan Reese" <R.A.Reese@gri.hull.ac.uk> |
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
| From: | "R. Allan Reese" <R.A.Reese@gri.hull.ac.uk> |
| Subject: | Re: Problem with a Table |
|
| In-Reply-To: | <3CB36A87.F708974E@indins.com> |
| Content-Type: | TEXT/PLAIN; charset=US-ASCII |
|---|
Agreed. Here's a simple example using an SPSS dataset.
GET
FILE='C:\Program Files\SPSS\Home sales [by neighborhood].sav'.
compute group=mod($casenum,2)+1.
execute.
TABLES
/OBSERVATION landval
/TABLES (landval) by (group)
/STATISTICS
validn( ( NEQUAL5.0 ))
mean( ( DOLLAR7.0 ) 'Average')
median( ( DOLLAR7.0 )'Median')
ptile 25( ( DOLLAR7.0 ) '75% Earn More Than')
ptile 75( ( DOLLAR7.0 ) '25% Earn More Than').
Tables
|----------------------------|-------|-------|
| |1.00 |2.00 |
|---------|------------------|-------|-------|
|Appraised|Valid N |N=1220 |N=1220 |
|Land |------------------|-------|-------|
|Value |Average |$16,828|$17,254|
| |------------------|-------|-------|
| |Median |$14,508|$14,490|
| |------------------|-------|-------|
| |75% Earn More Than|$9,940 |$9,940 |
| |------------------|-------|-------|
| |25% Earn More Than|$18,302|$19,084|
|---------|------------------|-------|-------|
TABLES
/OBSERVATION landval
/TABLES (landval) by (group)
/STATISTICS
validn( ( NEQUAL5.0 ))
mean( ( DOLLAR7.0 ) 'Average')
ptile 25( ( DOLLAR7.0 ) '75% Earn More Than')
ptile 75( ( DOLLAR7.0 ) '25% Earn More Than').
Tables
|----------------------------|-------|-------|
| |1.00 |2.00 |
|---------|------------------|-------|-------|
|Appraised|Valid N |N=1220 |N=1220 |
|Land |------------------|-------|-------|
|Value |Average |$16,828|$17,254|
| |------------------|-------|-------|
| |75% Earn More Than|$9,940 |$9,940 |
| |------------------|-------|-------|
| |25% Earn More Than|$18,304|$19,090|
|---------|------------------|-------|-------|
R. Allan Reese Email: r.a.reese@gri.hull.ac.uk
|