# 1. Memuat Paket (otomatis dipasang jika belum ada)
paket <- c("readxl", "dplyr", "tidyr", "stringr", "forecast", "ggplot2", "knitr")
belum <- paket[!(paket %in% rownames(installed.packages()))]
if (length(belum) > 0) install.packages(belum, type = "binary")
invisible(lapply(paket, library, character.only = TRUE))
# 2. Memuat & Memfilter Data WDI Khusus Filipina
file_data   <- "C:/Users/User/Downloads/P_Data_Extract_From_World_Development_Indicators.xlsx"
nama_negara <- "philippines"   # nama negara dalam data WDI (huruf kecil)

# Jika file memuat banyak indikator, isi nama indikator yang diinginkan,
# contoh: indikator_pilihan <- "GDP growth (annual %)"
# Biarkan NULL untuk memakai indikator pertama.
indikator_pilihan <- NULL

df_raw <- read_excel(file_data, sheet = 1)

# Cari kolom negara secara otomatis (country / negara)
col_neg <- names(df_raw)[str_detect(tolower(names(df_raw)), "country name|country|negara")][1]

df_ph <- df_raw %>%
  filter(tolower(as.character(.data[[col_neg]])) == nama_negara)

cat("Jumlah baris data Filipina:", nrow(df_ph), "\n")
## Jumlah baris data Filipina: 4
# Deteksi kolom tahun berformat wide (mis. "2000 [YR2000]")
kolom_thn <- names(df_ph)[str_detect(names(df_ph), "^[0-9]{4}")]

if (length(kolom_thn) > 3) {
  # ---- FORMAT WIDE: tahun sebagai kolom (format standar WDI) ----
  col_ind <- names(df_ph)[str_detect(tolower(names(df_ph)), "series name|series|indicator|indikator")][1]
  if (!is.na(col_ind)) {
    cat("Indikator tersedia:\n"); print(unique(df_ph[[col_ind]]))
    if (is.null(indikator_pilihan)) indikator_pilihan <- unique(df_ph[[col_ind]])[1]
    cat("\nIndikator yang dianalisis:", as.character(indikator_pilihan), "\n")
    df_ph <- df_ph %>% filter(.data[[col_ind]] == indikator_pilihan)
  }
  df_clean <- df_ph %>%
    select(all_of(kolom_thn)) %>%
    mutate(across(everything(), as.character)) %>%
    pivot_longer(everything(), names_to = "Tahun", values_to = "Nilai") %>%
    transmute(Tahun = as.numeric(str_sub(Tahun, 1, 4)),
              Nilai = suppressWarnings(as.numeric(Nilai))) %>%   # ".." otomatis jadi NA
    filter(!is.na(Nilai)) %>%
    arrange(Tahun)
} else {
  # ---- FORMAT LONG: satu kolom tahun & satu kolom nilai ----
  col_wkt <- names(df_ph)[str_detect(tolower(names(df_ph)), "year|tahun")][1]
  col_nil <- tail(names(df_ph)[sapply(df_ph, is.numeric) & names(df_ph) != col_wkt], 1)
  df_clean <- df_ph %>%
    transmute(Tahun = as.numeric(str_sub(as.character(.data[[col_wkt]]), 1, 4)),
              Nilai = suppressWarnings(as.numeric(as.character(.data[[col_nil]])))) %>%
    filter(!is.na(Nilai)) %>%
    arrange(Tahun)
}
## Indikator tersedia:
## [1] "GDP growth (annual %)"                                              
## [2] "Inflation, consumer prices (annual %)"                              
## [3] "Unemployment, total (% of total labor force) (modeled ILO estimate)"
## [4] "Foreign direct investment, net inflows (% of GDP)"                  
## 
## Indikator yang dianalisis: GDP growth (annual %)
head(df_clean)
## # A tibble: 6 × 2
##   Tahun Nilai
##   <dbl> <dbl>
## 1  2000  4.38
## 2  2001  3.05
## 3  2002  3.72
## 4  2003  5.09
## 5  2004  6.57
## 6  2005  4.94
# 3. Uji Stasioneritas & Plot ACF/PACF
ts_ph   <- ts(df_clean$Nilai, start = min(df_clean$Tahun), frequency = 1)
d_opt   <- ndiffs(ts_ph, test = "adf")
ts_diff <- if (d_opt > 0) diff(ts_ph, differences = d_opt) else ts_ph

cat(sprintf("Observasi: %d (%d-%d) | Rekomendasi Differencing (d) via ADF: %d\n",
            length(ts_ph), min(df_clean$Tahun), max(df_clean$Tahun), d_opt))
## Observasi: 26 (2000-2025) | Rekomendasi Differencing (d) via ADF: 0
par(mfrow = c(1, 2), mar = c(3, 3, 2, 1))
acf(ts_diff,  main = paste0("ACF (d=", d_opt, ")"))
pacf(ts_diff, main = paste0("PACF (d=", d_opt, ")"))

# 4. Estimasi Model AR, MA, ARMA, ARIMA & Perbandingan AIC/BIC
p <- 1; q <- 1

models <- list(
  "AR(1)"        = Arima(ts_ph, order = c(p, 0, 0)),
  "MA(1)"        = Arima(ts_ph, order = c(0, 0, q)),
  "ARMA(1,1)"    = Arima(ts_ph, order = c(p, 0, q)),
  "ARIMA(p,d,q)" = Arima(ts_ph, order = c(p, d_opt, q)),
  "Auto-ARIMA"   = auto.arima(ts_ph, seasonal = FALSE)
)

tabel_model <- data.frame(
  Model = names(models),
  AIC   = sapply(models, AIC),
  BIC   = sapply(models, BIC)
) %>% arrange(AIC)

kable(tabel_model, digits = 2, row.names = FALSE,
      caption = "Perbandingan Model (AIC & BIC Terkecil = Terbaik)")
Perbandingan Model (AIC & BIC Terkecil = Terbaik)
Model AIC BIC
Auto-ARIMA 138.75 141.27
ARMA(1,1) 139.35 144.38
ARIMA(p,d,q) 139.35 144.38
MA(1) 140.68 144.45
AR(1) 140.70 144.47
# 5. Koefisien Model Terbaik & Prediksi 5 Tahun ke Depan
nama_terbaik <- tabel_model$Model[1]
best_model   <- models[[nama_terbaik]]
cat("Model terbaik:", nama_terbaik, "\n")
## Model terbaik: Auto-ARIMA
print(coef(best_model))
## intercept 
##  4.956371
fc <- forecast(best_model, h = 5)

autoplot(fc) +
  labs(title = paste("Proyeksi Filipina -", as.character(best_model)),
       x = "Tahun", y = "Nilai") +
  theme_minimal()

kable(as.data.frame(fc), digits = 2, caption = "Hasil Prediksi 5 Tahun ke Depan")
Hasil Prediksi 5 Tahun ke Depan
Point Forecast Lo 80 Hi 80 Lo 95 Hi 95
2026 4.96 0.74 9.18 -1.5 11.41
2027 4.96 0.74 9.18 -1.5 11.41
2028 4.96 0.74 9.18 -1.5 11.41
2029 4.96 0.74 9.18 -1.5 11.41
2030 4.96 0.74 9.18 -1.5 11.41