title: “Regresi liniear Berganda Data Panel Statis dan Uji Asumsi Lengkap”

author: “Nova Maqvirotin (240611010036)”

date: “2026-11-20”

output:

html_document:

toc: true

toc_float: true

theme: cosmo

1. Instalasi dan Pemuatan Paket

pkgs <- c(

  "readxl", "dplyr", "tidyr", "stringr", "zoo",

  "plm", "lmtest", "car", "tseries", "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(tseries)

library(knitr)

library(kableExtra)

2. Definisi Fungsi Pendukung (Uji CIPS & Pesaran-Yamagata)

Fungsi-fungsi di bawah ini dirancang khusus untuk menangani pengujian panel generasi kedua (CIPS dan Heterogenitas Slope) secara aman dari masalah nilai konstan (varians nol) atau matriks singular.

# Fungsi pembersih nilai numerik & persentase

parse_num <- function(x) {

  s <- str_trim(as.character(x))

  has_pct <- str_detect(s, "%")

  s_clean <- str_replace_all(s, "%", "")

  s_clean <- str_replace_all(s_clean, ",", ".")

  s_clean[s_clean %in% c("", "..", "NA", "NaN", "null", "NULL", "-")] <- NA_character_

  val <- suppressWarnings(as.numeric(s_clean))

  ifelse(!is.na(val) & has_pct, val / 100, val)

}



# Uji CIPS Manual / Safe CADF

run_cips_manual <- function(df, var_name, lags = 1) {

  countries <- sort(unique(df$country))

  years <- sort(unique(df$year))

  N <- length(countries)

  T_len <- length(years)



  Y_mat <- sapply(countries, function(ct) {

    df$value[df$country == ct][match(years, df$year[df$country == ct])]

  })



  y_bar <- rowMeans(Y_mat, na.rm = TRUE)

  dy_mat <- apply(Y_mat, 2, function(col) c(NA, diff(col)))

  dy_bar <- c(NA, diff(y_bar))



  t_stats <- numeric(N)

  names(t_stats) <- countries



  for (j in seq_len(N)) {

    y_j <- Y_mat[, j]

    dy_j <- dy_mat[, j]

    if (all(is.na(y_j)) || sd(y_j, na.rm = TRUE) == 0) {

      t_stats[j] <- NA_real_

      next

    }

    lag_y <- c(NA, y_j[-T_len])

    lag_ybar <- c(NA, y_bar[-T_len])

    lag_dybar <- c(NA, dy_bar[-T_len])

    lag_dyj <- c(NA, 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) {

      for (l in seq_len(lags)) {

        data_cadf[[paste0("lag_dyj_", l)]] <- c(rep(NA, 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)) {

      sm_fit <- summary(fit_cadf)$coefficients

      t_stats[j] <- if ("lag_y" %in% rownames(sm_fit)) sm_fit["lag_y", "t value"] else NA_real_

    } else {

      t_stats[j] <- NA_real_

    }

  }



  valid_t <- t_stats[!is.na(t_stats)]

  cips_stat <- ifelse(length(valid_t) > 0, mean(valid_t), NA_real_)

  kesimpulan <- ifelse(is.na(cips_stat), "Tidak Terhitung",

                ifelse(cips_stat < -2.23, "Stasioner (p < 0.05)", "Tidak Stasioner / Akar Unit"))



  data.frame(

    Variabel = var_name,

    Statistik_CIPS = cips_stat,

    N_Aktif = length(valid_t),

    T_Tahun = T_len,

    Keterangan = kesimpulan

  )

}



# Uji Heterogenitas Slope (Pesaran & Yamagata, 2008)

pesaran_yamagata_test <- function(df, formula_obj) {

  countries <- unique(df$country)

  N <- length(countries)

  vars_all <- all.vars(formula_obj)

  y_name <- vars_all[1]

  x_names <- vars_all[-1]



  sd_x <- sapply(df[, x_names, drop = FALSE], function(col) sd(col, na.rm = TRUE))

  x_active <- x_names[sd_x > 0]

  k <- length(x_active)



  if (k == 0) {

    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 = "Variabel independen tidak memiliki variansi."

    ))

  }



  form_active <- as.formula(paste(y_name, "~", paste(x_active, collapse = " + ")))



  fit_pool <- lm(form_active, data = df)

  beta_pool <- coef(fit_pool)[x_active]



  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) <- countries

  valid_n <- 0L



  for (ct in countries) {

    sub_ct <- df[df$country == ct, , drop = FALSE]

    T_i <- nrow(sub_ct)

    if (T_i > (k + 2)) {

      X_mat <- as.matrix(sub_ct[, x_active, drop = FALSE])

      y_vec <- sub_ct[[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[ct] <- as.numeric(t(diff_b) %*% XtX %*% diff_b) / sigma2_pool

        valid_n <- valid_n + 1L

      }

    }

  }



  if (valid_n == 0) {

    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 = "Matriks individual tidak ter-invers."

    ))

  }



  S_tilde <- sum(s_tilde_list, na.rm = TRUE)

  T_bar <- mean(sapply(countries, function(ct) sum(df$country == ct)))



  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-negara",

      "Gagal Tolak H0: Slope Homogen"

    )

  )

}

3. Pembacaan dan Pembersihan Data Excel (data 15 negara asia.xlsx)

file_path <- "C:/Users/User/OneDrive/Documents/data 15 negara asia.xlsx"

stopifnot(file.exists(file_path))



sheets_avail <- readxl::excel_sheets(file_path)

target_sheet <- 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 >= 1990 & nums <= 2030) >= 10

}))[1]

if (is.na(year_row_idx)) year_row_idx <- 3



years_vec <- suppressWarnings(as.numeric(as.character(unlist(raw_df[year_row_idx, ]))))

valid_year_cols <- which(!is.na(years_vec) & years_vec >= 1990 & years_vec <= 2030)

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_val <- str_trim(as.character(data_rows[[2]][i]))

  if (!is.na(c_val) && nzchar(c_val) && !c_val %in% c("NA", "NaN")) {

    current_country <- c_val

  }

  ind_val <- str_trim(as.character(data_rows[[3]][i]))

  if (is.na(current_country) || is.na(ind_val) || !nzchar(ind_val)) next



  vals_num <- parse_num(unlist(data_rows[i, valid_year_cols]))

  long_list[[idx_counter]] <- tibble(

    country = current_country,

    indicator = ind_val,

    year = years_clean,

    value = vals_num

  )

  idx_counter <- idx_counter + 1L

}



long_df <- bind_rows(long_list) %>%

  mutate(

    var_code = case_when(

      str_detect(indicator, "\\(Y\\)")  ~ "Y",

      str_detect(indicator, "\\(X1\\)") ~ "X1",

      str_detect(indicator, "\\(X2\\)") ~ "X2",

      str_detect(indicator, "\\(X3\\)") ~ "X3",

      TRUE ~ make.names(indicator)

    )

  ) %>%

  group_by(country, year, 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(country, year)



for (col_nm in c("Y", "X1", "X2", "X3")) {

  if (!col_nm %in% names(panel_raw)) {

    panel_raw[[col_nm]] <- NA_real_

  }

}



# Pembentukan Panel Seimbang (Balanced Panel 2005 - 2020)

panel_bal <- panel_raw %>%

  filter(year >= 2005 & year <= 2020) %>%

  tidyr::drop_na(Y, X1, X2, X3) %>%

  arrange(country, year)



pdata <- pdata.frame(panel_bal, index = c("country", "year"))

form_panel <- Y ~ X1 + X2 + X3

4. Cuplikan Data & Statistik Deskriptif

# Preview 8 Baris Pertama Data Panel

kable(

  head(panel_bal[, c("country", "year", "Y", "X1", "X2", "X3")], 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
country year Y X1 X2 X3
Brunei Darusalam 2005 -0.0039 100 36.4664 64.8898
Brunei Darusalam 2006 4.0984 100 42.1863 82.6517
Brunei Darusalam 2007 -3.7636 100 44.6800 98.7233
Brunei Darusalam 2008 -3.9007 100 46.0000 105.5755
Brunei Darusalam 2009 -1.9003 100 49.0000 107.2554
Brunei Darusalam 2010 2.7414 100 53.0000 110.9020
Brunei Darusalam 2011 3.7444 100 56.0000 110.9597
Brunei Darusalam 2012 0.9131 100 60.2731 115.8259
cat("\n--- STATISTIK DESKRIPTIF ---\n")
## 
## --- STATISTIK DESKRIPTIF ---
summary(panel_bal[, c("Y", "X1", "X2", "X3")])
##        Y                X1               X2                X3          
##  Min.   :-9.518   Min.   : 20.20   Min.   : 0.0652   Min.   :  0.2713  
##  1st Qu.: 2.728   1st Qu.: 79.17   1st Qu.: 9.0000   1st Qu.: 58.3870  
##  Median : 5.487   Median : 93.60   Median :25.2237   Median :100.8166  
##  Mean   : 4.945   Mean   : 85.29   Mean   :34.5727   Mean   : 91.8846  
##  3rd Qu.: 7.333   3rd Qu.: 99.83   3rd Qu.:56.4863   3rd Qu.:128.8755  
##  Max.   :31.726   Max.   :100.00   Max.   :96.3055   Max.   :181.2219

5. Uji Cross-Sectional Independence (CD Test) & Stasioneritas CIPS

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"

  )

)



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) 13.4318 0 Tolak H0: Ada Cross-Sectional Dependence
Breusch-Pagan LM Test (Residual FEM) 477.0057 0 Tolak H0: Ada Cross-Sectional Dependence
# Uji CIPS Level

cips_level <- lapply(c("Y", "X1", "X2", "X3"), function(v) {

  sub_df <- panel_bal %>% select(country, year, value = all_of(v))

  run_cips_manual(sub_df, v, lags = 1)

}) %>% bind_rows()



kable(cips_level, digits = 4, caption = "Uji Stasioneritas Generasi Kedua (Pesaran CIPS Level)") %>%

  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Uji Stasioneritas Generasi Kedua (Pesaran CIPS Level)
Variabel Statistik_CIPS N_Aktif T_Tahun Keterangan
Y -0.9772 15 16 Tidak Stasioner / Akar Unit
X1 -1.8021 12 16 Tidak Stasioner / Akar Unit
X2 -1.5619 15 16 Tidak Stasioner / Akar Unit
X3 -2.2942 15 16 Stasioner (p < 0.05)
# Uji CIPS First Difference

panel_diff <- panel_bal %>%

  arrange(country, year) %>%

  group_by(country) %>%

  mutate(

    d_Y  = Y - lag(Y),

    d_X1 = X1 - lag(X1),

    d_X2 = X2 - lag(X2),

    d_X3 = X3 - lag(X3)

  ) %>%

  ungroup() %>%

  tidyr::drop_na(d_Y, d_X1, d_X2, d_X3)



cips_diff <- lapply(c("d_Y", "d_X1", "d_X2", "d_X3"), function(v) {

  sub_df <- panel_diff %>% select(country, year, value = all_of(v))

  run_cips_manual(sub_df, v, lags = 1)

}) %>% bind_rows()



kable(cips_diff, digits = 4, caption = "Uji Stasioneritas Generasi Kedua (Pesaran CIPS 1st Difference)") %>%

  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Uji Stasioneritas Generasi Kedua (Pesaran CIPS 1st Difference)
Variabel Statistik_CIPS N_Aktif T_Tahun Keterangan
d_Y NA 0 16 Tidak Terhitung
d_X1 NA 0 16 Tidak Terhitung
d_X2 NA 0 16 Tidak Terhitung
d_X3 NA 0 16 Tidak Terhitung

6. Uji Heterogenitas Slope (Pesaran dan Yamagata)

het_tbl <- pesaran_yamagata_test(panel_bal, form_panel)

kable(het_tbl, 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) 3.1066 0.0019 Tolak H0: Slope Heterogen antar-negara
Delta_tilde_adj 3.6976 0.0002 Tolak H0: Slope Heterogen antar-negara

7. Estimasi & Pemilihan Model Panel Statis (CEM, FEM, REM)

cem_mod <- plm(form_panel, data = pdata, model = "pooling")

fem_mod <- plm(form_panel, data = pdata, model = "within", effect = "individual")

rem_mod <- plm(form_panel, data = pdata, model = "random", effect = "individual")



chow_test <- pFtest(fem_mod, cem_mod)

hausman_test <- tryCatch(phtest(fem_mod, rem_mod), error = function(e) list(statistic = NA_real_, p.value = NA_real_))

bplm_test <- tryCatch(plmtest(cem_mod, type = "bp"), error = function(e) list(statistic = NA_real_, p.value = NA_real_))



cat("--- Ringkasan CEM ---\n")
## --- Ringkasan CEM ---
print(summary(cem_mod))
## Pooling Model
## 
## Call:
## plm(formula = form_panel, data = pdata, model = "pooling")
## 
## Balanced Panel: n = 15, T = 16, N = 240
## 
## Residuals:
##    Min. 1st Qu.  Median 3rd Qu.    Max. 
## -14.092  -1.653   0.304   1.897  26.910 
## 
## Coefficients:
##               Estimate Std. Error t-value  Pr(>|t|)    
## (Intercept)  9.2488629  1.3745204  6.7288 1.284e-10 ***
## X1          -0.0316461  0.0193548 -1.6350    0.1034    
## X2          -0.0593194  0.0144934 -4.0929 5.853e-05 ***
## X3           0.0048517  0.0088815  0.5463    0.5854    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    5020
## Residual Sum of Squares: 4047.5
## R-Squared:      0.19371
## Adj. R-Squared: 0.18346
## F-statistic: 18.8999 on 3 and 236 DF, p-value: 5.0883e-11
cat("\n--- Ringkasan FEM ---\n")
## 
## --- Ringkasan FEM ---
print(summary(fem_mod))
## Oneway (individual) effect Within Model
## 
## Call:
## plm(formula = form_panel, data = pdata, effect = "individual", 
##     model = "within")
## 
## Balanced Panel: n = 15, T = 16, N = 240
## 
## Residuals:
##    Min. 1st Qu.  Median 3rd Qu.    Max. 
##  -13.72   -1.23    0.32    1.87   24.46 
## 
## Coefficients:
##     Estimate Std. Error t-value Pr(>|t|)   
## X1  0.051516   0.034313  1.5014 0.134684   
## X2 -0.075793   0.025368 -2.9878 0.003126 **
## X3 -0.010134   0.010989 -0.9222 0.357427   
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    3753
## Residual Sum of Squares: 3441.6
## R-Squared:      0.082979
## Adj. R-Squared: 0.012756
## F-statistic: 6.69606 on 3 and 222 DF, p-value: 0.00024
cat("\n--- Ringkasan REM ---\n")
## 
## --- Ringkasan REM ---
print(summary(rem_mod))
## Oneway (individual) effect Random Effect Model 
##    (Swamy-Arora's transformation)
## 
## Call:
## plm(formula = form_panel, data = pdata, effect = "individual", 
##     model = "random")
## 
## Balanced Panel: n = 15, T = 16, N = 240
## 
## Effects:
##                  var std.dev share
## idiosyncratic 15.503   3.937 0.911
## individual     1.513   1.230 0.089
## theta: 0.3751
## 
## Residuals:
##    Min. 1st Qu.  Median 3rd Qu.    Max. 
## -13.629  -1.380   0.294   1.766  26.423 
## 
## Coefficients:
##               Estimate Std. Error z-value  Pr(>|z|)    
## (Intercept)  7.7749758  1.7587147  4.4208 9.832e-06 ***
## X1          -0.0054769  0.0245760 -0.2229 0.8236490    
## X2          -0.0646414  0.0181612 -3.5593 0.0003718 ***
## X3          -0.0013958  0.0095982 -0.1454 0.8843760    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    4247.7
## Residual Sum of Squares: 3718.1
## R-Squared:      0.12467
## Adj. R-Squared: 0.11354
## Chisq: 33.6119 on 3 DF, p-value: 2.3924e-07
sel_tbl <- data.frame(

  Uji = c("Uji Chow (CEM vs FEM)", "Uji Hausman (REM vs FEM)", "Uji Breusch-Pagan LM (CEM vs REM)"),

  Statistik = c(

    as.numeric(chow_test$statistic),

    as.numeric(hausman_test$statistic),

    as.numeric(bplm_test$statistic)

  ),

  P_Value = c(

    as.numeric(chow_test$p.value),

    as.numeric(hausman_test$p.value),

    as.numeric(bplm_test$p.value)

  ),

  Rekomendasi = c(

    ifelse(as.numeric(chow_test$p.value) < 0.05, "Pilih FEM", "Pilih CEM"),

    ifelse(is.na(hausman_test$p.value), "Cek Kovarians", ifelse(as.numeric(hausman_test$p.value) < 0.05, "Pilih FEM", "Pilih REM")),

    ifelse(is.na(bplm_test$p.value), "Cek Varians", ifelse(as.numeric(bplm_test$p.value) < 0.05, "Pilih REM", "Pilih CEM"))

  )

)



kable(sel_tbl, digits = 4, caption = "Ringkasan Uji Pemilihan Model Panel Statis") %>%

  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Ringkasan Uji Pemilihan Model Panel Statis
Uji Statistik P_Value Rekomendasi
Uji Chow (CEM vs FEM) 2.7920 0.0007 Pilih FEM
Uji Hausman (REM vs FEM) 7.1138 0.0684 Pilih REM
Uji Breusch-Pagan LM (CEM vs REM) 8.0608 0.0045 Pilih REM

8. Uji Asumsi Klasik Diagnostik & Driscoll-Kraay Robust Standard Errors

best_model <- if (as.numeric(chow_test$p.value) < 0.05) {

  if (!is.na(hausman_test$p.value) && as.numeric(hausman_test$p.value) < 0.05) fem_mod else rem_mod

} else {

  if (!is.na(bplm_test$p.value) && as.numeric(bplm_test$p.value) < 0.05) rem_mod else cem_mod

}



best_name <- if (identical(best_model, fem_mod)) {

  "Fixed Effect Model (FEM)"

} else if (identical(best_model, rem_mod)) {

  "Random Effect Model (REM)"

} else {

  "Common Effect Model (CEM)"

}



cat("Model panel statis terpilih otomatis:", best_name, "\n\n")
## Model panel statis terpilih otomatis: Random Effect Model (REM)
# 1. Multikolinearitas (VIF)

ols_aux <- lm(form_panel, data = panel_bal)

cat("--- Multikolinearitas (VIF) ---\n")
## --- Multikolinearitas (VIF) ---
print(car::vif(ols_aux))
##       X1       X2       X3 
## 1.929605 2.467176 2.233768
# 2. Heteroskedastisitas (Breusch-Pagan)

cat("\n--- Heteroskedastisitas (Breusch-Pagan) ---\n")
## 
## --- Heteroskedastisitas (Breusch-Pagan) ---
print(lmtest::bptest(ols_aux))
## 
##  studentized Breusch-Pagan test
## 
## data:  ols_aux
## BP = 1.3357, df = 3, p-value = 0.7207
# 3. Autokorelasi Serial Panel (Breusch-Godfrey & Durbin-Watson)

cat("\n--- Autokorelasi Serial Panel ---\n")
## 
## --- Autokorelasi Serial Panel ---
print(plm::pbgtest(best_model))
## 
##  Breusch-Godfrey/Wooldridge test for serial correlation in panel models
## 
## data:  form_panel
## chisq = 47.713, df = 16, p-value = 5.269e-05
## alternative hypothesis: serial correlation in idiosyncratic errors
print(plm::pdwtest(best_model))
## 
##  Durbin-Watson test for serial correlation in panel models
## 
## data:  form_panel
## DW = 1.4651, p-value = 7.569e-06
## alternative hypothesis: serial correlation in idiosyncratic errors
# 4. Normalitas Residual (Jarque-Bera Test)

res_vec <- as.numeric(residuals(best_model))

cat("\n--- Normalitas Residual (Jarque-Bera) ---\n")
## 
## --- Normalitas Residual (Jarque-Bera) ---
print(tseries::jarque.bera.test(res_vec))
## 
##  Jarque Bera Test
## 
## data:  res_vec
## X-squared = 1168.3, df = 2, p-value < 2.2e-16
# 5. Driscoll-Kraay Robust Standard Errors (Koreksi Autokorelasi & Heteroskedastisitas)

cat("\n--- Estimasi Robust (Driscoll-Kraay SE) ---\n")
## 
## --- Estimasi Robust (Driscoll-Kraay SE) ---
print(lmtest::coeftest(best_model, vcov. = function(x) plm::vcovSCC(x, type = "HC1", cluster = "group")))
## 
## t test of coefficients:
## 
##               Estimate Std. Error t value  Pr(>|t|)    
## (Intercept)  7.7749758  2.9069945  2.6746  0.008006 ** 
## X1          -0.0054769  0.0392548 -0.1395  0.889158    
## X2          -0.0646414  0.0126557 -5.1077 6.723e-07 ***
## X3          -0.0013958  0.0069852 -0.1998  0.841789    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

9. Evaluasi Performa Model (Goodness-of-Fit Comparison)

hitung_performa <- function(model, data_df, y_name = "Y", model_name = "Model") {

  y_act <- data_df[[y_name]]

  res   <- as.numeric(residuals(model))

  y_pred <- y_act - res

  n <- length(res)

  k <- length(coef(model))



  rmse <- sqrt(mean(res^2))

  mae  <- mean(abs(res))

  

  valid_mape_idx <- which(y_act != 0 & is.finite(res / y_act))

  mape <- mean(abs(res[valid_mape_idx] / y_act[valid_mape_idx])) * 100



  s_mod <- summary(model)

  r2_val <- tryCatch(as.numeric(s_mod$r.squared["rsq"]), error = function(e) cor(y_pred, y_act)^2)

  adj_r2 <- tryCatch(as.numeric(s_mod$r.squared["adjrsq"]), error = function(e) 1 - (1 - r2_val)*((n-1)/(n-k-1)))



  sse <- sum(res^2)

  log_lik <- -0.5 * n * (log(2 * pi) + log(sse / n) + 1)

  aic_val <- -2 * log_lik + 2 * (k + 1)

  bic_val <- -2 * log_lik + log(n) * (k + 1)



  data.frame(

    Model = model_name,

    RMSE = round(rmse, 4),

    MAE = round(mae, 4),

    `MAPE (%)` = round(mape, 2),

    `R-Squared` = round(r2_val, 4),

    `Adj R-Squared` = round(adj_r2, 4),

    AIC = round(aic_val, 2),

    BIC = round(bic_val, 2),

    check.names = FALSE

  )

}



perf_tbl <- rbind(

  hitung_performa(cem_mod, panel_bal, "Y", "Common Effect Model (CEM)"),

  hitung_performa(fem_mod, panel_bal, "Y", "Fixed Effect Model (FEM)"),

  hitung_performa(rem_mod, panel_bal, "Y", "Random Effect Model (REM)")

)



kable(perf_tbl, caption = "Tabel Komparasi Statistik Performa Model Panel Statis") %>%

  kable_styling(bootstrap_options = c("striped", "hover"), full_width = FALSE)
Tabel Komparasi Statistik Performa Model Panel Statis
Model RMSE MAE MAPE (%) R-Squared Adj R-Squared AIC BIC
Common Effect Model (CEM) 4.1067 2.7189 563.05 0.1937 0.1835 1369.14 1386.55
Fixed Effect Model (FEM) 3.7868 2.4278 407.12 0.0830 0.0128 1328.22 1342.14
Random Effect Model (REM) 3.9360 2.5238 497.50 0.1247 0.1135 1348.77 1366.18