1. Instalasi dan Pemuatan Paket

pkgs <- c(
  "readxl", "dplyr", "tidyr", "stringr", "zoo",
  "plm", "lmtest", "car", "knitr", "kableExtra"
)

installed <- rownames(installed.packages())
for (p in pkgs) {
  if (!p %in% installed) {
    install.packages(p, dependencies = TRUE)
  }
}

library(readxl)
library(dplyr)
library(tidyr)
library(stringr)
library(zoo)
library(plm)
library(lmtest)
library(car)
library(knitr)
library(kableExtra)

2. Definisi Fungsi Pendukung (CIPS, Pesaran-Yamagata & Tabel Panel)

parse_num_id <- function(x) {
  if (is.null(x) || length(x) == 0) return(numeric(0))
  if (is.numeric(x)) return(as.numeric(x))
  if (inherits(x, c("Date", "POSIXt"))) return(as.numeric(format(x, "%Y")))

  s <- str_trim(as.character(x))
  is_na_s <- is.na(s)
  has_pct <- ifelse(is_na_s, FALSE, str_detect(s, fixed("%")))
  s <- ifelse(is_na_s, NA_character_, str_replace_all(s, fixed("%"), ""))

  na_tokens <- c("", "-", "--", "..", "NA", "NaN", "N/A", "na", "n/a", "null", "NULL", "#N/A", "#VALUE!", "#DIV/0!")
  s <- ifelse(!is.na(s) & s %in% na_tokens, NA_character_, s)

  has_dot <- ifelse(is.na(s), FALSE, str_detect(s, fixed(".")))
  has_comma <- ifelse(is.na(s), FALSE, str_detect(s, fixed(",")))

  idx_both <- which(has_dot & has_comma)
  if (length(idx_both) > 0) {
    s[idx_both] <- str_replace_all(
      str_replace_all(s[idx_both], fixed("."), ""),
      fixed(","),
      "."
    )
  }

  idx_comma_only <- which((!has_dot) & has_comma)
  if (length(idx_comma_only) > 0) {
    s[idx_comma_only] <- str_replace_all(s[idx_comma_only], fixed(","), ".")
  }

  val <- suppressWarnings(as.numeric(s))
  ifelse(!is.na(val) & has_pct, val / 100, val)
}

interp_vec <- function(x, yr) {
  non_na <- sum(!is.na(x) & is.finite(x))
  if (non_na >= 2) {
    as.numeric(zoo::na.approx(x, x = yr, na.rm = FALSE, rule = 2))
  } else if (non_na == 1) {
    rep(x[!is.na(x) & is.finite(x)][1], length(x))
  } else {
    rep(NA_real_, length(x))
  }
}

run_cips_manual <- function(df, var_name, lags = 1) {
  units <- sort(unique(as.character(df$unit)))
  years <- sort(unique(as.numeric(df$time)))
  N <- length(units)
  T_len <- length(years)

  if (N < 2 || T_len < 6) {
    return(data.frame(
      Variabel = var_name,
      Statistik_CIPS = NA_real_,
      N_Unit = N,
      T_Periode = T_len,
      Keterangan = "Dimensi N atau T belum mencukupi untuk CIPS",
      stringsAsFactors = FALSE
    ))
  }

  Y_mat <- sapply(units, function(u) {
    sub_u <- df[as.character(df$unit) == u, , drop = FALSE]
    sub_u$value[match(years, sub_u$time)]
  })
  Y_mat <- matrix(as.numeric(Y_mat), nrow = T_len, ncol = N)

  y_bar <- rowMeans(Y_mat, na.rm = TRUE)
  dy_mat <- apply(Y_mat, 2, function(col) c(NA_real_, diff(col)))
  dy_mat <- matrix(as.numeric(dy_mat), nrow = T_len, ncol = N)
  dy_bar <- c(NA_real_, diff(y_bar))

  t_stats <- vapply(seq_len(N), function(j) {
    y_j <- Y_mat[, j]
    dy_j <- dy_mat[, j]

    lag_y <- c(NA_real_, y_j[-T_len])
    lag_ybar <- c(NA_real_, y_bar[-T_len])
    lag_dybar <- c(NA_real_, dy_bar[-T_len])
    lag_dyj <- c(NA_real_, dy_j[-T_len])

    data_cadf <- data.frame(
      dy = dy_j,
      lag_y = lag_y,
      lag_ybar = lag_ybar,
      dybar = dy_bar,
      lag_dybar = lag_dybar,
      lag_dyj = lag_dyj
    )

    if (lags >= 1 && T_len > (lags + 1)) {
      for (l in seq_len(lags)) {
        data_cadf[[paste0("lag_dyj_", l)]] <- c(rep(NA_real_, l), dy_j[seq_len(T_len - l)])
      }
    }

    fit_cadf <- tryCatch(
      lm(dy ~ ., data = data_cadf, na.action = na.omit),
      error = function(e) NULL
    )
    if (is.null(fit_cadf)) return(NA_real_)
    sm_fit <- summary(fit_cadf)$coefficients
    if ("lag_y" %in% rownames(sm_fit)) as.numeric(sm_fit["lag_y", "t value"]) else NA_real_
  }, numeric(1))

  valid_t <- t_stats[is.finite(t_stats)]
  cips_stat <- if (length(valid_t) > 0) mean(valid_t) else NA_real_
  kesimpulan <- if (is.na(cips_stat)) {
    "Tidak dapat dihitung"
  } else if (cips_stat < -2.23) {
    "Stasioner (p < 0.05)"
  } else {
    "Tidak Stasioner / Akar Unit"
  }

  data.frame(
    Variabel = var_name,
    Statistik_CIPS = cips_stat,
    N_Unit = N,
    T_Periode = T_len,
    Keterangan = kesimpulan,
    stringsAsFactors = FALSE
  )
}

pesaran_yamagata_test <- function(df, formula_obj) {
  units <- unique(as.character(df$unit))
  N <- length(units)
  vars_all <- all.vars(formula_obj)
  y_name <- vars_all[1]
  x_names <- vars_all[-1]
  k <- length(x_names)

  fit_pool <- lm(formula_obj, data = df)
  beta_pool <- coef(fit_pool)[x_names]

  resid_pool <- residuals(fit_pool)
  n_tot <- length(resid_pool)
  sigma2_pool <- sum(resid_pool^2) / max(1, (n_tot - N - k))

  s_tilde_list <- numeric(N)
  names(s_tilde_list) <- units
  valid_n <- 0L

  for (u in units) {
    sub_u <- df[as.character(df$unit) == u, , drop = FALSE]
    T_i <- nrow(sub_u)
    if (T_i > (k + 2)) {
      X_mat <- as.matrix(sub_u[, x_names, drop = FALSE])
      y_vec <- sub_u[[y_name]]
      X_dm <- scale(X_mat, center = TRUE, scale = FALSE)
      y_dm <- y_vec - mean(y_vec, na.rm = TRUE)
      XtX <- crossprod(X_dm)
      XtX_inv <- try(solve(XtX), silent = TRUE)
      if (!inherits(XtX_inv, "try-error")) {
        beta_i <- as.numeric(XtX_inv %*% crossprod(X_dm, y_dm))
        diff_b <- beta_i - beta_pool
        s_tilde_list[u] <- as.numeric(t(diff_b) %*% XtX %*% diff_b) / max(sigma2_pool, 1e-12)
        valid_n <- valid_n + 1L
      }
    }
  }

  if (valid_n == 0L) {
    return(data.frame(
      Statistik = c("Delta_tilde (Pesaran-Yamagata)", "Delta_tilde_adj"),
      Nilai = c(NA_real_, NA_real_),
      P_Value = c(NA_real_, NA_real_),
      Keputusan = c("Sampel T per unit terlalu kecil", "Sampel T per unit terlalu kecil"),
      stringsAsFactors = FALSE
    ))
  }

  S_tilde <- sum(s_tilde_list, na.rm = TRUE)
  T_bar <- mean(vapply(units, function(u) sum(as.character(df$unit) == u), integer(1)))

  delta_tilde <- sqrt(valid_n) * ((S_tilde / valid_n) - k) / sqrt(2 * k)
  v_nk <- max(1e-6, (2 * k * (T_bar - k - 1)) / (T_bar + 1))
  delta_adj <- sqrt(valid_n) * ((S_tilde / valid_n) - k) / sqrt(v_nk)

  pval_delta <- 2 * (1 - pnorm(abs(delta_tilde)))
  pval_adj <- 2 * (1 - pnorm(abs(delta_adj)))

  data.frame(
    Statistik = c("Delta_tilde (Pesaran-Yamagata)", "Delta_tilde_adj"),
    Nilai = c(delta_tilde, delta_adj),
    P_Value = c(pval_delta, pval_adj),
    Keputusan = ifelse(
      c(pval_delta, pval_adj) < 0.05,
      "Tolak H0: Slope Heterogen antar-unit",
      "Gagal Tolak H0: Slope Homogen"
    ),
    stringsAsFactors = FALSE
  )
}

extract_plm_table <- function(mod, label) {
  if (is.null(mod)) {
    return(list(
      coef_df = data.frame(Variabel = character(0), stringsAsFactors = FALSE),
      stats_df = data.frame(Variabel = character(0), stringsAsFactors = FALSE)
    ))
  }

  sm <- summary(mod)
  ct <- as.data.frame(sm$coefficients)
  ct$Variabel <- rownames(ct)

  est_col <- names(ct)[1]
  se_col  <- names(ct)[2]
  p_col   <- names(ct)[ncol(ct)]

  stars <- ifelse(
    ct[[p_col]] < 0.01, "***",
    ifelse(ct[[p_col]] < 0.05, "**",
      ifelse(ct[[p_col]] < 0.10, "*", "")
    )
  )

  cell_val <- paste0(
    formatC(ct[[est_col]], format = "f", digits = 4),
    stars,
    " (",
    formatC(ct[[se_col]], format = "f", digits = 4),
    ")"
  )

  coef_df <- data.frame(
    Variabel = ct$Variabel,
    val = cell_val,
    stringsAsFactors = FALSE
  )
  names(coef_df)[2] <- label

  r2_val <- if (!is.null(sm$r.squared)) {
    if (is.list(sm$r.squared)) as.numeric(sm$r.squared$rsq) else as.numeric(sm$r.squared[1])
  } else {
    NA_real_
  }

  adj_r2_val <- if (!is.null(sm$r.squared)) {
    if (is.list(sm$r.squared)) as.numeric(sm$r.squared$adjrsq) else as.numeric(sm$r.squared[2])
  } else {
    NA_real_
  }

  stat_val <- if (!is.null(sm$fstatistic)) {
    paste0(
      formatC(as.numeric(sm$fstatistic$statistic), format = "f", digits = 4),
      " (p = ",
      formatC(as.numeric(sm$fstatistic$p.value), format = "f", digits = 4),
      ")"
    )
  } else if (!is.null(sm$chisq)) {
    paste0(
      formatC(as.numeric(sm$chisq$statistic), format = "f", digits = 4),
      " (p = ",
      formatC(as.numeric(sm$chisq$p.value), format = "f", digits = 4),
      ")"
    )
  } else {
    "-"
  }

  n_obs <- nrow(model.frame(mod))

  stats_df <- data.frame(
    Variabel = c("R-squared", "Adj. R-squared", "Statistik Uji Model", "Jumlah Observasi (N*T)"),
    val = c(
      ifelse(is.finite(r2_val), formatC(r2_val, format = "f", digits = 4), "-"),
      ifelse(is.finite(adj_r2_val), formatC(adj_r2_val, format = "f", digits = 4), "-"),
      stat_val,
      as.character(n_obs)
    ),
    stringsAsFactors = FALSE
  )
  names(stats_df)[2] <- label

  list(coef_df = coef_df, stats_df = stats_df)
}

3. Pembacaan, Pembersihan Data Excel & Preview 8 Baris Pertama

file_paths <- c(
  "C:/Users/acer/OneDrive/Dokumen/Data indonesia pacific sri 1.xlsx",
  "Data indonesia pacific sri 1.xlsx"
)
existing_paths <- file_paths[file.exists(file_paths)]
stopifnot("File Excel tidak ditemukan. Periksa path file." = length(existing_paths) > 0)
file_path <- existing_paths[1]

sheets_avail <- readxl::excel_sheets(file_path)

first_sheet_df <- readxl::read_excel(file_path, sheet = sheets_avail[1])
lower_names <- str_to_lower(names(first_sheet_df))

has_direct_panel <- any(lower_names %in% c("negara", "country", "unit", "provinsi")) &&
                    any(lower_names %in% c("tahun", "year", "time", "periode"))

if (has_direct_panel) {
  u_col_raw <- names(first_sheet_df)[which(lower_names %in% c("negara", "country", "unit", "provinsi"))[1]]
  t_col_raw <- names(first_sheet_df)[which(lower_names %in% c("tahun", "year", "time", "periode"))[1]]

  num_cols <- setdiff(names(first_sheet_df), c(u_col_raw, t_col_raw))
  panel_bal <- first_sheet_df %>%
    mutate(
      unit = ifelse(is.na(.data[[u_col_raw]]), NA_character_, str_trim(as.character(.data[[u_col_raw]]))),
      time = as.integer(parse_num_id(.data[[t_col_raw]])),
      across(all_of(num_cols), parse_num_id)
    ) %>%
    filter(!is.na(unit), nzchar(unit), !is.na(time), is.finite(time))

  if (!("ln_GDPpc" %in% names(panel_bal)) && ("GDP_per_capita" %in% names(panel_bal))) {
    panel_bal <- panel_bal %>%
      mutate(ln_GDPpc = ifelse(!is.na(GDP_per_capita) & GDP_per_capita > 0, log(GDP_per_capita), NA_real_))
  }

  panel_bal <- panel_bal %>%
    drop_na() %>%
    arrange(unit, time)

  if (u_col_raw != "Negara" && !("Negara" %in% names(panel_bal))) {
    panel_bal$Negara <- panel_bal$unit
  }
  if (t_col_raw != "Tahun" && !("Tahun" %in% names(panel_bal))) {
    panel_bal$Tahun <- panel_bal$time
  }

  y_var <- if ("ln_GDPpc" %in% names(panel_bal)) {
    "ln_GDPpc"
  } else if ("GDP_growth" %in% names(panel_bal)) {
    "GDP_growth"
  } else {
    num_cols[1]
  }

  x_vars <- setdiff(
    names(panel_bal),
    c("unit", "time", "Negara", "Tahun", y_var, "GDP_per_capita")
  )
  if (length(x_vars) == 0) {
    x_vars <- setdiff(num_cols, y_var)
  }
} else {
  target_sheet <- if ("Data Model Manusia" %in% sheets_avail) {
    "Data Model Manusia"
  } else {
    sheets_avail[1]
  }

  raw_df <- readxl::read_excel(file_path, sheet = target_sheet, col_names = FALSE)

  year_row_idx <- which(apply(raw_df, 1, function(r) {
    nums <- suppressWarnings(as.numeric(as.character(r)))
    sum(!is.na(nums) & nums >= 1980 & nums <= 2035) >= 5
  }))[1]
  stopifnot("Baris tahun pada sheet tidak ditemukan." = !is.na(year_row_idx))

  years_vec <- suppressWarnings(as.numeric(as.character(unlist(raw_df[year_row_idx, ]))))
  valid_year_cols <- which(!is.na(years_vec) & years_vec >= 1980 & years_vec <= 2035)
  years_clean <- as.integer(years_vec[valid_year_cols])

  data_rows <- raw_df[(year_row_idx + 1):nrow(raw_df), , drop = FALSE]

  long_list <- list()
  current_country <- NA_character_
  idx_counter <- 1L

  for (i in seq_len(nrow(data_rows))) {
    c_raw <- data_rows[[2]][i]
    if (!is.na(c_raw)) {
      c_val <- str_trim(as.character(c_raw))
      if (nzchar(c_val) && !c_val %in% c("NA", "NaN")) {
        current_country <- c_val
      }
    }
    ind_raw <- data_rows[[3]][i]
    if (is.na(ind_raw)) next
    ind_val <- str_trim(as.character(ind_raw))
    if (is.na(current_country) || !nzchar(ind_val)) next

    vals_num <- parse_num_id(unlist(data_rows[i, valid_year_cols]))
    long_list[[idx_counter]] <- tibble(
      unit = current_country,
      indicator = ind_val,
      time = years_clean,
      value = vals_num
    )
    idx_counter <- idx_counter + 1L
  }

  long_df <- bind_rows(long_list) %>%
    mutate(
      var_code = case_when(
        str_detect(str_to_lower(indicator), fixed("education")) ~ "edu_exp",
        str_detect(str_to_lower(indicator), fixed("health")) ~ "health_exp",
        str_detect(str_to_lower(indicator), fixed("life expectancy")) ~ "life_exp",
        str_detect(str_to_lower(indicator), fixed("gdp per capita")) ~ "gdp_pc",
        TRUE ~ make.names(indicator)
      )
    ) %>%
    group_by(unit, time, var_code) %>%
    summarise(
      value = if (all(is.na(value))) NA_real_ else mean(value, na.rm = TRUE),
      .groups = "drop"
    )

  panel_raw <- long_df %>%
    pivot_wider(names_from = var_code, values_from = value) %>%
    arrange(unit, time)

  for (col_nm in c("gdp_pc", "edu_exp", "health_exp", "life_exp")) {
    if (!col_nm %in% names(panel_raw)) {
      panel_raw[[col_nm]] <- NA_real_
    }
  }

  panel_bal <- panel_raw %>%
    filter(time >= 2001 & time <= 2023) %>%
    group_by(unit) %>%
    arrange(time, .by_group = TRUE) %>%
    mutate(
      gdp_pc_i = interp_vec(gdp_pc, time),
      edu_exp_i = interp_vec(edu_exp, time),
      health_exp_i = interp_vec(health_exp, time),
      life_exp_i = interp_vec(life_exp, time)
    ) %>%
    ungroup() %>%
    mutate(
      ln_gdp = ifelse(!is.na(gdp_pc_i) & gdp_pc_i > 0, log(gdp_pc_i), NA_real_),
      edu = edu_exp_i,
      health = health_exp_i,
      life = life_exp_i,
      Negara = unit,
      Tahun = time
    ) %>%
    filter(!is.na(ln_gdp) & !is.na(edu) & !is.na(health) & !is.na(life))

  common_years <- Reduce(intersect, split(panel_bal$time, panel_bal$unit))
  panel_bal <- panel_bal %>%
    filter(time %in% common_years) %>%
    arrange(unit, time)

  y_var <- "ln_gdp"
  x_vars <- c("edu", "health", "life")
}

stopifnot("Data panel kosong setelah pembersihan." = nrow(panel_bal) > 0)

preview_cols <- intersect(
  c("Negara", "Tahun", "Exports", "GDP_growth", "Trade", "GDP_per_capita", "ln_GDPpc", y_var, x_vars),
  names(panel_bal)
)

knitr::kable(
  head(panel_bal[, preview_cols, drop = FALSE], 8),
  digits = 4,
  caption = "Preview 8 Baris Pertama Data Panel"
) %>%
  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Preview 8 Baris Pertama Data Panel
Negara Tahun ln_gdp edu health life
Brunei Darussalam 2001 9.8140 1.8438 2.5465 74.209
Brunei Darussalam 2002 9.8321 1.8438 2.5345 74.365
Brunei Darussalam 2003 9.9368 1.8438 2.6026 74.509
Brunei Darussalam 2004 10.1033 1.8438 2.5519 74.603
Brunei Darussalam 2005 10.2883 1.8438 2.2339 74.683
Brunei Darussalam 2006 10.4538 1.8438 1.9073 74.753
Brunei Darussalam 2007 10.4973 1.8438 1.9415 74.793
Brunei Darussalam 2008 10.6491 1.8438 1.8761 74.814
pdata <- pdata.frame(panel_bal, index = c("unit", "time"))
form_panel <- as.formula(paste(y_var, "~", paste(x_vars, collapse = " + ")))
vars_panel <- c(y_var, x_vars)
pdim(pdata)
## Balanced Panel: n = 15, T = 23, N = 345

4. Uji Cross-Sectional Independence (CD Test), Stasioneritas (IPS & CIPS), dan Heterogenitas Slope

# 4.1 Uji Cross-Sectional Independence (Pesaran CD & Breusch-Pagan LM) pada Residual FEM
fe_init <- plm(form_panel, data = pdata, model = "within")
cd_pesaran <- pcdtest(fe_init, test = "cd")
cd_bp_lm <- pcdtest(fe_init, test = "lm")

cd_model_tbl <- data.frame(
  Uji = c("Pesaran CD Test (Residual FEM)", "Breusch-Pagan LM Test (Residual FEM)"),
  Statistik = c(as.numeric(cd_pesaran$statistic), as.numeric(cd_bp_lm$statistic)),
  P_Value = c(as.numeric(cd_pesaran$p.value), as.numeric(cd_bp_lm$p.value)),
  Status_Independensi = ifelse(
    c(as.numeric(cd_pesaran$p.value), as.numeric(cd_bp_lm$p.value)) >= 0.05,
    "Gagal Tolak H0: Cross-Sectional Independent",
    "Tolak H0: Ada Cross-Sectional Dependence"
  ),
  stringsAsFactors = FALSE
)

kable(cd_model_tbl, digits = 4, caption = "Uji Cross-Sectional Independence pada Residual Model Panel") %>%
  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Uji Cross-Sectional Independence pada Residual Model Panel
Uji Statistik P_Value Status_Independensi
Pesaran CD Test (Residual FEM) 7.5845 0 Tolak H0: Ada Cross-Sectional Dependence
Breusch-Pagan LM Test (Residual FEM) 452.3273 0 Tolak H0: Ada Cross-Sectional Dependence
# 4.2 Uji Pesaran CD per Variabel
cd_vars <- lapply(vars_panel, function(v) {
  res <- pcdtest(pdata[[v]], test = "cd")
  pval <- as.numeric(res$p.value)
  data.frame(
    Variabel = v,
    Statistik_CD = as.numeric(res$statistic),
    P_Value = pval,
    Status_Independensi = ifelse(
      pval >= 0.05,
      "Cross-Sectional Independent",
      "Ada Cross-Sectional Dependence"
    ),
    stringsAsFactors = FALSE
  )
}) %>% bind_rows()

kable(cd_vars, digits = 4, caption = "Uji Pesaran CD per Variabel (pseries)") %>%
  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Uji Pesaran CD per Variabel (pseries)
Variabel Statistik_CD P_Value Status_Independensi
ln_gdp 41.0789 0.0000 Ada Cross-Sectional Dependence
edu -0.4415 0.6588 Cross-Sectional Independent
health 6.6317 0.0000 Ada Cross-Sectional Dependence
life 37.9252 0.0000 Ada Cross-Sectional Dependence
# 4.3 Uji Stasioneritas Panel Standar (Im-Pesaran-Shin / IPS)
for (v in vars_panel) {
  cat("\n### Uji Stasioneritas IPS:", v, "\n")
  ips_res <- tryCatch(
    purtest(pdata[[v]], test = "ips", exo = "intercept", lags = "AIC"),
    error = function(e) paste("Lewati IPS:", e$message)
  )
  print(ips_res)
}
## 
## ### Uji Stasioneritas IPS: ln_gdp 
## [1] "Lewati IPS: NA/NaN/Inf in foreign function call (arg 6)"
## 
## ### Uji Stasioneritas IPS: edu 
## [1] "Lewati IPS: NA/NaN/Inf in foreign function call (arg 6)"
## 
## ### Uji Stasioneritas IPS: health 
## [1] "Lewati IPS: NA/NaN/Inf in foreign function call (arg 6)"
## 
## ### Uji Stasioneritas IPS: life 
## [1] "Lewati IPS: NA/NaN/Inf in foreign function call (arg 6)"
# 4.4 Uji Stasioneritas Generasi Kedua (Pesaran CIPS)
cips_results <- lapply(vars_panel, function(v) {
  sub_df <- panel_bal %>% select(unit, time, value = all_of(v))
  run_cips_manual(sub_df, v, lags = 1)
}) %>% bind_rows()

kable(cips_results, digits = 4, caption = "Uji Stasioneritas Generasi Kedua (Pesaran CIPS)") %>%
  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Uji Stasioneritas Generasi Kedua (Pesaran CIPS)
Variabel Statistik_CIPS N_Unit T_Periode Keterangan
ln_gdp -2.2655 15 23 Stasioner (p < 0.05)
edu -1.7494 15 23 Tidak Stasioner / Akar Unit
health -2.0238 15 23 Tidak Stasioner / Akar Unit
life -2.4367 15 23 Stasioner (p < 0.05)
# 4.5 Uji Heterogenitas Slope (Pesaran & Yamagata, 2008)
het_results <- pesaran_yamagata_test(panel_bal, form_panel)
kable(het_results, digits = 4, caption = "Uji Heterogenitas Slope Pesaran-Yamagata") %>%
  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Uji Heterogenitas Slope Pesaran-Yamagata
Statistik Nilai P_Value Keputusan
Delta_tilde (Pesaran-Yamagata) 0.7699 0.4414 Gagal Tolak H0: Slope Homogen
Delta_tilde_adj 0.8653 0.3869 Gagal Tolak H0: Slope Homogen

5. Estimasi Model Panel Statis (CEM, FEM, REM), Tabel Perbandingan & Uji Pemilihan Model

cem_mod <- plm(form_panel, data = pdata, model = "pooling")
fem_mod <- plm(form_panel, data = pdata, model = "within")
rem_mod <- tryCatch(
  plm(form_panel, data = pdata, model = "random"),
  error = function(e) NULL
)

t_cem <- extract_plm_table(cem_mod, "CEM (Pooling)")
t_fem <- extract_plm_table(fem_mod, "FEM (Within)")
t_rem <- extract_plm_table(rem_mod, "REM (Random)")

coef_merged <- full_join(t_cem$coef_df, t_fem$coef_df, by = "Variabel")
if (ncol(t_rem$coef_df) > 1) {
  coef_merged <- full_join(coef_merged, t_rem$coef_df, by = "Variabel")
}

stats_merged <- full_join(t_cem$stats_df, t_fem$stats_df, by = "Variabel")
if (ncol(t_rem$stats_df) > 1) {
  stats_merged <- full_join(stats_merged, t_rem$stats_df, by = "Variabel")
}

tabel_cem_fem_rem <- bind_rows(coef_merged, stats_merged)

knitr::kable(
  tabel_cem_fem_rem,
  align = c("l", rep("r", ncol(tabel_cem_fem_rem) - 1)),
  caption = "Tabel Perbandingan Estimasi Model Panel Statis (CEM, FEM, dan REM)"
) %>%
  kable_styling(bootstrap_options = c("striped", "hover", "condensed"), full_width = FALSE) %>%
  footnote(
    general = "Angka dalam tanda kurung adalah standard error. Signifikansi: *** p < 0,01; ** p < 0,05; * p < 0,10.",
    general_title = "Catatan: "
  )
Tabel Perbandingan Estimasi Model Panel Statis (CEM, FEM, dan REM)
Variabel CEM (Pooling) FEM (Within) REM (Random)
(Intercept) -7.1810*** (0.3867) NA -7.0821*** (0.5973)
edu -0.0078 (0.0192) -0.0535 (0.0184) -0.0528 (0.0180)
health -0.0842 (0.0182) 0.0008 (0.0186) -0.0027 (0.0182)
life 0.2213 (0.0056) 0.2173 (0.0085) 0.2172 (0.0081)
R-squared 0.8279 0.7017 0.7101
Adj. R-squared 0.8264 0.6862 0.7076
Statistik Uji Model 546.7880 (p = 0.0000) 256.3651 (p = 0.0000) 835.3664 (p = 0.0000)
Jumlah Observasi (N*T) 345 345 345
Catatan:
Angka dalam tanda kurung adalah standard error. Signifikansi: *** p < 0,01; ** p < 0,05; * p < 0,10.
chow_res <- if (!is.null(fem_mod) && !is.null(cem_mod)) tryCatch(pFtest(fem_mod, cem_mod), error = function(e) NULL) else NULL
haus_res <- if (!is.null(fem_mod) && !is.null(rem_mod)) tryCatch(phtest(fem_mod, rem_mod), error = function(e) NULL) else NULL
bp_res   <- if (!is.null(cem_mod)) tryCatch(plmtest(cem_mod, type = "bp"), error = function(e) NULL) else NULL

uji_pemilihan_df <- data.frame(
  Uji_Pemilihan = c(
    "Uji Chow (CEM vs FEM)",
    "Uji Hausman (FEM vs REM)",
    "Uji Breusch-Pagan LM (CEM vs REM)"
  ),
  Statistik = c(
    if (!is.null(chow_res)) round(as.numeric(chow_res$statistic), 4) else NA_real_,
    if (!is.null(haus_res)) round(as.numeric(haus_res$statistic), 4) else NA_real_,
    if (!is.null(bp_res)) round(as.numeric(bp_res$statistic), 4) else NA_real_
  ),
  P_Value = c(
    if (!is.null(chow_res)) round(as.numeric(chow_res$p.value), 4) else NA_real_,
    if (!is.null(haus_res)) round(as.numeric(haus_res$p.value), 4) else NA_real_,
    if (!is.null(bp_res)) round(as.numeric(bp_res$p.value), 4) else NA_real_
  ),
  Keputusan_5pct = c(
    if (!is.null(chow_res)) ifelse(chow_res$p.value < 0.05, "Pilih FEM", "Pilih CEM") else "Tidak tersedia",
    if (!is.null(haus_res)) ifelse(haus_res$p.value < 0.05, "Pilih FEM", "Pilih REM") else "Tidak tersedia",
    if (!is.null(bp_res)) ifelse(bp_res$p.value < 0.05, "Pilih REM", "Pilih CEM") else "Tidak tersedia"
  ),
  stringsAsFactors = FALSE
)

knitr::kable(
  uji_pemilihan_df,
  digits = 4,
  caption = "Ringkasan Uji Pemilihan Model Panel Statis"
) %>%
  kable_styling(bootstrap_options = c("striped", "hover", "condensed"), full_width = FALSE)
Ringkasan Uji Pemilihan Model Panel Statis
Uji_Pemilihan Statistik P_Value Keputusan_5pct
F Uji Chow (CEM vs FEM) 77.0817 0.0000 Pilih FEM
Uji Hausman (FEM vs REM) 1.2605 0.7385 Pilih REM
chisq Uji Breusch-Pagan LM (CEM vs REM) 2051.5213 0.0000 Pilih REM

6. Uji Asumsi Klasik & Cluster-Robust Standard Errors

# 6.1 Multikolinearitas (VIF)
ols_base <- lm(form_panel, data = panel_bal)
cat("--- VIF (Multikolinearitas) ---\n")
## --- VIF (Multikolinearitas) ---
if (length(x_vars) >= 2) {
  print(vif(ols_base))
} else {
  cat("VIF memerlukan minimal 2 variabel independen.\n")
}
##      edu   health     life 
## 1.057802 1.211220 1.149950
# 6.2 Heteroskedastisitas (Breusch-Pagan)
cat("\n--- Uji Heteroskedastisitas (Breusch-Pagan) ---\n")
## 
## --- Uji Heteroskedastisitas (Breusch-Pagan) ---
print(bptest(ols_base))
## 
##  studentized Breusch-Pagan test
## 
## data:  ols_base
## BP = 20.432, df = 3, p-value = 0.0001381
# 6.3 Autokorelasi Serial pada Panel
cat("\n--- Uji Autokorelasi Serial Panel ---\n")
## 
## --- Uji Autokorelasi Serial Panel ---
print(pbgtest(fem_mod))
## 
##  Breusch-Godfrey/Wooldridge test for serial correlation in panel models
## 
## data:  form_panel
## chisq = 197.9, df = 23, p-value < 2.2e-16
## alternative hypothesis: serial correlation in idiosyncratic errors
# 6.4 Normalitas Residual (Shapiro-Wilk)
cat("\n--- Uji Normalitas Residual (Shapiro-Wilk) ---\n")
## 
## --- Uji Normalitas Residual (Shapiro-Wilk) ---
res_ols <- residuals(ols_base)
if (length(res_ols) >= 3 && length(res_ols) <= 5000) {
  print(shapiro.test(res_ols))
}
## 
##  Shapiro-Wilk normality test
## 
## data:  res_ols
## W = 0.93513, p-value = 4.035e-11
# 6.5 Estimasi FEM dengan Cluster-Robust Standard Errors
fem_vcov_cl <- vcovHC(fem_mod, type = "HC1", cluster = "group")
cat("\n--- Koefisien FEM dengan Cluster-Robust Standard Errors ---\n")
## 
## --- Koefisien FEM dengan Cluster-Robust Standard Errors ---
print(coeftest(fem_mod, vcov. = fem_vcov_cl))
## 
## t test of coefficients:
## 
##           Estimate  Std. Error t value Pr(>|t|)    
## edu    -0.05349987  0.03966815 -1.3487   0.1784    
## health  0.00083196  0.04149695  0.0200   0.9840    
## life    0.21734584  0.00762065 28.5207   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1