Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Use 'tab' function to tabulate the reversed data
From
keeler james <[email protected]>
To
<[email protected]>
Subject
st: Use 'tab' function to tabulate the reversed data
Date
Mon, 24 Jan 2011 19:16:15 +0000
Dear all,
I wonder if anyone can help. For data tabulation of a field in a dataset you can use the command 'tab mk' to list the frequency table as folows. What if we want to do a 'tab' for reversed mk, i.e. starting the largest number first to the smallest number last? In this case it is 112, 109, 106.7, ..., 22, 15.3 1nd 6.7? many thanks.
calchas
. tab mk
Assessment |
mark | Freq. Percent Cum.
------------+-----------------------------------
6.7 | 1 0.09 0.09
15.3 | 1 0.09 0.18
22 | 1 0.09 0.27
23.7 | 1 0.09 0.35
24.7 | 1 0.09 0.44
25.3 | 1 0.09 0.53
26.3 | 1 0.09 0.62
28.7 | 1 0.09 0.71
29.7 | 1 0.09 0.80
31 | 1 0.09 0.88
31.7 | 2 0.18 1.06
32.7 | 1 0.09 1.15
34.7 | 1 0.09 1.24
36 | 2 0.18 1.41
37.3 | 1 0.09 1.50
38 | 1 0.09 1.59
38.7 | 1 0.09 1.68
39.3 | 1 0.09 1.77
40.7 | 1 0.09 1.86
41.7 | 1 0.09 1.94
42 | 1 0.09 2.03
42.7 | 3 0.27 2.30
43 | 1 0.09 2.39
43.3 | 2 0.18 2.56
43.7 | 2 0.18 2.74
44 | 1 0.09 2.83
44.3 | 2 0.18 3.00
44.7 | 1 0.09 3.09
45 | 2 0.18 3.27
45.7 | 4 0.35 3.62
46.7 | 3 0.27 3.89
47 | 1 0.09 3.98
47.3 | 2 0.18 4.15
47.7 | 2 0.18 4.33
48.3 | 1 0.09 4.42
48.7 | 4 0.35 4.77
49 | 2 0.18 4.95
49.3 | 2 0.18 5.12
49.7 | 2 0.18 5.30
50 | 3 0.27 5.57
50.3 | 2 0.18 5.74
50.7 | 4 0.35 6.10
51 | 3 0.27 6.36
51.3 | 1 0.09 6.45
51.7 | 4 0.35 6.80
52 | 4 0.35 7.16
52.3 | 2 0.18 7.33
52.7 | 6 0.53 7.86
53 | 7 0.62 8.48
53.3 | 5 0.44 8.92
53.7 | 1 0.09 9.01
54 | 3 0.27 9.28
54.3 | 4 0.35 9.63
54.7 | 3 0.27 9.89
55 | 6 0.53 10.42
55.3 | 5 0.44 10.87
55.7 | 5 0.44 11.31
56 | 3 0.27 11.57
56.3 | 6 0.53 12.10
56.7 | 5 0.44 12.54
57 | 2 0.18 12.72
57.3 | 6 0.53 13.25
57.7 | 2 0.18 13.43
58 | 2 0.18 13.60
58.3 | 1 0.09 13.69
58.7 | 4 0.35 14.05
59 | 3 0.27 14.31
59.3 | 9 0.80 15.11
59.7 | 4 0.35 15.46
60 | 7 0.62 16.08
60.3 | 7 0.62 16.70
60.7 | 6 0.53 17.23
61 | 4 0.35 17.58
61.3 | 7 0.62 18.20
61.7 | 1 0.09 18.29
62 | 6 0.53 18.82
62.3 | 10 0.88 19.70
62.7 | 6 0.53 20.23
63 | 8 0.71 20.94
63.3 | 7 0.62 21.55
63.7 | 6 0.53 22.08
64 | 5 0.44 22.53
64.3 | 9 0.80 23.32
64.7 | 5 0.44 23.76
65 | 9 0.80 24.56
65.3 | 5 0.44 25.00
65.7 | 9 0.80 25.80
66 | 8 0.71 26.50
66.3 | 8 0.71 27.21
66.7 | 10 0.88 28.09
67 | 13 1.15 29.24
67.3 | 4 0.35 29.59
67.7 | 6 0.53 30.12
68 | 8 0.71 30.83
68.3 | 7 0.62 31.45
68.7 | 14 1.24 32.69
69 | 10 0.88 33.57
69.3 | 12 1.06 34.63
69.7 | 13 1.15 35.78
70 | 7 0.62 36.40
70.3 | 4 0.35 36.75
70.7 | 8 0.71 37.46
71 | 10 0.88 38.34
71.3 | 9 0.80 39.13
71.7 | 10 0.88 40.02
72 | 9 0.80 40.81
72.3 | 5 0.44 41.25
72.7 | 13 1.15 42.40
73 | 14 1.24 43.64
73.3 | 13 1.15 44.79
73.7 | 10 0.88 45.67
74 | 4 0.35 46.02
74.3 | 7 0.62 46.64
74.7 | 10 0.88 47.53
75 | 14 1.24 48.76
75.3 | 7 0.62 49.38
75.5 | 1 0.09 49.47
75.7 | 6 0.53 50.00
76 | 9 0.80 50.80
76.3 | 8 0.71 51.50
76.7 | 12 1.06 52.56
77 | 10 0.88 53.45
77.3 | 13 1.15 54.59
77.4 | 1 0.09 54.68
77.7 | 15 1.33 56.01
78 | 7 0.62 56.63
78.3 | 12 1.06 57.69
78.7 | 9 0.80 58.48
79 | 10 0.88 59.36
79.3 | 13 1.15 60.51
79.7 | 8 0.71 61.22
80 | 13 1.15 62.37
80.3 | 12 1.06 63.43
80.7 | 6 0.53 63.96
81 | 5 0.44 64.40
81.3 | 6 0.53 64.93
81.7 | 9 0.80 65.72
82 | 12 1.06 66.78
82.3 | 16 1.41 68.20
82.7 | 12 1.06 69.26
83 | 12 1.06 70.32
83.3 | 10 0.88 71.20
83.7 | 12 1.06 72.26
84 | 5 0.44 72.70
84.3 | 13 1.15 73.85
84.7 | 10 0.88 74.73
85 | 14 1.24 75.97
85.3 | 9 0.80 76.77
85.7 | 10 0.88 77.65
86 | 8 0.71 78.36
86.3 | 10 0.88 79.24
86.7 | 10 0.88 80.12
87 | 14 1.24 81.36
87.3 | 4 0.35 81.71
87.7 | 8 0.71 82.42
88 | 5 0.44 82.86
88.3 | 7 0.62 83.48
88.7 | 10 0.88 84.36
89 | 7 0.62 84.98
89.3 | 8 0.71 85.69
89.7 | 8 0.71 86.40
90 | 7 0.62 87.01
90.3 | 7 0.62 87.63
90.7 | 7 0.62 88.25
91 | 7 0.62 88.87
91.3 | 6 0.53 89.40
91.7 | 9 0.80 90.19
92 | 8 0.71 90.90
92.3 | 1 0.09 90.99
92.7 | 9 0.80 91.78
93 | 5 0.44 92.23
93.3 | 6 0.53 92.76
93.7 | 4 0.35 93.11
94 | 7 0.62 93.73
94.3 | 7 0.62 94.35
94.7 | 1 0.09 94.43
95 | 5 0.44 94.88
95.3 | 4 0.35 95.23
95.7 | 3 0.27 95.49
96 | 2 0.18 95.67
96.3 | 1 0.09 95.76
96.7 | 4 0.35 96.11
97 | 4 0.35 96.47
97.3 | 8 0.71 97.17
97.7 | 3 0.27 97.44
98 | 2 0.18 97.61
98.3 | 2 0.18 97.79
98.7 | 3 0.27 98.06
99 | 2 0.18 98.23
99.7 | 3 0.27 98.50
100 | 3 0.27 98.76
100.3 | 2 0.18 98.94
101 | 1 0.09 99.03
101.3 | 1 0.09 99.12
102 | 1 0.09 99.20
103 | 2 0.18 99.38
103.7 | 1 0.09 99.47
104 | 1 0.09 99.56
104.3 | 1 0.09 99.65
106 | 1 0.09 99.73
106.7 | 1 0.09 99.82
109 | 1 0.09 99.91
112 | 1 0.09 100.00
------------+-----------------------------------
Total | 1,132 100.00
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/