# ============================================
# ANALISIS REGRESI
# ============================================

# 1. LOAD PACKAGES
library(readxl)
## Warning: package 'readxl' was built under R version 4.5.2
library(lmtest)
## Warning: package 'lmtest' was built under R version 4.5.2
## Loading required package: zoo
## Warning: package 'zoo' was built under R version 4.5.2
## 
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
## 
##     as.Date, as.Date.numeric
library(car)
## Warning: package 'car' was built under R version 4.5.2
## Loading required package: carData
## Warning: package 'carData' was built under R version 4.5.2
library(ggplot2)

# 2. LOAD DATA LANGSUNG (Pastikan file satu folder dengan file Rmd)
data <- read_excel("dataset_regresi.xlsx", sheet = "Data_200_Observasi")

# Fungsi agar angka desimal koma (11,89) terbaca benar sebagai angka di R
bersihkan_angka <- function(x) {
  if (is.character(x)) as.numeric(gsub(",", ".", x)) else as.numeric(x)
}

# Bentuk dataframe
df <- data.frame(
  Pengeluaran = bersihkan_angka(data$Pengeluaran_Konsumsi_Bulanan_Juta_Rp),
  Pendapatan  = bersihkan_angka(data$Pendapatan_Bulanan_Juta_Rp),
  Anggota_RT  = bersihkan_angka(data$Jumlah_Anggota_Rumah_Tangga),
  Pendidikan  = bersihkan_angka(data$Pendidikan_Kepala_RT_Tahun),
  Tabungan    = bersihkan_angka(data$Tabungan_Bulanan_Juta_Rp),
  Usia        = bersihkan_angka(data$Usia_Kepala_RT_Tahun)
)
# 3. STATISTIK DESKRIPTIF
cat("=== STATISTIK DESKRIPTIF ===\n")
## === STATISTIK DESKRIPTIF ===
summary(df)
##   Pengeluaran       Pendapatan       Anggota_RT     Pendidikan  
##  Min.   : 2.990   Min.   : 2.000   Min.   :1.00   Min.   : 6.0  
##  1st Qu.: 5.865   1st Qu.: 5.430   1st Qu.:2.00   1st Qu.:10.0  
##  Median : 7.500   Median : 7.665   Median :4.00   Median :12.0  
##  Mean   : 7.539   Mean   : 7.528   Mean   :3.53   Mean   :12.1  
##  3rd Qu.: 8.963   3rd Qu.: 9.428   3rd Qu.:5.00   3rd Qu.:14.0  
##  Max.   :12.100   Max.   :14.250   Max.   :6.00   Max.   :18.0  
##     Tabungan          Usia      
##  Min.   :0.050   Min.   :22.00  
##  1st Qu.:0.665   1st Qu.:37.75  
##  Median :1.160   Median :43.00  
##  Mean   :1.214   Mean   :43.99  
##  3rd Qu.:1.732   3rd Qu.:51.00  
##  Max.   :3.570   Max.   :65.00
# 4. REGRESI LINIER BERGANDA (OLS)
model <- lm(Pengeluaran ~ Pendapatan + Anggota_RT + Pendidikan + Tabungan + Usia, data = df)

cat("=== PERSAMAAN REGRESI ===\n")
## === PERSAMAAN REGRESI ===
cat("Pengeluaran =", round(coef(model)[1], 4), "+", 
    round(coef(model)[2], 4), "*Pendapatan +",
    round(coef(model)[3], 4), "*Anggota_RT +",
    round(coef(model)[4], 4), "*Pendidikan +",
    round(coef(model)[5], 4), "*Tabungan +",
    round(coef(model)[6], 4), "*Usia\n\n")
## Pengeluaran = 0.723 + 0.6024 *Pendapatan + 0.4779 *Anggota_RT + 0.078 *Pendidikan + -0.1697 *Tabungan + -0.0033 *Usia
cat("=== TABEL KOEFISIEN ===\n")
## === TABEL KOEFISIEN ===
print(summary(model)$coefficients)
##                Estimate  Std. Error    t value     Pr(>|t|)
## (Intercept)  0.72299916 0.540513892  1.3376144 1.825882e-01
## Pendapatan   0.60237024 0.028572075 21.0824812 4.500278e-52
## Anggota_RT   0.47794679 0.042161262 11.3361595 3.485569e-23
## Pendidikan   0.07799720 0.025095912  3.1079642 2.166903e-03
## Tabungan    -0.16972681 0.107243682 -1.5826276 1.151352e-01
## Usia        -0.00325683 0.007334846 -0.4440216 6.575218e-01
# 5. UJI NORMALITAS RESIDUAL
cat("\n=== UJI NORMALITAS (Shapiro-Wilk) ===\n")
## 
## === UJI NORMALITAS (Shapiro-Wilk) ===
shapiro_test <- shapiro.test(residuals(model))
cat("p-value =", shapiro_test$p.value, "\n")
## p-value = 0.8128004
if(shapiro_test$p.value > 0.05) {
  cat("Kesimpulan: Residual berdistribusi normal\n")
} else {
  cat("Kesimpulan: Residual TIDAK berdistribusi normal\n")
}
## Kesimpulan: Residual berdistribusi normal
# 6. UJI AUTOKORELASI
cat("\n=== UJI AUTOKORELASI (Durbin-Watson) ===\n")
## 
## === UJI AUTOKORELASI (Durbin-Watson) ===
dw_test <- durbinWatsonTest(model)
cat("Statistik DW =", dw_test$dw, "\n")
## Statistik DW = 2.198797
cat("p-value =", dw_test$p, "\n")
## p-value = 0.156
if(dw_test$p > 0.05) {
  cat("Kesimpulan: Tidak ada autokorelasi\n")
} else {
  cat("Kesimpulan: Ada autokorelasi\n")
}
## Kesimpulan: Tidak ada autokorelasi
# 7. UJI HETEROSKEDASTISITAS
cat("\n=== UJI HETEROSKEDASTISITAS (Breusch-Pagan) ===\n")
## 
## === UJI HETEROSKEDASTISITAS (Breusch-Pagan) ===
bp_test <- bptest(model)
cat("p-value =", bp_test$p.value, "\n")
## p-value = 0.14008
if(bp_test$p.value > 0.05) {
  cat("Kesimpulan: Tidak ada masalah heteroskedastisitas\n")
} else {
  cat("Kesimpulan: Terjadi heteroskedastisitas\n")
}
## Kesimpulan: Tidak ada masalah heteroskedastisitas
# 8. UJI MULTIKOLINEARITAS (VIF)
cat("\n=== UJI MULTIKOLINEARITAS (VIF & Tolerance) ===\n")
## 
## === UJI MULTIKOLINEARITAS (VIF & Tolerance) ===
vif_values <- vif(model)
tolerance_values <- 1 / vif_values

multicoll_table <- data.frame(
  Variabel = names(vif_values),
  VIF = round(vif_values, 3),
  Tolerance = round(tolerance_values, 3)
)
print(multicoll_table)
##              Variabel   VIF Tolerance
## Pendapatan Pendapatan 1.179     0.848
## Anggota_RT Anggota_RT 1.011     0.989
## Pendidikan Pendidikan 1.034     0.967
## Tabungan     Tabungan 1.158     0.863
## Usia             Usia 1.042     0.960
# 9. UJI SIMULTAN (UJI F)
cat("\n=== UJI F (SIMULTAN) ===\n")
## 
## === UJI F (SIMULTAN) ===
f_stat <- summary(model)$fstatistic
p_f_val <- pf(f_stat[1], f_stat[2], f_stat[3], lower.tail = FALSE)
cat("F-hitung =", round(f_stat[1], 4), "\n")
## F-hitung = 124.7523
cat("p-value  =", p_f_val, "\n")
## p-value  = 1.209223e-58
if(p_f_val < 0.05) {
  cat("Kesimpulan: Signifikan (Secara bersama-sama berpengaruh terhadap Y)\n")
} else {
  cat("Kesimpulan: Tidak signifikan\n")
}
## Kesimpulan: Signifikan (Secara bersama-sama berpengaruh terhadap Y)
# 10. UJI PARSIAL (UJI T)
cat("\n=== UJI T (PARSIAL) ===\n")
## 
## === UJI T (PARSIAL) ===
coef_summary <- summary(model)$coefficients
for(i in 2:nrow(coef_summary)) {
  cat(rownames(coef_summary)[i], ": ")
  cat("t =", round(coef_summary[i, 3], 3), ", ")
  cat("p =", round(coef_summary[i, 4], 5))
  if(coef_summary[i, 4] < 0.05) {
    cat(" -> SIGNIFIKAN\n")
  } else {
    cat(" -> TIDAK SIGNIFIKAN\n")
  }
}
## Pendapatan : t = 21.082 , p = 0 -> SIGNIFIKAN
## Anggota_RT : t = 11.336 , p = 0 -> SIGNIFIKAN
## Pendidikan : t = 3.108 , p = 0.00217 -> SIGNIFIKAN
## Tabungan : t = -1.583 , p = 0.11514 -> TIDAK SIGNIFIKAN
## Usia : t = -0.444 , p = 0.65752 -> TIDAK SIGNIFIKAN
# 11. KOEFISIEN DETERMINASI (R-SQUARED)
cat("\n=== KOEFISIEN DETERMINASI ===\n")
## 
## === KOEFISIEN DETERMINASI ===
cat("R-squared =", round(summary(model)$r.squared, 4), "\n")
## R-squared = 0.7628
cat("Adjusted R-squared =", round(summary(model)$adj.r.squared, 4), "\n")
## Adjusted R-squared = 0.7567
# 12. PLOT DIAGNOSTIK
par(mfrow = c(2, 2))
plot(model, main = "Diagnostic Plots")

# Simpan otomatis tampilan plot di atas ke file JPG
dev.copy(jpeg, "plot_diagnostik_regresi.jpg", width = 1000, height = 800, res = 150)
## jpeg 
##    3
dev.off()
## png 
##   2
library(readxl)
library(ggplot2)
library(dplyr)
## Warning: package 'dplyr' was built under R version 4.5.2
## 
## Attaching package: 'dplyr'
## The following object is masked from 'package:car':
## 
##     recode
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
# A. Histogram Pengeluaran
p1 <- ggplot(df, aes(x = Pengeluaran)) +
  geom_histogram(bins = 15, fill = "skyblue", color = "white") +
  geom_vline(aes(xintercept = mean(Pengeluaran)), color = "pink", linetype = "dashed", size = 1) +
  labs(
    title = "Distribusi Pengeluaran Konsumsi Bulanan",
    x = "Pengeluaran Konsumsi (Juta Rp)",
    y = "Frekuensi"
  ) +
  theme_minimal()
## Warning: Using `size` aesthetic for lines was deprecated in ggplot2 3.4.0.
## ℹ Please use `linewidth` instead.
## This warning is displayed once per session.
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
print(p1)

# Simpan Histogram
ggsave("histogram_pengeluaran.jpg", plot = p1, width = 8, height = 5, dpi = 300) 
# B. Scatter Plot Pendapatan vs Pengeluaran
p2 <- ggplot(df, aes(x = Pendapatan, y = Pengeluaran)) +
  geom_point(color = "aquamarine3", alpha = 0.6) +
  geom_smooth(method = "lm", color = "salmon2", se = TRUE) +
  labs(
    title = "Hubungan Pendapatan Bulanan vs Pengeluaran Konsumsi",
    x = "Pendapatan Bulanan (Juta Rp)",
    y = "Pengeluaran Konsumsi (Juta Rp)"
  ) +
  theme_minimal()

print(p2)
## `geom_smooth()` using formula = 'y ~ x'

# Simpan Scatter Plot
ggsave("scatter_pendapatan_pengeluaran.jpg", plot = p2, width = 8, height = 5, dpi = 300)
## `geom_smooth()` using formula = 'y ~ x'