Lab2 Markdown
2026-10-02
Read the data
★讀取資料
library(haven)
pisa.dat <- read_spss("PISA_tawian2022_trimmed_lab.sav")Descriptive stat
★列出所有變項的最大值、最小值、中位數、平均值、第一四分位數、第三四分位數
summary(pisa.dat) ## CNT CNTSTUID NatCen Gender
## Length :5599 Min. :15800002 Length :5599 Min. :1.000
## N.unique : 1 1st Qu.:15802092 N.unique : 1 1st Qu.:1.000
## N.blank : 0 Median :15804235 N.blank : 0 Median :2.000
## Min.nchar: 3 Mean :15804221 Min.nchar: 6 Mean :1.503
## Max.nchar: 3 3rd Qu.:15806338 Max.nchar: 6 3rd Qu.:2.000
## Max. :15808413 Max. :2.000
## AGE ESCS REPEAT MISSSC
## Min. :15.33 Min. :-3.8421 Min. :0.000000 Min. :0.00000
## 1st Qu.:15.58 1st Qu.:-0.9395 1st Qu.:0.000000 1st Qu.:0.00000
## Median :15.83 Median :-0.2368 Median :0.000000 Median :0.00000
## Mean :15.81 Mean :-0.2701 Mean :0.007323 Mean :0.02375
## 3rd Qu.:16.08 3rd Qu.: 0.4393 3rd Qu.:0.000000 3rd Qu.:0.00000
## Max. :16.33 Max. : 4.2070 Max. :1.000000 Max. :1.00000
## SKIPPING WORKPAY MATHMOT RELATST
## Min. :0.0 Min. : 0.0000 Min. :0.00000 Min. :-6.2677
## 1st Qu.:0.0 1st Qu.: 0.0000 1st Qu.:0.00000 1st Qu.:-0.3331
## Median :0.0 Median : 0.0000 Median :0.00000 Median : 0.1440
## Mean :0.1 Mean : 0.6269 Mean :0.04608 Mean : 0.3006
## 3rd Qu.:0.0 3rd Qu.: 0.0000 3rd Qu.:0.00000 3rd Qu.: 0.8408
## Max. :1.0 Max. :10.0000 Max. :1.00000 Max. : 3.1654
## BELONG STRESAGR GROSAGR TEACHSUP
## Min. :-3.25830 Min. :-5.24990 Min. :-3.5994 Min. :-2.9095
## 1st Qu.:-0.48610 1st Qu.:-0.39990 1st Qu.:-0.3061 1st Qu.:-0.3322
## Median :-0.24820 Median :-0.00690 Median :-0.0144 Median :-0.1002
## Mean : 0.01419 Mean :-0.04094 Mean : 0.1384 Mean : 0.2342
## 3rd Qu.: 0.41630 3rd Qu.: 0.29860 3rd Qu.: 0.7798 3rd Qu.: 1.5558
## Max. : 2.75620 Max. : 5.58370 Max. : 3.3724 Max. : 1.5558
## ANXMAT MATHPERS PV1MATH PV1READ
## Min. :-2.3945 Min. :-3.13190 Min. :219.1 Min. :167.4
## 1st Qu.:-0.2758 1st Qu.:-1.08650 1st Qu.:460.4 1st Qu.:439.2
## Median : 0.3378 Median :-0.52750 Median :541.6 Median :515.9
## Mean : 0.3078 Mean :-0.51540 Mean :537.8 Mean :509.2
## 3rd Qu.: 0.7889 3rd Qu.:-0.02115 3rd Qu.:618.8 3rd Qu.:582.0
## Max. : 2.6350 Max. : 2.83150 Max. :917.4 Max. :864.8
## PV1SCIE
## Min. :194.7
## 1st Qu.:462.5
## Median :536.1
## Mean :530.8
## 3rd Qu.:602.8
## Max. :882.7★列出ESCS此變項的最大值、最小值、中位數、平均值、第一四分位數、第三四分位數
summary(pisa.dat$ESCS)## Min. 1st Qu. Median Mean 3rd Qu. Max.
## -3.8421 -0.9395 -0.2368 -0.2701 0.4393 4.2070★列出所有變項的敘述統計量
library(psych)
describe(pisa.dat) ## vars n mean sd median trimmed mad
## CNT* 1 5599 1.00 0.00 1.00 1.00 0.00
## CNTSTUID 2 5599 15804220.87 2429.17 15804235.00 15804223.15 3143.11
## NatCen* 3 5599 1.00 0.00 1.00 1.00 0.00
## Gender 4 5599 1.50 0.50 2.00 1.50 0.00
## AGE 5 5599 15.81 0.29 15.83 15.81 0.37
## ESCS 6 5599 -0.27 0.91 -0.24 -0.25 1.02
## REPEAT 7 5599 0.01 0.09 0.00 0.00 0.00
## MISSSC 8 5599 0.02 0.15 0.00 0.00 0.00
## SKIPPING 9 5599 0.10 0.30 0.00 0.00 0.00
## WORKPAY 10 5599 0.63 1.98 0.00 0.05 0.00
## MATHMOT 11 5599 0.05 0.21 0.00 0.00 0.00
## RELATST 12 5599 0.30 1.05 0.14 0.23 0.82
## BELONG 13 5599 0.01 0.93 -0.25 -0.09 0.64
## STRESAGR 14 5599 -0.04 0.83 -0.01 -0.04 0.51
## GROSAGR 15 5599 0.14 1.04 -0.01 0.18 1.01
## TEACHSUP 16 5599 0.23 0.99 -0.10 0.28 1.05
## ANXMAT 17 5599 0.31 1.09 0.34 0.30 0.80
## MATHPERS 18 5599 -0.52 1.03 -0.53 -0.54 0.78
## PV1MATH 19 5599 537.82 109.73 541.62 539.17 117.10
## PV1READ 20 5599 509.24 101.69 515.92 511.34 104.35
## PV1SCIE 21 5599 530.81 100.04 536.12 532.63 103.55
## min max range skew kurtosis se
## CNT* 1.00 1.00 0.00 NaN NaN 0.00
## CNTSTUID 15800002.00 15808413.00 8411.00 -0.01 -1.21 32.46
## NatCen* 1.00 1.00 0.00 NaN NaN 0.00
## Gender 1.00 2.00 1.00 -0.01 -2.00 0.01
## AGE 15.33 16.33 1.00 0.05 -1.17 0.00
## ESCS -3.84 4.21 8.05 -0.18 -0.31 0.01
## REPEAT 0.00 1.00 1.00 11.55 131.52 0.00
## MISSSC 0.00 1.00 1.00 6.25 37.11 0.00
## SKIPPING 0.00 1.00 1.00 2.67 5.11 0.00
## WORKPAY 0.00 10.00 10.00 3.59 12.54 0.03
## MATHMOT 0.00 1.00 1.00 4.33 16.74 0.00
## RELATST -6.27 3.17 9.43 0.36 1.38 0.01
## BELONG -3.26 2.76 6.01 1.00 1.70 0.01
## STRESAGR -5.25 5.58 10.83 0.59 8.72 0.01
## GROSAGR -3.60 3.37 6.97 -1.15 3.58 0.01
## TEACHSUP -2.91 1.56 4.47 -0.28 -0.12 0.01
## ANXMAT -2.39 2.63 5.03 -0.10 0.81 0.01
## MATHPERS -3.13 2.83 5.96 0.34 1.26 0.01
## PV1MATH 219.06 917.38 698.32 -0.10 -0.43 1.47
## PV1READ 167.43 864.80 697.37 -0.17 -0.19 1.36
## PV1SCIE 194.74 882.69 687.95 -0.14 -0.29 1.34★列出ESCS此變項的敘述統計量
describe(pisa.dat$ESCS)## vars n mean sd median trimmed mad min max range skew kurtosis
## X1 1 5599 -0.27 0.91 -0.24 -0.27 1.02 -3.84 4.21 8.05 -0.18 -0.31
## se
## X1 0.01IQR
★列出ESCS此變項的IQR(四分位距)
IQR(pisa.dat$ESCS)## [1] 1.37885Range
★列出ESCS此變項的全距
diff(range(pisa.dat$ESCS))## [1] 8.0491Boxplot
★變項ESCS的盒狀圖
boxplot(pisa.dat$ESCS, horizontal=TRUE)