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.