1. Persiapan Paket & Baca Data WDI
library(readxl)
library(dplyr)
library(tidyr)
library(ggplot2)
library(tseries)
library(forecast)
file_path <- "C:\\Users\\AXIOO\\Downloads\\Data WDI 25 Negara.xlsx"
# Cek daftar sheet
sheets <- excel_sheets(file_path)
cat("Daftar sheet:", paste(sheets, collapse = ", "), "\n")
## Daftar sheet: Data, Series - Metadata
# Baca sheet pertama (ubah sheet = ... atau tambahkan skip = ... jika perlu)
df_raw <- read_excel(file_path, sheet = sheets[1])
cat("Nama kolom:\n")
## Nama kolom:
print(names(df_raw))
## [1] "Negara" "Indikator" "2000" "2001" "2002" "2003"
## [7] "2004" "2005" "2006" "2007" "2008" "2009"
## [13] "2010" "2011" "2012" "2013" "2014" "2015"
## [19] "2016" "2017" "2018" "2019" "2020" "2021"
## [25] "2022" "2023" "2024"
head(df_raw, 3)
## # A tibble: 3 × 27
## Negara Indikator `2000` `2001` `2002` `2003` `2004` `2005` `2006` `2007`
## <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
## 1 Indonesia Official ex… 8421.… 10260… 9311.… 8577.… 8938.… 9704.… 9159.… 9141
## 2 Indonesia Employment … 16.29… 17.55… 17.52… 16.53… 16.79… 17.52… 17.34… 17.52…
## 3 Indonesia Fertility r… 2.503… 2.466… 2.435… 2.41 2.415 2.452 2.456… 2.476
## # ℹ 17 more variables: `2008` <chr>, `2009` <chr>, `2010` <chr>, `2011` <chr>,
## # `2012` <chr>, `2013` <chr>, `2014` <chr>, `2015` <chr>, `2016` <chr>,
## # `2017` <chr>, `2018` <chr>, `2019` <chr>, `2020` <chr>, `2021` <chr>,
## # `2022` <chr>, `2023` <chr>, `2024` <chr>
2. Filter Data Malaysia & Reshape ke Format Deret Waktu
cols_lower <- tolower(names(df_raw))
col_country <- names(df_raw)[which(grepl("country|negara", cols_lower))[1]]
if (is.na(col_country)) {
stop("Kolom nama negara tidak ditemukan. Periksa nama kolom pada bagian 1.")
}
df_my <- df_raw %>%
filter(tolower(trimws(as.character(.data[[col_country]]))) == "malaysia")
if (nrow(df_my) == 0) {
stop("Data 'Malaysia' tidak ditemukan pada kolom negara.")
}
# Deteksi format WIDE (kolom tahun 4 digit 1950-2100) atau LONG
tahun_cols <- names(df_my)[grepl("^(19[5-9][0-9]|20[0-9]{2}|2100)$", trimws(names(df_my)))]
if (length(tahun_cols) > 1) {
df_long <- df_my %>%
mutate(across(all_of(tahun_cols), ~ suppressWarnings(as.numeric(.)))) %>%
pivot_longer(
cols = all_of(tahun_cols),
names_to = "tahun",
values_to = "nilai"
) %>%
mutate(tahun = as.integer(tahun))
} else {
col_year <- names(df_my)[which(grepl("^year$|^tahun$\vert{}^date$", cols_lower))[1]]
col_val <- names(df_my)[which(grepl("^value$\vert{}^nilai$", cols_lower))[1]]
df_long <- df_my %>%
rename(tahun = all_of(col_year), nilai = all_of(col_val)) %>%
mutate(
tahun = suppressWarnings(as.integer(tahun)),
nilai = suppressWarnings(as.numeric(nilai))
)
}
# Deteksi kolom indikator jika tersedia
col_indikator <- names(df_long)[which(grepl("indicator|series|indikator|variabel", tolower(names(df_long))))[1]]
if (!is.na(col_indikator)) {
daftar_ind <- unique(na.omit(df_long[[col_indikator]]))
cat("Indikator tersedia untuk Malaysia:\n")
for (i in seq_along(daftar_ind)) {
cat(sprintf(" [%d] %s\n", i, daftar_ind[i]))
}
# Pilih indikator pertama secara default (ubah angka [1] sesuai kebutuhan)
ind_terpilih <- daftar_ind[1]
cat("\nMenggunakan indikator:", ind_terpilih, "\n")
ts_df <- df_long %>% filter(.data[[col_indikator]] == ind_terpilih)
} else {
ts_df <- df_long
}
## Indikator tersedia untuk Malaysia:
## [1] Official exchange rate (LCU per US$, period average)
## [2] Employment in industry (% of total employment) (modeled ILO estimate)
## [3] Fertility rate, total (births per woman)
## [4] Electric power consumption (kWh per capita)
##
## Menggunakan indikator: Official exchange rate (LCU per US$, period average)
ts_clean <- ts_df %>%
filter(!is.na(tahun), !is.na(nilai)) %>%
distinct(tahun, .keep_all = TRUE) %>%
arrange(tahun)
ts_my <- ts(
ts_clean$nilai,
start = min(ts_clean$tahun),
frequency = 1
)
cat("Periode:", min(ts_clean$tahun), "-", max(ts_clean$tahun),
"| Jumlah observasi:", length(ts_my), "\n")
## Periode: 2000 - 2024 | Jumlah observasi: 25
autoplot(ts_my) + ggtitle("Data Deret Waktu Malaysia")

3. Uji Stasioneritas (ADF Test) & Plot ACF/PACF
adf_asli <- adf.test(na.omit(ts_my))
cat(sprintf("ADF Data Asli -> Stat: %.4f | p-value: %.4f\n",
adf_asli$statistic, adf_asli$p.value))
## ADF Data Asli -> Stat: -1.6469 | p-value: 0.7069
ts_diff <- diff(ts_my)
adf_diff <- adf.test(na.omit(ts_diff))
cat(sprintf("ADF First Difference -> Stat: %.4f | p-value: %.4f\n",
adf_diff$statistic, adf_diff$p.value))
## ADF First Difference -> Stat: -2.5182 | p-value: 0.3750
par(mfrow = c(1, 2))
acf(na.omit(ts_diff), main = "ACF (First Difference)")
pacf(na.omit(ts_diff), main = "PACF (First Difference)")

par(mfrow = c(1, 1))
4. Model AR, MA, ARMA, ARIMA & ETS
n_diff <- length(ts_diff)
split_diff <- max(1, floor(0.8 * n_diff))
train_diff <- window(ts_diff, end = time(ts_diff)[split_diff])
test_diff <- window(ts_diff, start = time(ts_diff)[min(n_diff, split_diff + 1)])
h_diff <- length(test_diff)
# A. AR(1) pada data stasioner
fit_ar <- Arima(train_diff, order = c(1, 0, 0))
cat("=== AR(1) ===\n")
## === AR(1) ===
print(summary(fit_ar))
## Series: train_diff
## ARIMA(1,0,0) with non-zero mean
##
## Coefficients:
## ar1 mean
## 0.2656 0.0193
## s.e. 0.2151 0.0608
##
## sigma^2 = 0.04392: log likelihood = 3.75
## AIC=-1.5 AICc=0.1 BIC=1.33
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE ACF1
## Training set 0.0003058861 0.1982322 0.1338067 -Inf Inf 0.7192558 0.01574186
if (h_diff > 0) print(accuracy(forecast(fit_ar, h = h_diff), test_diff))
## ME RMSE MAE MPE MAPE MASE
## Training set 0.0003058861 0.1982322 0.13380670 -Inf Inf 0.7192558
## Test set 0.0611003216 0.1290790 0.09684925 65.76838 74.99421 0.5205972
## ACF1 Theil's U
## Training set 0.01574186 NA
## Test set -0.16682946 0.7354549
# B. MA(1) pada data stasioner
fit_ma <- Arima(train_diff, order = c(0, 0, 1))
cat("\n=== MA(1) ===\n")
##
## === MA(1) ===
print(summary(fit_ma))
## Series: train_diff
## ARIMA(0,0,1) with non-zero mean
##
## Coefficients:
## ma1 mean
## 0.2389 0.0199
## s.e. 0.1969 0.0561
##
## sigma^2 = 0.04428: log likelihood = 3.68
## AIC=-1.36 AICc=0.24 BIC=1.47
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE ACF1
## Training set 0.0001827338 0.199054 0.1358341 -Inf Inf 0.730154 0.04123909
if (h_diff > 0) print(accuracy(forecast(fit_ma, h = h_diff), test_diff))
## ME RMSE MAE MPE MAPE MASE
## Training set 0.0001827338 0.1990540 0.13583414 -Inf Inf 0.7301540
## Test set 0.0591901106 0.1284897 0.09282914 58.23834 68.49966 0.4989877
## ACF1 Theil's U
## Training set 0.04123909 NA
## Test set -0.11821013 0.7332541
# C. ARMA(1, 1) pada data stasioner
fit_arma <- Arima(train_diff, order = c(1, 0, 1))
cat("\n=== ARMA(1, 1) ===\n")
##
## === ARMA(1, 1) ===
print(summary(fit_arma))
## Series: train_diff
## ARIMA(1,0,1) with non-zero mean
##
## Coefficients:
## ar1 ma1 mean
## 0.2544 0.0131 0.0195
## s.e. 0.6342 0.6509 0.0608
##
## sigma^2 = 0.04666: log likelihood = 3.75
## AIC=0.5 AICc=3.35 BIC=4.27
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE ACF1
## Training set 0.0002462611 0.1982267 0.1337559 -Inf Inf 0.718983 0.01378772
if (h_diff > 0) print(accuracy(forecast(fit_arma, h = h_diff), test_diff))
## ME RMSE MAE MPE MAPE MASE
## Training set 0.0002462611 0.1982267 0.1337559 -Inf Inf 0.7189830
## Test set 0.0607539858 0.1290176 0.0966171 65.2324 74.76829 0.5193493
## ACF1 Theil's U
## Training set 0.01378772 NA
## Test set -0.16361387 0.7354036
# D. ARIMA(1, 1, 1), Auto ARIMA & ETS pada data asli
n_raw <- length(ts_my)
split_raw <- max(1, floor(0.8 * n_raw))
train_raw <- window(ts_my, end = time(ts_my)[split_raw])
test_raw <- window(ts_my, start = time(ts_my)[min(n_raw, split_raw + 1)])
h_raw <- length(test_raw)
fit_arima <- Arima(train_raw, order = c(1, 1, 1))
fit_auto <- auto.arima(train_raw, seasonal = FALSE)
fit_ets <- ets(train_raw)
cat("\n=== ARIMA(1, 1, 1) ===\n")
##
## === ARIMA(1, 1, 1) ===
print(summary(fit_arima))
## Series: train_raw
## ARIMA(1,1,1)
##
## Coefficients:
## ar1 ma1
## 0.2737 -0.0041
## s.e. 0.6298 0.6508
##
## sigma^2 = 0.04415: log likelihood = 3.7
## AIC=-1.4 AICc=0.2 BIC=1.43
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE
## Training set 0.01411611 0.1937137 0.1247737 0.265075 3.428757 0.8682533
## ACF1
## Training set 0.01195365
cat("\n=== AUTO ARIMA ===\n")
##
## === AUTO ARIMA ===
print(summary(fit_auto))
## Series: train_raw
## ARIMA(1,0,0) with non-zero mean
##
## Coefficients:
## ar1 mean
## 0.8381 3.7622
## s.e. 0.1095 0.2286
##
## sigma^2 = 0.04327: log likelihood = 3.47
## AIC=-0.94 AICc=0.56 BIC=2.04
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE
## Training set -0.002444126 0.1973388 0.1397842 -0.3981049 3.849861 0.9727062
## ACF1
## Training set 0.3442192
cat("\n=== ETS ===\n")
##
## === ETS ===
print(summary(fit_ets))
## ETS(A,N,N)
##
## Call:
## ets(y = train_raw)
##
## Smoothing parameters:
## alpha = 0.9999
##
## Initial states:
## l = 3.7999
##
## sigma: 0.2128
##
## AIC AICc BIC
## 1.915813 3.415813 4.903010
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE
## Training set 0.01712785 0.2019024 0.1365288 0.2782697 3.738356 0.950053
## ACF1
## Training set 0.2769844
if (h_raw > 0) {
fc_auto <- forecast(fit_auto, h = h_raw)
print(accuracy(fc_auto, test_raw))
autoplot(fc_auto) +
autolayer(test_raw, series = "Aktual (Test)") +
ggtitle("Prakiraan Auto ARIMA vs Data Aktual Malaysia")
}
## ME RMSE MAE MPE MAPE MASE
## Training set -0.002444126 0.1973388 0.1397842 -0.3981049 3.849861 0.9727062
## Test set 0.383880316 0.4483295 0.3838803 8.5693308 8.569331 2.6712793
## ACF1 Theil's U
## Training set 0.3442192 NA
## Test set 0.4890906 3.066077

5. Model VAR (Opsional, Jika Paket vars Tersedia)
if (requireNamespace("vars", quietly = TRUE) && !is.na(col_indikator) && length(daftar_ind) >= 2) {
ind_var <- daftar_ind[1:2]
cat("Menjalankan VAR untuk:", paste(ind_var, collapse = " & "), "\n")
df_var <- df_long %>%
filter(.data[[col_indikator]] %in% ind_var, !is.na(tahun), !is.na(nilai)) %>%
select(tahun, all_of(col_indikator), nilai) %>%
pivot_wider(names_from = all_of(col_indikator), values_from = nilai) %>%
arrange(tahun) %>%
drop_na()
if (nrow(df_var) >= 8) {
var_diff <- df_var %>%
select(-tahun) %>%
mutate(across(everything(), ~ c(NA, diff(.)))) %>%
drop_na()
lag_opt <- max(1, vars::VARselect(var_diff, lag.max = 2, type = "const")$selection[["AIC(n)"]])
fit_var <- vars::VAR(var_diff, p = lag_opt, type = "const")
cat("Lag VAR terpilih (AIC):", lag_opt, "\n")
print(predict(fit_var, n.ahead = 3))
} else {
cat("Jumlah observasi bersama belum cukup untuk VAR.\n")
}
} else {
cat("Paket 'vars' belum terinstal atau indikator kurang dari 2; bagian VAR dilewati.\n")
}
## Paket 'vars' belum terinstal atau indikator kurang dari 2; bagian VAR dilewati.