library (readxl)
## Warning: package 'readxl' was built under R version 4.3.2
library (ggplot2)
## Warning: package 'ggplot2' was built under R version 4.3.2
data <- read_xlsx("C:\\Users\\ade\\Downloads\\Data Tugas 1 AED.xlsx")
data
## # A tibble: 13 × 5
##    Provinsi           `Februari 2022` `Agustus 2022` Pulau      rataan
##    <chr>                        <dbl>          <dbl> <chr>       <dbl>
##  1 SUMATERA UTARA                5.47           6.16 Sumatera     5.82
##  2 SUMATERA BARAT                6.17           6.28 Sumatera     6.22
##  3 SUMATERA SELATAN              4.74           4.63 Sumatera     4.69
##  4 KALIMANTAN BARAT              4.86           5.11 Kalimantan   4.99
##  5 KALIMANTAN TENGAH             4.2            4.26 Kalimantan   4.23
##  6 KALIMANTAN SELATAN            4.2            4.74 Kalimantan   4.47
##  7 KALIMANTAN TIMUR              6.77           5.71 Kalimantan   6.24
##  8 KALIMANTAN UTARA              4.62           4.33 Kalimantan   4.47
##  9 SULAWESI UTARA                6.51           6.61 Sulawesi     6.56
## 10 SULAWESI TENGAH               3.67           3    Sulawesi     3.34
## 11 SULAWESI SELATAN              5.75           4.51 Sulawesi     5.13
## 12 SULAWESI TENGGARA             3.86           3.36 Sulawesi     3.61
## 13 SULAWESI BARAT                3.11           2.34 Sulawesi     2.72
View (data)
bar <- read_xlsx("C:\\Users\\ade\\Downloads\\Data Tugas 1 AED.xlsx", sheet="bar")
bar
## # A tibble: 3 × 2
##   Prov       rataan
##   <chr>       <dbl>
## 1 Sumatera     5.58
## 2 Kalimantan   4.88
## 3 Sulawesi     4.27
View (bar)

BOXPLOT FEBRUARI 2022

ggplot(data, aes(x = Pulau, y = `Februari 2022`, color = Pulau)) +
  geom_boxplot() +
  geom_jitter(alpha = 0.5) +
  theme_minimal() + 
  labs(x = NULL, y = "Tingkat Pengangguran Terbuka Indonesia", caption = "Februari 2022") +
  scale_x_discrete(limits = rev(levels(data$Pulau))) + 
  theme(plot.caption = element_text(hjust = 1.2))

BOXPLOT AGUSTUS 2022

ggplot(data, aes(x = Pulau, y = `Agustus 2022`, color = Pulau)) +
  geom_boxplot() +
  geom_jitter(alpha = 0.5) +
  theme_minimal() + 
  labs(x = NULL, y = "Tingkat Pengangguran Terbuka Indonesia",caption = "Agustus 2022") + 
  scale_x_discrete(limits = rev(levels(data$Pulau))) +
  theme(plot.caption = element_text(hjust = 1.2))

MEMBUAT DATA SETIAP PROVINSI

data1 <- data [-(4:13),-3]
data2 <- data [-(1:3),-3]
data3 <- data2 [-(6:10),] 
data4 <- data2 [-(1:5),]
data5 <- data [-(4:13),-2]
data6 <- data [-(1:3),-2]
data7 <- data6 [-(6:10),] 
data8 <- data6 [-(1:5),]
View (data1)
View (data2)
View (data3)
View (data4)
View (data5)
View (data6)
View (data7)
View (data8)

SUMMARY TIAP PROVINSI

summary (data1)
##    Provinsi         Februari 2022      Pulau               rataan     
##  Length:3           Min.   :4.740   Length:3           Min.   :4.685  
##  Class :character   1st Qu.:5.105   Class :character   1st Qu.:5.250  
##  Mode  :character   Median :5.470   Mode  :character   Median :5.815  
##                     Mean   :5.460                      Mean   :5.575  
##                     3rd Qu.:5.820                      3rd Qu.:6.020  
##                     Max.   :6.170                      Max.   :6.225
summary (data3)
##    Provinsi         Februari 2022     Pulau               rataan     
##  Length:5           Min.   :4.20   Length:5           Min.   :4.230  
##  Class :character   1st Qu.:4.20   Class :character   1st Qu.:4.470  
##  Mode  :character   Median :4.62   Mode  :character   Median :4.475  
##                     Mean   :4.93                      Mean   :4.880  
##                     3rd Qu.:4.86                      3rd Qu.:4.985  
##                     Max.   :6.77                      Max.   :6.240
summary (data4)
##    Provinsi         Februari 2022     Pulau               rataan     
##  Length:5           Min.   :3.11   Length:5           Min.   :2.725  
##  Class :character   1st Qu.:3.67   Class :character   1st Qu.:3.335  
##  Mode  :character   Median :3.86   Mode  :character   Median :3.610  
##                     Mean   :4.58                      Mean   :4.272  
##                     3rd Qu.:5.75                      3rd Qu.:5.130  
##                     Max.   :6.51                      Max.   :6.560
summary (data5)
##    Provinsi          Agustus 2022      Pulau               rataan     
##  Length:3           Min.   :4.630   Length:3           Min.   :4.685  
##  Class :character   1st Qu.:5.395   Class :character   1st Qu.:5.250  
##  Mode  :character   Median :6.160   Mode  :character   Median :5.815  
##                     Mean   :5.690                      Mean   :5.575  
##                     3rd Qu.:6.220                      3rd Qu.:6.020  
##                     Max.   :6.280                      Max.   :6.225
summary (data7)
##    Provinsi          Agustus 2022     Pulau               rataan     
##  Length:5           Min.   :4.26   Length:5           Min.   :4.230  
##  Class :character   1st Qu.:4.33   Class :character   1st Qu.:4.470  
##  Mode  :character   Median :4.74   Mode  :character   Median :4.475  
##                     Mean   :4.83                      Mean   :4.880  
##                     3rd Qu.:5.11                      3rd Qu.:4.985  
##                     Max.   :5.71                      Max.   :6.240
summary (data8)
##    Provinsi          Agustus 2022      Pulau               rataan     
##  Length:5           Min.   :2.340   Length:5           Min.   :2.725  
##  Class :character   1st Qu.:3.000   Class :character   1st Qu.:3.335  
##  Mode  :character   Median :3.360   Mode  :character   Median :3.610  
##                     Mean   :3.964                      Mean   :4.272  
##                     3rd Qu.:4.510                      3rd Qu.:5.130  
##                     Max.   :6.610                      Max.   :6.560

BARCHART

library(ggplot2)
ggplot(bar,
       aes(x = `rataan`, y = `Prov`, fill = Prov)) + 
  geom_bar(stat = "identity") +
  theme_minimal() +
  theme(axis.text.x = element_text(angle = 0, vjust = 0.5, hjust = 0.5),
        plot.title = element_text(hjust = 0.5)) +
  labs(x = "Rata-rata", y = "Provinsi", 
       title = "Barchart Tingkat Pengangguran Terbuka Tahun 2022") +
  scale_fill_manual(values = c("#1f77b4", "#008080", "#8c564b"))