LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2002)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments:   To: Steve Kretzer <skretzer@indins.com>
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


Back to: Top of message | Previous page | Main SPSSX-L page