###############################################################################
# ANALISIS REGRESI LINEAR BERGANDA & DATA PANEL STATIS (CEM, FEM, REM)
# Data : Data_Panel_WDI.xlsx (World Development Indicators)
#
# Isi script:
# 1. Persiapan paket & pengaturan variabel
# 2. Impor & pembersihan data (".." WDI otomatis dianggap NA)
# 3. Statistik deskriptif & korelasi
# 4. Uji stasioneritas panel: LLC, IPS, ADF-Fisher (Maddala-Wu), Hadri
# + Uji CIPS (Pesaran 2007, generasi kedua, tahan cross-sectional dependence)
# 5. Regresi linear berganda (OLS) + uji asumsi klasik
# 6. Estimasi panel statis: CEM (Pooled), FEM, REM (+ efek waktu/two-ways)
# 7. Pemilihan model: Chow, Breusch-Pagan LM, Hausman
# 8. Uji asumsi/heterogenitas panel: heteroskedastisitas (Breusch-Pagan,
# Modified Wald groupwise), autokorelasi (Wooldridge, Breusch-Godfrey),
# dependensi antar-unit (Pesaran CD, Breusch-Pagan LM CD), heterogenitas
# individu & waktu
# 9. Model terpilih dengan standar error robust (Arellano cluster & Driscoll-Kraay)
# 10. Tabel ringkasan, ekspor Excel (.xlsx) & grafik (.pdf)
# Output: Hasil_Analisis_Data_Panel.txt, Tabel_Hasil_Analisis_Data_Panel.xlsx,
# Grafik_Analisis_Data_Panel.pdf (di folder yang sama dengan data)
###############################################################################
# =============================== 1. PAKET ===================================
paket <- c("readxl", "dplyr", "plm", "lmtest", "car", "sandwich",
"tseries", "urca")
baru <- paket[!(paket %in% rownames(installed.packages()))]
if (length(baru) > 0) install.packages(baru, dependencies = TRUE)
invisible(lapply(paket, library, character.only = TRUE))
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
##
## Attaching package: 'plm'
## The following objects are masked from 'package:dplyr':
##
## between, lag, lead
## Loading required package: zoo
##
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric
## Warning: package 'car' was built under R version 4.6.2
## Loading required package: carData
## Warning: package 'carData' was built under R version 4.6.2
##
## Attaching package: 'car'
## The following object is masked from 'package:dplyr':
##
## recode
## Warning: package 'tseries' was built under R version 4.6.2
## Registered S3 method overwritten by 'quantmod':
## method from
## as.zoo.data.frame zoo
## Warning: package 'urca' was built under R version 4.6.2
options(scipen = 999, digits = 5)
# ======================= PENGATURAN (SESUAIKAN DI SINI) ======================
FILE_DATA <- "C:/Users/ADVAN/OneDrive/Dokumen/Data_Panel_WDI.xlsx" # pakai "/" bukan "\"
SHEET <- 1 # nomor atau nama sheet
# Nama kolom (setelah dirapikan dengan make.names, spasi -> titik).
# Biarkan NULL agar otomatis: kolom 1 = unit/negara, kolom 2 = tahun,
# kolom 3 = variabel dependen (Y), kolom 4 dst = variabel independen (X).
ID_COL <- NULL # contoh: "Country.Name"
TIME_COL <- NULL # contoh: "Year"
DEP_VAR <- NULL # contoh: "GDP_growth"
INDEP_VARS <- NULL # contoh: c("FDI", "Inflation", "Trade")
# Variabel yang ingin di-log-kan (harus > 0). Contoh: c("GDP", "FDI"). Kosongkan jika tidak.
LOG_VARS <- c()
ALPHA <- 0.05 # taraf signifikansi
# Semua output disimpan di folder yang sama dengan file data
FILE_OUT <- file.path(dirname(FILE_DATA), "Hasil_Analisis_Data_Panel.txt")
sink(FILE_OUT, split = TRUE)
cat("VERSI SCRIPT: v4 (REM aman N kecil, deteksi kolom, grafik PDF & tabel Excel)\n")
## VERSI SCRIPT: v4 (REM aman N kecil, deteksi kolom, grafik PDF & tabel Excel)
judul <- function(teks) {
cat("\n", strrep("=", 78), "\n", teks, "\n", strrep("=", 78), "\n", sep = "")
}
aman <- function(expr) { # jalankan uji; jika gagal tampilkan pesan, bukan stop
tryCatch(expr, error = function(e) {
cat(">> Uji tidak dapat dijalankan: ", conditionMessage(e), "\n", sep = ""); NULL })
}
kesimpulan <- function(p, h0, tolak, terima) {
if (is.na(p)) return(invisible(NULL))
cat(sprintf(" p-value = %.4f -> %s\n", p,
ifelse(p < ALPHA, paste0("Tolak H0 (", tolak, ")"),
paste0("Gagal tolak H0 (", terima, ")"))))
}
# ============================ 2. IMPOR DATA =================================
judul("2. IMPOR & PEMBERSIHAN DATA")
##
## ==============================================================================
## 2. IMPOR & PEMBERSIHAN DATA
## ==============================================================================
stopifnot(file.exists(FILE_DATA))
raw <- read_excel(FILE_DATA, sheet = SHEET, na = c("..", "", "NA", "N/A", "n/a"))
raw <- as.data.frame(raw)
names(raw) <- make.names(names(raw), unique = TRUE)
cat("Kolom terbaca :", paste(names(raw), collapse = " | "), "\n")
## Kolom terbaca : Negara | Kode | Tahun | Y_Kemiskinan | X1_Melek_Huruf | X2_TPT | X3_PDRB_per_kapita | X4_Pengeluaran_Pemerintah
cat("\nContoh 5 baris pertama data mentah:\n"); print(head(raw, 5))
##
## Contoh 5 baris pertama data mentah:
## Negara Kode Tahun Y_Kemiskinan X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
## 1 Australia AUS 2000 NA NA 6.288 2.73355
## 2 Australia AUS 2001 NA NA 6.747 0.72978
## 3 Australia AUS 2002 NA NA 6.375 2.77404
## 4 Australia AUS 2003 NA NA 5.933 1.91232
## 5 Australia AUS 2004 NA NA 5.399 3.11057
## X4_Pengeluaran_Pemerintah
## 1 18.505
## 2 18.507
## 3 18.318
## 4 18.380
## 5 18.273
# ---- Deteksi otomatis kolom (jika ID_COL dst. dibiarkan NULL) ----
nm_low <- tolower(names(raw))
bisa_angka <- function(x) { # kolom dianggap numerik jika >50% terisi angka
x2 <- suppressWarnings(as.numeric(as.character(x)))
ok <- sum(!is.na(x)); ok > 0 && sum(!is.na(x2)) / ok > 0.5
}
if (is.null(ID_COL)) {
i <- grep("country.?name|^country$|negara|^nama|^unit$|^id$", nm_low)
ID_COL <- if (length(i) > 0) names(raw)[i[1]] else names(raw)[1]
}
if (is.null(TIME_COL)) {
i <- grep("^year$|^years$|^tahun$|^time$|^periode$|^time.?code$", nm_low)
TIME_COL <- if (length(i) > 0) names(raw)[i[1]] else names(raw)[2]
}
abaikan <- grepl("code|kode|series|iso|region|income|wilayah|^no$|^x$", nm_low)
kandidat <- names(raw)[!(names(raw) %in% c(ID_COL, TIME_COL)) & !abaikan &
sapply(raw, bisa_angka)]
if (is.null(DEP_VAR)) DEP_VAR <- kandidat[1]
if (is.null(INDEP_VARS)) INDEP_VARS <- setdiff(kandidat, DEP_VAR)
if (length(INDEP_VARS) == 0 || is.na(DEP_VAR))
stop("Variabel Y/X tidak terdeteksi. Isi DEP_VAR dan INDEP_VARS manual (lihat nama kolom di atas).")
cat("\nPengaturan variabel yang dipakai:\n")
##
## Pengaturan variabel yang dipakai:
cat(" Unit (cross-section):", ID_COL, "\n")
## Unit (cross-section): Negara
cat(" Waktu :", TIME_COL, "\n")
## Waktu : Tahun
cat(" Dependen (Y) :", DEP_VAR, "\n")
## Dependen (Y) : Y_Kemiskinan
cat(" Independen (X) :", paste(INDEP_VARS, collapse = ", "), "\n")
## Independen (X) : X1_Melek_Huruf, X2_TPT, X3_PDRB_per_kapita, X4_Pengeluaran_Pemerintah
stopifnot(all(c(ID_COL, TIME_COL, DEP_VAR, INDEP_VARS) %in% names(raw)))
VARS <- c(DEP_VAR, INDEP_VARS)
dat <- raw[, c(ID_COL, TIME_COL, VARS)]
names(dat)[1:2] <- c("unit", "waktu")
dat$unit <- as.character(dat$unit)
dat$waktu <- as.numeric(dat$waktu)
for (v in VARS) dat[[v]] <- suppressWarnings(as.numeric(dat[[v]]))
for (v in LOG_VARS) {
if (any(dat[[v]] <= 0, na.rm = TRUE)) stop("Variabel ", v, " mengandung nilai <= 0, tidak bisa di-log.")
dat[[v]] <- log(dat[[v]])
cat("Variabel", v, "ditransformasi ke ln()\n")
}
cat("\nJumlah nilai kosong (NA) per kolom setelah konversi angka:\n")
##
## Jumlah nilai kosong (NA) per kolom setelah konversi angka:
print(colSums(is.na(dat)))
## unit waktu Y_Kemiskinan
## 0 0 296
## X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
## 301 0 0
## X4_Pengeluaran_Pemerintah
## 58
n_awal <- nrow(dat)
dat <- dat[complete.cases(dat), ]
if (nrow(dat) == 0) {
stop("Semua baris terbuang karena NA. Lihat tabel NA di atas: kolom yang NA semua ",
"kemungkinan salah pilih (mis. kolom kode/teks terbaca sebagai angka) atau data ",
"berformat wide. Atur ID_COL, TIME_COL, DEP_VAR, INDEP_VARS secara manual.")
}
dat <- dat[order(dat$unit, dat$waktu), ]
cat(sprintf("\nObservasi awal: %d | setelah buang missing: %d\n", n_awal, nrow(dat)))
##
## Observasi awal: 390 | setelah buang missing: 29
# Hanya pertahankan unit dengan T >= 3
tabel_T <- table(dat$unit)
dat <- dat[dat$unit %in% names(tabel_T[tabel_T >= 3]), ]
N <- length(unique(dat$unit)); Tn <- length(unique(dat$waktu))
seimbang <- all(table(dat$unit) == Tn)
cat(sprintf("Jumlah unit (N) = %d | periode (T) = %d | total obs = %d | panel %s\n",
N, Tn, nrow(dat), ifelse(seimbang, "SEIMBANG (balanced)", "TIDAK SEIMBANG (unbalanced)")))
## Jumlah unit (N) = 3 | periode (T) = 15 | total obs = 22 | panel TIDAK SEIMBANG (unbalanced)
cat("Daftar unit:", paste(sort(unique(dat$unit)), collapse = ", "), "\n")
## Daftar unit: China, Indonesia, Thailand
K_koef <- length(INDEP_VARS) + 1
if (N < 10) cat("\n!! PERINGATAN: N =", N, "unit sangat sedikit. Uji panel (CIPS, IPS, Hausman, Pesaran CD,",
"\n standar error cluster) tidak andal. Model Random Effect butuh N >", K_koef - 1,
"(jumlah koefisien =", K_koef, ").\n Pastikan kolom unit (ID_COL) sudah benar.\n")
##
## !! PERINGATAN: N = 3 unit sangat sedikit. Uji panel (CIPS, IPS, Hausman, Pesaran CD,
## standar error cluster) tidak andal. Model Random Effect butuh N > 4 (jumlah koefisien = 5 ).
## Pastikan kolom unit (ID_COL) sudah benar.
pdat <- pdata.frame(dat, index = c("unit", "waktu"), drop.index = FALSE)
f_rhs <- paste(INDEP_VARS, collapse = " + ")
fm <- as.formula(paste(DEP_VAR, "~", f_rhs))
cat("Model:", deparse(fm), "\n")
## Model: Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + X4_Pengeluaran_Pemerintah
# ===================== 3. STATISTIK DESKRIPTIF & KORELASI ===================
judul("3. STATISTIK DESKRIPTIF & KORELASI")
##
## ==============================================================================
## 3. STATISTIK DESKRIPTIF & KORELASI
## ==============================================================================
desk <- t(sapply(dat[VARS], function(x) c(
N = length(x), Mean = mean(x), SD = sd(x), Min = min(x),
Median = median(x), Max = max(x))))
print(round(desk, 4))
## N Mean SD Min Median Max
## Y_Kemiskinan 22 14.3955 11.1591 0.0000 11.2500 49.800
## X1_Melek_Huruf 22 93.4632 1.9410 90.3800 92.8400 96.740
## X2_TPT 22 3.6453 2.4207 0.2490 4.2780 7.551
## X3_PDRB_per_kapita 22 3.8300 2.4382 -2.8942 3.7428 10.059
## X4_Pengeluaran_Pemerintah 22 12.7098 3.7787 8.3219 11.6627 17.716
cat("\nMatriks korelasi:\n")
##
## Matriks korelasi:
print(round(cor(dat[VARS]), 4))
## Y_Kemiskinan X1_Melek_Huruf X2_TPT
## Y_Kemiskinan 1.0000 -0.3285 0.0847
## X1_Melek_Huruf -0.3285 1.0000 -0.0418
## X2_TPT 0.0847 -0.0418 1.0000
## X3_PDRB_per_kapita 0.4284 -0.0637 0.1293
## X4_Pengeluaran_Pemerintah 0.0049 -0.0473 -0.8001
## X3_PDRB_per_kapita X4_Pengeluaran_Pemerintah
## Y_Kemiskinan 0.4284 0.0049
## X1_Melek_Huruf -0.0637 -0.0473
## X2_TPT 0.1293 -0.8001
## X3_PDRB_per_kapita 1.0000 0.0626
## X4_Pengeluaran_Pemerintah 0.0626 1.0000
# ================== 4. UJI STASIONERITAS (UNIT ROOT PANEL) ==================
judul("4. UJI STASIONERITAS PANEL")
##
## ==============================================================================
## 4. UJI STASIONERITAS PANEL
## ==============================================================================
cat("Catatan: H0 LLC, IPS, ADF-Fisher, CIPS = ada unit root (tidak stasioner);\n")
## Catatan: H0 LLC, IPS, ADF-Fisher, CIPS = ada unit root (tidak stasioner);
cat(" H0 Hadri = stasioner.\n")
## H0 Hadri = stasioner.
# Data first-difference
dat_d <- dat %>% group_by(unit) %>% arrange(waktu, .by_group = TRUE) %>%
mutate(across(all_of(VARS), ~ . - dplyr::lag(.))) %>% ungroup() %>%
as.data.frame()
dat_d <- dat_d[complete.cases(dat_d), ]
pdat_d <- pdata.frame(dat_d, index = c("unit", "waktu"), drop.index = FALSE)
jalankan_pu <- function(x, test, exo) {
for (lg in list("AIC", 1, 0)) {
r <- tryCatch({
if (is.character(lg)) purtest(x, test = test, exo = exo, lags = lg, pmax = 2)
else purtest(x, test = test, exo = exo, lags = lg)
}, error = function(e) NULL)
if (!is.null(r))
return(c(stat = as.numeric(r$statistic$statistic), p = as.numeric(r$statistic$p.value)))
}
c(stat = NA_real_, p = NA_real_)
}
uji_pu <- list(`Levin-Lin-Chu` = "levinlin", `Im-Pesaran-Shin` = "ips",
`ADF-Fisher (Maddala-Wu)` = "madwu", `Hadri` = "hadri")
hasil_pu <- data.frame()
for (tingkat in c("Level", "First Difference")) {
pd <- if (tingkat == "Level") pdat else pdat_d
for (v in VARS) {
for (exo in c("intercept", "trend")) {
for (nm in names(uji_pu)) {
if (nm == "Hadri" && exo == "trend") next
r <- jalankan_pu(pd[[v]], uji_pu[[nm]], exo)
h0_unitroot <- nm != "Hadri"
stasioner <- if (is.na(r["p"])) NA else
if (h0_unitroot) r["p"] < ALPHA else r["p"] >= ALPHA
hasil_pu <- rbind(hasil_pu, data.frame(
Tingkat = tingkat, Variabel = v, Spesifikasi = exo, Uji = nm,
Statistik = round(r["stat"], 4), p.value = round(r["p"], 4),
Stasioner = ifelse(is.na(stasioner), "NA", ifelse(stasioner, "Ya", "Tidak")),
row.names = NULL))
}
}
}
}
print(hasil_pu, row.names = FALSE)
## Tingkat Variabel Spesifikasi Uji
## Level Y_Kemiskinan intercept Levin-Lin-Chu
## Level Y_Kemiskinan intercept Im-Pesaran-Shin
## Level Y_Kemiskinan intercept ADF-Fisher (Maddala-Wu)
## Level Y_Kemiskinan intercept Hadri
## Level Y_Kemiskinan trend Levin-Lin-Chu
## Level Y_Kemiskinan trend Im-Pesaran-Shin
## Level Y_Kemiskinan trend ADF-Fisher (Maddala-Wu)
## Level X1_Melek_Huruf intercept Levin-Lin-Chu
## Level X1_Melek_Huruf intercept Im-Pesaran-Shin
## Level X1_Melek_Huruf intercept ADF-Fisher (Maddala-Wu)
## Level X1_Melek_Huruf intercept Hadri
## Level X1_Melek_Huruf trend Levin-Lin-Chu
## Level X1_Melek_Huruf trend Im-Pesaran-Shin
## Level X1_Melek_Huruf trend ADF-Fisher (Maddala-Wu)
## Level X2_TPT intercept Levin-Lin-Chu
## Level X2_TPT intercept Im-Pesaran-Shin
## Level X2_TPT intercept ADF-Fisher (Maddala-Wu)
## Level X2_TPT intercept Hadri
## Level X2_TPT trend Levin-Lin-Chu
## Level X2_TPT trend Im-Pesaran-Shin
## Level X2_TPT trend ADF-Fisher (Maddala-Wu)
## Level X3_PDRB_per_kapita intercept Levin-Lin-Chu
## Level X3_PDRB_per_kapita intercept Im-Pesaran-Shin
## Level X3_PDRB_per_kapita intercept ADF-Fisher (Maddala-Wu)
## Level X3_PDRB_per_kapita intercept Hadri
## Level X3_PDRB_per_kapita trend Levin-Lin-Chu
## Level X3_PDRB_per_kapita trend Im-Pesaran-Shin
## Level X3_PDRB_per_kapita trend ADF-Fisher (Maddala-Wu)
## Level X4_Pengeluaran_Pemerintah intercept Levin-Lin-Chu
## Level X4_Pengeluaran_Pemerintah intercept Im-Pesaran-Shin
## Level X4_Pengeluaran_Pemerintah intercept ADF-Fisher (Maddala-Wu)
## Level X4_Pengeluaran_Pemerintah intercept Hadri
## Level X4_Pengeluaran_Pemerintah trend Levin-Lin-Chu
## Level X4_Pengeluaran_Pemerintah trend Im-Pesaran-Shin
## Level X4_Pengeluaran_Pemerintah trend ADF-Fisher (Maddala-Wu)
## First Difference Y_Kemiskinan intercept Levin-Lin-Chu
## First Difference Y_Kemiskinan intercept Im-Pesaran-Shin
## First Difference Y_Kemiskinan intercept ADF-Fisher (Maddala-Wu)
## First Difference Y_Kemiskinan intercept Hadri
## First Difference Y_Kemiskinan trend Levin-Lin-Chu
## First Difference Y_Kemiskinan trend Im-Pesaran-Shin
## First Difference Y_Kemiskinan trend ADF-Fisher (Maddala-Wu)
## First Difference X1_Melek_Huruf intercept Levin-Lin-Chu
## First Difference X1_Melek_Huruf intercept Im-Pesaran-Shin
## First Difference X1_Melek_Huruf intercept ADF-Fisher (Maddala-Wu)
## First Difference X1_Melek_Huruf intercept Hadri
## First Difference X1_Melek_Huruf trend Levin-Lin-Chu
## First Difference X1_Melek_Huruf trend Im-Pesaran-Shin
## First Difference X1_Melek_Huruf trend ADF-Fisher (Maddala-Wu)
## First Difference X2_TPT intercept Levin-Lin-Chu
## First Difference X2_TPT intercept Im-Pesaran-Shin
## First Difference X2_TPT intercept ADF-Fisher (Maddala-Wu)
## First Difference X2_TPT intercept Hadri
## First Difference X2_TPT trend Levin-Lin-Chu
## First Difference X2_TPT trend Im-Pesaran-Shin
## First Difference X2_TPT trend ADF-Fisher (Maddala-Wu)
## First Difference X3_PDRB_per_kapita intercept Levin-Lin-Chu
## First Difference X3_PDRB_per_kapita intercept Im-Pesaran-Shin
## First Difference X3_PDRB_per_kapita intercept ADF-Fisher (Maddala-Wu)
## First Difference X3_PDRB_per_kapita intercept Hadri
## First Difference X3_PDRB_per_kapita trend Levin-Lin-Chu
## First Difference X3_PDRB_per_kapita trend Im-Pesaran-Shin
## First Difference X3_PDRB_per_kapita trend ADF-Fisher (Maddala-Wu)
## First Difference X4_Pengeluaran_Pemerintah intercept Levin-Lin-Chu
## First Difference X4_Pengeluaran_Pemerintah intercept Im-Pesaran-Shin
## First Difference X4_Pengeluaran_Pemerintah intercept ADF-Fisher (Maddala-Wu)
## First Difference X4_Pengeluaran_Pemerintah intercept Hadri
## First Difference X4_Pengeluaran_Pemerintah trend Levin-Lin-Chu
## First Difference X4_Pengeluaran_Pemerintah trend Im-Pesaran-Shin
## First Difference X4_Pengeluaran_Pemerintah trend ADF-Fisher (Maddala-Wu)
## Statistik p.value Stasioner
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
## NA NA NA
# ---------------------------- UJI CIPS (Pesaran 2007) -----------------------
judul("4b. UJI CIPS (Cross-sectionally Augmented IPS, Pesaran 2007)")
##
## ==============================================================================
## 4b. UJI CIPS (Cross-sectionally Augmented IPS, Pesaran 2007)
## ==============================================================================
cat("H0: semua unit memiliki unit root (tidak stasioner). Tolak H0 jika p < alpha.\n")
## H0: semua unit memiliki unit root (tidak stasioner). Tolak H0 jika p < alpha.
cat("Uji CIPS mensyaratkan panel SEIMBANG.\n\n")
## Uji CIPS mensyaratkan panel SEIMBANG.
hasil_cips <- data.frame()
if (!seimbang) {
cat(">> Panel tidak seimbang, CIPS tidak dapat dijalankan.\n",
" Seimbangkan data (hapus unit/tahun yang bolong) lalu jalankan ulang.\n")
} else {
for (tingkat in c("Level", "First Difference")) {
pd <- if (tingkat == "Level") pdat else pdat_d
seimbang_pd <- all(table(pd$unit) == length(unique(pd$waktu)))
if (!seimbang_pd) next
for (v in VARS) {
for (tp in c("drift", "trend")) {
for (lg in 0:2) {
r <- tryCatch(cipstest(pd[[v]], lags = lg, type = tp, model = "cmg"),
error = function(e) NULL)
if (is.null(r)) next
pv <- as.numeric(r$p.value)
hasil_cips <- rbind(hasil_cips, data.frame(
Tingkat = tingkat, Variabel = v, Spesifikasi = tp, Lag = lg,
CIPS = round(as.numeric(r$statistic), 4), p.value = round(pv, 4),
Stasioner = ifelse(pv < ALPHA, "Ya", "Tidak"), row.names = NULL))
}
}
}
}
if (nrow(hasil_cips) > 0) print(hasil_cips, row.names = FALSE)
else cat(">> CIPS tidak menghasilkan output (cek jumlah T dan kelengkapan data).\n")
}
## >> Panel tidak seimbang, CIPS tidak dapat dijalankan.
## Seimbangkan data (hapus unit/tahun yang bolong) lalu jalankan ulang.
# ===================== 5. REGRESI LINEAR BERGANDA (OLS) =====================
judul("5. REGRESI LINEAR BERGANDA (OLS) & UJI ASUMSI KLASIK")
##
## ==============================================================================
## 5. REGRESI LINEAR BERGANDA (OLS) & UJI ASUMSI KLASIK
## ==============================================================================
ols <- lm(fm, data = dat)
print(summary(ols))
##
## Call:
## lm(formula = fm, data = dat)
##
## Residuals:
## Min 1Q Median 3Q Max
## -10.351 -5.478 -2.481 -0.013 27.503
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 174.235 115.942 1.50 0.151
## X1_Melek_Huruf -1.759 1.199 -1.47 0.160
## X2_TPT -0.135 1.674 -0.08 0.937
## X3_PDRB_per_kapita 1.906 0.992 1.92 0.072 .
## X4_Pengeluaran_Pemerintah -0.175 1.066 -0.16 0.872
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 10.6 on 17 degrees of freedom
## Multiple R-squared: 0.276, Adjusted R-squared: 0.106
## F-statistic: 1.62 on 4 and 17 DF, p-value: 0.215
cat("\nSelang kepercayaan 95%:\n"); print(round(confint(ols), 4))
##
## Selang kepercayaan 95%:
## 2.5 % 97.5 %
## (Intercept) -70.3821 418.8521
## X1_Melek_Huruf -4.2881 0.7696
## X2_TPT -3.6679 3.3977
## X3_PDRB_per_kapita -0.1876 3.9988
## X4_Pengeluaran_Pemerintah -2.4241 2.0748
cat("\n--- 5.1 Normalitas residual ---\n")
##
## --- 5.1 Normalitas residual ---
res_ols <- residuals(ols)
jb <- aman(jarque.bera.test(res_ols)); if (!is.null(jb)) { print(jb); kesimpulan(jb$p.value, "", "residual tidak normal", "residual normal") }
##
## Jarque Bera Test
##
## data: res_ols
## X-squared = 21.4, df = 2, p-value = 0.000022
##
## p-value = 0.0000 -> Tolak H0 (residual tidak normal)
if (length(res_ols) <= 5000) {
sw <- aman(shapiro.test(res_ols)); if (!is.null(sw)) { print(sw); kesimpulan(sw$p.value, "", "residual tidak normal", "residual normal") }
}
##
## Shapiro-Wilk normality test
##
## data: res_ols
## W = 0.727, p-value = 0.000044
##
## p-value = 0.0000 -> Tolak H0 (residual tidak normal)
cat("\n--- 5.2 Multikolinearitas (VIF; > 10 indikasi masalah) ---\n")
##
## --- 5.2 Multikolinearitas (VIF; > 10 indikasi masalah) ---
if (length(INDEP_VARS) >= 2) print(round(vif(ols), 4)) else cat("Hanya 1 regressor, VIF tidak relevan.\n")
## X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
## 1.0208 3.0984 1.1036
## X4_Pengeluaran_Pemerintah
## 3.0608
cat("\n--- 5.3 Heteroskedastisitas (Breusch-Pagan) ---\n")
##
## --- 5.3 Heteroskedastisitas (Breusch-Pagan) ---
bp_ols <- aman(bptest(ols)); if (!is.null(bp_ols)) { print(bp_ols); kesimpulan(bp_ols$p.value, "", "ada heteroskedastisitas", "homoskedastis") }
##
## studentized Breusch-Pagan test
##
## data: ols
## BP = 2.81, df = 4, p-value = 0.59
##
## p-value = 0.5907 -> Gagal tolak H0 (homoskedastis)
cat("\n--- 5.4 Autokorelasi (Durbin-Watson & Breusch-Godfrey) ---\n")
##
## --- 5.4 Autokorelasi (Durbin-Watson & Breusch-Godfrey) ---
dw <- aman(dwtest(ols)); if (!is.null(dw)) { print(dw); kesimpulan(dw$p.value, "", "ada autokorelasi", "tidak ada autokorelasi") }
##
## Durbin-Watson test
##
## data: ols
## DW = 1.13, p-value = 0.0018
## alternative hypothesis: true autocorrelation is greater than 0
##
## p-value = 0.0018 -> Tolak H0 (ada autokorelasi)
bg <- aman(bgtest(ols, order = 1)); if (!is.null(bg)) { print(bg); kesimpulan(bg$p.value, "", "ada autokorelasi", "tidak ada autokorelasi") }
##
## Breusch-Godfrey test for serial correlation of order up to 1
##
## data: ols
## LM test = 3.12, df = 1, p-value = 0.077
##
## p-value = 0.0775 -> Gagal tolak H0 (tidak ada autokorelasi)
cat("\n--- 5.5 Spesifikasi model (Ramsey RESET) ---\n")
##
## --- 5.5 Spesifikasi model (Ramsey RESET) ---
rs <- aman(resettest(ols, power = 2:3, type = "fitted")); if (!is.null(rs)) { print(rs); kesimpulan(rs$p.value, "", "spesifikasi model kurang tepat", "spesifikasi model sesuai") }
##
## RESET test
##
## data: ols
## RESET = 4.15, df1 = 2, df2 = 15, p-value = 0.037
##
## p-value = 0.0369 -> Tolak H0 (spesifikasi model kurang tepat)
cat("\n--- 5.6 OLS dengan standar error robust (HC1) ---\n")
##
## --- 5.6 OLS dengan standar error robust (HC1) ---
print(coeftest(ols, vcov = vcovHC(ols, type = "HC1")))
##
## t test of coefficients:
##
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 174.235 98.710 1.77 0.095 .
## X1_Melek_Huruf -1.759 1.095 -1.61 0.127
## X2_TPT -0.135 1.140 -0.12 0.907
## X3_PDRB_per_kapita 1.906 1.086 1.76 0.097 .
## X4_Pengeluaran_Pemerintah -0.175 0.863 -0.20 0.842
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
# ========================= 6. ESTIMASI PANEL STATIS =========================
judul("6. ESTIMASI MODEL PANEL STATIS")
##
## ==============================================================================
## 6. ESTIMASI MODEL PANEL STATIS
## ==============================================================================
cem <- plm(fm, data = pdat, model = "pooling")
fem <- plm(fm, data = pdat, model = "within", effect = "individual")
rem <- NULL; rem_metode <- NA
for (mt in c("swar", "walhus", "amemiya", "nerlove")) {
rem <- tryCatch(plm(fm, data = pdat, model = "random", effect = "individual", random.method = mt),
error = function(e) NULL)
if (!is.null(rem)) { rem_metode <- mt; break }
}
if (is.null(rem)) {
cat("\n>> REM TIDAK DAPAT DIESTIMASI (jumlah unit terlalu sedikit). Model dibandingkan: CEM vs FEM saja.\n")
} else if (rem_metode != "swar") {
cat("\n>> REM Swamy-Arora tidak estimable (N <= jumlah koefisien); REM memakai metode '", rem_metode,
"'. Interpretasi REM/Hausman dengan N sekecil ini sangat tidak andal.\n", sep = "")
}
##
## >> REM Swamy-Arora tidak estimable (N <= jumlah koefisien); REM memakai metode 'walhus'. Interpretasi REM/Hausman dengan N sekecil ini sangat tidak andal.
cat("\n--- 6.1 Common Effect Model (Pooled OLS) ---\n"); print(summary(cem))
##
## --- 6.1 Common Effect Model (Pooled OLS) ---
## Pooling Model
##
## Call:
## plm(formula = fm, data = pdat, model = "pooling")
##
## Unbalanced Panel: n = 3, T = 3-11, N = 22
##
## Residuals:
## Min. 1st Qu. Median 3rd Qu. Max.
## -10.3506 -5.4780 -2.4811 -0.0127 27.5031
##
## Coefficients:
## Estimate Std. Error t-value Pr(>|t|)
## (Intercept) 174.235 115.942 1.50 0.151
## X1_Melek_Huruf -1.759 1.199 -1.47 0.160
## X2_TPT -0.135 1.674 -0.08 0.937
## X3_PDRB_per_kapita 1.906 0.992 1.92 0.072 .
## X4_Pengeluaran_Pemerintah -0.175 1.066 -0.16 0.872
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Total Sum of Squares: 2620
## Residual Sum of Squares: 1890
## R-Squared: 0.276
## Adj. R-Squared: 0.106
## F-statistic: 1.621 on 4 and 17 DF, p-value: 0.215
cat("\n--- 6.2 Fixed Effect Model (within, individu) ---\n"); print(summary(fem))
##
## --- 6.2 Fixed Effect Model (within, individu) ---
## Oneway (individual) effect Within Model
##
## Call:
## plm(formula = fm, data = pdat, effect = "individual", model = "within")
##
## Unbalanced Panel: n = 3, T = 3-11, N = 22
##
## Residuals:
## Min. 1st Qu. Median 3rd Qu. Max.
## -14.951 -3.131 -0.963 3.697 16.761
##
## Coefficients:
## Estimate Std. Error t-value Pr(>|t|)
## X1_Melek_Huruf -3.13 1.18 -2.66 0.0180 *
## X2_TPT -4.63 2.44 -1.89 0.0776 .
## X3_PDRB_per_kapita -0.05 1.00 -0.05 0.9609
## X4_Pengeluaran_Pemerintah -8.50 2.74 -3.10 0.0073 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Total Sum of Squares: 2400
## Residual Sum of Squares: 1100
## R-Squared: 0.539
## Adj. R-Squared: 0.354
## F-statistic: 4.38255 on 4 and 15 DF, p-value: 0.0152
if (!is.null(rem)) { cat("\n--- 6.3 Random Effect Model (individu) ---\n"); print(summary(rem)) }
##
## --- 6.3 Random Effect Model (individu) ---
## Oneway (individual) effect Random Effect Model
## (Wallace-Hussain's transformation)
##
## Call:
## plm(formula = fm, data = pdat, effect = "individual", model = "random",
## random.method = mt)
##
## Unbalanced Panel: n = 3, T = 3-11, N = 22
##
## Effects:
## var std.dev share
## idiosyncratic 95.39 9.77 0.35
## individual 177.78 13.33 0.65
## theta:
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.610 0.749 0.767 0.748 0.784 0.784
##
## Residuals:
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## -10.699 -5.464 -3.232 -0.667 0.242 23.558
##
## Coefficients:
## Estimate Std. Error z-value Pr(>|z|)
## (Intercept) 296.31 131.79 2.25 0.025 *
## X1_Melek_Huruf -2.46 1.25 -1.98 0.048 *
## X2_TPT -2.39 2.37 -1.01 0.313
## X3_PDRB_per_kapita 1.11 1.00 1.11 0.267
## X4_Pengeluaran_Pemerintah -3.33 2.03 -1.64 0.100
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Total Sum of Squares: 2480
## Residual Sum of Squares: 1580
## R-Squared: 0.37
## Adj. R-Squared: 0.222
## Chisq: 9.0926 on 4 DF, p-value: 0.0588
cat("\n--- 6.4 Fixed effect tiap unit ---\n")
##
## --- 6.4 Fixed effect tiap unit ---
print(round(fixef(fem), 4))
## China Indonesia Thailand
## 477 409 446
fem_tw <- aman(plm(fm, data = pdat, model = "within", effect = "twoways"))
if (!is.null(fem_tw)) { cat("\n--- 6.5 Fixed Effect Model two-ways (individu + waktu) ---\n"); print(summary(fem_tw)) }
##
## --- 6.5 Fixed Effect Model two-ways (individu + waktu) ---
## Twoways effects Within Model
##
## Call:
## plm(formula = fm, data = pdat, effect = "twoways", model = "within")
##
## Unbalanced Panel: n = 3, T = 3-11, N = 22
##
## Residuals:
## China-2000 China-2010 China-2020 Indonesia-2004
## 0.0177473757436486 0.0117029364378576 -0.0294503121809713 0.0000000000004578
## Indonesia-2006 Indonesia-2008 Indonesia-2009 Indonesia-2010
## 0.0000000000002187 0.0000000000002273 0.0000000000001237 0.0751693810879863
## Indonesia-2011 Indonesia-2014 Indonesia-2015 Indonesia-2016
## 0.0000000000000725 0.0000000000001644 -0.1079504366313700 0.4133555399612904
## Indonesia-2018 Indonesia-2020 Thailand-2000 Thailand-2010
## -0.4100247965990277 0.0294503121817170 -0.0177473757435539 -0.0868723175256361
## Thailand-2013 Thailand-2015 Thailand-2016 Thailand-2018
## -0.0000000000000515 0.1079504366316235 -0.4133555399610850 0.4100247965988151
## Thailand-2019 Thailand-2022
## -0.0000000000001086 -0.0000000000002321
##
## Coefficients:
## Estimate Std. Error t-value Pr(>|t|)
## X1_Melek_Huruf -3.342 1.032 -3.24 0.191
## X2_TPT -5.444 0.544 -10.01 0.063 .
## X3_PDRB_per_kapita 7.006 2.380 2.94 0.208
## X4_Pengeluaran_Pemerintah -4.444 0.918 -4.84 0.130
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Total Sum of Squares: 79.6
## Residual Sum of Squares: 0.717
## R-Squared: 0.991
## Adj. R-Squared: 0.811
## F-statistic: 27.4952 on 4 and 1 DF, p-value: 0.142
# ============================ 7. PEMILIHAN MODEL ============================
judul("7. UJI PEMILIHAN MODEL")
##
## ==============================================================================
## 7. UJI PEMILIHAN MODEL
## ==============================================================================
cat("\n--- 7.1 Uji Chow (F test): CEM vs FEM ---\n")
##
## --- 7.1 Uji Chow (F test): CEM vs FEM ---
cat("H0: CEM lebih baik (tidak ada efek individu)\n")
## H0: CEM lebih baik (tidak ada efek individu)
chow <- aman(pFtest(fem, cem)); p_chow <- NA_real_
if (!is.null(chow)) { print(chow); p_chow <- chow$p.value; kesimpulan(p_chow, "", "pilih FEM", "pilih CEM") }
##
## F test for individual effects
##
## data: fm
## F = 5.35, df1 = 2, df2 = 15, p-value = 0.018
## alternative hypothesis: significant effects
##
## p-value = 0.0176 -> Tolak H0 (pilih FEM)
cat("\n--- 7.2 Uji Breusch-Pagan LM: CEM vs REM ---\n")
##
## --- 7.2 Uji Breusch-Pagan LM: CEM vs REM ---
cat("H0: varians efek individu = 0 (CEM lebih baik)\n")
## H0: varians efek individu = 0 (CEM lebih baik)
lm_bp <- aman(plmtest(cem, effect = "individual", type = "bp")); p_lm <- NA_real_
if (!is.null(lm_bp)) { print(lm_bp); p_lm <- lm_bp$p.value; kesimpulan(p_lm, "", "pilih REM", "pilih CEM") }
##
## Lagrange Multiplier Test - (Breusch-Pagan)
##
## data: fm
## chisq = 0.978, df = 1, p-value = 0.32
## alternative hypothesis: significant effects
##
## p-value = 0.3226 -> Gagal tolak H0 (pilih CEM)
cat("\n--- 7.3 Uji Hausman: FEM vs REM ---\n")
##
## --- 7.3 Uji Hausman: FEM vs REM ---
cat("H0: REM konsisten & efisien (pilih REM)\n")
## H0: REM konsisten & efisien (pilih REM)
haus <- if (is.null(rem)) NULL else aman(phtest(fem, rem)); p_haus <- NA_real_
if (is.null(rem)) cat(">> Dilewati: REM tidak tersedia.\n")
if (!is.null(haus)) { print(haus); p_haus <- haus$p.value; kesimpulan(p_haus, "", "pilih FEM", "pilih REM") }
##
## Hausman Test
##
## data: fm
## chisq = 10.3, df = 4, p-value = 0.036
## alternative hypothesis: one model is inconsistent
##
## p-value = 0.0358 -> Tolak H0 (pilih FEM)
cat("\n--- 7.4 Uji efek waktu ---\n")
##
## --- 7.4 Uji efek waktu ---
if (!is.null(fem_tw)) {
tw <- aman(pFtest(fem_tw, fem)); if (!is.null(tw)) { print(tw); kesimpulan(tw$p.value, "", "efek waktu signifikan (pertimbangkan two-ways FE)", "efek waktu tidak signifikan") }
}
##
## F test for twoways effects
##
## data: fm
## F = 110, df1 = 14, df2 = 1, p-value = 0.075
## alternative hypothesis: significant effects
##
## p-value = 0.0746 -> Gagal tolak H0 (efek waktu tidak signifikan)
tw_lm <- aman(plmtest(cem, effect = "twoways", type = "bp")); if (!is.null(tw_lm)) { print(tw_lm); kesimpulan(tw_lm$p.value, "", "ada efek individu dan/atau waktu", "tidak ada efek") }
##
## Lagrange Multiplier Test - two-ways effects (Breusch-Pagan)
##
## data: fm
## chisq = 7.88, df = 2, p-value = 0.019
## alternative hypothesis: significant effects
##
## p-value = 0.0194 -> Tolak H0 (ada efek individu dan/atau waktu)
# Keputusan model terbaik
model_pilihan <- "FEM"
if (!is.na(p_chow) && !is.na(p_lm) && p_chow >= ALPHA && p_lm >= ALPHA) {
model_pilihan <- "CEM"
} else if (is.null(rem)) {
model_pilihan <- "FEM"
} else if (!is.na(p_haus)) {
model_pilihan <- ifelse(p_haus < ALPHA, "FEM", "REM")
}
cat("\n>>> MODEL TERPILIH BERDASARKAN UJI CHOW, LM, HAUSMAN :", model_pilihan, "<<<\n")
##
## >>> MODEL TERPILIH BERDASARKAN UJI CHOW, LM, HAUSMAN : FEM <<<
model_final <- switch(model_pilihan, CEM = cem, FEM = fem, REM = rem)
# ================== 8. UJI ASUMSI & HETEROGENITAS PANEL =====================
judul("8. UJI ASUMSI MODEL PANEL & HETEROGENITAS")
##
## ==============================================================================
## 8. UJI ASUMSI MODEL PANEL & HETEROGENITAS
## ==============================================================================
cat("\n--- 8.1 Heterogenitas antar-unit (efek individu) ---\n")
##
## --- 8.1 Heterogenitas antar-unit (efek individu) ---
cat("Ditunjukkan oleh uji Chow & LM di atas; ringkasan variasi fixed effect:\n")
## Ditunjukkan oleh uji Chow & LM di atas; ringkasan variasi fixed effect:
fe_vals <- as.numeric(fixef(fem))
cat(sprintf(" Min = %.4f | Maks = %.4f | SD = %.4f\n", min(fe_vals), max(fe_vals), sd(fe_vals)))
## Min = 408.6977 | Maks = 476.9793 | SD = 34.1886
ftest_het <- aman(pooltest(fm, data = pdat, model = "within"))
## >> Uji tidak dapat dijalankan: insufficient number of observations for at least one group in individual dimension, so defined model is non-estimable
if (!is.null(ftest_het)) {
cat("\nUji homogenitas koefisien slope antar-unit (pooltest, H0: slope sama):\n")
print(ftest_het); kesimpulan(ftest_het$p.value, "", "slope heterogen antar-unit", "slope homogen")
}
cat("\n--- 8.2 Heteroskedastisitas: Breusch-Pagan pada model LSDV ---\n")
##
## --- 8.2 Heteroskedastisitas: Breusch-Pagan pada model LSDV ---
fm_lsdv <- as.formula(paste(DEP_VAR, "~", f_rhs, "+ factor(unit)"))
bp_fe <- aman(bptest(fm_lsdv, data = dat, studentize = TRUE))
if (!is.null(bp_fe)) { print(bp_fe); kesimpulan(bp_fe$p.value, "", "ada heteroskedastisitas", "homoskedastis") }
##
## studentized Breusch-Pagan test
##
## data: fm_lsdv
## BP = 17.8, df = 6, p-value = 0.0067
##
## p-value = 0.0067 -> Tolak H0 (ada heteroskedastisitas)
cat("\n--- 8.3 Heteroskedastisitas antar-unit: Modified Wald (groupwise) pada FEM ---\n")
##
## --- 8.3 Heteroskedastisitas antar-unit: Modified Wald (groupwise) pada FEM ---
cat("H0: varians galat sama antar unit (homoskedastis)\n")
## H0: varians galat sama antar unit (homoskedastis)
mod_wald <- function(m) {
e <- as.numeric(residuals(m))
id <- as.character(index(m)[[1]])
s2 <- tapply(e^2, id, mean) # varians tiap unit
Ti <- tapply(e, id, length)
Vi <- sapply(names(s2), function(g) {
eg <- e[id == g]; sum((eg^2 - s2[g])^2) / (length(eg) * (length(eg) - 1)) })
W <- sum((s2 - mean(e^2))^2 / Vi)
df <- length(s2)
list(W = W, df = df, p = pchisq(W, df, lower.tail = FALSE))
}
mw <- aman(mod_wald(fem))
if (!is.null(mw)) {
cat(sprintf(" Chi2(%d) = %.4f\n", mw$df, mw$W))
kesimpulan(mw$p, "", "ada heteroskedastisitas antar-unit", "homoskedastis antar-unit")
}
## Chi2(3) = 146.6716
## p-value = 0.0000 -> Tolak H0 (ada heteroskedastisitas antar-unit)
cat("\n--- 8.4 Autokorelasi serial ---\n")
##
## --- 8.4 Autokorelasi serial ---
cat("a) Wooldridge (H0: tidak ada autokorelasi orde-1)\n")
## a) Wooldridge (H0: tidak ada autokorelasi orde-1)
wd <- aman(pwartest(fem)); if (!is.null(wd)) { print(wd); kesimpulan(wd$p.value, "", "ada autokorelasi", "tidak ada autokorelasi") }
##
## Wooldridge's test for serial correlation in FE panels
##
## data: fem
## F = 0.0141, df1 = 1, df2 = 17, p-value = 0.91
## alternative hypothesis: serial correlation
##
## p-value = 0.9069 -> Gagal tolak H0 (tidak ada autokorelasi)
cat("b) Breusch-Godfrey panel pada FEM\n")
## b) Breusch-Godfrey panel pada FEM
pbg <- aman(pbgtest(fem, order = 1)); if (!is.null(pbg)) { print(pbg); kesimpulan(pbg$p.value, "", "ada autokorelasi", "tidak ada autokorelasi") }
##
## Breusch-Godfrey/Wooldridge test for serial correlation in panel models
##
## data: fm
## chisq = 0.192, df = 1, p-value = 0.66
## alternative hypothesis: serial correlation in idiosyncratic errors
##
## p-value = 0.6615 -> Gagal tolak H0 (tidak ada autokorelasi)
cat("c) Durbin-Watson panel pada CEM\n")
## c) Durbin-Watson panel pada CEM
pdw <- aman(pdwtest(cem)); if (!is.null(pdw)) { print(pdw); kesimpulan(pdw$p.value, "", "ada autokorelasi", "tidak ada autokorelasi") }
##
## Durbin-Watson test for serial correlation in panel models
##
## data: fm
## DW = 1.13, p-value = 0.0018
## alternative hypothesis: serial correlation in idiosyncratic errors
##
## p-value = 0.0018 -> Tolak H0 (ada autokorelasi)
cat("\n--- 8.5 Dependensi antar-unit (cross-sectional dependence) ---\n")
##
## --- 8.5 Dependensi antar-unit (cross-sectional dependence) ---
cat("H0: tidak ada dependensi antar-unit\n")
## H0: tidak ada dependensi antar-unit
cat("a) Pesaran CD\n")
## a) Pesaran CD
cd1 <- aman(pcdtest(fem, test = "cd")); if (!is.null(cd1)) { print(cd1); kesimpulan(cd1$p.value, "", "ada cross-sectional dependence", "tidak ada") }
##
## Pesaran CD test for cross-sectional dependence in panels
##
## data: Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + X4_Pengeluaran_Pemerintah
## z = 0.973, p-value = 0.33
## alternative hypothesis: cross-sectional dependence
##
## p-value = 0.3303 -> Gagal tolak H0 (tidak ada)
cat("b) Breusch-Pagan LM (cocok bila T > N)\n")
## b) Breusch-Pagan LM (cocok bila T > N)
cd2 <- aman(pcdtest(fem, test = "lm")); if (!is.null(cd2)) { print(cd2); kesimpulan(cd2$p.value, "", "ada cross-sectional dependence", "tidak ada") }
##
## Breusch-Pagan LM test for cross-sectional dependence in panels
##
## data: Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + X4_Pengeluaran_Pemerintah
## chisq = 5.31, df = 3, p-value = 0.15
## alternative hypothesis: cross-sectional dependence
##
## p-value = 0.1508 -> Gagal tolak H0 (tidak ada)
cat("\n--- 8.6 Normalitas residual model terpilih ---\n")
##
## --- 8.6 Normalitas residual model terpilih ---
res_f <- as.numeric(residuals(model_final))
jb2 <- aman(jarque.bera.test(res_f)); if (!is.null(jb2)) { print(jb2); kesimpulan(jb2$p.value, "", "residual tidak normal", "residual normal") }
##
## Jarque Bera Test
##
## data: res_f
## X-squared = 0.447, df = 2, p-value = 0.8
##
## p-value = 0.7996 -> Gagal tolak H0 (residual normal)
cat("\n--- 8.7 Multikolinearitas (VIF) pada regressor ---\n")
##
## --- 8.7 Multikolinearitas (VIF) pada regressor ---
if (length(INDEP_VARS) >= 2) print(round(vif(ols), 4)) else cat("Hanya 1 regressor.\n")
## X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
## 1.0208 3.0984 1.1036
## X4_Pengeluaran_Pemerintah
## 3.0608
# ================== 9. INFERENSI ROBUST & MODEL TERPILIH ====================
judul(paste("9. MODEL TERPILIH:", model_pilihan, "- STANDAR ERROR ROBUST"))
##
## ==============================================================================
## 9. MODEL TERPILIH: FEM - STANDAR ERROR ROBUST
## ==============================================================================
cat("\n--- 9.1 Standar error biasa ---\n")
##
## --- 9.1 Standar error biasa ---
print(summary(model_final))
## Oneway (individual) effect Within Model
##
## Call:
## plm(formula = fm, data = pdat, effect = "individual", model = "within")
##
## Unbalanced Panel: n = 3, T = 3-11, N = 22
##
## Residuals:
## Min. 1st Qu. Median 3rd Qu. Max.
## -14.951 -3.131 -0.963 3.697 16.761
##
## Coefficients:
## Estimate Std. Error t-value Pr(>|t|)
## X1_Melek_Huruf -3.13 1.18 -2.66 0.0180 *
## X2_TPT -4.63 2.44 -1.89 0.0776 .
## X3_PDRB_per_kapita -0.05 1.00 -0.05 0.9609
## X4_Pengeluaran_Pemerintah -8.50 2.74 -3.10 0.0073 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Total Sum of Squares: 2400
## Residual Sum of Squares: 1100
## R-Squared: 0.539
## Adj. R-Squared: 0.354
## F-statistic: 4.38255 on 4 and 15 DF, p-value: 0.0152
cat("\n--- 9.2 Robust Arellano (cluster per unit; tahan heteroskedastisitas & autokorelasi) ---\n")
##
## --- 9.2 Robust Arellano (cluster per unit; tahan heteroskedastisitas & autokorelasi) ---
rob1 <- aman(coeftest(model_final, vcov = vcovHC(model_final, method = "arellano", type = "HC1", cluster = "group")))
if (!is.null(rob1)) print(rob1)
##
## t test of coefficients:
##
## Estimate Std. Error t value Pr(>|t|)
## X1_Melek_Huruf -3.126 2.177 -1.44 0.17164
## X2_TPT -4.626 2.627 -1.76 0.09857 .
## X3_PDRB_per_kapita -0.050 0.534 -0.09 0.92657
## X4_Pengeluaran_Pemerintah -8.496 1.917 -4.43 0.00048 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
cat("\n--- 9.3 Driscoll-Kraay (tahan heteroskedastisitas, autokorelasi & cross-sectional dependence) ---\n")
##
## --- 9.3 Driscoll-Kraay (tahan heteroskedastisitas, autokorelasi & cross-sectional dependence) ---
rob2 <- aman(coeftest(model_final, vcov = vcovSCC(model_final, type = "HC1")))
if (!is.null(rob2)) print(rob2)
##
## t test of coefficients:
##
## Estimate Std. Error t value Pr(>|t|)
## X1_Melek_Huruf -3.126 1.592 -1.96 0.068 .
## X2_TPT -4.626 2.922 -1.58 0.134
## X3_PDRB_per_kapita -0.050 0.556 -0.09 0.929
## X4_Pengeluaran_Pemerintah -8.496 3.762 -2.26 0.039 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
cat("\n--- 9.4 Perbandingan ringkas koefisien CEM, FEM, REM ---\n")
##
## --- 9.4 Perbandingan ringkas koefisien CEM, FEM, REM ---
bandingan <- function(...) {
ml <- list(...)
kf <- lapply(ml, coef)
nm <- Reduce(union, lapply(kf, names))
out <- sapply(kf, function(k) round(k[nm], 4)); rownames(out) <- nm; out
}
if (is.null(rem)) print(bandingan(CEM = cem, FEM = fem)) else print(bandingan(CEM = cem, FEM = fem, REM = rem))
## CEM FEM REM
## (Intercept) 174.2350 NA 296.3084
## X1_Melek_Huruf -1.7593 -3.1255 -2.4641
## X2_TPT -0.1351 -4.6260 -2.3932
## X3_PDRB_per_kapita 1.9056 -0.0500 1.1143
## X4_Pengeluaran_Pemerintah -0.1747 -8.4965 -3.3344
cat("\nR-squared CEM:", round(summary(cem)$r.squared["rsq"], 4),
"| FEM (within):", round(summary(fem)$r.squared["rsq"], 4),
if (!is.null(rem)) paste("| REM:", round(summary(rem)$r.squared["rsq"], 4)), "\n")
##
## R-squared CEM: 0.2761 | FEM (within): 0.5389 | REM: 0.3699
# ======================== 10. GRAFIK & TABEL OUTPUT =========================
judul("10. TABEL RINGKASAN, EKSPOR EXCEL & GRAFIK")
##
## ==============================================================================
## 10. TABEL RINGKASAN, EKSPOR EXCEL & GRAFIK
## ==============================================================================
FILE_PDF <- file.path(dirname(FILE_DATA), "Grafik_Analisis_Data_Panel.pdf")
FILE_XLSX <- file.path(dirname(FILE_DATA), "Tabel_Hasil_Analisis_Data_Panel.xlsx")
# ---------------------------- 10.1 TABEL RINGKASAN --------------------------
ambil_p <- function(x) if (is.null(x)) NA_real_ else as.numeric(x$p.value)
tabel_uji <- data.frame(
Kelompok = c(rep("Pemilihan model", 3), rep("Heteroskedastisitas", 3),
rep("Autokorelasi", 2), rep("Cross-sectional dependence", 2), "Normalitas"),
Uji = c("Chow (CEM vs FEM)", "Breusch-Pagan LM (CEM vs REM)", "Hausman (FEM vs REM)",
"Breusch-Pagan (OLS)", "Breusch-Pagan (LSDV)", "Modified Wald groupwise",
"Wooldridge", "Breusch-Godfrey panel",
"Pesaran CD", "Breusch-Pagan LM CD", "Jarque-Bera (model terpilih)"),
p_value = c(p_chow, p_lm, p_haus, ambil_p(bp_ols), ambil_p(bp_fe),
if (is.null(mw)) NA_real_ else mw$p,
ambil_p(wd), ambil_p(pbg), ambil_p(cd1), ambil_p(cd2), ambil_p(jb2)),
stringsAsFactors = FALSE)
tabel_uji$Keputusan <- ifelse(is.na(tabel_uji$p_value), "Tidak tersedia",
ifelse(tabel_uji$p_value < ALPHA, "Tolak H0", "Gagal tolak H0"))
tabel_uji$p_value <- round(tabel_uji$p_value, 4)
cat("\n--- Tabel ringkasan uji diagnostik & pemilihan model ---\n")
##
## --- Tabel ringkasan uji diagnostik & pemilihan model ---
print(tabel_uji, row.names = FALSE)
## Kelompok Uji p_value
## Pemilihan model Chow (CEM vs FEM) 0.0176
## Pemilihan model Breusch-Pagan LM (CEM vs REM) 0.3226
## Pemilihan model Hausman (FEM vs REM) 0.0358
## Heteroskedastisitas Breusch-Pagan (OLS) 0.5907
## Heteroskedastisitas Breusch-Pagan (LSDV) 0.0067
## Heteroskedastisitas Modified Wald groupwise 0.0000
## Autokorelasi Wooldridge 0.9069
## Autokorelasi Breusch-Godfrey panel 0.6615
## Cross-sectional dependence Pesaran CD 0.3303
## Cross-sectional dependence Breusch-Pagan LM CD 0.1508
## Normalitas Jarque-Bera (model terpilih) 0.7996
## Keputusan
## Tolak H0
## Gagal tolak H0
## Tolak H0
## Gagal tolak H0
## Tolak H0
## Tolak H0
## Gagal tolak H0
## Gagal tolak H0
## Gagal tolak H0
## Gagal tolak H0
## Gagal tolak H0
koef_tabel <- function(m, nama) {
s <- summary(m)$coefficients
data.frame(Model = nama, Variabel = rownames(s), Koefisien = s[, 1],
Std.Error = s[, 2], Statistik = s[, 3], p_value = s[, 4], row.names = NULL)
}
tabel_koef <- rbind(koef_tabel(ols, "OLS"), koef_tabel(cem, "CEM"), koef_tabel(fem, "FEM"),
if (!is.null(rem)) koef_tabel(rem, "REM"))
tabel_koef$Signifikan <- ifelse(tabel_koef$p_value < ALPHA, "Ya", "Tidak")
num_k <- c("Koefisien", "Std.Error", "Statistik", "p_value")
tabel_koef[num_k] <- round(tabel_koef[num_k], 4)
cat("\n--- Tabel koefisien seluruh model ---\n")
##
## --- Tabel koefisien seluruh model ---
print(tabel_koef, row.names = FALSE)
## Model Variabel Koefisien Std.Error Statistik p_value
## OLS (Intercept) 174.2350 115.9424 1.5028 0.1512
## OLS X1_Melek_Huruf -1.7593 1.1986 -1.4677 0.1604
## OLS X2_TPT -0.1351 1.6745 -0.0807 0.9366
## OLS X3_PDRB_per_kapita 1.9056 0.9921 1.9207 0.0717
## OLS X4_Pengeluaran_Pemerintah -0.1747 1.0662 -0.1638 0.8718
## CEM (Intercept) 174.2350 115.9424 1.5028 0.1512
## CEM X1_Melek_Huruf -1.7593 1.1986 -1.4677 0.1604
## CEM X2_TPT -0.1351 1.6745 -0.0807 0.9366
## CEM X3_PDRB_per_kapita 1.9056 0.9921 1.9207 0.0717
## CEM X4_Pengeluaran_Pemerintah -0.1747 1.0662 -0.1638 0.8718
## FEM X1_Melek_Huruf -3.1255 1.1772 -2.6551 0.0180
## FEM X2_TPT -4.6260 2.4417 -1.8946 0.0776
## FEM X3_PDRB_per_kapita -0.0500 1.0046 -0.0498 0.9609
## FEM X4_Pengeluaran_Pemerintah -8.4965 2.7394 -3.1016 0.0073
## REM (Intercept) 296.3084 131.7856 2.2484 0.0245
## REM X1_Melek_Huruf -2.4641 1.2469 -1.9762 0.0481
## REM X2_TPT -2.3932 2.3736 -1.0083 0.3133
## REM X3_PDRB_per_kapita 1.1143 1.0029 1.1111 0.2665
## REM X4_Pengeluaran_Pemerintah -3.3344 2.0293 -1.6431 0.1004
## Signifikan
## Tidak
## Tidak
## Tidak
## Tidak
## Tidak
## Tidak
## Tidak
## Tidak
## Tidak
## Tidak
## Ya
## Tidak
## Tidak
## Ya
## Ya
## Ya
## Tidak
## Tidak
## Tidak
tabel_robust <- NULL
if (!is.null(rob1)) {
tabel_robust <- data.frame(Model = model_pilihan, Variabel = rownames(rob1),
Koefisien = rob1[, 1], Std.Error.Robust = rob1[, 2],
Statistik = rob1[, 3], p_value = rob1[, 4], row.names = NULL)
tabel_robust[-(1:2)] <- round(tabel_robust[-(1:2)], 4)
}
# ---------------------------- 10.2 EKSPOR EXCEL ----------------------------
if (!requireNamespace("writexl", quietly = TRUE)) aman(install.packages("writexl"))
lst <- list(
Deskriptif = data.frame(Variabel = rownames(desk), desk, row.names = NULL),
Korelasi = data.frame(Variabel = VARS, cor(dat[VARS]), row.names = NULL),
Unit_Root = hasil_pu,
CIPS = hasil_cips,
Koefisien = tabel_koef,
Uji_Diagnostik = tabel_uji,
Fixed_Effect = data.frame(Unit = names(fixef(fem)), Fixed_Effect = as.numeric(fixef(fem))),
Robust_Arellano = tabel_robust)
lst <- lst[sapply(lst, function(x) is.data.frame(x) && nrow(x) > 0)]
if (requireNamespace("writexl", quietly = TRUE)) {
aman({ writexl::write_xlsx(lst, FILE_XLSX); cat("\nTabel Excel tersimpan di:", FILE_XLSX, "\n") })
} else cat("\n>> Paket writexl tidak tersedia, ekspor Excel dilewati.\n")
##
## Tabel Excel tersimpan di: C:/Users/ADVAN/OneDrive/Dokumen/Tabel_Hasil_Analisis_Data_Panel.xlsx
# ------------------------------- 10.3 GRAFIK --------------------------------
units <- sort(unique(dat$unit))
warna <- hcl.colors(length(units), "Dark 3")
pdf_ok <- !is.null(aman({ pdf(FILE_PDF, width = 11, height = 8); TRUE }))
if (pdf_ok) {
# (1) Tren tiap variabel per unit
for (v in VARS) aman({
plot(NA, xlim = range(dat$waktu), ylim = range(dat[[v]]), xlab = "Tahun", ylab = v,
main = paste("Tren", v, "per unit"))
for (i in seq_along(units)) {
d <- dat[dat$unit == units[i], ]
lines(d$waktu, d[[v]], col = warna[i], lwd = 2); points(d$waktu, d[[v]], col = warna[i], pch = 19, cex = 0.6)
}
if (length(units) <= 15) legend("topright", legend = units, col = warna, lwd = 2, cex = 0.7, bty = "n")
})
# (2) Boxplot per unit -> heterogenitas antar-unit
for (v in VARS) aman({
par(mar = c(9, 4, 4, 2))
boxplot(dat[[v]] ~ dat$unit, las = 2, col = warna, ylab = v, xlab = "",
main = paste("Sebaran", v, "per unit (heterogenitas antar-unit)"), cex.axis = 0.7)
par(mar = c(5, 4, 4, 2) + 0.1)
})
# (3) Rata-rata Y per unit + 95% CI
aman({
y <- dat[[DEP_VAR]]
m <- tapply(y, dat$unit, mean); se <- tapply(y, dat$unit, function(x) sd(x) / sqrt(length(x)))
par(mar = c(9, 4, 4, 2))
bp <- barplot(m, col = warna, las = 2, ylab = paste("Rata-rata", DEP_VAR), cex.names = 0.7,
ylim = range(c(0, m - 1.96 * se, m + 1.96 * se), na.rm = TRUE),
main = paste("Rata-rata", DEP_VAR, "per unit (± 95% CI)"))
arrows(bp, m - 1.96 * se, bp, m + 1.96 * se, angle = 90, code = 3, length = 0.05)
par(mar = c(5, 4, 4, 2) + 0.1)
})
# (4) Heatmap korelasi
aman({
cm <- cor(dat[VARS]); k <- ncol(cm)
par(mar = c(9, 9, 4, 2))
image(1:k, 1:k, t(cm[k:1, , drop = FALSE]), col = hcl.colors(21, "RdBu"), zlim = c(-1, 1),
axes = FALSE, xlab = "", ylab = "", main = "Heatmap korelasi")
axis(1, 1:k, colnames(cm), las = 2, cex.axis = 0.8); axis(2, 1:k, rev(colnames(cm)), las = 2, cex.axis = 0.8)
for (i in 1:k) for (j in 1:k) text(j, k - i + 1, sprintf("%.2f", cm[i, j]), cex = 0.8)
par(mar = c(5, 4, 4, 2) + 0.1)
})
# (5) Scatter Y vs tiap X
for (v in INDEP_VARS) aman({
plot(dat[[v]], dat[[DEP_VAR]], col = warna[match(dat$unit, units)], pch = 19,
xlab = v, ylab = DEP_VAR, main = paste(DEP_VAR, "vs", v))
abline(lm(dat[[DEP_VAR]] ~ dat[[v]]), lwd = 2, lty = 2)
if (length(units) <= 15) legend("topright", legend = units, col = warna, pch = 19, cex = 0.7, bty = "n")
})
# (6) Diagnostik OLS (4 panel)
aman({ par(mfrow = c(2, 2)); plot(ols); par(mfrow = c(1, 1)) })
# (7) Residual model terpilih
aman({
par(mfrow = c(1, 3), mar = c(9, 4, 4, 2))
qqnorm(res_f, main = paste("QQ-plot residual", model_pilihan)); qqline(res_f, col = "red")
hist(res_f, breaks = 20, col = "grey80", main = paste("Histogram residual", model_pilihan), xlab = "Residual")
boxplot(res_f ~ as.character(index(model_final)[[1]]), las = 2, col = warna, cex.axis = 0.7,
main = "Residual per unit (cek heteroskedastisitas)", xlab = "", ylab = "Residual")
par(mfrow = c(1, 1), mar = c(5, 4, 4, 2) + 0.1)
})
# (8) Fixed effect tiap unit
aman({
fe <- fixef(fem); fe <- setNames(as.numeric(fe), names(fe)); fe <- sort(fe)
par(mar = c(9, 4, 4, 2))
barplot(fe, las = 2, col = "steelblue", cex.names = 0.7, ylab = "Fixed effect",
main = "Fixed effect tiap unit (FEM)")
par(mar = c(5, 4, 4, 2) + 0.1)
})
# (9) Plot koefisien model terpilih (95% CI)
aman({
s <- summary(model_final)$coefficients
s <- s[rownames(s) != "(Intercept)", , drop = FALSE]
est <- s[, 1]; lo <- est - 1.96 * s[, 2]; hi <- est + 1.96 * s[, 2]; yy <- seq_along(est)
par(mar = c(5, 12, 4, 2))
plot(est, yy, xlim = range(c(lo, hi, 0)), yaxt = "n", pch = 19, ylab = "",
xlab = "Koefisien (95% CI)", main = paste("Koefisien model", model_pilihan))
segments(lo, yy, hi, yy, lwd = 2); abline(v = 0, lty = 2, col = "red")
axis(2, yy, rownames(s), las = 1)
par(mar = c(5, 4, 4, 2) + 0.1)
})
invisible(dev.off())
cat("\nGrafik tersimpan di:", FILE_PDF, "\n")
}
##
## Grafik tersimpan di: C:/Users/ADVAN/OneDrive/Dokumen/Grafik_Analisis_Data_Panel.pdf
judul("SELESAI")
##
## ==============================================================================
## SELESAI
## ==============================================================================
cat("Output teks :", FILE_OUT, "\nTabel Excel :", FILE_XLSX, "\nGrafik (PDF) :", FILE_PDF, "\n")
## Output teks : C:/Users/ADVAN/OneDrive/Dokumen/Hasil_Analisis_Data_Panel.txt
## Tabel Excel : C:/Users/ADVAN/OneDrive/Dokumen/Tabel_Hasil_Analisis_Data_Panel.xlsx
## Grafik (PDF) : C:/Users/ADVAN/OneDrive/Dokumen/Grafik_Analisis_Data_Panel.pdf
sink()