X-Git-Url: https://pintos-os.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=tests%2Flanguage%2Fstats%2Fctables.at;h=44609c73b5dfbb88c6d0b1561172022f43138ece;hb=2569c1e25ddb52f847e688c6b15f1d6c3bb66f28;hp=ef3faabbb8c5d659262fb56e9b02d89e8ce56d6e;hpb=3640237a5fc890a84cb814fbe8bf6fd9299624e4;p=pspp diff --git a/tests/language/stats/ctables.at b/tests/language/stats/ctables.at index ef3faabbb8..44609c73b5 100644 --- a/tests/language/stats/ctables.at +++ b/tests/language/stats/ctables.at @@ -2,7 +2,6 @@ AT_BANNER([CTABLES]) dnl Features not yet tested: dnl - Summary functions: -dnl * Separate summary functions for totals and subtotals. dnl * U-prefix for unweighted summaries. dnl * areaPCT.SUM and UareaPCT.SUM functions. dnl * WEIGHT and adjustment weights. @@ -4804,180 +4803,171 @@ FREQUENCIES SPLIT FILE OFF. CTABLES - /VLABELS VARIABLE=qn19a DISPLAY=NAME /*XXX NONE yields an assertion failure - /TABLE region BY qn19a[VALIDN, MISSING, MEAN, SEMEAN, MEDIAN, MODE, STDDEV, VARIANCE, RANGE, MINIMUM, MAXIMUM, SUM, COUNT, TOTALN, COLPCT.SUM] + /VLABELS VARIABLE=qn19a DISPLAY=NONE + /TABLE region BY qn19a[VALIDN, MISSING, MEAN, SEMEAN, MEDIAN, MODE, STDDEV, VARIANCE, RANGE, MINIMUM, MAXIMUM, SUM, COUNT, TOTALN, ROWPCT.SUM] /CATEGORIES VARIABLES=qn19a TOTAL=YES MISSING=INCLUDE - /SLABELS POSITION=ROW. + /SLABELS POSITION=ROW + /CLABELS ROWLABELS=OPPOSITE. ]]) AT_CHECK([pspp ctables.sps -O box=unicode -O width=120], [0], [dnl - Statistics -╭────────────────┬────────╮ -│REGION │ QN19A │ -├────────────────┼────────┤ -│NE N Valid │ 936│ -│ Missing│ 473│ -│ ╶─────────┼────────┤ -│ Mean │ 19.33│ -│ ╶─────────┼────────┤ -│ S.E. Mean│ .14│ -│ ╶─────────┼────────┤ -│ Median │ 18.00│ -│ ╶─────────┼────────┤ -│ Mode │ 18.00│ -│ ╶─────────┼────────┤ -│ Std Dev │ 4.41│ -│ ╶─────────┼────────┤ -│ Variance │ 19.41│ -│ ╶─────────┼────────┤ -│ Range │ 59.00│ -│ ╶─────────┼────────┤ -│ Minimum │ .00│ -│ ╶─────────┼────────┤ -│ Maximum │ 59.00│ -│ ╶─────────┼────────┤ -│ Sum │18092.00│ -├────────────────┼────────┤ -│MW N Valid │ 1019│ -│ Missing│ 635│ -│ ╶─────────┼────────┤ -│ Mean │ 19.83│ -│ ╶─────────┼────────┤ -│ S.E. Mean│ .16│ -│ ╶─────────┼────────┤ -│ Median │ 19.00│ -│ ╶─────────┼────────┤ -│ Mode │ 18.00│ -│ ╶─────────┼────────┤ -│ Std Dev │ 5.15│ -│ ╶─────────┼────────┤ -│ Variance │ 26.47│ -│ ╶─────────┼────────┤ -│ Range │ 71.00│ -│ ╶─────────┼────────┤ -│ Minimum │ 4.00│ -│ ╶─────────┼────────┤ -│ Maximum │ 75.00│ -│ ╶─────────┼────────┤ -│ Sum │20206.00│ -├────────────────┼────────┤ -│S N Valid │ 1276│ -│ Missing│ 1114│ -│ ╶─────────┼────────┤ -│ Mean │ 20.29│ -│ ╶─────────┼────────┤ -│ S.E. Mean│ .18│ -│ ╶─────────┼────────┤ -│ Median │ 19.00│ -│ ╶─────────┼────────┤ -│ Mode │ 18.00│ -│ ╶─────────┼────────┤ -│ Std Dev │ 6.44│ -│ ╶─────────┼────────┤ -│ Variance │ 41.43│ -│ ╶─────────┼────────┤ -│ Range │ 75.00│ -│ ╶─────────┼────────┤ -│ Minimum │ 4.00│ -│ ╶─────────┼────────┤ -│ Maximum │ 79.00│ -│ ╶─────────┼────────┤ -│ Sum │25886.00│ -├────────────────┼────────┤ -│W N Valid │ 950│ -│ Missing│ 596│ -│ ╶─────────┼────────┤ -│ Mean │ 19.87│ -│ ╶─────────┼────────┤ -│ S.E. Mean│ .17│ -│ ╶─────────┼────────┤ -│ Median │ 19.00│ -│ ╶─────────┼────────┤ -│ Mode │ 18.00│ -│ ╶─────────┼────────┤ -│ Std Dev │ 5.25│ -│ ╶─────────┼────────┤ -│ Variance │ 27.59│ -│ ╶─────────┼────────┤ -│ Range │ 61.00│ -│ ╶─────────┼────────┤ -│ Minimum │ 4.00│ -│ ╶─────────┼────────┤ -│ Maximum │ 65.00│ -│ ╶─────────┼────────┤ -│ Sum │18877.00│ -╰────────────────┴────────╯ + Statistics +╭─────────┬───────────────────────────────────╮ +│ │ REGION │ +│ ├────────┬────────┬────────┬────────┤ +│ │ NE │ MW │ S │ W │ +│ ├────────┼────────┼────────┼────────┤ +│ │ QN19A │ QN19A │ QN19A │ QN19A │ +├─────────┼────────┼────────┼────────┼────────┤ +│N Valid │ 936│ 1019│ 1276│ 950│ +│ Missing│ 473│ 635│ 1114│ 596│ +├─────────┼────────┼────────┼────────┼────────┤ +│Mean │ 19.33│ 19.83│ 20.29│ 19.87│ +├─────────┼────────┼────────┼────────┼────────┤ +│S.E. Mean│ .14│ .16│ .18│ .17│ +├─────────┼────────┼────────┼────────┼────────┤ +│Median │ 18.00│ 19.00│ 19.00│ 19.00│ +├─────────┼────────┼────────┼────────┼────────┤ +│Mode │ 18.00│ 18.00│ 18.00│ 18.00│ +├─────────┼────────┼────────┼────────┼────────┤ +│Std Dev │ 4.41│ 5.15│ 6.44│ 5.25│ +├─────────┼────────┼────────┼────────┼────────┤ +│Variance │ 19.41│ 26.47│ 41.43│ 27.59│ +├─────────┼────────┼────────┼────────┼────────┤ +│Range │ 59.00│ 71.00│ 75.00│ 61.00│ +├─────────┼────────┼────────┼────────┼────────┤ +│Minimum │ .00│ 4.00│ 4.00│ 4.00│ +├─────────┼────────┼────────┼────────┼────────┤ +│Maximum │ 59.00│ 75.00│ 79.00│ 65.00│ +├─────────┼────────┼────────┼────────┼────────┤ +│Sum │18092.00│20206.00│25886.00│18877.00│ +╰─────────┴────────┴────────┴────────┴────────╯ - Custom Tables -╭───────────────────────────┬────────╮ -│ │ QN19A │ -├───────────────────────────┼────────┤ -│REGION NE Valid N │ 936│ -│ Missing │ 473.00│ -│ Mean │ 19.33│ -│ Std Error of Mean│ .14│ -│ Median │ 18.00│ -│ Mode │ 18.00│ -│ Std Deviation │ 4.41│ -│ Variance │ 19.41│ -│ Range │ 59.00│ -│ Minimum │ .00│ -│ Maximum │ 59.00│ -│ Sum │18092.00│ -│ Count │ 1409│ -│ Total N │ 1409│ -│ Column Sum % │ 21.8%│ -│ ╶────────────────────┼────────┤ -│ MW Valid N │ 1019│ -│ Missing │ 635.00│ -│ Mean │ 19.83│ -│ Std Error of Mean│ .16│ -│ Median │ 19.00│ -│ Mode │ 18.00│ -│ Std Deviation │ 5.15│ -│ Variance │ 26.47│ -│ Range │ 71.00│ -│ Minimum │ 4.00│ -│ Maximum │ 75.00│ -│ Sum │20206.00│ -│ Count │ 1654│ -│ Total N │ 1654│ -│ Column Sum % │ 24.3%│ -│ ╶────────────────────┼────────┤ -│ S Valid N │ 1276│ -│ Missing │ 1114.00│ -│ Mean │ 20.29│ -│ Std Error of Mean│ .18│ -│ Median │ 19.00│ -│ Mode │ 18.00│ -│ Std Deviation │ 6.44│ -│ Variance │ 41.43│ -│ Range │ 75.00│ -│ Minimum │ 4.00│ -│ Maximum │ 79.00│ -│ Sum │25886.00│ -│ Count │ 2390│ -│ Total N │ 2390│ -│ Column Sum % │ 31.2%│ -│ ╶────────────────────┼────────┤ -│ W Valid N │ 950│ -│ Missing │ 596.00│ -│ Mean │ 19.87│ -│ Std Error of Mean│ .17│ -│ Median │ 19.00│ -│ Mode │ 18.00│ -│ Std Deviation │ 5.25│ -│ Variance │ 27.59│ -│ Range │ 61.00│ -│ Minimum │ 4.00│ -│ Maximum │ 65.00│ -│ Sum │18877.00│ -│ Count │ 1546│ -│ Total N │ 1546│ -│ Column Sum % │ 22.7%│ -╰───────────────────────────┴────────╯ + Custom Tables +╭────────────────────────┬────────┬────────┬────────┬────────╮ +│ │ NE │ MW │ S │ W │ +├────────────────────────┼────────┼────────┼────────┼────────┤ +│REGION Valid N │ 936│ 1019│ 1276│ 950│ +│ Missing │ 473.00│ 635.00│ 1114.00│ 596.00│ +│ Mean │ 19.33│ 19.83│ 20.29│ 19.87│ +│ Std Error of Mean│ .14│ .16│ .18│ .17│ +│ Median │ 18.00│ 19.00│ 19.00│ 19.00│ +│ Mode │ 18.00│ 18.00│ 18.00│ 18.00│ +│ Std Deviation │ 4.41│ 5.15│ 6.44│ 5.25│ +│ Variance │ 19.41│ 26.47│ 41.43│ 27.59│ +│ Range │ 59.00│ 71.00│ 75.00│ 61.00│ +│ Minimum │ .00│ 4.00│ 4.00│ 4.00│ +│ Maximum │ 59.00│ 75.00│ 79.00│ 65.00│ +│ Sum │18092.00│20206.00│25886.00│18877.00│ +│ Count │ 1409│ 1654│ 2390│ 1546│ +│ Total N │ 1409│ 1654│ 2390│ 1546│ +│ Row Sum % │ 21.8%│ 24.3%│ 31.2%│ 22.7%│ +╰────────────────────────┴────────┴────────┴────────┴────────╯ ]) AT_CLEANUP +AT_SETUP([CTABLES scale summary functions - weighting]) +weight=1 +c=10 +for a in 1 2 9; do + for b in 3 4 9; do + for n in 1 2 3 4 5 6 7 8 9 10; do + if test $c -lt 15; then + cval=. + else + cval=$c + fi + printf "$weight $a $b $cval\n" + weight=$(expr \( $weight + 3 \) % 7 + 2) + c=$(expr \( $c + 13 \) % 29 + 7) + done + done +done > ctables.txt + +AT_DATA([ctables.sps], +[[DATA LIST LIST NOTABLE FILE='ctables.txt' + /w (F5.0) a b c (f2.0). +VAR LEVEL w c (SCALE) a b (NOMINAL). +MISSING VALUES a b (9). + +* Use SPLIT FILE with FREQUENCIES to generate output equivalent to + CTABLES later, to make the results easier to verify. +SPLIT FILE BY a b. +FREQUENCIES + c + /STATISTICS=MEAN SEMEAN MEDIAN MODE STDDEV VARIANCE RANGE MINIMUM MAXIMUM SUM + /FORMAT NOTABLE /MISSING=INCLUDE. +SPLIT FILE OFF. + +CTABLES + /TABLE c[VALIDN, MISSING, MEAN F8.2, SEMEAN F8.2, MEDIAN F8.2, MODE, STDDEV F8.2, VARIANCE F8.2, RANGE F8.2, MINIMUM, MAXIMUM, SUM F8.2, COUNT, TOTALN, LAYERROWPCT.SUM] BY a>b + /SLABELS POSITION=ROW + /CATEGORIES VARIABLES=a b MISSING=INCLUDE. +]]) +AT_CHECK([pspp ctables.sps -O box=unicode -O width=120], [0], [dnl + Statistics +╭─────────┬──────────────────────────────────────────────────────────────╮ +│ │ a │ +│ ├────────────────────┬────────────────────┬────────────────────┤ +│ │ 1 │ 2 │ 9 │ +│ ├────────────────────┼────────────────────┼────────────────────┤ +│ │ b │ b │ b │ +│ ├──────┬──────┬──────┼──────┬──────┬──────┼──────┬──────┬──────┤ +│ │ 3 │ 4 │ 9 │ 3 │ 4 │ 9 │ 3 │ 4 │ 9 │ +│ ├──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│ │ c │ c │ c │ c │ c │ c │ c │ c │ c │ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│N Valid │ 7│ 6│ 8│ 7│ 7│ 8│ 7│ 7│ 8│ +│ Missing│ 3│ 4│ 2│ 3│ 3│ 2│ 3│ 3│ 2│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Mean │ 25.86│ 24.50│ 24.63│ 25.86│ 25.71│ 24.25│ 25.43│ 25.29│ 23.88│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│S.E. Mean│ 2.44│ 2.14│ 2.58│ 2.44│ 2.18│ 2.43│ 2.36│ 2.18│ 2.47│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Median │ 25.00│ 24.50│ 25.00│ 25.00│ 27.00│ 25.00│ 25.00│ 24.00│ 23.50│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Mode │ .│ .│ .│ .│ .│ .│ .│ .│ .│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Std Dev │ 6.47│ 5.24│ 7.31│ 6.47│ 5.77│ 6.88│ 6.24│ 5.77│ 6.98│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Variance │ 41.81│ 27.50│ 53.41│ 41.81│ 33.24│ 47.36│ 38.95│ 33.24│ 48.70│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Range │ 18.00│ 13.00│ 20.00│ 18.00│ 15.00│ 20.00│ 18.00│ 15.00│ 20.00│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Minimum │ 16│ 18│ 15│ 16│ 18│ 15│ 16│ 18│ 15│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Maximum │ 34│ 31│ 35│ 34│ 33│ 35│ 34│ 33│ 35│ +├─────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│Sum │181.00│147.00│197.00│181.00│180.00│194.00│178.00│177.00│191.00│ +╰─────────┴──────┴──────┴──────┴──────┴──────┴──────┴──────┴──────┴──────╯ + + Custom Tables +╭───────────────────┬──────────────────────────────────────────────────────────────╮ +│ │ a │ +│ ├────────────────────┬────────────────────┬────────────────────┤ +│ │ 1 │ 2 │ 9 │ +│ ├────────────────────┼────────────────────┼────────────────────┤ +│ │ b │ b │ b │ +│ ├──────┬──────┬──────┼──────┬──────┬──────┼──────┬──────┬──────┤ +│ │ 3 │ 4 │ 9 │ 3 │ 4 │ 9 │ 3 │ 4 │ 9 │ +├───────────────────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┼──────┤ +│c Valid N │ 7│ 6│ 8│ 7│ 7│ 8│ 7│ 7│ 8│ +│ Missing │ 3│ 4│ 2│ 3│ 3│ 2│ 3│ 3│ 2│ +│ Mean │ 25.86│ 24.50│ 24.63│ 25.86│ 25.71│ 24.25│ 25.43│ 25.29│ 23.88│ +│ Std Error of Mean│ 2.44│ 2.14│ 2.58│ 2.44│ 2.18│ 2.43│ 2.36│ 2.18│ 2.47│ +│ Median │ 25.00│ 24.50│ 25.00│ 25.00│ 27.00│ 25.00│ 25.00│ 24.00│ 23.50│ +│ Mode │ 16│ 18│ 15│ 16│ 18│ 15│ 16│ 18│ 15│ +│ Std Deviation │ 6.47│ 5.24│ 7.31│ 6.47│ 5.77│ 6.88│ 6.24│ 5.77│ 6.98│ +│ Variance │ 41.81│ 27.50│ 53.41│ 41.81│ 33.24│ 47.36│ 38.95│ 33.24│ 48.70│ +│ Range │ 18.00│ 13.00│ 20.00│ 18.00│ 15.00│ 20.00│ 18.00│ 15.00│ 20.00│ +│ Minimum │ 16│ 18│ 15│ 16│ 18│ 15│ 16│ 18│ 15│ +│ Maximum │ 34│ 31│ 35│ 34│ 33│ 35│ 34│ 33│ 35│ +│ Sum │181.00│147.00│197.00│181.00│180.00│194.00│178.00│177.00│191.00│ +│ Count │ 10│ 10│ 10│ 10│ 10│ 10│ 10│ 10│ 10│ +│ Total N │ 10│ 10│ 10│ 10│ 10│ 10│ 10│ 10│ 10│ +│ Layer Row Sum % │ xxxx%│ xxxx%│ xxxx%│ xxxx%│ xxxx%│ xxxx%│ xxx8%│ xxxx%│ xxxx%│ +╰───────────────────┴──────┴──────┴──────┴──────┴──────┴──────┴──────┴──────┴──────╯ +]) +AT_CLEANUP AT_SETUP([CTABLES hidden scale VLABELS]) AT_CHECK([ln $top_srcdir/examples/nhtsa.sav . || cp $top_srcdir/examples/nhtsa.sav .])