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