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|

## 
## 
## ---