R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

summary(cars)
##      speed           dist       
##  Min.   : 4.0   Min.   :  2.00  
##  1st Qu.:12.0   1st Qu.: 26.00  
##  Median :15.0   Median : 36.00  
##  Mean   :15.4   Mean   : 42.98  
##  3rd Qu.:19.0   3rd Qu.: 56.00  
##  Max.   :25.0   Max.   :120.00

Including Plots

You can also embed plots, for example:

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.

library("readxl")
## Warning: package 'readxl' was built under R version 4.5.3
library("Matrix")
library("lme4")
## Warning: package 'lme4' was built under R version 4.5.3
library("robustlmm")
## Warning: package 'robustlmm' was built under R version 4.5.3
library("ggplot2")
## Warning: package 'ggplot2' was built under R version 4.5.3
rm(list = ls())
set.seed(123)


#===============================================================================
# 1. PERSIAPAN DATA
#===============================================================================

## Data asli
data = as.data.frame(read_excel("C:/Users/HP/Downloads/Data_IKP_Indonesia_2024.xlsx"))
data$Provinsi = as.factor(data$Provinsi)
head(data)
##   Provinsi     Kabupaten   IKP MISKIN  POU TNPAIR STUNTING  PPH NCPR Longitude
## 1     Aceh  Aceh Selatan 70.13   12.1 13.7   34.0     40.2 69.8 0.91  97.46916
## 2     Aceh Aceh Tenggara 64.98   12.5 13.0   44.2     32.9 82.7 0.55  97.74567
## 3     Aceh    Aceh Timur 67.80   13.4  8.6   38.7     29.7 79.2 0.77  97.64295
## 4     Aceh   Aceh Tengah 67.62   14.4  8.6   26.3     23.6 84.1 2.87  96.96191
## 5     Aceh    Aceh Barat 68.78   17.9  6.2   23.4     33.4 83.4 0.71  96.17833
## 6     Aceh    Aceh Besar 71.73   13.4  8.6   10.1     30.1 75.1 0.50  95.49564
##   Latitude
## 1 3.067177
## 2 3.338722
## 3 4.702227
## 4 4.564238
## 5 4.427494
## 6 5.354233
summary(data[, 3:9])
##       IKP            MISKIN           POU             TNPAIR     
##  Min.   :30.05   Min.   : 2.30   Min.   : 0.700   Min.   : 0.00  
##  1st Qu.:64.67   1st Qu.: 6.60   1st Qu.: 6.725   1st Qu.:13.62  
##  Median :70.47   Median : 9.65   Median : 9.200   Median :25.05  
##  Mean   :68.04   Mean   :11.50   Mean   :12.058   Mean   :28.69  
##  3rd Qu.:74.30   3rd Qu.:14.10   3rd Qu.:13.400   3rd Qu.:38.62  
##  Max.   :86.58   Max.   :40.00   Max.   :67.200   Max.   :99.60  
##     STUNTING          PPH             NCPR       
##  Min.   : 1.60   Min.   :50.70   Min.   : 0.090  
##  1st Qu.:17.30   1st Qu.:80.62   1st Qu.: 0.590  
##  Median :22.90   Median :87.35   Median : 1.120  
##  Mean   :23.44   Mean   :85.28   Mean   : 3.257  
##  3rd Qu.:29.10   3rd Qu.:91.80   3rd Qu.: 5.160  
##  Max.   :65.00   Max.   :99.50   Max.   :10.000
n    = nrow(data)                  # jumlah kabupaten/kota (514)
J    = nlevels(data$Provinsi)      # jumlah provinsi (38)
prov = as.integer(data$Provinsi)   # nomor provinsi setiap kab/kota

## Uji normalitas
shapiro.test(data$IKP)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$IKP
## W = 0.88279, p-value < 2.2e-16
shapiro.test(data$MISKIN)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$MISKIN
## W = 0.85718, p-value < 2.2e-16
shapiro.test(data$POU)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$POU
## W = 0.73407, p-value < 2.2e-16
shapiro.test(data$TNPAIR)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$TNPAIR
## W = 0.91838, p-value = 4.771e-16
shapiro.test(data$STUNTING)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$STUNTING
## W = 0.986, p-value = 7.544e-05
shapiro.test(data$PPH)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$PPH
## W = 0.919, p-value = 5.54e-16
shapiro.test(data$NCPR)
## 
##  Shapiro-Wilk normality test
## 
## data:  data$NCPR
## W = 0.72185, p-value < 2.2e-16
## Pencilan setiap variabel (boxplot)
boxplot(data[, 3:9])

out.IKP      = boxplot.stats(data$IKP)$out
out.MISKIN   = boxplot.stats(data$MISKIN)$out
out.POU      = boxplot.stats(data$POU)$out
out.TNPAIR   = boxplot.stats(data$TNPAIR)$out
out.STUNTING = boxplot.stats(data$STUNTING)$out
out.PPH      = boxplot.stats(data$PPH)$out
out.NCPR     = boxplot.stats(data$NCPR)$out

persen.pencilan = c(
  IKP      = length(out.IKP) / n,
  MISKIN   = length(out.MISKIN) / n,
  POU      = length(out.POU) / n,
  TNPAIR   = length(out.TNPAIR) / n,
  STUNTING = length(out.STUNTING) / n,
  PPH      = length(out.PPH) / n,
  NCPR     = length(out.NCPR) / n
)
round(persen.pencilan * 100, 2)   # persentase pencilan (%)
##      IKP   MISKIN      POU   TNPAIR STUNTING      PPH     NCPR 
##     7.00     6.61     9.92     3.70     1.56     1.75     0.00
## Model pada data asli
model = IKP ~ MISKIN + POU + TNPAIR + STUNTING + PPH + NCPR + (1 | Provinsi)

model.lmm  = lmer(model, data = data)
model.rlmm = rlmer(model, data = data)
# summary(model.lmm)   
fixef(model.lmm)          
## (Intercept)      MISKIN         POU      TNPAIR    STUNTING         PPH 
## 53.00336626 -0.39463785 -0.23897520 -0.09097450 -0.09794259  0.35399693 
##        NCPR 
## -0.72244037
VarCorr(model.lmm)       
##  Groups   Name        Std.Dev.
##  Provinsi (Intercept) 2.0163  
##  Residual             3.1203
sigma(model.lmm)^2       
## [1] 9.736123
# summary(model.rlmm)   
fixef(model.rlmm)         
## (Intercept)      MISKIN         POU      TNPAIR    STUNTING         PPH 
## 53.29436039 -0.40451151 -0.23216105 -0.08905541 -0.10093294  0.34896026 
##        NCPR 
## -0.71703317
VarCorr(model.rlmm)      
##  Groups   Name        Std.Dev.
##  Provinsi (Intercept) 2.1441  
##  Residual             2.9985
sigma(model.rlmm)^2       
## [1] 8.991258
## Fungsi validasi model 
model.val = function(y, yt){
  e    = y - yt
  MSE  = mean(e^2)
  RMSE = sqrt(MSE)
  SST  = sum((y - mean(y))^2)
  SSE  = sum(e^2)
  Rsqr = (SST - SSE)/SST
  hasil = data.frame(MSE = MSE, RMSE = RMSE, R2 = Rsqr)
  return(hasil)
}

model.val(data$IKP, fitted(model.lmm))    # LMM
##        MSE     RMSE        R2
## 1 9.050438 3.008395 0.9094473
model.val(data$IKP, fitted(model.rlmm))   # Robust LMM
##       MSE    RMSE        R2
## 1 9.06389 3.01063 0.9093127
## Parameter awal (diambil dari Robust LMM karena tidak terpengaruh pencilan)
beta_awal = fixef(model.rlmm)                              # koefisien regresi
sd_u      = sqrt(as.numeric(VarCorr(model.rlmm)$Provinsi)) # sd efek acak provinsi
sd_e      = sigma(model.rlmm)                              # sd error

parameter = c(beta_awal, sd_u^2, sd_e^2)
names(parameter) = c("b0", "b_MISKIN", "b_POU", "b_TNPAIR", "b_STUNTING",
                     "b_PPH", "b_NCPR", "var_random", "var_error")
parameter
##          b0    b_MISKIN       b_POU    b_TNPAIR  b_STUNTING       b_PPH 
## 53.29436039 -0.40451151 -0.23216105 -0.08905541 -0.10093294  0.34896026 
##      b_NCPR  var_random   var_error 
## -0.71703317  4.59736186  8.99125759
#===============================================================================
# 2. BANGKITKAN DATA BERDASARKAN PARAMETER DAN PERSENTASE PENCILAN
#===============================================================================
# Persentase pencilan setiap variabel = persentase pencilan pada data asli

bangkit.data = function(){
  # (a) variabel X : distribusi normal sesuai rata-rata dan sd data asli
  MISKIN   = rnorm(n, mean(data$MISKIN),   sd(data$MISKIN))
  POU      = rnorm(n, mean(data$POU),      sd(data$POU))
  TNPAIR   = rnorm(n, mean(data$TNPAIR),   sd(data$TNPAIR))
  STUNTING = rnorm(n, mean(data$STUNTING), sd(data$STUNTING))
  PPH      = rnorm(n, mean(data$PPH),      sd(data$PPH))
  NCPR     = rnorm(n, mean(data$NCPR),     sd(data$NCPR))
  
  # (b) pencilan X 
  index = sample(1:n, round(persen.pencilan["MISKIN"] * n))
  MISKIN[index] = rnorm(length(index), mean(out.MISKIN), sd(out.MISKIN))
  
  index = sample(1:n, round(persen.pencilan["POU"] * n))
  POU[index] = rnorm(length(index), mean(out.POU), sd(out.POU))
  
  index = sample(1:n, round(persen.pencilan["TNPAIR"] * n))
  TNPAIR[index] = rnorm(length(index), mean(out.TNPAIR), sd(out.TNPAIR))
  
  index = sample(1:n, round(persen.pencilan["STUNTING"] * n))
  STUNTING[index] = rnorm(length(index), mean(out.STUNTING), sd(out.STUNTING))
  
  index = sample(1:n, round(persen.pencilan["PPH"] * n))
  PPH[index] = rnorm(length(index), mean(out.PPH), sd(out.PPH))
  # NCPR tidak memiliki pencilan pada data asli
  
  # (c) variabel Y : parameter awal + efek acak provinsi + error
  u = rnorm(J, 0, sd_u)
  e = rnorm(n, 0, sd_e)
  IKP = beta_awal[1] + beta_awal[2]*MISKIN + beta_awal[3]*POU + beta_awal[4]*TNPAIR +
    beta_awal[5]*STUNTING + beta_awal[6]*PPH + beta_awal[7]*NCPR + u[prov] + e
  IKP = as.numeric(IKP)
  
  # (d) pencilan Y
  index = sample(1:n, round(persen.pencilan["IKP"] * n))
  IKP[index] = rnorm(length(index), mean(out.IKP), sd(out.IKP))
  
  ds = data.frame(Provinsi = data$Provinsi, IKP, MISKIN, POU, TNPAIR, STUNTING, PPH, NCPR)
  return(ds)
}

## Contoh satu data simulasi
ds = bangkit.data()
head(ds)
##   Provinsi      IKP    MISKIN       POU    TNPAIR STUNTING      PPH      NCPR
## 1     Aceh 67.03692  7.493975  6.080643 37.112968 22.75772 84.67639 4.6583136
## 2     Aceh 68.21733  9.857548  4.932994 43.154072 35.87741 90.41602 6.3801811
## 3     Aceh 65.95012 22.658593 10.779631  4.690865 24.90479 87.14483 0.9590951
## 4     Aceh 66.33953 12.009219 15.063504 34.710315 37.51144 87.29948 3.9149276
## 5     Aceh 65.00210 28.704608  1.976875  9.553243 22.88482 94.78673 1.1103680
## 6     Aceh 53.23348 23.777462 10.270534 19.507763 28.91329 76.84152 6.6199018
summary(ds[, -1])
##       IKP            MISKIN            POU              TNPAIR      
##  Min.   :28.14   Min.   :-7.537   Min.   :-15.186   Min.   :-25.36  
##  1st Qu.:59.39   1st Qu.: 7.389   1st Qu.:  6.519   1st Qu.: 15.97  
##  Median :65.97   Median :12.024   Median : 13.466   Median : 30.98  
##  Mean   :64.58   Mean   :12.797   Mean   : 14.528   Mean   : 31.28  
##  3rd Qu.:71.24   3rd Qu.:17.624   3rd Qu.: 21.286   3rd Qu.: 43.74  
##  Max.   :85.29   Max.   :36.640   Max.   : 58.213   Max.   :103.98  
##     STUNTING           PPH              NCPR        
##  Min.   :-3.749   Min.   : 50.77   Min.   :-7.5410  
##  1st Qu.:17.964   1st Qu.: 79.35   1st Qu.: 0.8415  
##  Median :23.814   Median : 84.72   Median : 3.1102  
##  Mean   :24.402   Mean   : 84.31   Mean   : 3.2973  
##  3rd Qu.:31.197   3rd Qu.: 90.40   3rd Qu.: 5.9200  
##  Max.   :62.467   Max.   :111.10   Max.   :15.9176
boxplot(ds[, -1])

## Pencilan IKP pada data simulasi (seperti pertemuan 11)
bxy = boxplot(ds$IKP)

QX  = bxy$stats[4] - bxy$stats[2]      # IQR = Q3 - Q1
ba  = bxy$stats[4] + 1.5 * QX          # batas atas
bb  = bxy$stats[2] - 1.5 * QX          # batas bawah

ggplot(ds) +
  geom_point(aes(x = c(1:n), y = IKP)) +
  geom_line(aes(x = c(1:n), y = bb), color = 'red', linetype = 2) +
  geom_line(aes(x = c(1:n), y = ba), color = 'red', linetype = 2) +
  labs(x = "kabupaten/kota", y = "IKP")

#===============================================================================
# 3. MODEL LMM
#===============================================================================
m.lmm = lmer(model, data = ds)
# summary(m.lmm)   # aktifkan jika paket sudah diperbarui (error as_dpoMatrix)
fixef(m.lmm)          # koefisien regresi
## (Intercept)      MISKIN         POU      TNPAIR    STUNTING         PPH 
## 61.40879185 -0.33040408 -0.22942204 -0.08583039 -0.12317858  0.22559455 
##        NCPR 
## -0.74215395
VarCorr(m.lmm)        # varian efek acak provinsi
##  Groups   Name        Std.Dev.
##  Provinsi (Intercept) 2.5829  
##  Residual             7.2601
sigma(m.lmm)^2        # varian error
## [1] 52.70925
model.val(ds$IKP, fitted(m.lmm))
##        MSE     RMSE        R2
## 1 49.79051 7.056239 0.4526812
## Uji asumsi LMM
shapiro.test(resid(m.lmm))                       # normalitas residual
## 
##  Shapiro-Wilk normality test
## 
## data:  resid(m.lmm)
## W = 0.7171, p-value < 2.2e-16
qqnorm(resid(m.lmm)); qqline(resid(m.lmm), col = "red")

shapiro.test(ranef(m.lmm)$Provinsi[, 1])          # normalitas efek acak
## 
##  Shapiro-Wilk normality test
## 
## data:  ranef(m.lmm)$Provinsi[, 1]
## W = 0.96704, p-value = 0.3184
plot(fitted(m.lmm), resid(m.lmm), xlab = "Nilai dugaan", ylab = "Residual")
abline(h = 0, col = "red", lty = 2)               # homoskedastisitas

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
## Registered S3 method overwritten by 'car':
##   method           from
##   na.action.merMod lme4
vif(lm(IKP ~ MISKIN + POU + TNPAIR + STUNTING + PPH + NCPR, data = ds))  # multikolinearitas
##   MISKIN      POU   TNPAIR STUNTING      PPH     NCPR 
## 1.001739 1.012006 1.011688 1.002340 1.006749 1.006555
#===============================================================================
# 4. MODEL ROBUST LMM
#===============================================================================
m.rlmm = rlmer(model, data = ds)
# summary(m.rlmm)   # aktifkan jika paket sudah diperbarui (error as_dpoMatrix)
fixef(m.rlmm)          # koefisien regresi
## (Intercept)      MISKIN         POU      TNPAIR    STUNTING         PPH 
## 55.66642304 -0.41986612 -0.22413873 -0.08189099 -0.10933257  0.31457654 
##        NCPR 
## -0.73682844
VarCorr(m.rlmm)        # varian efek acak provinsi
##  Groups   Name        Std.Dev.
##  Provinsi (Intercept) 2.4236  
##  Residual             3.4175
sigma(m.rlmm)^2        # varian error
## [1] 11.67964
model.val(ds$IKP, fitted(m.rlmm))
##       MSE    RMSE        R2
## 1 53.5262 7.31616 0.4116168
#===============================================================================
# 5. SIMULASI MONTE CARLO
#===============================================================================
simulasi = function(nsim){
  mat.lmm  = matrix(nrow = nsim, ncol = length(parameter))
  mat.rlmm = matrix(nrow = nsim, ncol = length(parameter))
  val.lmm  = matrix(nrow = nsim, ncol = 3)    # MSE, RMSE, R2
  val.rlmm = matrix(nrow = nsim, ncol = 3)
  
  for (i in 1:nsim) {
    set.seed(i)
    message("=> proses: ", round(i/nsim*100, 2), "%")
    
    ds.tmp = bangkit.data()
    m1 = lmer(model, data = ds.tmp)    # LMM
    m2 = rlmer(model, data = ds.tmp)   # Robust LMM
    
    mat.lmm[i, ]  = c(fixef(m1), as.numeric(VarCorr(m1)$Provinsi), sigma(m1)^2)
    mat.rlmm[i, ] = c(fixef(m2), as.numeric(VarCorr(m2)$Provinsi), sigma(m2)^2)
    
    val.lmm[i, ]  = as.numeric(model.val(ds.tmp$IKP, fitted(m1)))
    val.rlmm[i, ] = as.numeric(model.val(ds.tmp$IKP, fitted(m2)))
  }
  
  colnames(mat.lmm)  = names(parameter)
  colnames(mat.rlmm) = names(parameter)
  colnames(val.lmm)  = c("MSE", "RMSE", "R2")
  colnames(val.rlmm) = c("MSE", "RMSE", "R2")
  return(list(LMM = mat.lmm, RLMM = mat.rlmm, val.LMM = val.lmm, val.RLMM = val.rlmm))
}

nsim = 500   # coba dulu dengan nsim = 5

sim = simulasi(nsim)
## => proses: 0.2%
## => proses: 0.4%
## => proses: 0.6%
## => proses: 0.8%
## => proses: 1%
## => proses: 1.2%
## => proses: 1.4%
## => proses: 1.6%
## => proses: 1.8%
## => proses: 2%
## => proses: 2.2%
## => proses: 2.4%
## => proses: 2.6%
## => proses: 2.8%
## => proses: 3%
## => proses: 3.2%
## => proses: 3.4%
## => proses: 3.6%
## => proses: 3.8%
## => proses: 4%
## => proses: 4.2%
## => proses: 4.4%
## => proses: 4.6%
## => proses: 4.8%
## => proses: 5%
## => proses: 5.2%
## => proses: 5.4%
## => proses: 5.6%
## => proses: 5.8%
## => proses: 6%
## => proses: 6.2%
## => proses: 6.4%
## => proses: 6.6%
## => proses: 6.8%
## => proses: 7%
## => proses: 7.2%
## => proses: 7.4%
## => proses: 7.6%
## => proses: 7.8%
## => proses: 8%
## => proses: 8.2%
## => proses: 8.4%
## => proses: 8.6%
## => proses: 8.8%
## => proses: 9%
## => proses: 9.2%
## => proses: 9.4%
## => proses: 9.6%
## => proses: 9.8%
## => proses: 10%
## => proses: 10.2%
## => proses: 10.4%
## => proses: 10.6%
## => proses: 10.8%
## => proses: 11%
## => proses: 11.2%
## => proses: 11.4%
## => proses: 11.6%
## => proses: 11.8%
## => proses: 12%
## => proses: 12.2%
## => proses: 12.4%
## => proses: 12.6%
## => proses: 12.8%
## => proses: 13%
## => proses: 13.2%
## => proses: 13.4%
## => proses: 13.6%
## => proses: 13.8%
## => proses: 14%
## => proses: 14.2%
## => proses: 14.4%
## => proses: 14.6%
## => proses: 14.8%
## => proses: 15%
## => proses: 15.2%
## => proses: 15.4%
## => proses: 15.6%
## => proses: 15.8%
## => proses: 16%
## => proses: 16.2%
## => proses: 16.4%
## => proses: 16.6%
## => proses: 16.8%
## => proses: 17%
## => proses: 17.2%
## => proses: 17.4%
## => proses: 17.6%
## => proses: 17.8%
## => proses: 18%
## => proses: 18.2%
## => proses: 18.4%
## => proses: 18.6%
## => proses: 18.8%
## => proses: 19%
## => proses: 19.2%
## => proses: 19.4%
## => proses: 19.6%
## => proses: 19.8%
## => proses: 20%
## => proses: 20.2%
## => proses: 20.4%
## => proses: 20.6%
## => proses: 20.8%
## => proses: 21%
## => proses: 21.2%
## => proses: 21.4%
## => proses: 21.6%
## => proses: 21.8%
## => proses: 22%
## => proses: 22.2%
## => proses: 22.4%
## => proses: 22.6%
## => proses: 22.8%
## => proses: 23%
## => proses: 23.2%
## => proses: 23.4%
## => proses: 23.6%
## => proses: 23.8%
## => proses: 24%
## => proses: 24.2%
## => proses: 24.4%
## => proses: 24.6%
## => proses: 24.8%
## => proses: 25%
## => proses: 25.2%
## => proses: 25.4%
## => proses: 25.6%
## => proses: 25.8%
## => proses: 26%
## => proses: 26.2%
## => proses: 26.4%
## => proses: 26.6%
## => proses: 26.8%
## => proses: 27%
## => proses: 27.2%
## => proses: 27.4%
## => proses: 27.6%
## => proses: 27.8%
## => proses: 28%
## => proses: 28.2%
## => proses: 28.4%
## => proses: 28.6%
## => proses: 28.8%
## => proses: 29%
## => proses: 29.2%
## => proses: 29.4%
## => proses: 29.6%
## => proses: 29.8%
## => proses: 30%
## => proses: 30.2%
## => proses: 30.4%
## => proses: 30.6%
## => proses: 30.8%
## => proses: 31%
## => proses: 31.2%
## => proses: 31.4%
## => proses: 31.6%
## => proses: 31.8%
## => proses: 32%
## => proses: 32.2%
## => proses: 32.4%
## => proses: 32.6%
## => proses: 32.8%
## boundary (singular) fit: see help('isSingular')
## boundary (singular) fit: see help('isSingular')
## => proses: 33%
## => proses: 33.2%
## => proses: 33.4%
## => proses: 33.6%
## => proses: 33.8%
## => proses: 34%
## => proses: 34.2%
## => proses: 34.4%
## => proses: 34.6%
## => proses: 34.8%
## => proses: 35%
## => proses: 35.2%
## => proses: 35.4%
## => proses: 35.6%
## => proses: 35.8%
## => proses: 36%
## => proses: 36.2%
## => proses: 36.4%
## => proses: 36.6%
## => proses: 36.8%
## => proses: 37%
## => proses: 37.2%
## => proses: 37.4%
## => proses: 37.6%
## => proses: 37.8%
## => proses: 38%
## => proses: 38.2%
## => proses: 38.4%
## => proses: 38.6%
## => proses: 38.8%
## => proses: 39%
## => proses: 39.2%
## => proses: 39.4%
## => proses: 39.6%
## => proses: 39.8%
## => proses: 40%
## => proses: 40.2%
## => proses: 40.4%
## => proses: 40.6%
## => proses: 40.8%
## => proses: 41%
## => proses: 41.2%
## => proses: 41.4%
## => proses: 41.6%
## => proses: 41.8%
## => proses: 42%
## => proses: 42.2%
## => proses: 42.4%
## => proses: 42.6%
## => proses: 42.8%
## => proses: 43%
## => proses: 43.2%
## => proses: 43.4%
## => proses: 43.6%
## => proses: 43.8%
## => proses: 44%
## => proses: 44.2%
## => proses: 44.4%
## => proses: 44.6%
## => proses: 44.8%
## => proses: 45%
## => proses: 45.2%
## => proses: 45.4%
## => proses: 45.6%
## => proses: 45.8%
## => proses: 46%
## => proses: 46.2%
## => proses: 46.4%
## => proses: 46.6%
## => proses: 46.8%
## => proses: 47%
## => proses: 47.2%
## => proses: 47.4%
## => proses: 47.6%
## => proses: 47.8%
## => proses: 48%
## => proses: 48.2%
## => proses: 48.4%
## => proses: 48.6%
## => proses: 48.8%
## => proses: 49%
## => proses: 49.2%
## => proses: 49.4%
## => proses: 49.6%
## => proses: 49.8%
## => proses: 50%
## => proses: 50.2%
## => proses: 50.4%
## => proses: 50.6%
## => proses: 50.8%
## => proses: 51%
## => proses: 51.2%
## => proses: 51.4%
## => proses: 51.6%
## => proses: 51.8%
## => proses: 52%
## => proses: 52.2%
## => proses: 52.4%
## => proses: 52.6%
## => proses: 52.8%
## => proses: 53%
## => proses: 53.2%
## => proses: 53.4%
## => proses: 53.6%
## => proses: 53.8%
## => proses: 54%
## => proses: 54.2%
## => proses: 54.4%
## => proses: 54.6%
## => proses: 54.8%
## => proses: 55%
## => proses: 55.2%
## => proses: 55.4%
## => proses: 55.6%
## => proses: 55.8%
## => proses: 56%
## => proses: 56.2%
## => proses: 56.4%
## => proses: 56.6%
## => proses: 56.8%
## => proses: 57%
## => proses: 57.2%
## => proses: 57.4%
## => proses: 57.6%
## => proses: 57.8%
## => proses: 58%
## => proses: 58.2%
## => proses: 58.4%
## => proses: 58.6%
## => proses: 58.8%
## => proses: 59%
## => proses: 59.2%
## => proses: 59.4%
## boundary (singular) fit: see help('isSingular')
## boundary (singular) fit: see help('isSingular')
## => proses: 59.6%
## => proses: 59.8%
## => proses: 60%
## => proses: 60.2%
## => proses: 60.4%
## => proses: 60.6%
## => proses: 60.8%
## => proses: 61%
## => proses: 61.2%
## => proses: 61.4%
## boundary (singular) fit: see help('isSingular')
## boundary (singular) fit: see help('isSingular')
## => proses: 61.6%
## => proses: 61.8%
## => proses: 62%
## => proses: 62.2%
## => proses: 62.4%
## => proses: 62.6%
## => proses: 62.8%
## => proses: 63%
## => proses: 63.2%
## => proses: 63.4%
## => proses: 63.6%
## => proses: 63.8%
## => proses: 64%
## => proses: 64.2%
## => proses: 64.4%
## => proses: 64.6%
## => proses: 64.8%
## => proses: 65%
## => proses: 65.2%
## => proses: 65.4%
## => proses: 65.6%
## => proses: 65.8%
## => proses: 66%
## => proses: 66.2%
## => proses: 66.4%
## => proses: 66.6%
## => proses: 66.8%
## => proses: 67%
## => proses: 67.2%
## => proses: 67.4%
## => proses: 67.6%
## => proses: 67.8%
## => proses: 68%
## => proses: 68.2%
## => proses: 68.4%
## => proses: 68.6%
## => proses: 68.8%
## => proses: 69%
## => proses: 69.2%
## => proses: 69.4%
## => proses: 69.6%
## => proses: 69.8%
## => proses: 70%
## => proses: 70.2%
## => proses: 70.4%
## => proses: 70.6%
## => proses: 70.8%
## => proses: 71%
## => proses: 71.2%
## => proses: 71.4%
## => proses: 71.6%
## => proses: 71.8%
## => proses: 72%
## => proses: 72.2%
## => proses: 72.4%
## => proses: 72.6%
## => proses: 72.8%
## => proses: 73%
## => proses: 73.2%
## => proses: 73.4%
## => proses: 73.6%
## => proses: 73.8%
## => proses: 74%
## => proses: 74.2%
## => proses: 74.4%
## => proses: 74.6%
## => proses: 74.8%
## => proses: 75%
## => proses: 75.2%
## => proses: 75.4%
## => proses: 75.6%
## => proses: 75.8%
## => proses: 76%
## => proses: 76.2%
## => proses: 76.4%
## => proses: 76.6%
## => proses: 76.8%
## => proses: 77%
## => proses: 77.2%
## => proses: 77.4%
## => proses: 77.6%
## => proses: 77.8%
## => proses: 78%
## => proses: 78.2%
## => proses: 78.4%
## => proses: 78.6%
## => proses: 78.8%
## => proses: 79%
## => proses: 79.2%
## => proses: 79.4%
## => proses: 79.6%
## => proses: 79.8%
## => proses: 80%
## => proses: 80.2%
## => proses: 80.4%
## => proses: 80.6%
## => proses: 80.8%
## => proses: 81%
## => proses: 81.2%
## => proses: 81.4%
## => proses: 81.6%
## => proses: 81.8%
## => proses: 82%
## => proses: 82.2%
## => proses: 82.4%
## => proses: 82.6%
## => proses: 82.8%
## => proses: 83%
## => proses: 83.2%
## => proses: 83.4%
## => proses: 83.6%
## => proses: 83.8%
## => proses: 84%
## => proses: 84.2%
## => proses: 84.4%
## => proses: 84.6%
## => proses: 84.8%
## => proses: 85%
## => proses: 85.2%
## => proses: 85.4%
## => proses: 85.6%
## => proses: 85.8%
## => proses: 86%
## => proses: 86.2%
## => proses: 86.4%
## => proses: 86.6%
## => proses: 86.8%
## => proses: 87%
## => proses: 87.2%
## => proses: 87.4%
## => proses: 87.6%
## => proses: 87.8%
## => proses: 88%
## => proses: 88.2%
## => proses: 88.4%
## => proses: 88.6%
## => proses: 88.8%
## => proses: 89%
## => proses: 89.2%
## => proses: 89.4%
## => proses: 89.6%
## => proses: 89.8%
## => proses: 90%
## => proses: 90.2%
## => proses: 90.4%
## => proses: 90.6%
## => proses: 90.8%
## => proses: 91%
## => proses: 91.2%
## => proses: 91.4%
## => proses: 91.6%
## => proses: 91.8%
## => proses: 92%
## => proses: 92.2%
## => proses: 92.4%
## => proses: 92.6%
## => proses: 92.8%
## => proses: 93%
## => proses: 93.2%
## => proses: 93.4%
## => proses: 93.6%
## => proses: 93.8%
## boundary (singular) fit: see help('isSingular')
## boundary (singular) fit: see help('isSingular')
## => proses: 94%
## => proses: 94.2%
## => proses: 94.4%
## => proses: 94.6%
## => proses: 94.8%
## => proses: 95%
## => proses: 95.2%
## => proses: 95.4%
## => proses: 95.6%
## => proses: 95.8%
## => proses: 96%
## => proses: 96.2%
## => proses: 96.4%
## => proses: 96.6%
## => proses: 96.8%
## => proses: 97%
## => proses: 97.2%
## => proses: 97.4%
## => proses: 97.6%
## => proses: 97.8%
## => proses: 98%
## => proses: 98.2%
## => proses: 98.4%
## => proses: 98.6%
## => proses: 98.8%
## => proses: 99%
## => proses: 99.2%
## => proses: 99.4%
## => proses: 99.6%
## => proses: 99.8%
## => proses: 100%
## Visualisasi simulasi Monte Carlo 
df.plot = data.frame(
  simulasi  = rep(1:nsim, times = 2 * length(parameter)),
  parameter = rep(rep(names(parameter), each = nsim), times = 2),
  model     = rep(c("LMM", "Robust LMM"), each = nsim * length(parameter)),
  estimasi  = c(as.vector(sim$LMM), as.vector(sim$RLMM))
)
df.asli = data.frame(parameter = names(parameter), asli = parameter)

# urutan panel sesuai urutan parameter
df.plot$parameter = factor(df.plot$parameter, levels = names(parameter))
df.asli$parameter = factor(df.asli$parameter, levels = names(parameter))

ggplot(df.plot) +
  geom_line(aes(x = simulasi, y = estimasi, color = model), alpha = 0.7) +
  geom_hline(data = df.asli, aes(yintercept = asli), linetype = 2) +
  facet_wrap(~ parameter, scales = "free_y", ncol = 3) +
  labs(x = "simulasi", y = "nilai estimasi", colour = "Model") +
  theme_minimal() -> plot.semua
plot.semua

png("hasil simulasi semua parameter.png", width = 3600, height = 3000, res = 300)
plot.semua
dev.off()
## png 
##   2
#===============================================================================
# 6. EVALUASI MODEL
#===============================================================================
evaluasi = function(mat){
  asli    = matrix(parameter, nrow = nrow(mat), ncol = length(parameter), byrow = TRUE)
  rata2   = colMeans(mat)
  bias    = rata2 - parameter
  varians = apply(mat, 2, var)
  MSE     = colMeans((mat - asli)^2)
  RMSE    = sqrt(MSE)
  hasil = data.frame(asli = parameter, rata2 = rata2, bias = bias,
                     varians = varians, MSE = MSE, RMSE = RMSE)
  return(round(hasil, 4))
}

## (a) Evaluasi parameter
evaluasi(sim$LMM)    # LMM
##               asli   rata2    bias varians       MSE    RMSE
## b0         53.2944 52.5750 -0.7193 11.3341   11.8288  3.4393
## b_MISKIN   -0.4045 -0.3747  0.0298  0.0014    0.0023  0.0480
## b_POU      -0.2322 -0.2159  0.0163  0.0008    0.0011  0.0331
## b_TNPAIR   -0.0891 -0.0814  0.0077  0.0002    0.0003  0.0166
## b_STUNTING -0.1009 -0.0954  0.0056  0.0012    0.0012  0.0354
## b_PPH       0.3490  0.3226 -0.0264  0.0014    0.0021  0.0455
## b_NCPR     -0.7170 -0.6646  0.0524  0.0092    0.0119  0.1091
## var_random  4.5974  3.8521 -0.7452  4.0674    4.6146  2.1482
## var_error   8.9913 57.4858 48.4945 29.7707 2381.4291 48.7999
evaluasi(sim$RLMM)   # Robust LMM
##               asli   rata2    bias varians     MSE   RMSE
## b0         53.2944 52.8928 -0.4015  2.7541  2.9098 1.7058
## b_MISKIN   -0.4045 -0.4029  0.0016  0.0004  0.0004 0.0190
## b_POU      -0.2322 -0.2316  0.0005  0.0002  0.0002 0.0137
## b_TNPAIR   -0.0891 -0.0883  0.0007  0.0001  0.0001 0.0074
## b_STUNTING -0.1009 -0.1017 -0.0008  0.0003  0.0003 0.0171
## b_PPH       0.3490  0.3480 -0.0009  0.0003  0.0003 0.0178
## b_NCPR     -0.7170 -0.7137  0.0034  0.0023  0.0023 0.0479
## var_random  4.5974  4.4557 -0.1417  2.3499  2.3653 1.5379
## var_error   8.9913 12.5438  3.5526  0.9140 13.5330 3.6787
## (b) Evaluasi antar model : rata-rata 500 replikasi
validasi = rbind(
  LMM  = colMeans(sim$val.LMM),
  RLMM = colMeans(sim$val.RLMM)
)
round(validasi, 4)
##          MSE   RMSE     R2
## LMM  55.0450 7.4101 0.4351
## RLMM 57.4829 7.5726 0.4101
#===============================================================================
# 7. PEMILIHAN MODEL TERBAIK
#===============================================================================
# Model terbaik = model dengan RMSE lebih kecil
pilih.model = function(sim){
  e1 = evaluasi(sim$LMM)
  e2 = evaluasi(sim$RLMM)
  hasil = data.frame(RMSE.LMM  = e1$RMSE,
                     RMSE.RLMM = e2$RMSE,
                     terbaik   = ifelse(e2$RMSE < e1$RMSE, "Robust LMM", "LMM"),
                     row.names = names(parameter))
  return(hasil)
}