# ============================================
# 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'