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