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