#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)

tabel

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%)   |        |

pembetukan model

Partisi data

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 ...

model

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

Uji asumsi

uji multicol

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

Uji GOF

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)

Uji Simultant

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

Partial test

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

Prediksi pada data test

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)

Confussion matrix

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

Odds ratio

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.