R Markdown merupakan format dokumen yang menggabungkan teks, syntax R, hasil analisis, tabel, dan visualisasi dalam satu dokumen.
install.packages(c(
"car",
"lmtest",
"knitr",
"DiagrammeR"
))
library(car)
## Warning: package 'car' was built under R version 4.5.3
## Loading required package: carData
## Warning: package 'carData' was built under R version 4.5.3
library(lmtest)
## Warning: package 'lmtest' was built under R version 4.5.3
## Loading required package: zoo
## Warning: package 'zoo' was built under R version 4.5.3
##
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric
library(knitr)
## Warning: package 'knitr' was built under R version 4.5.3
Data dimasukkan melalui Clipboard dari Microsoft Excel menggunakan
fungsi read.delim().
DATA9 <- read.delim("clipboard", header = TRUE)
DATA9
## Y X1 X2 X3
## 1 13.65 1.83 33.149 7.88
## 2 9.53 4.66 26.314 7.78
## 3 10.63 4.52 30.681 7.90
## 4 6.53 5.65 43.297 8.66
## 5 8.69 4.91 35.812 7.83
## 6 10.72 5.79 30.193 8.24
## 7 9.45 5.70 47.272 7.75
## 8 8.93 3.67 35.178 7.14
## 9 9.51 4.01 36.837 6.52
## 10 7.34 4.75 58.086 7.76
## 11 13.34 4.15 31.432 6.36
## 12 11.90 3.27 36.190 6.90
## 13 17.19 3.24 36.006 6.29
## 14 9.24 5.48 113.683 7.44
## 15 5.00 8.05 127.382 10.78
## 16 9.80 4.67 91.112 9.11
## 17 9.15 4.66 36.991 8.77
## 18 10.89 4.68 29.917 8.24
## 19 11.04 5.14 31.588 7.95
## 20 9.80 4.16 33.627 8.67
## 21 14.40 2.41 27.619 7.78
## 22 12.18 4.63 74.242 7.45
## 23 14.91 4.40 67.176 7.40
## 24 12.42 5.46 35.726 8.34
## 25 10.96 6.82 130.527 10.01
## 26 19.35 6.18 25.408 5.99
## 27 21.76 2.72 23.978 5.07
## 28 13.85 1.74 23.842 7.15
## 29 18.70 1.71 37.474 5.94
## 30 7.15 4.06 541.068 10.69
## 31 7.30 5.24 55.523 10.78
## 32 4.26 6.80 107.542 10.94
## 33 6.48 4.53 57.885 9.56
## 34 6.60 5.64 48.058 9.78
## 35 5.77 4.73 59.061 11.05
## 36 4.74 5.85 86.285 11.82
## 37 4.65 6.76 245.685 10.70
## 38 3.31 4.52 93.214 9.85
Catatan: Salin tabel dari Excel terlebih dahulu
sebelum menjalankan kode tersebut. Pastikan nama kolom sesuai, yaitu
Kabupaten.Kota, Y, X1,
X2, dan X3. Jika nama kolom berbeda, sesuaikan
syntax berikutnya.
str(DATA9)
## 'data.frame': 38 obs. of 4 variables:
## $ Y : num 13.65 9.53 10.63 6.53 8.69 ...
## $ X1: num 1.83 4.66 4.52 5.65 4.91 5.79 5.7 3.67 4.01 4.75 ...
## $ X2: num 33.1 26.3 30.7 43.3 35.8 ...
## $ X3: num 7.88 7.78 7.9 8.66 7.83 8.24 7.75 7.14 6.52 7.76 ...
summary(DATA9)
## Y X1 X2 X3
## Min. : 3.310 Min. :1.710 Min. : 23.84 Min. : 5.070
## 1st Qu.: 7.188 1st Qu.:4.082 1st Qu.: 31.98 1st Qu.: 7.410
## Median : 9.665 Median :4.665 Median : 37.23 Median : 7.925
## Mean :10.293 Mean :4.663 Mean : 70.66 Mean : 8.376
## 3rd Qu.:12.360 3rd Qu.:5.600 3rd Qu.: 72.48 3rd Qu.: 9.725
## Max. :21.760 Max. :8.050 Max. :541.07 Max. :11.820
dim(DATA9)
## [1] 38 4
nrow(DATA9)
## [1] 38
ncol(DATA9)
## [1] 4
names(DATA9)
## [1] "Y" "X1" "X2" "X3"
Variabel yang digunakan terdiri atas satu variabel dependen dan tiga variabel independen.
Y <- DATA9$Y
X1 <- DATA9$X1
X2 <- DATA9$X2
X3 <- DATA9$X3
summary(DATA9[, c("Y", "X1", "X2", "X3")])
## Y X1 X2 X3
## Min. : 3.310 Min. :1.710 Min. : 23.84 Min. : 5.070
## 1st Qu.: 7.188 1st Qu.:4.082 1st Qu.: 31.98 1st Qu.: 7.410
## Median : 9.665 Median :4.665 Median : 37.23 Median : 7.925
## Mean :10.293 Mean :4.663 Mean : 70.66 Mean : 8.376
## 3rd Qu.:12.360 3rd Qu.:5.600 3rd Qu.: 72.48 3rd Qu.: 9.725
## Max. :21.760 Max. :8.050 Max. :541.07 Max. :11.820
sapply(DATA9[, c("Y", "X1", "X2", "X3")], mean)
## Y X1 X2 X3
## 10.292632 4.662895 70.659474 8.375526
sapply(DATA9[, c("Y", "X1", "X2", "X3")], median)
## Y X1 X2 X3
## 9.6650 4.6650 37.2325 7.9250
sapply(DATA9[, c("Y", "X1", "X2", "X3")], var)
## Y X1 X2 X3
## 18.673539 2.041551 8001.549695 2.750301
sapply(DATA9[, c("Y", "X1", "X2", "X3")], sd)
## Y X1 X2 X3
## 4.321289 1.428828 89.451382 1.658403
statistik <- data.frame(
Variabel = c("Y", "X1", "X2", "X3"),
Minimum = sapply(DATA9[, c("Y", "X1", "X2", "X3")], min),
Q1 = sapply(DATA9[, c("Y", "X1", "X2", "X3")], quantile, 0.25),
Median = sapply(DATA9[, c("Y", "X1", "X2", "X3")], median),
Mean = sapply(DATA9[, c("Y", "X1", "X2", "X3")], mean),
Q3 = sapply(DATA9[, c("Y", "X1", "X2", "X3")], quantile, 0.75),
Maksimum = sapply(DATA9[, c("Y", "X1", "X2", "X3")], max)
)
kable(statistik, digits = 3,
caption = "Tabel Statistik Deskriptif")
| Variabel | Minimum | Q1 | Median | Mean | Q3 | Maksimum | |
|---|---|---|---|---|---|---|---|
| Y | Y | 3.310 | 7.188 | 9.665 | 10.293 | 12.360 | 21.760 |
| X1 | X1 | 1.710 | 4.082 | 4.665 | 4.663 | 5.600 | 8.050 |
| X2 | X2 | 23.842 | 31.978 | 37.233 | 70.659 | 72.476 | 541.068 |
| X3 | X3 | 5.070 | 7.410 | 7.925 | 8.376 | 9.725 | 11.820 |
par(mfrow = c(2, 2))
hist(Y, main = "Histogram Y",
xlab = "Persentase Penduduk Miskin")
hist(X1, main = "Histogram X1",
xlab = "Tingkat Pengangguran Terbuka")
hist(X2, main = "Histogram X2",
xlab = "PDRB per Kapita")
hist(X3, main = "Histogram X3",
xlab = "Rata-rata Lama Sekolah")
par(mfrow = c(1, 1))
par(mfrow = c(2, 2))
boxplot(Y, main = "Boxplot Y")
boxplot(X1, main = "Boxplot X1")
boxplot(X2, main = "Boxplot X2")
boxplot(X3, main = "Boxplot X3")
par(mfrow = c(1, 1))
par(mfrow = c(1, 3))
plot(X1, Y,
main = "Y terhadap X1",
xlab = "X1", ylab = "Y")
plot(X2, Y,
main = "Y terhadap X2",
xlab = "X2", ylab = "Y")
plot(X3, Y,
main = "Y terhadap X3",
xlab = "X3", ylab = "Y")
par(mfrow = c(1, 1))
cor(DATA9[, c("Y", "X1", "X2", "X3")])
## Y X1 X2 X3
## Y 1.0000000 -0.5644719 -0.3434974 -0.8238308
## X1 -0.5644719 1.0000000 0.2137265 0.5772813
## X2 -0.3434974 0.2137265 1.0000000 0.4753711
## X3 -0.8238308 0.5772813 0.4753711 1.0000000
model <- lm(Y ~ X1 + X2 + X3, data = DATA9)
model
##
## Call:
## lm(formula = Y ~ X1 + X2 + X3, data = DATA9)
##
## Coefficients:
## (Intercept) X1 X2 X3
## 28.827935 -0.388860 0.002517 -2.017774
summary(model)
##
## Call:
## lm(formula = Y ~ X1 + X2 + X3, data = DATA9)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.6954 -1.5925 0.0325 1.7025 4.9477
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 28.827935 2.246905 12.830 1.38e-14 ***
## X1 -0.388860 0.353425 -1.100 0.279
## X2 0.002517 0.005240 0.480 0.634
## X3 -2.017774 0.338110 -5.968 9.48e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.499 on 34 degrees of freedom
## Multiple R-squared: 0.6926, Adjusted R-squared: 0.6655
## F-statistic: 25.54 on 3 and 34 DF, p-value: 7.812e-09
coef(model)
## (Intercept) X1 X2 X3
## 28.827934951 -0.388860442 0.002516719 -2.017773869
b <- coef(model)
cat("Persamaan Regresi:\n")
## Persamaan Regresi:
cat("Y =", round(b[1], 4),
"+", round(b[2], 4), "X1",
"+", round(b[3], 4), "X2",
"+", round(b[4], 4), "X3")
## Y = 28.8279 + -0.3889 X1 + 0.0025 X2 + -2.0178 X3
prediksi <- fitted(model)
prediksi
## 1 2 3 4 5 6 7 8
## 12.299689 11.383790 11.207088 9.265918 11.209590 10.025964 11.092653 13.082445
## 9 10 11 12 13 14 15 16
## 14.205427 11.469109 14.460228 13.724802 14.966846 11.970850 4.266591 8.859340
## 17 18 19 20 21 22 23 24
## 9.413064 10.456904 10.867388 9.800806 12.262010 12.181942 12.354486 9.966435
## 25 26 27 28 29 30 31 32
## 6.306490 14.402257 17.600467 13.784238 16.271718 7.040875 5.178440 4.379891
## 33 34 35 36 37 38
## 7.922159 7.021882 4.840864 2.920169 5.227378 7.429807
residual <- residuals(model)
residual
## 1 2 3 4 5
## 1.3503110103 -1.8537895494 -0.5770876609 -2.7359181542 -2.5195895470
## 6 7 8 9 10
## 0.6940363744 -1.6426533126 -4.1524448639 -4.6954273499 -4.1291087976
## 11 12 13 14 15
## -1.1202278385 -1.8248016891 2.2231535141 -2.7308503647 0.7334091521
## 16 17 18 19 20
## 0.9406599133 -0.2630644329 0.4330958989 0.1726118418 -0.0008057964
## 21 22 23 24 25
## 2.1379901381 -0.0019420694 2.5555144753 2.4535648069 4.6535098473
## 26 27 28 29 30
## 4.9477432445 4.1595330661 0.0657617543 2.4282816402 0.1091247377
## 31 32 33 34 35
## 2.1215602545 -0.1198908669 -1.4421592703 -0.4218821269 0.9291362204
## 36 37 38
## 1.8198306235 -0.5773781887 -4.1198066344
anova(model)
## Analysis of Variance Table
##
## Response: Y
## Df Sum Sq Mean Sq F value Pr(>F)
## X1 1 220.147 220.147 35.2458 1.040e-06 ***
## X2 1 35.957 35.957 5.7567 0.02205 *
## X3 1 222.451 222.451 35.6147 9.482e-07 ***
## Residuals 34 212.366 6.246
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
summary(model)$coefficients
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 28.827934951 2.246905095 12.8300635 1.381733e-14
## X1 -0.388860442 0.353425005 -1.1002630 2.789468e-01
## X2 0.002516719 0.005239549 0.4803313 6.340680e-01
## X3 -2.017773869 0.338109790 -5.9678067 9.481861e-07
summary(model)$r.squared
## [1] 0.6926337
summary(model)$adj.r.squared
## [1] 0.6655131
vif(model)
## X1 X2 X3
## 1.510604 1.301241 1.862480
bptest(model)
##
## studentized Breusch-Pagan test
##
## data: model
## BP = 7.0674, df = 3, p-value = 0.06978
dwtest(model)
##
## Durbin-Watson test
##
## data: model
## DW = 0.874, p-value = 3.324e-05
## alternative hypothesis: true autocorrelation is greater than 0
shapiro.test(residuals(model))
##
## Shapiro-Wilk normality test
##
## data: residuals(model)
## W = 0.97723, p-value = 0.6193
par(mfrow = c(2, 2))
plot(model)
par(mfrow = c(1, 1))
Uji Lack of Fit digunakan untuk mengetahui kesesuaian model regresi terhadap data. Pengujian ini membutuhkan pengamatan berulang pada kombinasi nilai variabel independen yang sama.
# Menggabungkan variabel independen
X <- DATA9[, c("X1", "X2", "X3")]
# Membuat kelompok kombinasi X yang sama
kelompok <- interaction(X, drop = TRUE)
# Menghitung banyak kombinasi X yang berbeda
jumlah_kombinasi <- length(unique(kelompok))
# Menghitung banyak observasi
jumlah_data <- nrow(DATA9)
# Memeriksa apakah terdapat pengamatan berulang
if (jumlah_kombinasi < jumlah_data) {
# Model regresi
model <- lm(Y ~ X1 + X2 + X3, data = DATA9)
# Pure error sum of squares
SSE <- sum(residuals(model)^2)
# Pure error berdasarkan kelompok pengamatan
rata2_kelompok <- ave(Y, kelompok, FUN = mean)
SSPE <- sum((Y - rata2_kelompok)^2)
# Lack of fit sum of squares
SSLOF <- SSE - SSPE
# Derajat bebas
df_LOF <- jumlah_kombinasi - length(coef(model))
df_PE <- jumlah_data - jumlah_kombinasi
# Statistik uji
F_LOF <- (SSLOF / df_LOF) / (SSPE / df_PE)
# P-value
p_value <- pf(F_LOF, df_LOF, df_PE,
lower.tail = FALSE)
hasil_LOF <- data.frame(
F_Hitung = F_LOF,
df_LOF = df_LOF,
df_PE = df_PE,
P_Value = p_value
)
print(hasil_LOF)
} else {
cat("Uji Lack of Fit tidak dapat dihitung karena",
"tidak terdapat pengamatan berulang pada kombinasi X.")
}
## Uji Lack of Fit tidak dapat dihitung karena tidak terdapat pengamatan berulang pada kombinasi X.
regresi <- lm(Y ~ X1 + X2 + X3, data = DATA9)
summary(regresi)
##
## Call:
## lm(formula = Y ~ X1 + X2 + X3, data = DATA9)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.6954 -1.5925 0.0325 1.7025 4.9477
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 28.827935 2.246905 12.830 1.38e-14 ***
## X1 -0.388860 0.353425 -1.100 0.279
## X2 0.002517 0.005240 0.480 0.634
## X3 -2.017774 0.338110 -5.968 9.48e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.499 on 34 degrees of freedom
## Multiple R-squared: 0.6926, Adjusted R-squared: 0.6655
## F-statistic: 25.54 on 3 and 34 DF, p-value: 7.812e-09
influencePlot(regresi,
main = "Influence Plot",
sub = "Ukuran Lingkaran Sebanding dengan Cook's Distance")
## StudRes Hat CookD
## 25 2.0423912 0.0913278 0.09587030
## 26 2.4135158 0.2316811 0.38455305
## 27 1.8598523 0.1412773 0.13267526
## 30 0.1100091 0.8470400 0.01725556
outlierTest(regresi)
## No Studentized residuals with Bonferroni p < 0.05
## Largest |rstudent|:
## rstudent unadjusted p-value Bonferroni p
## 26 2.413516 0.021511 0.81744
nilai_dffits <- dffits(regresi)
nilai_dffits
## 1 2 3 4 5
## 2.640636e-01 -1.424571e-01 -4.205674e-02 -2.447697e-01 -1.985490e-01
## 6 7 8 9 10
## 7.059239e-02 -1.797245e-01 -3.769314e-01 -5.240089e-01 -3.205596e-01
## 11 12 13 14 15
## -1.281098e-01 -1.824478e-01 2.591552e-01 -3.663936e-01 1.490445e-01
## 16 17 18 19 20
## 7.111739e-02 -2.086719e-02 3.187119e-02 1.419507e-02 -7.123038e-05
## 21 22 23 24 25
## 3.224102e-01 -1.643033e-04 2.102131e-01 2.135640e-01 6.474956e-01
## 26 27 28 29 30
## 1.325332e+00 7.543766e-01 1.186107e-02 4.363686e-01 2.588759e-01
## 31 32 33 34 35
## 3.316291e-01 -1.743333e-02 -1.492971e-01 -4.397816e-02 1.762213e-01
## 36 37 38
## 3.651199e-01 -1.090066e-01 -4.619481e-01
n <- nrow(DATA9)
p <- length(coef(regresi)) - 1
batas_dffits <- 2 * sqrt(p / n)
batas_dffits
## [1] 0.5619515
data_dffits <- data.frame(
Pengamatan = 1:n,
DFFITS = nilai_dffits,
Absolut_DFFITS = abs(nilai_dffits)
)
data_dffits
## Pengamatan DFFITS Absolut_DFFITS
## 1 1 2.640636e-01 2.640636e-01
## 2 2 -1.424571e-01 1.424571e-01
## 3 3 -4.205674e-02 4.205674e-02
## 4 4 -2.447697e-01 2.447697e-01
## 5 5 -1.985490e-01 1.985490e-01
## 6 6 7.059239e-02 7.059239e-02
## 7 7 -1.797245e-01 1.797245e-01
## 8 8 -3.769314e-01 3.769314e-01
## 9 9 -5.240089e-01 5.240089e-01
## 10 10 -3.205596e-01 3.205596e-01
## 11 11 -1.281098e-01 1.281098e-01
## 12 12 -1.824478e-01 1.824478e-01
## 13 13 2.591552e-01 2.591552e-01
## 14 14 -3.663936e-01 3.663936e-01
## 15 15 1.490445e-01 1.490445e-01
## 16 16 7.111739e-02 7.111739e-02
## 17 17 -2.086719e-02 2.086719e-02
## 18 18 3.187119e-02 3.187119e-02
## 19 19 1.419507e-02 1.419507e-02
## 20 20 -7.123038e-05 7.123038e-05
## 21 21 3.224102e-01 3.224102e-01
## 22 22 -1.643033e-04 1.643033e-04
## 23 23 2.102131e-01 2.102131e-01
## 24 24 2.135640e-01 2.135640e-01
## 25 25 6.474956e-01 6.474956e-01
## 26 26 1.325332e+00 1.325332e+00
## 27 27 7.543766e-01 7.543766e-01
## 28 28 1.186107e-02 1.186107e-02
## 29 29 4.363686e-01 4.363686e-01
## 30 30 2.588759e-01 2.588759e-01
## 31 31 3.316291e-01 3.316291e-01
## 32 32 -1.743333e-02 1.743333e-02
## 33 33 -1.492971e-01 1.492971e-01
## 34 34 -4.397816e-02 4.397816e-02
## 35 35 1.762213e-01 1.762213e-01
## 36 36 3.651199e-01 3.651199e-01
## 37 37 -1.090066e-01 1.090066e-01
## 38 38 -4.619481e-01 4.619481e-01
data_dffits[
abs(data_dffits$DFFITS) > batas_dffits,
]
## Pengamatan DFFITS Absolut_DFFITS
## 25 25 0.6474956 0.6474956
## 26 26 1.3253321 1.3253321
## 27 27 0.7543766 0.7543766
nilai_dfbetas <- dfbetas(regresi)
nilai_dfbetas
## (Intercept) X1 X2 X3
## 1 4.872375e-02 -2.381684e-01 -5.334426e-02 1.218593e-01
## 2 -4.706807e-02 -2.773707e-02 4.386740e-02 3.001917e-02
## 3 -1.245485e-02 -1.956102e-03 1.343735e-02 3.801547e-03
## 4 3.068929e-02 -1.305763e-01 7.200020e-02 1.549320e-02
## 5 -6.400771e-02 -7.286669e-02 3.928902e-02 6.374632e-02
## 6 2.246026e-03 4.725598e-02 -1.841698e-02 -2.011546e-02
## 7 -5.024843e-02 -1.322168e-01 -4.906069e-04 1.006600e-01
## 8 -2.550097e-01 9.701578e-02 2.236603e-02 1.013685e-01
## 9 -4.328961e-01 -8.504769e-02 -6.713572e-02 3.531168e-01
## 10 -1.495680e-01 -9.877698e-02 -2.009014e-02 1.379483e-01
## 11 -1.045177e-01 -3.410286e-02 -1.525469e-02 9.368201e-02
## 12 -1.316900e-01 7.117955e-02 6.313709e-04 4.513054e-02
## 13 2.259327e-01 -4.903335e-02 3.337617e-02 -1.328507e-01
## 14 -1.839573e-01 -2.335987e-01 -1.883698e-01 2.784500e-01
## 15 -7.393033e-02 1.089400e-01 5.586507e-03 2.719929e-03
## 16 -1.320730e-02 -1.937910e-02 -3.398366e-04 3.073703e-02
## 17 3.844406e-03 3.869596e-03 1.014748e-02 -9.131490e-03
## 18 2.709419e-03 9.445671e-04 -1.361621e-02 3.181146e-03
## 19 3.114042e-03 6.551072e-03 -3.601891e-03 -4.165876e-03
## 20 7.956663e-06 3.319717e-05 3.369664e-05 -3.776863e-05
## 21 7.536385e-02 -2.707348e-01 -7.844440e-02 1.303385e-01
## 22 -1.037953e-04 -5.218307e-05 -4.985407e-05 1.006767e-04
## 23 1.405017e-01 3.755449e-02 5.091696e-02 -1.152484e-01
## 24 3.374204e-03 1.120651e-01 -6.321175e-02 -3.579391e-02
## 25 -2.515992e-01 4.140873e-01 1.150775e-01 -6.631679e-03
## 26 6.597477e-01 1.060486e+00 1.808157e-01 -1.100308e+00
## 27 7.230974e-01 -7.127972e-02 1.530394e-01 -5.056498e-01
## 28 4.492084e-03 -1.007136e-02 -1.829250e-03 3.245018e-03
## 29 3.246292e-01 -2.748954e-01 4.622485e-02 -7.716252e-02
## 30 3.195918e-02 -4.929001e-02 2.365091e-01 -2.106116e-02
## 31 -2.301836e-01 -9.716636e-02 -1.618134e-01 2.826566e-01
## 32 1.226939e-02 -6.186438e-03 2.662347e-03 -7.713770e-03
## 33 6.316998e-02 6.674016e-02 6.025387e-02 -1.109619e-01
## 34 2.512997e-02 -5.143323e-03 2.119540e-02 -2.383449e-02
## 35 -1.147865e-01 -8.446465e-02 -8.023906e-02 1.608939e-01
## 36 -2.914417e-01 -7.647951e-02 -1.390656e-01 3.142830e-01
## 37 2.999402e-02 -4.168991e-02 -6.876904e-02 3.146258e-03
## 38 1.998650e-01 2.299003e-01 7.706861e-02 -3.446161e-01
batas_dfbetas <- 2 / sqrt(n)
batas_dfbetas
## [1] 0.3244428
hasil_dfbetas <- data.frame(
Pengamatan = 1:n,
nilai_dfbetas
)
hasil_dfbetas
## Pengamatan X.Intercept. X1 X2 X3
## 1 1 4.872375e-02 -2.381684e-01 -5.334426e-02 1.218593e-01
## 2 2 -4.706807e-02 -2.773707e-02 4.386740e-02 3.001917e-02
## 3 3 -1.245485e-02 -1.956102e-03 1.343735e-02 3.801547e-03
## 4 4 3.068929e-02 -1.305763e-01 7.200020e-02 1.549320e-02
## 5 5 -6.400771e-02 -7.286669e-02 3.928902e-02 6.374632e-02
## 6 6 2.246026e-03 4.725598e-02 -1.841698e-02 -2.011546e-02
## 7 7 -5.024843e-02 -1.322168e-01 -4.906069e-04 1.006600e-01
## 8 8 -2.550097e-01 9.701578e-02 2.236603e-02 1.013685e-01
## 9 9 -4.328961e-01 -8.504769e-02 -6.713572e-02 3.531168e-01
## 10 10 -1.495680e-01 -9.877698e-02 -2.009014e-02 1.379483e-01
## 11 11 -1.045177e-01 -3.410286e-02 -1.525469e-02 9.368201e-02
## 12 12 -1.316900e-01 7.117955e-02 6.313709e-04 4.513054e-02
## 13 13 2.259327e-01 -4.903335e-02 3.337617e-02 -1.328507e-01
## 14 14 -1.839573e-01 -2.335987e-01 -1.883698e-01 2.784500e-01
## 15 15 -7.393033e-02 1.089400e-01 5.586507e-03 2.719929e-03
## 16 16 -1.320730e-02 -1.937910e-02 -3.398366e-04 3.073703e-02
## 17 17 3.844406e-03 3.869596e-03 1.014748e-02 -9.131490e-03
## 18 18 2.709419e-03 9.445671e-04 -1.361621e-02 3.181146e-03
## 19 19 3.114042e-03 6.551072e-03 -3.601891e-03 -4.165876e-03
## 20 20 7.956663e-06 3.319717e-05 3.369664e-05 -3.776863e-05
## 21 21 7.536385e-02 -2.707348e-01 -7.844440e-02 1.303385e-01
## 22 22 -1.037953e-04 -5.218307e-05 -4.985407e-05 1.006767e-04
## 23 23 1.405017e-01 3.755449e-02 5.091696e-02 -1.152484e-01
## 24 24 3.374204e-03 1.120651e-01 -6.321175e-02 -3.579391e-02
## 25 25 -2.515992e-01 4.140873e-01 1.150775e-01 -6.631679e-03
## 26 26 6.597477e-01 1.060486e+00 1.808157e-01 -1.100308e+00
## 27 27 7.230974e-01 -7.127972e-02 1.530394e-01 -5.056498e-01
## 28 28 4.492084e-03 -1.007136e-02 -1.829250e-03 3.245018e-03
## 29 29 3.246292e-01 -2.748954e-01 4.622485e-02 -7.716252e-02
## 30 30 3.195918e-02 -4.929001e-02 2.365091e-01 -2.106116e-02
## 31 31 -2.301836e-01 -9.716636e-02 -1.618134e-01 2.826566e-01
## 32 32 1.226939e-02 -6.186438e-03 2.662347e-03 -7.713770e-03
## 33 33 6.316998e-02 6.674016e-02 6.025387e-02 -1.109619e-01
## 34 34 2.512997e-02 -5.143323e-03 2.119540e-02 -2.383449e-02
## 35 35 -1.147865e-01 -8.446465e-02 -8.023906e-02 1.608939e-01
## 36 36 -2.914417e-01 -7.647951e-02 -1.390656e-01 3.142830e-01
## 37 37 2.999402e-02 -4.168991e-02 -6.876904e-02 3.146258e-03
## 38 38 1.998650e-01 2.299003e-01 7.706861e-02 -3.446161e-01
pengamatan_dfbetas <- which(
apply(abs(nilai_dfbetas) > batas_dfbetas, 1, any)
)
pengamatan_dfbetas
## 9 25 26 27 29 38
## 9 25 26 27 29 38
pengamatan_dffits <- which(
abs(nilai_dffits) > batas_dffits
)
pengamatan_berpengaruh <- sort(unique(c(
pengamatan_dffits,
pengamatan_dfbetas
)))
pengamatan_berpengaruh
## [1] 9 25 26 27 29 38
Bagian ini menghapus pengamatan yang teridentifikasi berpengaruh berdasarkan DFFITS atau DFBETAS. Penghapusan perlu dievaluasi terlebih dahulu berdasarkan konteks data.
DATA9_baru <- DATA9[
-pengamatan_berpengaruh,
]
DATA9_baru
## Y X1 X2 X3
## 1 13.65 1.83 33.149 7.88
## 2 9.53 4.66 26.314 7.78
## 3 10.63 4.52 30.681 7.90
## 4 6.53 5.65 43.297 8.66
## 5 8.69 4.91 35.812 7.83
## 6 10.72 5.79 30.193 8.24
## 7 9.45 5.70 47.272 7.75
## 8 8.93 3.67 35.178 7.14
## 10 7.34 4.75 58.086 7.76
## 11 13.34 4.15 31.432 6.36
## 12 11.90 3.27 36.190 6.90
## 13 17.19 3.24 36.006 6.29
## 14 9.24 5.48 113.683 7.44
## 15 5.00 8.05 127.382 10.78
## 16 9.80 4.67 91.112 9.11
## 17 9.15 4.66 36.991 8.77
## 18 10.89 4.68 29.917 8.24
## 19 11.04 5.14 31.588 7.95
## 20 9.80 4.16 33.627 8.67
## 21 14.40 2.41 27.619 7.78
## 22 12.18 4.63 74.242 7.45
## 23 14.91 4.40 67.176 7.40
## 24 12.42 5.46 35.726 8.34
## 28 13.85 1.74 23.842 7.15
## 30 7.15 4.06 541.068 10.69
## 31 7.30 5.24 55.523 10.78
## 32 4.26 6.80 107.542 10.94
## 33 6.48 4.53 57.885 9.56
## 34 6.60 5.64 48.058 9.78
## 35 5.77 4.73 59.061 11.05
## 36 4.74 5.85 86.285 11.82
## 37 4.65 6.76 245.685 10.70
regresi_baru <- lm(
Y ~ X1 + X2 + X3,
data = DATA9_baru
)
summary(regresi_baru)
##
## Call:
## lm(formula = Y ~ X1 + X2 + X3, data = DATA9_baru)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.5825 -0.7704 -0.1633 0.9179 3.4019
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 25.3985738 1.9400986 13.091 1.86e-13 ***
## X1 -0.8759728 0.2873416 -3.049 0.00498 **
## X2 -0.0004154 0.0036995 -0.112 0.91140
## X3 -1.3524683 0.2846271 -4.752 5.47e-05 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.742 on 28 degrees of freedom
## Multiple R-squared: 0.7515, Adjusted R-squared: 0.7249
## F-statistic: 28.23 on 3 and 28 DF, p-value: 1.298e-08
summary(regresi)
##
## Call:
## lm(formula = Y ~ X1 + X2 + X3, data = DATA9)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.6954 -1.5925 0.0325 1.7025 4.9477
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 28.827935 2.246905 12.830 1.38e-14 ***
## X1 -0.388860 0.353425 -1.100 0.279
## X2 0.002517 0.005240 0.480 0.634
## X3 -2.017774 0.338110 -5.968 9.48e-07 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.499 on 34 degrees of freedom
## Multiple R-squared: 0.6926, Adjusted R-squared: 0.6655
## F-statistic: 25.54 on 3 and 34 DF, p-value: 7.812e-09
summary(regresi_baru)
##
## Call:
## lm(formula = Y ~ X1 + X2 + X3, data = DATA9_baru)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.5825 -0.7704 -0.1633 0.9179 3.4019
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 25.3985738 1.9400986 13.091 1.86e-13 ***
## X1 -0.8759728 0.2873416 -3.049 0.00498 **
## X2 -0.0004154 0.0036995 -0.112 0.91140
## X3 -1.3524683 0.2846271 -4.752 5.47e-05 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.742 on 28 degrees of freedom
## Multiple R-squared: 0.7515, Adjusted R-squared: 0.7249
## F-statistic: 28.23 on 3 and 28 DF, p-value: 1.298e-08
AIC(regresi, regresi_baru)
## Warning in AIC.default(regresi, regresi_baru): models are not all fitted to the
## same number of observations
## df AIC
## regresi 5 183.2268
## regresi_baru 5 132.0634
Berdasarkan analisis yang telah dilakukan, dapat diketahui bahwa analisis regresi linier berganda digunakan untuk mengetahui hubungan antara variabel dependen dan variabel independen. Pengujian dilakukan melalui statistika deskriptif, pembentukan model regresi, pengujian signifikansi parameter, pengujian asumsi klasik, pengujian Lack of Fit, serta identifikasi outlier dan pengamatan berpengaruh.
Hasil analisis dapat digunakan untuk mengevaluasi kesesuaian model regresi dan mengetahui pengamatan yang memiliki pengaruh terhadap hasil estimasi model.