title: “tugas ARIMA”
author: “Archyn Tiku Allo (240611010042)”
date: “2026-11-19”
output: html_document
# 1. Muat Library
library(readxl)
library(dplyr)
library(tidyr)
library(tseries)
library(forecast)
library(ggplot2)
library(knitr)
# 2. Baca Data Excel dengan Pengaman Path & OneDrive
nama_file <- "Data Aplikasi Statistika Tugas Individu.xlsx"
path_onedrive <- "C:/Users/Asus/OneDrive/Documents/Data Aplikasi Statistika Tugas Individu.xlsx"
if (file.exists(nama_file)) {
file_path <- nama_file
} else if (file.exists(path_onedrive)) {
file_path <- path_onedrive
} else {
file_path <- file.choose()
}
temp_xlsx <- tempfile(fileext = ".xlsx")
berhasil_salin <- file.copy(file_path, temp_xlsx, overwrite = TRUE)
if (!berhasil_salin) {
stop("File Excel tidak bisa dibaca. Pastikan Microsoft Excel sudah DITUTUP dan file OneDrive sudah terunduh (centang hijau).")
}
raw_df <- read_excel(temp_xlsx, sheet = 1, col_names = FALSE)
# 3. Deteksi Otomatis Posisi Tahun (2001-2025) & Blok Data Singapura
baris_tahun <- which(apply(raw_df, 1, function(r) any(suppressWarnings(as.numeric(r)) == 2001, na.rm = TRUE)))[1]
kolom_tahun <- which(!is.na(suppressWarnings(as.numeric(raw_df[baris_tahun, ]))) &
suppressWarnings(as.numeric(raw_df[baris_tahun, ])) >= 2000)
tahun_vec <- as.numeric(unlist(raw_df[baris_tahun, kolom_tahun]))
kolom_indikator <- min(kolom_tahun) - 1
# Cari baris awal "Singapura" (mencakup 4 baris indikator ke bawah)
baris_sg <- which(apply(raw_df, 1, function(r) any(grepl("singap", as.character(r), ignore.case = TRUE), na.rm = TRUE)))[1]
sg_raw <- raw_df[baris_sg:(baris_sg + 3), c(kolom_indikator, kolom_tahun)]
colnames(sg_raw) <- c("Indikator", as.character(tahun_vec))
# Seragamkan tipe data semua kolom tahun menjadi numeric sebelum pivot_longer()
df_sg_long <- sg_raw %>%
mutate(
Indikator = as.character(Indikator),
across(-Indikator, ~ suppressWarnings(as.numeric(as.character(.))))
) %>%
pivot_longer(
cols = -Indikator,
names_to = "Tahun",
values_to = "Nilai"
) %>%
mutate(Tahun = as.numeric(Tahun)) %>%
arrange(Indikator, Tahun)
daftar_indikator <- unique(df_sg_long$Indikator)
# 4. Loop Analisis Lengkap untuk Setiap Indikator Singapura
for (ind in daftar_indikator) {
cat("\n\n## Indikator Singapura:", ind, "\n\n")
sub_data <- df_sg_long %>% filter(Indikator == ind)
ts_data <- ts(sub_data$Nilai, start = min(sub_data$Tahun), frequency = 1)
ts_diff1 <- diff(ts_data, differences = 1)
# A. Plot Data Historis (2001 - 2025)
p_hist <- autoplot(ts_data) +
geom_point(color = "#1f77b4", size = 2) +
ggtitle(paste("Data Historis Singapura (2001-2025):", ind)) +
xlab("Tahun") +
ylab(ind) +
scale_x_continuous(breaks = seq(2001, 2025, by = 3)) +
theme_minimal(base_size = 12)
print(p_hist)
cat("\n\n")
# B. Uji Stasioneritas (ADF Test)
adf_lvl <- adf.test(ts_data)
adf_d1 <- adf.test(ts_diff1)
tabel_adf <- data.frame(
Tingkat_Data = c("Level (Asli, d=0)", "First Difference (d=1)"),
ADF_Statistic = c(adf_lvl$statistic, adf_d1$statistic),
p_value = c(adf_lvl$p.value, adf_d1$p.value),
Kesimpulan = c(
ifelse(adf_lvl$p.value <= 0.05, "Stasioner", "Tidak Stasioner"),
ifelse(adf_d1$p.value <= 0.05, "Stasioner", "Tidak Stasioner")
)
)
print(kable(tabel_adf, digits = 4, row.names = FALSE, caption = "Hasil Uji Stasioneritas (ADF Test)"))
cat("\n\n")
# C. Plot ACF dan PACF
p_acf <- ggAcf(ts_diff1) + ggtitle("ACF (Differencing ke-1)") + theme_minimal()
p_pacf <- ggPacf(ts_diff1) + ggtitle("PACF (Differencing ke-1)") + theme_minimal()
print(p_acf)
cat("\n\n")
print(p_pacf)
cat("\n\n")
# D. Estimasi Model AR, MA, ARMA, ARIMA, dan Auto-ARIMA
model_ar <- Arima(ts_data, order = c(1, 0, 0))
model_ma <- Arima(ts_data, order = c(0, 0, 1))
model_arma <- Arima(ts_data, order = c(1, 0, 1))
model_arima <- Arima(ts_data, order = c(1, 1, 1), include.drift = TRUE)
model_auto <- auto.arima(ts_data, seasonal = FALSE, stepwise = FALSE, approximation = FALSE)
perbandingan <- data.frame(
Model = c("AR(1)", "MA(1)", "ARMA(1,1)", "ARIMA(1,1,1) + Drift", "Auto ARIMA"),
Orde = c("(1,0,0)", "(0,0,1)", "(1,0,1)", "(1,1,1)",
paste0("(", paste(arimaorder(model_auto), collapse = ","), ")")),
AIC = c(AIC(model_ar), AIC(model_ma), AIC(model_arma), AIC(model_arima), AIC(model_auto)),
BIC = c(BIC(model_ar), BIC(model_ma), BIC(model_arma), BIC(model_arima), BIC(model_auto))
)
print(kable(perbandingan, digits = 4, caption = "Perbandingan Nilai AIC dan BIC Antar Model"))
cat("\n\n")
# E. Peramalan (Forecasting) 5 Tahun ke Depan (2026 - 2030)
fc_auto <- forecast(model_auto, h = 5)
fc_arima <- forecast(model_arima, h = 5)
tabel_fc <- data.frame(
Tahun = 2026:2030,
Prediksi_Auto_ARIMA = as.numeric(fc_auto$mean),
Batas_Bawah_95 = as.numeric(fc_auto$lower[, 2]),
Batas_Atas_95 = as.numeric(fc_auto$upper[, 2]),
Prediksi_ARIMA_111_Drift = as.numeric(fc_arima$mean)
)
print(kable(tabel_fc, digits = 4, caption = "Hasil Peramalan (Forecast) Tahun 2026 - 2030"))
cat("\n\n")
# F. Grafik Kurva Peramalan (Auto-ARIMA + Pita Kepercayaan + Kurva Tren ARIMA(1,1,1))
df_kurva_arima <- data.frame(
Tahun = 2025:2030,
Nilai = c(tail(as.numeric(ts_data), 1), as.numeric(fc_arima$mean)),
Model = "ARIMA(1,1,1) + Drift"
)
p_fc <- autoplot(fc_auto) +
geom_point(data = sub_data, aes(x = Tahun, y = Nilai), color = "black", size = 2) +
geom_line(data = df_kurva_arima, aes(x = Tahun, y = Nilai), color = "#d62728", linetype = "dashed", linewidth = 1) +
geom_point(data = df_kurva_arima[-1, ], aes(x = Tahun, y = Nilai), color = "#d62728", size = 2.5) +
ggtitle(paste("Kurva Peramalan 2026-2030 Singapura:", ind)) +
labs(subtitle = "Garis Biru = Auto ARIMA | Garis Merah Putus-putus = ARIMA(1,1,1) + Drift | Area Bayangan = CI 80% & 95%") +
xlab("Tahun") +
ylab(ind) +
scale_x_continuous(breaks = seq(2001, 2030, by = 3)) +
theme_minimal(base_size = 12)
print(p_fc)
cat("\n\n---\n\n")
}
##
##
## ## Indikator Singapura: Exports of goods and services (% of GDP)
##
##
##
##
## Table: Hasil Uji Stasioneritas (ADF Test)
##
## |Tingkat_Data | ADF_Statistic| p_value|Kesimpulan |
## |:----------------------|-------------:|-------:|:---------------|
## |Level (Asli, d=0) | -2.8370| 0.2535|Tidak Stasioner |
## |First Difference (d=1) | -2.4184| 0.4130|Tidak Stasioner |
##
##
##
##
## Table: Perbandingan Nilai AIC dan BIC Antar Model
##
## |Model |Orde | AIC| BIC|
## |:--------------------|:-------|--------:|--------:|
## |AR(1) |(1,0,0) | 197.4465| 201.1031|
## |MA(1) |(0,0,1) | 207.7184| 211.3750|
## |ARMA(1,1) |(1,0,1) | 199.3243| 204.1998|
## |ARIMA(1,1,1) + Drift |(1,1,1) | 193.2526| 197.9648|
## |Auto ARIMA |(0,1,0) | 188.1780| 189.3561|
##
##
##
##
## Table: Hasil Peramalan (Forecast) Tahun 2026 - 2030
##
## | Tahun| Prediksi_Auto_ARIMA| Batas_Bawah_95| Batas_Atas_95| Prediksi_ARIMA_111_Drift|
## |-----:|-------------------:|--------------:|-------------:|------------------------:|
## | 2026| 177.8515| 154.9156| 200.7873| 176.8551|
## | 2027| 177.8515| 145.4153| 210.2877| 176.9295|
## | 2028| 177.8515| 138.1254| 217.5776| 176.5926|
## | 2029| 177.8515| 131.9798| 223.7232| 176.4136|
## | 2030| 177.8515| 126.5653| 229.1376| 176.1740|
##
##
## ---
##
##
##
## ## Indikator Singapura: GDP growth (annual %)
##
##
## Table: Hasil Uji Stasioneritas (ADF Test)
##
## |Tingkat_Data | ADF_Statistic| p_value|Kesimpulan |
## |:----------------------|-------------:|-------:|:----------|
## |Level (Asli, d=0) | -3.9265| 0.0267|Stasioner |
## |First Difference (d=1) | -4.5084| 0.0100|Stasioner |
##
##
##
##
## Table: Perbandingan Nilai AIC dan BIC Antar Model
##
## |Model |Orde | AIC| BIC|
## |:--------------------|:-------|--------:|--------:|
## |AR(1) |(1,0,0) | 143.8101| 147.4667|
## |MA(1) |(0,0,1) | 143.8039| 147.4606|
## |ARMA(1,1) |(1,0,1) | 145.4819| 150.3574|
## |ARIMA(1,1,1) + Drift |(1,1,1) | 143.7093| 148.4215|
## |Auto ARIMA |(0,0,0) | 141.8227| 144.2604|
##
##
##
##
## Table: Hasil Peramalan (Forecast) Tahun 2026 - 2030
##
## | Tahun| Prediksi_Auto_ARIMA| Batas_Bawah_95| Batas_Atas_95| Prediksi_ARIMA_111_Drift|
## |-----:|-------------------:|--------------:|-------------:|------------------------:|
## | 2026| 4.6628| -2.9578| 12.2834| 3.4291|
## | 2027| 4.6628| -2.9578| 12.2834| 3.3282|
## | 2028| 4.6628| -2.9578| 12.2834| 3.2330|
## | 2029| 4.6628| -2.9578| 12.2834| 3.1377|
## | 2030| 4.6628| -2.9578| 12.2834| 3.0424|
##
##
## ---
##
##
##
## ## Indikator Singapura: GDP per capita (constant 2015 US$)
##
##
##
##
## Table: Hasil Uji Stasioneritas (ADF Test)
##
## |Tingkat_Data | ADF_Statistic| p_value|Kesimpulan |
## |:----------------------|-------------:|-------:|:----------|
## |Level (Asli, d=0) | -3.8713| 0.0306|Stasioner |
## |First Difference (d=1) | -4.2037| 0.0162|Stasioner |
##
##
##
##
## Table: Perbandingan Nilai AIC dan BIC Antar Model
##
## |Model |Orde | AIC| BIC|
## |:--------------------|:-------|--------:|--------:|
## |AR(1) |(1,0,0) | 476.3565| 480.0132|
## |MA(1) |(0,0,1) | 516.1007| 519.7573|
## |ARMA(1,1) |(1,0,1) | 477.4778| 482.3533|
## |ARIMA(1,1,1) + Drift |(1,1,1) | 435.3133| 440.0255|
## |Auto ARIMA |(2,1,0) | 437.4181| 442.1304|
##
##
##
##
## Table: Hasil Peramalan (Forecast) Tahun 2026 - 2030
##
## | Tahun| Prediksi_Auto_ARIMA| Batas_Bawah_95| Batas_Atas_95| Prediksi_ARIMA_111_Drift|
## |-----:|-------------------:|--------------:|-------------:|------------------------:|
## | 2026| 71536.99| 67699.82| 75374.17| 72237.05|
## | 2027| 72730.63| 68099.42| 77361.83| 73744.33|
## | 2028| 74709.08| 69976.00| 79442.16| 75246.22|
## | 2029| 76253.95| 71053.11| 81454.79| 76747.47|
## | 2030| 77526.30| 71700.92| 83351.68| 78248.66|
##
##
## ---
##
##
##
## ## Indikator Singapura: Trade (% of GDP)
##
##
##
##
## Table: Hasil Uji Stasioneritas (ADF Test)
##
## |Tingkat_Data | ADF_Statistic| p_value|Kesimpulan |
## |:----------------------|-------------:|-------:|:---------------|
## |Level (Asli, d=0) | -3.0499| 0.1724|Tidak Stasioner |
## |First Difference (d=1) | -2.4756| 0.3912|Tidak Stasioner |
##
##
##
##
## Table: Perbandingan Nilai AIC dan BIC Antar Model
##
## |Model |Orde | AIC| BIC|
## |:--------------------|:-------|--------:|--------:|
## |AR(1) |(1,0,0) | 233.0281| 236.6847|
## |MA(1) |(0,0,1) | 244.8521| 248.5088|
## |ARMA(1,1) |(1,0,1) | 234.3763| 239.2518|
## |ARIMA(1,1,1) + Drift |(1,1,1) | 226.0297| 230.7419|
## |Auto ARIMA |(0,1,0) | 222.1106| 223.2887|
##
##
##
##
## Table: Hasil Peramalan (Forecast) Tahun 2026 - 2030
##
## | Tahun| Prediksi_Auto_ARIMA| Batas_Bawah_95| Batas_Atas_95| Prediksi_ARIMA_111_Drift|
## |-----:|-------------------:|--------------:|-------------:|------------------------:|
## | 2026| 320.306| 273.7978| 366.8143| 316.5596|
## | 2027| 320.306| 254.5334| 386.0786| 316.2440|
## | 2028| 320.306| 239.7514| 400.8607| 314.6075|
## | 2029| 320.306| 227.2895| 413.3225| 313.4795|
## | 2030| 320.306| 216.3104| 424.3016| 312.1558|
##
##
## ---