# 1. Memuat Paket
library(readxl)
library(dplyr)
library(tidyr)
library(stringr)
library(forecast)
library(ggplot2)
library(knitr)
# 2. Memuat & Memfilter Data Khusus Indonesia
df_raw <- read_excel("C:/Users/valem/Downloads/DATA_15_NEGARA_CLEANED.xlsx", sheet = 1)

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

df_indo <- df_raw %>%
  filter(tolower(as.character(.data[[col_neg]])) == "indonesia")

# Deteksi kolom tahun berformat wide (mis. 2000, 2001, ... atau "2000 [YR2000]")
kolom_thn <- names(df_indo)[str_detect(names(df_indo), "^[0-9]{4}")]

if (length(kolom_thn) > 3) {
  # ---- FORMAT WIDE: tahun sebagai kolom ----
  col_ind <- names(df_indo)[str_detect(tolower(names(df_indo)), "series|indicator|indikator")][1]
  if (!is.na(col_ind)) {
    # Jika ada banyak indikator, pakai indikator pertama.
    # Ganti dengan nama indikator lain jika perlu, mis.:
    # indikator_pilihan <- "GDP growth (annual %)"
    indikator_pilihan <- unique(df_indo[[col_ind]])[1]
    cat("Indikator yang dianalisis:", as.character(indikator_pilihan), "\n")
    df_indo <- df_indo %>% filter(.data[[col_ind]] == indikator_pilihan)
  }
  df_clean <- df_indo %>%
    select(all_of(kolom_thn)) %>%
    pivot_longer(everything(), names_to = "Tahun", values_to = "Nilai") %>%
    transmute(Tahun = as.numeric(str_sub(Tahun, 1, 4)),
              Nilai = suppressWarnings(as.numeric(as.character(Nilai)))) %>%
    filter(!is.na(Nilai)) %>%
    arrange(Tahun)
} else {
  # ---- FORMAT LONG: satu kolom tahun & satu kolom nilai ----
  col_wkt <- names(df_indo)[str_detect(tolower(names(df_indo)), "year|tahun")][1]
  col_nil <- tail(names(df_indo)[sapply(df_indo, is.numeric) & names(df_indo) != col_wkt], 1)
  df_clean <- df_indo %>%
    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 yang dianalisis: Foreign direct investment, net inflows (% of GDP)
head(df_clean)
## # A tibble: 6 × 2
##   Tahun   Nilai
##   <dbl>   <dbl>
## 1  2001 -1.86  
## 2  2002  0.0742
## 3  2003 -0.254 
## 4  2004  0.738 
## 5  2005  2.92  
## 6  2006  1.35
# 3. Uji Stasioneritas & Plot ACF/PACF
ts_indo <- ts(df_clean$Nilai, start = min(df_clean$Tahun), frequency = 1)
d_opt   <- ndiffs(ts_indo, test = "adf")
ts_diff <- if (d_opt > 0) diff(ts_indo, differences = d_opt) else ts_indo

cat(sprintf("Observasi: %d (%d-%d) | Rekomendasi Differencing (d) via ADF: %d\n",
            length(ts_indo), min(df_clean$Tahun), max(df_clean$Tahun), d_opt))
## Observasi: 25 (2001-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_indo, order = c(p, 0, 0)),
  "MA(1)"      = Arima(ts_indo, order = c(0, 0, q)),
  "ARMA(1,1)"  = Arima(ts_indo, order = c(p, 0, q)),
  "ARIMA(p,d,q)" = Arima(ts_indo, order = c(p, d_opt, q)),
  "Auto-ARIMA" = auto.arima(ts_indo, 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 66.79 67.97
AR(1) 71.06 74.71
ARMA(1,1) 72.24 77.12
ARIMA(p,d,q) 72.24 77.12
MA(1) 73.52 77.18
# 5. Koefisien Model Terbaik & Prediksi 5 Tahun ke Depan
nama_terbaik <- tabel_model$Model[1]          # model dengan AIC terkecil
best_model   <- models[[nama_terbaik]]
cat("Model terbaik:", nama_terbaik, "\n")
## Model terbaik: Auto-ARIMA
print(coef(best_model))
## numeric(0)
fc <- forecast(best_model, h = 5)

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

# Tabel hasil prediksi
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 1.57 0.37 2.77 -0.26 3.40
2027 1.57 -0.12 3.26 -1.02 4.16
2028 1.57 -0.50 3.64 -1.60 4.74
2029 1.57 -0.82 3.96 -2.09 5.23
2030 1.57 -1.10 4.24 -2.52 5.66