# =====================================================================
# Analisis Time Series Indonesia: AR, MA, ARMA, ARIMA (+ diagnostik & forecast)
# Data: Data_Panel_WDI.xlsx
# =====================================================================

# install.packages(c("readxl", "dplyr", "tseries", "forecast", "lmtest", "FinTS"))
library(readxl)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(tseries)
## Warning: package 'tseries' was built under R version 4.6.2
## Registered S3 method overwritten by 'quantmod':
##   method            from
##   as.zoo.data.frame zoo
library(forecast)
## Warning: package 'forecast' was built under R version 4.6.2
library(lmtest)
## Loading required package: zoo
## 
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
## 
##     as.Date, as.Date.numeric
# ===== 1. Import data =====
path <- "C:/Users/ADVAN/OneDrive/Dokumen/Data_Panel_WDI.xlsx"
data <- read_excel(path)                  # tambahkan sheet = "NamaSheet" jika perlu
names(data) <- make.names(names(data))    # "Country Name" -> Country.Name

print(names(data))
## [1] "Negara"                    "Kode"                     
## [3] "Tahun"                     "Y_Kemiskinan"             
## [5] "X1_Melek_Huruf"            "X2_TPT"                   
## [7] "X3_PDRB_per_kapita"        "X4_Pengeluaran_Pemerintah"
head(data)
## # A tibble: 6 × 8
##   Negara    Kode  Tahun Y_Kemiskinan X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
##   <chr>     <chr> <dbl>        <dbl>          <dbl>  <dbl>              <dbl>
## 1 Australia AUS    2000           NA             NA   6.29              2.73 
## 2 Australia AUS    2001           NA             NA   6.75              0.730
## 3 Australia AUS    2002           NA             NA   6.38              2.77 
## 4 Australia AUS    2003           NA             NA   5.93              1.91 
## 5 Australia AUS    2004           NA             NA   5.40              3.11 
## 6 Australia AUS    2005           NA             NA   5.04              1.91 
## # ℹ 1 more variable: X4_Pengeluaran_Pemerintah <dbl>
# ===== 2. Deteksi kolom negara & tahun =====
# Jika salah deteksi, isi manual, contoh: id_col <- "Country.Name"
id_col   <- names(data)[grep("country|negara|economy", names(data), ignore.case = TRUE)][1]
time_col <- names(data)[grep("year|tahun|time", names(data), ignore.case = TRUE)][1]
cat("Kolom negara:", id_col, "| Kolom waktu:", time_col, "\n")
## Kolom negara: Negara | Kolom waktu: Tahun
# ===== 3. Filter Indonesia =====
idn <- data[grepl("indonesia|^IDN$", data[[id_col]], ignore.case = TRUE), ]
idn[[time_col]] <- as.numeric(as.character(idn[[time_col]]))
idn <- idn[order(idn[[time_col]]), ]
cat("Jumlah observasi Indonesia:", nrow(idn), "\n")
## Jumlah observasi Indonesia: 26
# ===== 4. Pilih variabel yang dianalisis =====
num_vars <- setdiff(names(idn)[sapply(idn, is.numeric)], time_col)
print(num_vars)
## [1] "Y_Kemiskinan"              "X1_Melek_Huruf"           
## [3] "X2_TPT"                    "X3_PDRB_per_kapita"       
## [5] "X4_Pengeluaran_Pemerintah"
# GANTI dengan variabel Anda, contoh: var_name <- "GDP.growth"
var_name <- num_vars[1]
cat("Variabel dianalisis:", var_name, "\n")
## Variabel dianalisis: Y_Kemiskinan
# Hapus NA di awal/akhir, lalu buat objek time series (data tahunan)
idn_clean <- idn[!is.na(idn[[var_name]]), c(time_col, var_name)]
y <- ts(idn_clean[[var_name]], start = min(idn_clean[[time_col]]), frequency = 1)

plot(y, main = paste("Indonesia -", var_name), ylab = var_name, xlab = "Tahun")

# ===== 5. Uji stasioneritas & penentuan orde diferensiasi =====
adf.test(y)                    # H0: tidak stasioner (p < 0.05 -> stasioner)
## 
##  Augmented Dickey-Fuller Test
## 
## data:  y
## Dickey-Fuller = -1.4711, Lag order = 2, p-value = 0.7739
## alternative hypothesis: stationary
kpss.test(y)                   # H0: stasioner      (p > 0.05 -> stasioner)
## Warning in kpss.test(y): p-value smaller than printed p-value
## 
##  KPSS Test for Level Stationarity
## 
## data:  y
## KPSS Level = 0.9315, Truncation lag parameter = 2, p-value = 0.01
d <- ndiffs(y, test = "adf")   # jumlah diferensiasi yang disarankan
cat("Orde diferensiasi (d) disarankan:", d, "\n")
## Orde diferensiasi (d) disarankan: 1
y_d <- if (d > 0) diff(y, differences = d) else y
if (d > 0) {
  plot(y_d, main = paste("Setelah differencing d =", d))
  print(adf.test(y_d))
}

## 
##  Augmented Dickey-Fuller Test
## 
## data:  y_d
## Dickey-Fuller = -3.2526, Lag order = 2, p-value = 0.09825
## alternative hypothesis: stationary
# ===== 6. ACF & PACF (identifikasi orde p dan q) =====
par(mfrow = c(1, 2))
acf(y_d,  main = "ACF")        # petunjuk orde MA (q)
pacf(y_d, main = "PACF")       # petunjuk orde AR (p)

par(mfrow = c(1, 1))

# ===== 7. Estimasi model =====
# GANTI orde p dan q sesuai pola ACF/PACF
p <- 1
q <- 1

m_ar    <- Arima(y, order = c(p, 0, 0))   # AR(p)   (asumsi y sudah stasioner)
m_ma    <- Arima(y, order = c(0, 0, q))   # MA(q)
m_arma  <- Arima(y, order = c(p, 0, q))   # ARMA(p,q)
m_arima <- Arima(y, order = c(p, d, q))   # ARIMA(p,d,q)
m_auto  <- auto.arima(y, ic = "aic", stepwise = FALSE, approximation = FALSE)

print(m_ar); print(m_ma); print(m_arma); print(m_arima); print(m_auto)
## Series: y 
## ARIMA(1,0,0) with non-zero mean 
## 
## Coefficients:
##          ar1     mean
##       0.9887  13.6986
## s.e.  0.0154   4.6230
## 
## sigma^2 = 0.5964:  log likelihood = -31.03
## AIC=68.06   AICc=69.15   BIC=71.83
## Series: y 
## ARIMA(0,0,1) with non-zero mean 
## 
## Coefficients:
##          ma1     mean
##       0.8840  13.0825
## s.e.  0.1094   0.7345
## 
## sigma^2 = 4.432:  log likelihood = -55.97
## AIC=117.93   AICc=119.02   BIC=121.71
## Series: y 
## ARIMA(1,0,1) with non-zero mean 
## 
## Coefficients:
##          ar1     ma1     mean
##       0.9839  0.2309  13.6914
## s.e.  0.0218  0.1654   4.4936
## 
## sigma^2 = 0.5785:  log likelihood = -30.14
## AIC=68.28   AICc=70.18   BIC=73.31
## Series: y 
## ARIMA(1,1,1) 
## 
## Coefficients:
##          ar1      ma1
##       0.9991  -0.9720
## s.e.  0.0127   0.1854
## 
## sigma^2 = 0.4319:  log likelihood = -24.86
## AIC=55.72   AICc=56.86   BIC=59.38
## Series: y 
## ARIMA(0,1,0) with drift 
## 
## Coefficients:
##        drift
##       -0.424
## s.e.   0.122
## 
## sigma^2 = 0.3877:  log likelihood = -23.12
## AIC=50.24   AICc=50.79   BIC=52.68
# Uji signifikansi koefisien
coeftest(m_arima)
## 
## z test of coefficients:
## 
##      Estimate Std. Error z value  Pr(>|z|)    
## ar1  0.999057   0.012659  78.919 < 2.2e-16 ***
## ma1 -0.972025   0.185360  -5.244 1.572e-07 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
# ===== 8. Perbandingan model =====
perbandingan <- data.frame(
  Model = c(paste0("AR(", p, ")"), paste0("MA(", q, ")"),
            paste0("ARMA(", p, ",", q, ")"),
            paste0("ARIMA(", p, ",", d, ",", q, ")"),
            paste0("auto.arima ", paste(arimaorder(m_auto), collapse = ","))),
  AIC  = c(AIC(m_ar), AIC(m_ma), AIC(m_arma), AIC(m_arima), AIC(m_auto)),
  BIC  = c(BIC(m_ar), BIC(m_ma), BIC(m_arma), BIC(m_arima), BIC(m_auto))
)
print(perbandingan[order(perbandingan$AIC), ])
##              Model       AIC       BIC
## 5 auto.arima 0,1,0  50.24044  52.67819
## 4     ARIMA(1,1,1)  55.71880  59.37542
## 1            AR(1)  68.05843  71.83272
## 3        ARMA(1,1)  68.27608  73.30847
## 2            MA(1) 117.93391 121.70820
# Akurasi in-sample
accuracy(m_ar); accuracy(m_ma); accuracy(m_arma); accuracy(m_arima); accuracy(m_auto)
##                      ME      RMSE       MAE       MPE     MAPE     MASE
## Training set -0.3819282 0.7419881 0.6314973 -3.201089 4.787475 1.012015
##                    ACF1
## Training set -0.0418511
##                       ME     RMSE     MAE       MPE    MAPE     MASE      ACF1
## Training set -0.09249296 2.022671 1.74766 -4.477379 13.9841 2.800737 0.5828186
##                      ME      RMSE       MAE     MPE     MAPE      MASE
## Training set -0.3109377 0.7153592 0.5653187 -2.6372 4.230794 0.9059595
##                    ACF1
## Training set -0.2408096
##                       ME      RMSE       MAE         MPE     MAPE      MASE
## Training set -0.04074388 0.6181404 0.4308821 -0.08168673 3.204791 0.6905162
##                    ACF1
## Training set 0.01578895
##                        ME      RMSE      MAE       MPE     MAPE      MASE
## Training set 0.0007509227 0.5982661 0.405674 0.1490576 3.038649 0.6501186
##                      ACF1
## Training set -0.003312096
# ===== 9. Diagnostik residual (model terpilih) =====
model_terpilih <- m_arima        # GANTI jika model lain lebih baik
res <- residuals(model_terpilih)

checkresiduals(model_terpilih)                 # plot + Ljung-Box

## 
##  Ljung-Box test
## 
## data:  Residuals from ARIMA(1,1,1)
## Q* = 1.3999, df = 3, p-value = 0.7056
## 
## Model df: 2.   Total lags used: 5
Box.test(res, lag = 10, type = "Ljung-Box")    # H0: residual white noise (p > 0.05 baik)
## 
##  Box-Ljung test
## 
## data:  res
## X-squared = 2.528, df = 10, p-value = 0.9905
shapiro.test(res)                              # H0: residual normal
## 
##  Shapiro-Wilk normality test
## 
## data:  res
## W = 0.8912, p-value = 0.01001
jarque.bera.test(res)                          # H0: residual normal
## 
##  Jarque Bera Test
## 
## data:  res
## X-squared = 22.214, df = 2, p-value = 1.5e-05
# Uji efek ARCH (heteroskedastisitas bersyarat)
if (requireNamespace("FinTS", quietly = TRUE)) {
  print(FinTS::ArchTest(res, lags = 4))
}

# ===== 10. Peramalan =====
h <- 5                                         # jumlah tahun ke depan
fc <- forecast(model_terpilih, h = h)
print(fc)
##      Point Forecast    Lo 80    Hi 80    Lo 95    Hi 95
## 2026       8.122654 7.274172 8.971136 6.825012 9.420295
## 2027       7.745663 6.521035 8.970292 5.872755 9.618571
## 2028       7.369028 5.839218 8.898839 5.029385 9.708672
## 2029       6.992749 5.192007 8.793491 4.238752 9.746747
## 2030       6.616825 4.565555 8.668094 3.479679 9.753970
plot(fc, main = paste("Forecast", var_name, "Indonesia"))

# ===== 11. Simpan hasil =====
write.csv(as.data.frame(fc), "forecast_indonesia.csv")