options linesize=72;
iv. $BE}7W4XO"(B
/* Lesson 9-01 */ /* File Name = les0901.sas 11/26/08 */ data gakusei; infile 'all08be.prn' firstobs=2; input sex $ shintyou taijyuu kyoui jitaku $ kodukai carryer $ tsuuwa; diff180 =shintyou-180.0; : 180.0 $B$H$N:9$r?7$7$$JQNL$H$7$F(B diff170 =shintyou-170.0; : 170.0 $B$H$N:9$r(B diff169 =shintyou-169.0; : 169.0 $B$H$N:9$r(B diff168 =shintyou-168.0; : 168.0 $B$H$N:9$r(B diff1678=shintyou-167.8; : 167.8 $B$H$N:9$r(B proc print data=gakusei(obs=5); run; proc univariate data=gakusei plot; var shintyou diff180 diff170 diff169 diff168 diff1678; run;
SAS $B%7%9%F%`(B 1 21:18 Monday, November 24, 2008 S D H T K C D D D D I I A J O A T I I I I F N I K I D R S F F F F F T J Y T U R U F F F F 1 O S Y Y O A K Y U 1 1 1 1 6 B E O U U K A E W 8 7 6 6 7 S X U U I U I R A 0 0 9 8 8 1 F 145.0 38 . J 10000 . -35.0 -25.0 -24.0 -23.0 -22.8 2 F 146.7 41 85 J 10000 Vodafone 6000 -33.3 -23.3 -22.3 -21.3 -21.1 3 F 148.0 42 . J 50000 . -32.0 -22.0 -21.0 -20.0 -19.8 4 F 148.0 43 80 J 50000 DoCoMo 4000 -32.0 -22.0 -21.0 -20.0 -19.8 5 F 148.9 . . J 60000 . -31.1 -21.1 -20.1 -19.1 -18.9 SAS $B%7%9%F%`(B 2 21:18 Monday, November 24, 2008 Univariate Procedure Variable=SHINTYOU Moments N 389 Sum Wgts 389 Mean 167.9093 Sum 65316.7 Std Dev 8.267388 Variance 68.34971 Skewness -0.2778 Kurtosis -0.41402 USS 10993798 CSS 26519.69 CV 4.923724 Std Mean 0.419173 T:Mean=0 400.5725 Pr>|T| 0.0001 Num ^= 0 389 Num > 0 389 M(Sign) 194.5 Pr>=|M| 0.0001 Sgn Rank 37927.5 Pr>=|S| 0.0001 SAS $B%7%9%F%`(B 6 21:18 Monday, November 24, 2008 Univariate Procedure Variable=SHINTYOU Histogram # Boxplot 187.5+** 5 | .******** 23 | .******************* 57 | .************************************ 106 +-----+ 167.5+************************* 73 *--+--* .******************** 58 +-----+ .*************** 43 | .****** 18 | 147.5+** 6 | ----+----+----+----+----+----+----+- * may represent up to 3 counts SAS $B%7%9%F%`(B 7 21:18 Monday, November 24, 2008 Univariate Procedure Variable=SHINTYOU Normal Probability Plot 187.5+ ++*** | ******* | ******* | ********* 167.5+ ******++ | *****+ | ******* | ******* 147.5+*+** +----+----+----+----+----+----+----+----+----+----+ -2 -1 0 +1 +2 SAS $B%7%9%F%`(B 8 21:18 Monday, November 24, 2008 Univariate Procedure Variable=DIFF180 Moments N 389 Sum Wgts 389 Mean -12.0907 Sum -4703.3 Std Dev 8.267388 Variance 68.34971 Skewness -0.2778 Kurtosis -0.41402 USS 83386.09 CSS 26519.69 CV -68.3778 Std Mean 0.419173 T:Mean=0 -28.8443 Pr>|T| 0.0001 Num ^= 0 378 Num > 0 17 M(Sign) -172 Pr>=|M| 0.0001 Sgn Rank -35154 Pr>=|S| 0.0001 SAS $B%7%9%F%`(B 14 21:18 Monday, November 24, 2008 Univariate Procedure Variable=DIFF170 Moments N 389 Sum Wgts 389 Mean -2.09075 Sum -813.3 Std Dev 8.267388 Variance 68.34971 Skewness -0.2778 Kurtosis -0.41402 USS 28220.09 CSS 26519.69 CV -395.428 Std Mean 0.419173 T:Mean=0 -4.98778 Pr>|T| 0.0001 Num ^= 0 363 Num > 0 165 M(Sign) -16.5 Pr>=|M| 0.0929 Sgn Rank -8527 Pr>=|S| 0.0001 SAS $B%7%9%F%`(B 20 21:18 Monday, November 24, 2008 Univariate Procedure Variable=DIFF169 Moments N 389 Sum Wgts 389 Mean -1.09075 Sum -424.3 Std Dev 8.267388 Variance 68.34971 Skewness -0.2778 Kurtosis -0.41402 USS 26982.49 CSS 26519.69 CV -757.958 Std Mean 0.419173 T:Mean=0 -2.60214 Pr>|T| 0.0096 Num ^= 0 382 Num > 0 193 M(Sign) 2 Pr>=|M| 0.8780 Sgn Rank -4063.5 Pr>=|S| 0.0596 SAS $B%7%9%F%`(B 26 21:18 Monday, November 24, 2008 Univariate Procedure Variable=DIFF168 Moments N 389 Sum Wgts 389 Mean -0.09075 Sum -35.3 Std Dev 8.267388 Variance 68.34971 Skewness -0.2778 Kurtosis -0.41402 USS 26522.89 CSS 26519.69 CV -9110.52 Std Mean 0.419173 T:Mean=0 -0.21649 Pr>|T| 0.8287 Num ^= 0 371 Num > 0 204 M(Sign) 18.5 Pr>=|M| 0.0615 Sgn Rank 461.5 Pr>=|S| 0.8236 SAS $B%7%9%F%`(B 32 21:18 Monday, November 24, 2008 Univariate Procedure Variable=DIFF1678 Moments N 389 Sum Wgts 389 Mean 0.109254 Sum 42.5 Std Dev 8.267388 Variance 68.34971 Skewness -0.2778 Kurtosis -0.41402 USS 26524.33 CSS 26519.69 CV 7567.092 Std Mean 0.419173 T:Mean=0 0.260643 Pr>|T| 0.7945 Num ^= 0 389 Num > 0 222 M(Sign) 27.5 Pr>=|M| 0.0061 Sgn Rank 1873 Pr>=|S| 0.3993
/* Lesson 9-02 */
/* File Name = les0902.sas 11/26/08 */
data gakusei;
infile 'all08be.prn'
firstobs=2;
input sex $ shintyou taijyuu kyoui
jitaku $ kodukai carryer $ tsuuwa;
if sex^='M' & sex^='F' then delete; : $BCK$G$b=w$G$b$J$$
SAS $B%7%9%F%`(B 2
21:18 Monday, November 24, 2008
Variable N Mean Std Dev Minimum Maximum
---------------------------------------------------------------------
SHINTYOU 388 167.9090206 8.2780614 145.0000000 188.0000000
TAIJYUU 349 58.9512894 9.3973449 35.0000000 100.0000000
KYOUI 119 86.2100840 8.3289102 46.0000000 112.0000000
KODUKAI 373 49058.98 54257.36 0 500000.00
TSUUWA 174 7034.09 7069.90 0 80000.00
---------------------------------------------------------------------
SAS $B%7%9%F%`(B 21
21:18 Monday, November 24, 2008
Univariate Procedure
Variable=KODUKAI
Moments
N 373 Sum Wgts 373
Mean 49058.98 Sum 18299000
Std Dev 54257.36 Variance 2.9439E9
Skewness 3.041002 Kurtosis 16.53948
USS 1.993E12 CSS 1.095E12
CV 110.5962 Std Mean 2809.339
T:Mean=0 17.46282 Pr>|T| 0.0001
Num ^= 0 316 Num > 0 316
M(Sign) 158 Pr>=|M| 0.0001
Sgn Rank 25043 Pr>=|S| 0.0001
SAS $B%7%9%F%`(B 22
21:18 Monday, November 24, 2008
Univariate Procedure
Variable=KODUKAI
Quantiles(Def=5)
100% Max 500000 99% 300000
75% Q3 60000 95% 150000
50% Med 30000 90% 120000
25% Q1 20000 10% 0
0% Min 0 5% 0
1% 0
Range 500000
Q3-Q1 40000
Mode 0
SAS $B%7%9%F%`(B 25
21:18 Monday, November 24, 2008
Univariate Procedure
Variable=KODUKAI
Histogram # Boxplot
550000+* 1 *
.
.* 3 *
.* 2 *
.********* 58 0
50000+********************************************* 309 +--+--+
----+----+----+----+----+----+----+----+----+
* may represent up to 7 counts
SAS $B%7%9%F%`(B 26
21:18 Monday, November 24, 2008
Univariate Procedure
Variable=KODUKAI
Normal Probability Plot
550000+ *
|
| * *
| *
| ************++++
50000+* *********************************
+----+----+----+----+----+----+----+----+----+----+
-2 -1 0 +1 +2
SAS $B%7%9%F%`(B 27
21:18 Monday, November 24, 2008
SHINTYOU Cum. Cum.
Midpoint Freq Freq Percent Percent
|
144 | 1 1 0.26 0.26
148 |* 5 6 1.29 1.55
152 |*** 16 22 4.12 5.67
156 |****** 29 51 7.47 13.14
160 |********* 43 94 11.08 24.23
164 |********* 45 139 11.60 35.82
168 |************ 58 197 14.95 50.77
172 |******************* 95 292 24.48 75.26
176 |********** 49 341 12.63 87.89
180 |******* 35 376 9.02 96.91
184 |** 9 385 2.32 99.23
188 |* 3 388 0.77 100.00
|
----+---+---+---+---
20 40 60 80
Frequency
SAS $B%7%9%F%`(B 32
21:18 Monday, November 24, 2008
KODUKAI Cum. Cum.
Midpoint Freq Freq Percent Percent
|
0 |***************** 129 129 34.58 34.58
50000 |********************** 165 294 44.24 78.82
100000 |******* 49 343 13.14 91.96
150000 |*** 23 366 6.17 98.12
200000 | 3 369 0.80 98.93
250000 | 0 369 0.00 98.93
300000 | 2 371 0.54 99.46
350000 | 1 372 0.27 99.73
400000 | 0 372 0.00 99.73
450000 | 0 372 0.00 99.73
500000 | 1 373 0.27 100.00
|
----+---+---+---+---+--
30 60 90 120 150
Frequency
SAS $B%7%9%F%`(B 33
21:18 Monday, November 24, 2008
--------------------------------- SEX=F --------------------------------
Variable N Mean Std Dev Minimum Maximum
---------------------------------------------------------------------
SHINTYOU 136 159.9139706 6.4932805 145.0000000 187.0000000
TAIJYUU 97 50.4762887 7.4931326 35.0000000 86.0000000
KYOUI 47 83.4893617 4.6150620 70.0000000 100.0000000
KODUKAI 132 51553.03 58503.87 0 500000.00
TSUUWA 77 7653.69 9348.96 80.0000000 80000.00
---------------------------------------------------------------------
SAS $B%7%9%F%`(B 34
21:18 Monday, November 24, 2008
--------------------------------- SEX=M --------------------------------
Variable N Mean Std Dev Minimum Maximum
---------------------------------------------------------------------
SHINTYOU 252 172.2238095 5.4454547 156.0000000 188.0000000
TAIJYUU 252 62.2134921 7.9070633 46.0000000 100.0000000
KYOUI 72 87.9861111 9.6640659 46.0000000 112.0000000
KODUKAI 241 47692.95 51860.04 0 350000.00
TSUUWA 97 6542.25 4508.67 0 30000.00
---------------------------------------------------------------------
SAS $B%7%9%F%`(B 35
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Moments
N 136 Sum Wgts 136
Mean 159.914 Sum 21748.3
Std Dev 6.493281 Variance 42.16269
Skewness 0.790107 Kurtosis 2.206185
USS 3483549 CSS 5691.963
CV 4.060484 Std Mean 0.556794
T:Mean=0 287.2048 Pr>|T| 0.0001
Num ^= 0 136 Num > 0 136
M(Sign) 68 Pr>=|M| 0.0001
Sgn Rank 4658 Pr>=|S| 0.0001
SAS $B%7%9%F%`(B 37
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Quantiles(Def=5)
100% Max 187 99% 180
75% Q3 163.5 95% 171
50% Med 160 90% 167
25% Q1 156 10% 152
0% Min 145 5% 150
1% 146.7
Range 42
Q3-Q1 7.5
Mode 156
SAS $B%7%9%F%`(B 40
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Histogram # Boxplot
185+* 2 0
.*** 6 0
165+******************************** 63 +-----+
.****************************** 59 +--+--+
145+*** 6 |
----+----+----+----+----+----+--
* may represent up to 2 counts
SAS $B%7%9%F%`(B 41
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Normal Probability Plot
185+ * *
| **+*+*++++
165+ ****************
| *****************+
145+*+*+*++**+
+----+----+----+----+----+----+----+----+----+----+
-2 -1 0 +1 +2
SAS $B%7%9%F%`(B 56
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=KODUKAI
Moments
N 132 Sum Wgts 132
Mean 51553.03 Sum 6805000
Std Dev 58503.87 Variance 3.4227E9
Skewness 4.356751 Kurtosis 27.98135
USS 7.992E11 CSS 4.484E11
CV 113.4829 Std Mean 5092.109
T:Mean=0 10.1241 Pr>|T| 0.0001
Num ^= 0 120 Num > 0 120
M(Sign) 60 Pr>=|M| 0.0001
Sgn Rank 3630 Pr>=|S| 0.0001
SAS $B%7%9%F%`(B 58
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=KODUKAI
Quantiles(Def=5)
100% Max 500000 99% 300000
75% Q3 60000 95% 130000
50% Med 40000 90% 100000
25% Q1 20000 10% 8000
0% Min 0 5% 0
1% 0
Range 500000
Q3-Q1 40000
Mode 20000
SAS $B%7%9%F%`(B 61
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=KODUKAI
Histogram # Boxplot
550000+* 1 *
.
.* 1 *
.* 1 *
.***** 15 0
50000+************************************** 114 +--+--+
----+----+----+----+----+----+----+---
* may represent up to 3 counts
SAS $B%7%9%F%`(B 62
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
Univariate Procedure
Variable=KODUKAI
Normal Probability Plot
550000+ *
|
| *
| *
| ++*******+*++++++
50000+* ** ******************************
+----+----+----+----+----+----+----+----+----+----+
-2 -1 0 +1 +2
SAS $B%7%9%F%`(B 63
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Moments
N 252 Sum Wgts 252
Mean 172.2238 Sum 43400.4
Std Dev 5.445455 Variance 29.65298
Skewness 0.00227 Kurtosis 0.247
USS 7482025 CSS 7442.897
CV 3.161848 Std Mean 0.343031
T:Mean=0 502.0643 Pr>|T| 0.0001
Num ^= 0 252 Num > 0 252
M(Sign) 126 Pr>=|M| 0.0001
Sgn Rank 15939 Pr>=|S| 0.0001
SAS $B%7%9%F%`(B 65
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Quantiles(Def=5)
100% Max 188 99% 185
75% Q3 175.5 95% 181
50% Med 172 90% 180
25% Q1 169 10% 166
0% Min 156 5% 163
1% 160
Range 32
Q3-Q1 6.5
Mode 170
SAS $B%7%9%F%`(B 68
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Histogram # Boxplot
187.5+** 4 0
.******** 22 |
.******************* 55 +-----+
172.5+********************************** 102 *--+--*
.***************** 51 +-----+
.****** 16 |
157.5+* 2 0
----+----+----+----+----+----+----
* may represent up to 3 counts
SAS $B%7%9%F%`(B 69
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=SHINTYOU
Normal Probability Plot
187.5+ **+*
| ********+++
| ********++
172.5+ ************
| *********+
| *********+
157.5+*++
+----+----+----+----+----+----+----+----+----+----+
-2 -1 0 +1 +2
SAS $B%7%9%F%`(B 84
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=KODUKAI
Moments
N 241 Sum Wgts 241
Mean 47692.95 Sum 11494000
Std Dev 51860.04 Variance 2.6895E9
Skewness 2.001955 Kurtosis 6.26984
USS 1.194E12 CSS 6.455E11
CV 108.7373 Std Mean 3340.599
T:Mean=0 14.27677 Pr>|T| 0.0001
Num ^= 0 196 Num > 0 196
M(Sign) 98 Pr>=|M| 0.0001
Sgn Rank 9653 Pr>=|S| 0.0001
SAS $B%7%9%F%`(B 86
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=KODUKAI
Quantiles(Def=5)
100% Max 350000 99% 200000
75% Q3 65000 95% 150000
50% Med 30000 90% 120000
25% Q1 10000 10% 0
0% Min 0 5% 0
1% 0
Range 350000
Q3-Q1 55000
Mode 0
SAS $B%7%9%F%`(B 89
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=KODUKAI
Histogram # Boxplot
375000+* 1 *
.* 1 *
.
.* 1 0
.**** 15 0
.******* 28 |
.*********** 43 +-----+
25000+************************************** 152 *--+--*
----+----+----+----+----+----+----+---
* may represent up to 4 counts
SAS $B%7%9%F%`(B 90
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
Univariate Procedure
Variable=KODUKAI
Normal Probability Plot
375000+ *
| *
|
| *
| *****+**+++
| ******+++++
| ++*******+
25000+* ***************************
+----+----+----+----+----+----+----+----+----+----+
-2 -1 0 +1 +2
SAS $B%7%9%F%`(B 91
21:18 Monday, November 24, 2008
Univariate Procedure
Schematic Plots
Variable=SHINTYOU
200 +
|
| * 0
180 + 0 |
| 0 *--+--*
| +-----+ +-----+
160 + *--+--* 0
| +-----+ 0
| |
140 +
------------+-----------+-----------
SEX F M
SAS $B%7%9%F%`(B 92
21:18 Monday, November 24, 2008
Univariate Procedure
Schematic Plots
Variable=TAIJYUU
|
100 + *
| * 0
| 0 *--+--*
50 + *--+--* +-----+
| 0
|
0 +
------------+-----------+-----------
SEX F M
SAS $B%7%9%F%`(B 93
21:18 Monday, November 24, 2008
Univariate Procedure
Schematic Plots
Variable=KYOUI
150 +
|
| 0
100 + 0 +-----+
| *--+--* *--+--*
| 0 0
50 + *
|
|
0 +
------------+-----------+-----------
SEX F M
SAS $B%7%9%F%`(B 94
21:18 Monday, November 24, 2008
Univariate Procedure
Schematic Plots
Variable=KODUKAI
600000 +
| *
|
400000 +
| * *
|
200000 + 0 0
| 0 0
| *--+--* +--+--+
0 + +-----+ *-----*
------------+-----------+-----------
SEX F M
SAS $B%7%9%F%`(B 95
21:18 Monday, November 24, 2008
-------------------------------- SEX=F ---------------------------------
SHINTYOU Cum. Cum.
Midpoint Freq Freq Percent Percent
|
144 |* 2 2 1.47 1.47
150 |****** 12 14 8.82 10.29
156 |********************* 42 56 30.88 41.18
162 |************************** 51 107 37.50 78.68
168 |*********** 22 129 16.18 94.85
174 |** 4 133 2.94 97.79
180 |* 2 135 1.47 99.26
186 |* 1 136 0.74 100.00
|
-----+----+----+----+----+-
10 20 30 40 50
Frequency
SAS $B%7%9%F%`(B 99
21:18 Monday, November 24, 2008
-------------------------------- SEX=M ---------------------------------
SHINTYOU Cum. Cum.
Midpoint Freq Freq Percent Percent
|
156 | 2 2 0.79 0.79
160 |* 6 8 2.38 3.17
164 |*** 17 25 6.75 9.92
168 |********* 44 69 17.46 27.38
172 |****************** 91 160 36.11 63.49
176 |********** 48 208 19.05 82.54
180 |******* 33 241 13.10 95.63
184 |** 9 250 3.57 99.21
188 | 2 252 0.79 100.00
|
----+---+---+---+--
20 40 60 80
Frequency
SAS $B%7%9%F%`(B 104
21:18 Monday, November 24, 2008
SEX SHINTYOU Cum. Cum.
Midpoint Freq Freq Percent Percent
|
F 144 | 1 1 0.26 0.26
148 |* 5 6 1.29 1.55
152 |*** 16 22 4.12 5.67
156 |***** 27 49 6.96 12.63
160 |******* 37 86 9.54 22.16
164 |****** 28 114 7.22 29.38
168 |*** 14 128 3.61 32.99
172 |* 4 132 1.03 34.02
176 | 1 133 0.26 34.28
180 | 2 135 0.52 34.79
184 | 0 135 0.00 34.79
188 | 1 136 0.26 35.05
|
M 144 | 0 136 0.00 35.05
148 | 0 136 0.00 35.05
152 | 0 136 0.00 35.05
156 | 2 138 0.52 35.57
160 |* 6 144 1.55 37.11
164 |*** 17 161 4.38 41.49
168 |********* 44 205 11.34 52.84
172 |****************** 91 296 23.45 76.29
176 |********** 48 344 12.37 88.66
180 |******* 33 377 8.51 97.16
184 |** 9 386 2.32 99.48
188 | 2 388 0.52 100.00
|
----+---+---+---+--
20 40 60 80
Frequency
SAS $B%7%9%F%`(B 110
21:18 Monday, November 24, 2008
SEX KODUKAI Cum. Cum.
Midpoint Freq Freq Percent Percent
|
F 0 |******** 39 39 10.46 10.46
50000 |************** 70 109 18.77 29.22
100000 |*** 14 123 3.75 32.98
150000 |* 5 128 1.34 34.32
200000 | 2 130 0.54 34.85
250000 | 0 130 0.00 34.85
300000 | 1 131 0.27 35.12
350000 | 0 131 0.00 35.12
400000 | 0 131 0.00 35.12
450000 | 0 131 0.00 35.12
500000 | 1 132 0.27 35.39
|
M 0 |****************** 90 222 24.13 59.52
50000 |******************* 95 317 25.47 84.99
100000 |******* 35 352 9.38 94.37
150000 |**** 18 370 4.83 99.20
200000 | 1 371 0.27 99.46
250000 | 0 371 0.00 99.46
300000 | 1 372 0.27 99.73
350000 | 1 373 0.27 100.00
400000 | 0 373 0.00 100.00
450000 | 0 373 0.00 100.00
500000 | 0 373 0.00 100.00
|
----+---+---+---+---
20 40 60 80
Frequency
$B9V5A$N%[!<%`%Z!<%8(B$B$XLa$j$^$9(B