###############################################################################
#  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()