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