library(sf)
library(spData)
library(spdep)
library(spatialreg)
library(MuMIn)
library(car)
library(lmtest)
library(nortest)
library(corrplot)
library(tidyverse)Data yang dipakai adalah data kriminalitas di 49 lingkungan
(neighborhood) Kota Columbus, Ohio, tersedia pada paket
spData. Peubah yang dianalisis:
| Peubah | Keterangan |
|---|---|
CRIME (y) |
Banyak kasus pencurian rumah dan pencurian kendaraan per 1000 rumah tangga |
INC (x1) |
Pendapatan rumah tangga (ribu dolar) |
HOVAL (x2) |
Nilai rumah (ribu dolar) |
Analisis dibagi dua mengikuti materi: Bagian A
memodelkan CRIME dengan satu peubah penjelas
(INC) memakai bobot invers jarak, lalu membandingkan OLS
dengan SLX. Bagian B adalah analisis model dependensi
spasial lengkap dengan dua peubah penjelas (INC dan
HOVAL).
peta <- st_read(system.file("shapes/columbus.gpkg", package = "spData"), quiet = TRUE) %>%
select(POLYID, CRIME, INC, HOVAL, OPEN, PLUMB, DISCBD) %>%
st_set_crs(3857) # koordinat asli tidak bersatuan; CRS dummy hanya agar ggplot dapat menggambar
dat <- st_drop_geometry(peta)
coords <- st_coordinates(st_centroid(st_geometry(peta)))
dim(dat)## [1] 49 7
## POLYID CRIME INC HOVAL OPEN PLUMB DISCBD
## 0 0 0 0 0 0 0
peta %>%
select(CRIME, INC) %>%
pivot_longer(c(CRIME, INC), names_to = "Peubah", values_to = "Nilai") %>%
ggplot() +
geom_sf(aes(fill = Nilai), color = "white", linewidth = .2) +
scale_fill_viridis_c(option = "magma", name = NULL) +
facet_wrap(~Peubah) + coord_sf(datum = NA) + theme_minimal() +
theme(legend.position = "bottom")##
## Call:
## lm(formula = CRIME ~ INC, data = dat)
##
## Residuals:
## Min 1Q Median 3Q Max
## -47.066 -6.663 -0.836 8.488 32.806
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 64.4632 4.7480 13.577 < 2e-16 ***
## INC -2.0407 0.3074 -6.638 2.9e-08 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 12.15 on 47 degrees of freedom
## Multiple R-squared: 0.4838, Adjusted R-squared: 0.4729
## F-statistic: 44.06 on 1 and 47 DF, p-value: 2.901e-08
Bobot dihitung dari jarak antar pusat lingkungan: \(w_{ij} = 1/d_{ij}\) dengan diagonal 0, kemudian dibakukan baris.
\(H_0\): tidak ada autokorelasi spasial pada sisaan OLS.
##
## Global Moran I for regression residuals
##
## data:
## model: lm(formula = CRIME ~ INC, data = dat)
## weights: Wa.listw
##
## Moran I statistic standard deviate = 3.7442, p-value = 9.049e-05
## alternative hypothesis: greater
## sample estimates:
## Observed Moran I Expectation Variance
## 0.0544449470 -0.0235931219 0.0004344105
a.lagrange <- lm.LMtests(a.lm, Wa.listw,
test = c("LMerr", "RLMerr", "LMlag", "RLMlag", "SARMA"))
summary(a.lagrange)## Rao's score (a.k.a Lagrange multiplier) diagnostics for spatial
## dependence
## data:
## model: lm(formula = CRIME ~ INC, data = dat)
## test weights: listw
##
## statistic parameter p.value
## RSerr 2.1993 1 0.138073
## adjRSerr 1.9657 1 0.160903
## RSlag 7.2774 1 0.006983 **
## adjRSlag 7.0438 1 0.007954 **
## SARMA 9.2431 2 0.009837 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Model SLX menambahkan lag spasial peubah penjelas (\(WX\)) ke dalam regresi.
##
## Call:
## lm(formula = formula(paste("y ~ ", paste(colnames(x)[-1], collapse = "+"))),
## data = as.data.frame(x), weights = weights)
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.200e+02 2.046e+01 5.863e+00 4.637e-07
## INC -1.542e+00 3.389e-01 -4.552e+00 3.887e-05
## lag.INC -4.576e+00 1.647e+00 -2.779e+00 7.870e-03
LR <- 2 * (as.numeric(logLik(a.slx)) - as.numeric(logLik(a.lm)))
db <- attr(logLik(a.slx), "df") - attr(logLik(a.lm), "df")
p.lr <- pchisq(LR, df = db, lower.tail = FALSE)
data.frame(LR = LR, db = db, p.value = p.lr)Uji Moran pada sisaan OLS memberikan p-value <1e-04, sehingga terdapat autokorelasi spasial pada sisaan OLS (tolak \(H_0\)). Uji rasio likelihood SLX terhadap OLS memberikan p-value 0.00582 (SLX lebih baik daripada OLS), dan AICc terkecil dimiliki model SLX.
dat.b <- dat[, c("CRIME", "INC", "HOVAL")]
colnames(dat.b) <- c("y", "x1", "x2")
dat.b[!complete.cases(dat.b), ]## y x1 x2
## Min. : 0.1783 Min. : 4.477 Min. :17.90
## 1st Qu.:20.0485 1st Qu.: 9.963 1st Qu.:25.70
## Median :34.0008 Median :13.380 Median :33.50
## Mean :35.1288 Mean :14.375 Mean :38.44
## 3rd Qu.:48.5855 3rd Qu.:18.324 3rd Qu.:43.30
## Max. :68.8920 Max. :31.070 Max. :96.40
par(mfrow = c(1, 3))
boxplot(dat.b$y, main = "Sebaran Y (CRIME)", col = "dodgerblue")
boxplot(dat.b$x1, main = "Sebaran X1 (INC)", col = "dodgerblue")
boxplot(dat.b$x2, main = "Sebaran X2 (HOVAL)", col = "dodgerblue")##
## Pearson's product-moment correlation
##
## data: dat.b$y and dat.b$x1
## t = -6.6376, df = 47, p-value = 2.901e-08
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
## -0.8169860 -0.5151565
## sample estimates:
## cor
## -0.6955898
##
## Pearson's product-moment correlation
##
## data: dat.b$y and dat.b$x2
## t = -4.8117, df = 47, p-value = 1.585e-05
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
## -0.7366777 -0.3497978
## sample estimates:
## cor
## -0.5744867
peta %>%
select(CRIME, INC, HOVAL) %>%
pivot_longer(c(CRIME, INC, HOVAL), names_to = "Peubah", values_to = "Nilai") %>%
mutate(Peubah = factor(Peubah, levels = c("CRIME", "INC", "HOVAL"))) %>%
ggplot() +
geom_sf(aes(fill = Nilai), color = "white", linewidth = .2) +
scale_fill_gradientn(colors = colorRampPalette(c("green", "yellow", "red"))(101),
name = NULL) +
facet_wrap(~Peubah) + coord_sf(datum = NA) + theme_minimal() +
theme(legend.position = "bottom")Delapan matriks bobot dibandingkan: dua berbasis ketetanggaan (Queen dan Rook) dan enam berbasis jarak (KNN, radial, invers jarak dengan \(\alpha\) = 1 dan 2, eksponensial dengan \(\alpha\) = 1 dan 2). Semuanya dibakukan baris.
queen <- poly2nb(peta, queen = TRUE)
rook <- poly2nb(peta, queen = FALSE)
knn5 <- knn2nb(knearneigh(coords, k = 5))
dmax <- max(unlist(nbdists(knn2nb(knearneigh(coords, k = 1)), coords)))
rdw <- dnearneigh(coords, 0, dmax)
dist_listw <- function(f) {
M <- f(Dm); diag(M) <- 0; M <- M / rowSums(M)
mat2listw(M, style = "W")
}
W.list <- list(
"Queen Contiguity" = nb2listw(queen, style = "W"),
"Rook Contiguity" = nb2listw(rook, style = "W"),
"K-Nearest Neighbor (k=5)" = nb2listw(knn5, style = "W"),
"Radial Distance Weight" = nb2listw(rdw, style = "W"),
"Invers Distance (alpha=1)" = dist_listw(function(D) 1 / D^1),
"Invers Distance (alpha=2)" = dist_listw(function(D) 1 / D^2),
"Exponential Distance (alpha=1)" = dist_listw(function(D) exp(-1 * D)),
"Exponential Distance (alpha=2)" = dist_listw(function(D) exp(-2 * D))
)
names(W.list)[4] <- paste0("Radial Distance Weight (dmax=", round(dmax, 2), ")")Matriks bobot dipilih berdasarkan indeks Moran peubah respon \(y\): dipilih matriks yang menghasilkan autokorelasi paling kuat dan signifikan (\(p < 0.05\)).
moran.y <- lapply(W.list, function(w)
moran.test(dat.b$y, w, randomisation = TRUE, alternative = "greater"))
Matriks <- data.frame(
`Matriks Bobot` = names(W.list),
`Indeks Moran` = sapply(moran.y, function(m) unname(m$estimate[1])),
`p-value` = sapply(moran.y, function(m) m$p.value),
check.names = FALSE, row.names = NULL)
MatriksMatriks bobot terpilih untuk seluruh analisis berikutnya adalah K-Nearest Neighbor (k=5) dengan indeks Moran 0.5776.
##
## Call:
## lm(formula = y ~ x1 + x2, data = dat.b)
##
## Residuals:
## Min 1Q Median 3Q Max
## -34.418 -6.388 -1.580 9.052 28.649
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 68.6190 4.7355 14.490 < 2e-16 ***
## x1 -1.5973 0.3341 -4.780 1.83e-05 ***
## x2 -0.2739 0.1032 -2.654 0.0109 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 11.43 on 46 degrees of freedom
## Multiple R-squared: 0.5524, Adjusted R-squared: 0.5329
## F-statistic: 28.39 on 2 and 46 DF, p-value: 9.341e-09
## [1] 382.7545
Uji normalitas sisaan (Anderson-Darling). \(H_0\): sisaan menyebar normal.
##
## Anderson-Darling normality test
##
## data: err.ols
## A = 0.32266, p-value = 0.5179
par(mfrow = c(1, 2))
hist(err.ols, main = "Histogram Sisaan OLS", col = "lightblue")
qqnorm(err.ols, datax = TRUE)
qqline(rnorm(length(err.ols), mean(err.ols), sd(err.ols)), datax = TRUE, col = "red")Uji kehomogenan ragam (Breusch-Pagan). \(H_0\): ragam sisaan homogen.
##
## studentized Breusch-Pagan test
##
## data: ols
## BP = 7.2166, df = 2, p-value = 0.0271
Uji multikolinearitas (VIF). Nilai VIF kurang dari 10 menandakan tidak ada multikolinearitas serius.
## x1 x2
## 1.333117 1.333117
Uji Moran’s I pada sisaan OLS dan pada tiap peubah.
##
## Global Moran I for regression residuals
##
## data:
## model: lm(formula = y ~ x1 + x2, data = dat.b)
## weights: ww
##
## Moran I statistic standard deviate = 4.675, p-value = 2.94e-06
## alternative hypothesis: two.sided
## sample estimates:
## Observed Moran I Expectation Variance
## 0.326573741 -0.032435384 0.005897336
merr <- moran.test(err.ols, ww, randomisation = TRUE, alternative = "two.sided")
my <- moran.test(dat.b$y, ww, randomisation = TRUE, alternative = "two.sided")
mx1 <- moran.test(dat.b$x1, ww, randomisation = TRUE, alternative = "two.sided")
mx2 <- moran.test(dat.b$x2, ww, randomisation = TRUE, alternative = "two.sided")
data.frame(Peubah = c("Y", "X1", "X2", "Sisaan"),
`Indeks Moran` = c(my$estimate[1], mx1$estimate[1], mx2$estimate[1], merr$estimate[1]),
`p-value` = c(my$p.value, mx1$p.value, mx2$p.value, merr$p.value),
check.names = FALSE)Uji Lagrange Multiplier untuk menentukan jenis ketergantungan spasial.
lm.test <- lm.LMtests(ols, listw = ww,
test = c("LMerr", "RLMerr", "LMlag", "RLMlag", "SARMA"))
summary(lm.test)## Rao's score (a.k.a Lagrange multiplier) diagnostics for spatial
## dependence
## data:
## model: lm(formula = y ~ x1 + x2, data = dat.b)
## test weights: listw
##
## statistic parameter p.value
## RSerr 14.7165 1 0.0001249 ***
## adjRSerr 2.3334 1 0.1266230
## RSlag 16.4244 1 5.063e-05 ***
## adjRSlag 4.0413 1 0.0444009 *
## SARMA 18.7578 2 8.449e-05 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Fungsi bantu berikut merangkum tiga diagnostik sisaan pada tiap model spasial: uji normalitas Anderson-Darling, uji Breusch-Pagan, dan uji Moran pada sisaan.
diag_sp <- function(m, w) {
r <- residuals(m)
data.frame(`AD (normalitas)` = ad.test(r)$p.value,
`BP (homogenitas)` = bptest.Sarlm(m)$p.value,
`Moran sisaan` = moran.test(r, w, alternative = "two.sided")$p.value,
check.names = FALSE)
}##
## Call:lagsarlm(formula = y ~ x1 + x2, data = dat.b, listw = ww)
##
## Residuals:
## Min 1Q Median 3Q Max
## -35.6198 -5.3893 -0.1713 5.7518 22.1828
##
## Type: lag
## Coefficients: (asymptotic standard errors)
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) 40.241885 7.107879 5.6616 1.5e-08
## x1 -0.927289 0.298045 -3.1112 0.001863
## x2 -0.257340 0.084122 -3.0591 0.002220
##
## Rho: 0.49029, LR test value: 14.694, p-value: 0.00012648
## Asymptotic standard error: 0.11535
## z-value: 4.2505, p-value: 2.1332e-05
## Wald statistic: 18.067, p-value: 2.1332e-05
##
## Log likelihood: -180.0305 for lag model
## ML residual variance (sigma squared): 86.761, (sigma: 9.3145)
## Nagelkerke pseudo-R-squared: 0.66837
## Number of observations: 49
## Number of parameters estimated: 5
## AIC: 370.06, (AIC for lm: 382.75)
## LM test for residual autocorrelation
## test value: 2.3267, p-value: 0.12717
##
## Call:errorsarlm(formula = y ~ x1 + x2, data = dat.b, listw = ww)
##
## Residuals:
## Min 1Q Median 3Q Max
## -34.37943 -5.49295 -0.24731 5.45155 21.42179
##
## Type: error
## Coefficients: (asymptotic standard errors)
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) 56.598253 5.996412 9.4387 < 2.2e-16
## x1 -1.004095 0.306011 -3.2812 0.001034
## x2 -0.250254 0.080858 -3.0950 0.001968
##
## Lambda: 0.69125, LR test value: 15.772, p-value: 7.1456e-05
## Asymptotic standard error: 0.11118
## z-value: 6.2176, p-value: 5.0473e-10
## Wald statistic: 38.659, p-value: 5.0473e-10
##
## Log likelihood: -179.4913 for error model
## ML residual variance (sigma squared): 79.629, (sigma: 8.9235)
## Number of observations: 49
## Number of parameters estimated: 5
## AIC: 368.98, (AIC for lm: 382.75)
##
## Call:sacsarlm(formula = y ~ x1 + x2, data = dat.b, listw = ww)
##
## Residuals:
## Min 1Q Median 3Q Max
## -35.25313 -5.20506 -0.75845 4.72368 21.62045
##
## Type: sac
## Coefficients: (asymptotic standard errors)
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) 48.282171 10.249411 4.7107 2.468e-06
## x1 -1.030778 0.309185 -3.3339 0.0008565
## x2 -0.258834 0.083157 -3.1126 0.0018544
##
## Rho: 0.3004
## Asymptotic standard error: 0.24011
## z-value: 1.2511, p-value: 0.21089
## Lambda: 0.44306
## Asymptotic standard error: 0.26781
## z-value: 1.6544, p-value: 0.098047
##
## LR test value: 16.781, p-value: 0.00022703
##
## Log likelihood: -178.9868 for sac model
## ML residual variance (sigma squared): 82.643, (sigma: 9.0908)
## Number of observations: 49
## Number of parameters estimated: 6
## AIC: 369.97, (AIC for lm: 382.75)
##
## Call:lagsarlm(formula = y ~ x1 + x2, data = dat.b, listw = ww, type = "mixed")
##
## Residuals:
## Min 1Q Median 3Q Max
## -34.72682 -5.33045 -0.64785 4.95882 21.40567
##
## Type: mixed
## Coefficients: (asymptotic standard errors)
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) 24.839522 9.661006 2.5711 0.010137
## x1 -1.002721 0.308459 -3.2507 0.001151
## x2 -0.256790 0.081930 -3.1343 0.001723
## lag.x1 0.513882 0.539446 0.9526 0.340787
## lag.x2 0.098518 0.199400 0.4941 0.621257
##
## Rho: 0.64154, LR test value: 12.106, p-value: 0.00050261
## Asymptotic standard error: 0.12419
## z-value: 5.1658, p-value: 2.3941e-07
## Wald statistic: 26.686, p-value: 2.3941e-07
##
## Log likelihood: -179.1964 for mixed model
## ML residual variance (sigma squared): 80.26, (sigma: 8.9588)
## Number of observations: 49
## Number of parameters estimated: 7
## AIC: 372.39, (AIC for lm: 382.5)
## LM test for residual autocorrelation
## test value: 2.0393, p-value: 0.15328
##
## Call:
## lm(formula = formula(paste("y ~ ", paste(colnames(x)[-1], collapse = "+"))),
## data = as.data.frame(x), weights = weights)
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 7.679e+01 6.569e+00 1.169e+01 4.364e-15
## x1 -1.214e+00 3.853e-01 -3.150e+00 2.936e-03
## x2 -2.717e-01 1.024e-01 -2.654e+00 1.103e-02
## lag.x1 -7.855e-01 6.412e-01 -1.225e+00 2.271e-01
## lag.x2 -7.368e-02 2.450e-01 -3.007e-01 7.650e-01
tabel.gof <- data.frame(
Model = c("OLS", "SLX", "SAR", "SEM", "SARMA", "SDM"),
AIC = c(AIC(ols), AIC(slx), AIC(sar), AIC(sem), AIC(sarma), AIC(sdm)),
AICc = c(AICc(ols), AICc(slx), AICc(sar), AICc(sem), AICc(sarma), AICc(sdm)))
tabel.gof <- tabel.gof[order(tabel.gof$AICc), ]
tabel.gofBerdasarkan AICc terkecil (370.378), model terbaik adalah SEM.
Ukuran dampak (impacts) hanya tersedia untuk model dengan lag spasial pada peubah respon, yaitu SAR, SARMA, dan SDM. Dampak dihitung untuk model terbaik di antara ketiganya berdasarkan AICc.
kandidat <- list(SAR = sar, SARMA = sarma, SDM = sdm)
nama.lag <- names(which.min(sapply(kandidat, AICc)))
model.lag <- kandidat[[nama.lag]]
nama.lag## [1] "SAR"
## Impact measures (lag, exact):
## Direct Indirect Total
## x1 dy/dx -0.9783113 -0.8409496 -1.8192609
## x2 dy/dx -0.2714996 -0.2333792 -0.5048789
if (nama.lag %in% c("SAR", "SARMA")) {
koef <- coef(model.lag)[c("x1", "x2")]
diref <- as.vector(Im$direct)
data.frame(Koefisien = koef, EfekLangsung = diref, UmpanBalik = diref - koef)
}INC = -1.597 dan
HOVAL = -0.274. Kenaikan pendapatan dan nilai rumah
berhubungan dengan penurunan kriminalitas. Uji normalitas sisaan
memberikan p-value 0.518 dan uji Breusch-Pagan p-value 0.027, sehingga
asumsi normalitas terpenuhi dan ragam sisaan tidak dapat dianggap
homogen. VIF kedua peubah 1.33 (di bawah 10), sehingga tidak terdapat
multikolinearitas.CRIME memiliki indeks Moran 0.578 (p-value <1e-04)
dengan bobot K-Nearest Neighbor (k=5), dan sisaan OLS memiliki indeks
Moran 0.327 (p-value <1e-04). Hal ini menunjukkan bahwa OLS belum
cukup karena sisaannya masih berautokorelasi spasial, sehingga
diperlukan model regresi spasial.