Data Collection;

https://www.bps.go.id/id/statistics-table/2/MjE2MCMy/-metode-baru--aspek-indeks-demokrasi-indonesia--idi--menurut-provinsi.html

Data Frame;

library(readxl)
aspectdemocration <-read_xlsx("/Users/mymac/Downloads/aspectdemocration.xlsx")

View Data Frame;

library(knitr)
kable(aspectdemocration)
Province Label Index
1 West Nusa Tenggara 64.49
2 Jambi 65.28
3 North Maluku 65.58
4 Bangka Belitung Island 68.34
5 Maluku 70.55
6 Southeast Sulawesi 71.72
7 West Sumatera 72.15
8 West Papua 72.89
9 Lampung 73.79
10 Bengkulu 74.62
11 West Sulawesi 74.87
12 Special of Region Yogyakarta 77.76
13 North Sulawesi 78.15
14 Riau 79.39
15 Riau Island 79.72
16 Papua 79.98
17 South Sumatera 80.94
18 South Kalimantan 81.40
19 Gorontalo 81.68
20 South Sulawesi 81.70
21 Centra Kalimantan 82.01
22 East Kalimantan 83.00
23 Banten 83.11
24 North Sumatera 83.12
25 North Kalimantan 84.59
26 Bali 85.23
27 Aceh 85.71
28 Central Tengah 85.84
29 Central Sulawesi 87.11
30 East Java 87.29
31 West Java 87.97
32 East Nusa Tenggara 90.05
33 Special of Capital City Jakarta 90.66
34 West Kalimantan 92.16

Create Data Graph;

library(ggplot2)
library(ggrepel)
ggplot(aspectdemocration, aes(x = Province, y = Index)) + 
  geom_point(color = "white", size = 1) +
  geom_text_repel(aes(label = Label),  
                  color = "black", 
                  size = 3.5,
                  max.overlaps = 30) + 
  labs(title = "Index Democracy Province in Indonesia 2023",
       subtitle = "Source: Indonesian Democracy Index (IDI) and Central Statistics Agency",
       x = "Province",
       y = "Index") + 
  ylim(min(aspectdemocration$Index) - 10, max(aspectdemocration$Index) + 10) +
  theme(plot.title = element_text(face="bold")) +
  theme_bw()

Interpretation Data;

Shows that this graph analyzes the Indonesian Province Democracy Index in 2023, the data of which comes from the Indonesian Democracy Index (IDI) and the Central Statistics Agency.

Interpretation of Index Values Provinces with High Index; Provinces such as “West Kalimantan”, “Special of Capital City Jakarta”, and “East Nusa Tenggara” have a high democracy index (above 100), indicating a better quality of democracy compared to other provinces.

Provinces with Low Index; Provinces such as “West Nusa Tenggara”, “Jambi”, and “North Maluku” have a lower index (below 70), indicating a relatively lower quality of democracy.

Distribution of Democracy: This graph shows the distribution of the Democracy Index across provinces in Indonesia, where most provinces have index values ​​between 60 and 100. Provinces with an index above 100 stand out in terms of the quality of democracy, while provinces with values ​​below 70 may need more attention in terms of democracy development.