#package
library(caret)
## Warning: package 'caret' was built under R version 4.2.3
## Loading required package: ggplot2
## Warning: package 'ggplot2' was built under R version 4.2.3
## Loading required package: lattice
library(readxl)
## Warning: package 'readxl' was built under R version 4.2.3
library(MASS)
## Warning: package 'MASS' was built under R version 4.2.3
library(tidyverse)
## Warning: package 'tidyverse' was built under R version 4.2.3
## Warning: package 'tidyr' was built under R version 4.2.3
## Warning: package 'readr' was built under R version 4.2.3
## Warning: package 'purrr' was built under R version 4.2.3
## Warning: package 'stringr' was built under R version 4.2.3
## Warning: package 'forcats' was built under R version 4.2.3
## Warning: package 'lubridate' was built under R version 4.2.3
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.0.10 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ lubridate 1.9.2 ✔ tibble 3.1.8
## ✔ purrr 1.0.1 ✔ tidyr 1.3.0
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ✖ purrr::lift() masks caret::lift()
## ✖ dplyr::select() masks MASS::select()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
#input
data_pendapatan<-read_xlsx("E:/kuliah/SMT 4/analisis data kualitatif/latihan/reg log ordinal/prak 1/Data Latihan.xlsx", sheet="Pendapatan")
head(data_pendapatan)
#merubah variabel ke faktor
data_pendapatan$Pendidikan<- as.factor(data_pendapatan$Pendidikan)
data_pendapatan$Klasifikasi.Daerah<- as.factor(data_pendapatan$Klasifikasi.Daerah)
data_pendapatan$Jenis.Kelamin<-as.factor(data_pendapatan$Jenis.Kelamin)
data_pendapatan$Status.KRT<-as.factor(data_pendapatan$Status.KRT)
data_pendapatan$Status.Perkawinan<-as.factor(data_pendapatan$Status.Perkawinan)
data_pendapatan$Pendapatan<-as.factor(data_pendapatan$Pendapatan)
library(arsenal)
## Warning: package 'arsenal' was built under R version 4.2.3
##
## Attaching package: 'arsenal'
## The following object is masked from 'package:lubridate':
##
## is.Date
tab<-tableby(Pendapatan~ .,data=data_pendapatan)
summary(tab,text=TRUE)
##
##
## | | 1 (N=279) | 2 (N=568) | 3 (N=133) | 4 (N=20) | Total (N=1000) | p value|
## |:------------------|:---------------:|:---------------:|:---------------:|:---------------:|:---------------:|-------:|
## |Pendidikan | | | | | | < 0.001|
## |- 0 | 268 (96.1%) | 524 (92.3%) | 74 (55.6%) | 8 (40.0%) | 874 (87.4%) | |
## |- 1 | 11 (3.9%) | 44 (7.7%) | 59 (44.4%) | 12 (60.0%) | 126 (12.6%) | |
## |Klasifikasi.Daerah | | | | | | < 0.001|
## |- 0 | 66 (23.7%) | 128 (22.5%) | 2 (1.5%) | 0 (0.0%) | 196 (19.6%) | |
## |- 1 | 213 (76.3%) | 440 (77.5%) | 131 (98.5%) | 20 (100.0%) | 804 (80.4%) | |
## |Jenis.Kelamin | | | | | | < 0.001|
## |- 0 | 132 (47.3%) | 128 (22.5%) | 45 (33.8%) | 4 (20.0%) | 309 (30.9%) | |
## |- 1 | 147 (52.7%) | 440 (77.5%) | 88 (66.2%) | 16 (80.0%) | 691 (69.1%) | |
## |Status.KRT | | | | | | < 0.001|
## |- 0 | 141 (50.5%) | 208 (36.6%) | 54 (40.6%) | 4 (20.0%) | 407 (40.7%) | |
## |- 1 | 138 (49.5%) | 360 (63.4%) | 79 (59.4%) | 16 (80.0%) | 593 (59.3%) | |
## |Usia | | | | | | < 0.001|
## |- Mean (SD) | 42.957 (14.304) | 38.165 (12.304) | 39.910 (10.340) | 46.000 (5.554) | 39.891 (12.753) | |
## |- Range | 15.000 - 80.000 | 14.000 - 78.000 | 19.000 - 66.000 | 37.000 - 56.000 | 14.000 - 80.000 | |
## |Status.Perkawinan | | | | | | 0.007|
## |- 0 | 91 (32.6%) | 138 (24.3%) | 32 (24.1%) | 1 (5.0%) | 262 (26.2%) | |
## |- 1 | 188 (67.4%) | 430 (75.7%) | 101 (75.9%) | 19 (95.0%) | 738 (73.8%) | |
set.seed(123)
acak<-createDataPartition(data_pendapatan$Pendapatan,p=0.8, list=FALSE)
data_train<-data_pendapatan[acak, ]
data_test<-data_pendapatan[-acak,]
str(data_train)
## tibble [802 × 7] (S3: tbl_df/tbl/data.frame)
## $ Pendidikan : Factor w/ 2 levels "0","1": 1 1 1 1 1 1 1 1 1 1 ...
## $ Klasifikasi.Daerah: Factor w/ 2 levels "0","1": 1 1 1 2 2 2 2 2 2 2 ...
## $ Jenis.Kelamin : Factor w/ 2 levels "0","1": 2 2 2 2 2 2 2 2 2 1 ...
## $ Status.KRT : Factor w/ 2 levels "0","1": 2 2 2 2 1 1 2 1 2 1 ...
## $ Usia : num [1:802] 47 61 27 46 43 32 51 32 60 58 ...
## $ Status.Perkawinan : Factor w/ 2 levels "0","1": 2 2 2 2 1 1 2 1 2 2 ...
## $ Pendapatan : Factor w/ 4 levels "1","2","3","4": 2 1 2 4 1 1 2 1 2 1 ...
str(data_test)
## tibble [198 × 7] (S3: tbl_df/tbl/data.frame)
## $ Pendidikan : Factor w/ 2 levels "0","1": 1 2 1 1 1 1 1 1 1 1 ...
## $ Klasifikasi.Daerah: Factor w/ 2 levels "0","1": 1 1 1 2 2 2 2 2 2 2 ...
## $ Jenis.Kelamin : Factor w/ 2 levels "0","1": 2 1 2 2 1 2 1 2 2 1 ...
## $ Status.KRT : Factor w/ 2 levels "0","1": 2 1 2 2 1 1 1 2 2 2 ...
## $ Usia : num [1:198] 49 23 50 49 45 21 44 78 37 51 ...
## $ Status.Perkawinan : Factor w/ 2 levels "0","1": 2 1 2 2 2 1 2 2 2 1 ...
## $ Pendapatan : Factor w/ 4 levels "1","2","3","4": 2 2 2 1 1 3 2 2 1 1 ...
library(MASS)
model_pendapatan <- polr(Pendapatan~., method="logistic", data=data_train, Hess=T)
summary(model_pendapatan)
## Call:
## polr(formula = Pendapatan ~ ., data = data_train, Hess = T, method = "logistic")
##
## Coefficients:
## Value Std. Error t value
## Pendidikan1 2.52138 0.237066 10.636
## Klasifikasi.Daerah1 0.56414 0.175636 3.212
## Jenis.Kelamin1 0.54822 0.199061 2.754
## Status.KRT1 0.64226 0.212620 3.021
## Usia -0.03221 0.006865 -4.692
## Status.Perkawinan1 0.53006 0.180398 2.938
##
## Intercepts:
## Value Std. Error t value
## 1|2 -0.5217 0.3040 -1.7161
## 2|3 2.6805 0.3220 8.3249
## 3|4 5.1927 0.4173 12.4437
##
## Residual Deviance: 1454.495
## AIC: 1472.495
library(car)
## Warning: package 'car' was built under R version 4.2.3
## Loading required package: carData
## Warning: package 'carData' was built under R version 4.2.2
##
## Attaching package: 'car'
## The following object is masked from 'package:dplyr':
##
## recode
## The following object is masked from 'package:purrr':
##
## some
vif(model_pendapatan)
## Pendidikan Klasifikasi.Daerah Jenis.Kelamin Status.KRT
## 1.045494 1.026166 1.637565 2.146962
## Usia Status.Perkawinan
## 1.467146 1.279745
VIF < 10 tidak terjadi multikolinearitas
library(generalhoslem)
## Warning: package 'generalhoslem' was built under R version 4.2.3
## Loading required package: reshape
## Warning: package 'reshape' was built under R version 4.2.3
##
## Attaching package: 'reshape'
## The following object is masked from 'package:lubridate':
##
## stamp
## The following object is masked from 'package:dplyr':
##
## rename
## The following objects are masked from 'package:tidyr':
##
## expand, smiths
lipsitz.test(model_pendapatan)
##
## Lipsitz goodness of fit test for ordinal response models
##
## data: formula: Pendapatan ~ Pendidikan + Klasifikasi.Daerah + Jenis.Kelamin + formula: Status.KRT + Usia + Status.Perkawinan
## LR statistic = 25.252, df = 9, p-value = 0.002705
(misal alpha 5%) p-value = 0.002705 < 0,05 maka semua variabel signifikan terhadap respon(pendapatan)
library(lmtest)
## Warning: package 'lmtest' was built under R version 4.2.2
## Loading required package: zoo
## Warning: package 'zoo' was built under R version 4.2.2
##
## Attaching package: 'zoo'
## The following objects are masked from 'package:base':
##
## as.Date, as.Date.numeric
lrtest(model_pendapatan)
lrtest < 0,05 signifikan
coefmodel <- c(-model_pendapatan$coefficients)
koefisien <- coef(summary(model_pendapatan))
# Menghitung p-value
p <- pnorm(abs(koefisien[,"t value"]),lower.tail = FALSE)*2
(ctabel<-cbind <-cbind(round(koefisien,4),"p-value"=round(p,4)))
## Value Std. Error t value p-value
## Pendidikan1 2.5214 0.2371 10.6358 0.0000
## Klasifikasi.Daerah1 0.5641 0.1756 3.2120 0.0013
## Jenis.Kelamin1 0.5482 0.1991 2.7540 0.0059
## Status.KRT1 0.6423 0.2126 3.0207 0.0025
## Usia -0.0322 0.0069 -4.6924 0.0000
## Status.Perkawinan1 0.5301 0.1804 2.9383 0.0033
## 1|2 -0.5217 0.3040 -1.7161 0.0862
## 2|3 2.6805 0.3220 8.3249 0.0000
## 3|4 5.1927 0.4173 12.4437 0.0000
predict_prob=predict(model_pendapatan, data_test, type="prob")
head(predict_prob,10)
## 1 2 3 4
## 1 0.33989193 0.5869007 0.06684284 0.006364482
## 2 0.09094504 0.6200168 0.25712374 0.031914397
## 3 0.34715626 0.5817922 0.06488758 0.006163973
## 4 0.22654704 0.6515250 0.11079339 0.011134596
## 5 0.45852474 0.4956463 0.04194932 0.003879622
## 6 0.27736764 0.6268207 0.08729227 0.008519372
## 7 0.45053826 0.5022034 0.04325224 0.004006122
## 8 0.42708974 0.5211741 0.04733153 0.004404657
## 9 0.16596916 0.6643290 0.15339845 0.016303380
## 10 0.47871059 0.4788780 0.03883282 0.003578580
head(data.frame(predict_prob, data_test$Pendapatan), 20)
nilai akurasi model dalam melakukan prediksi 0.6111, artinya ketepatan model dalam melakukan prediksi sebesar 61.11%
library(caret)
prediksi.test <- predict(model_pendapatan, data_test, type="class")
data_test$Pendapatan<-as.factor(data_test$Pendapatan)
confusionMatrix(as.factor(prediksi.test), data_test$Pendapatan, positive="1")
## Confusion Matrix and Statistics
##
## Reference
## Prediction 1 2 3 4
## 1 11 2 0 0
## 2 43 107 23 2
## 3 1 4 3 2
## 4 0 0 0 0
##
## Overall Statistics
##
## Accuracy : 0.6111
## 95% CI : (0.5394, 0.6794)
## No Information Rate : 0.5707
## P-Value [Acc > NIR] : 0.1406
##
## Kappa : 0.1738
##
## Mcnemar's Test P-Value : NA
##
## Statistics by Class:
##
## Class: 1 Class: 2 Class: 3 Class: 4
## Sensitivity 0.20000 0.9469 0.11538 0.0000
## Specificity 0.98601 0.2000 0.95930 1.0000
## Pos Pred Value 0.84615 0.6114 0.30000 NaN
## Neg Pred Value 0.76216 0.7391 0.87766 0.9798
## Prevalence 0.27778 0.5707 0.13131 0.0202
## Detection Rate 0.05556 0.5404 0.01515 0.0000
## Detection Prevalence 0.06566 0.8838 0.05051 0.0000
## Balanced Accuracy 0.59301 0.5735 0.53734 0.5000
untuk interpretasi model, dilakukan dengan menghitung nilai odds ratio
data.frame(coef(model_pendapatan), exp(coef(model_pendapatan)))
Tingkat pendidikan, 12.44, Responden pendidikan tinggi memiliki peluang 12.44 kali lebih besar untuk mendapatkan pendapatan yang lebih tinggi dibandingkan lulusan SMA ke bawah.
Jenis kelamin, 1.73 Responden dengan jenis kelamin laki-laki memiliki peluang 1.73 kali lebih besar dibanding responden perempuan untuk mendapatkan pendapatan yang lebih besar.
Status perkawinan, 1.69 Responden dengan status yang sudah menikah memiliki peluang 1.69 kai lebih besar dibanding responden yang belum menikah untuk mendapatkan pendapatan yang lebih besar.