# MEMANGGIL DATASET & MERAPIKAN NAMA KOLOM
setwd("/Users/a1234/DATASET_PBL.csv")
DATASET_PBL <- read.csv("DATASET_PBL.csv")
colnames(DATASET_PBL)[4] <- "Konsumsi.telur.ayam.dan.telur.bebek"

# MENGHAPUS DATA TOTAL DAN DATA KOSONG
DATA_UJI <- subset(
  DATASET_PBL,
  !is.na(Provinsi) & Provinsi != "Total"
)

# Histogram Konsumsi Daging Sapi dan Kerbau
hist(
  x = DATA_UJI$Konsumsi.daging.sapi.dan.kerbau,
  col = "hotpink1",
  border = "ghostwhite",
  main = "Distribusi Total Konsumsi Daging Sapi dan Kerbau Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Konsumsi Daging Sapi dan Kerbau",
  ylab = "Provinsi",
  breaks = 10
)

# Histogram Konsumsi Daging Ayam
hist(
  x = DATA_UJI$Konsumsi.daging.ayam,
  col = "hotpink1",
  border = "ghostwhite",
  main = "Distribusi Total Konsumsi Daging Ayam Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Konsumsi Protein Hewani",
  ylab = "Provinsi",
  breaks = 33 
)

# Histogram Konsumsi Telur Ayam dan Telur Bebek
hist(
  x = DATA_UJI$Konsumsi.telur.ayam.dan.telur.bebek,
  col = "hotpink1",
  border = "ghostwhite",
  main = "Distribusi Total Konsumsi Telur Ayam dan Telur Bebek Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Konsumsi Protein Hewani",
  ylab = "Provinsi",
  breaks = 33 
)

# Histogram Konsumsi Ikan Segar
hist(
  x = DATA_UJI$Konsumsi.ikan.segar,
  col = "hotpink1",
  border = "ghostwhite",
  main = "Distribusi Total Konsumsi Ikan Segar Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Konsumsi Protein Hewani",
  ylab = "Provinsi",
  breaks = 33
)

# Bar Plot Konsumsi Daging Sapi dan Kerbau
par(mar = c(12, 4, 4, 2))
barplot(
  height = DATA_UJI$Konsumsi.daging.sapi.dan.kerbau,
  names.arg = DATA_UJI$Provinsi,
  col = "darkorchid4",
  main = "Distribusi Total Konsumsi Daging Sapi dan Kerbau Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Provinsi", 
  ylab = "Konsumsi daging sapi dan kerbau",
  las = 2,
  cex.names = 0.65,
  cex.axis = 0.8
)

par(mar = c(5,4,4,2))

# Bar Plot Konsumsi Daging Ayam
par(mar = c(12, 4, 4, 2))
barplot(
  height = DATA_UJI$Konsumsi.daging.ayam,
  names.arg = DATA_UJI$Provinsi,
  col = "darkorchid4",
  main = "Distribusi Total Konsumsi Daging Ayam Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Provinsi", 
  ylab = "Konsumsi Daging Ayam",
  las = 2,
  cex.names = 0.65,
  cex.axis = 0.8
)

par(mar = c(5,4,4,2))

# Bar Plot Konsumsi Telur Ayam dan Telur Bebek
par(mar = c(12, 4, 4, 2))
barplot(
  height = DATA_UJI$Konsumsi.telur.ayam.dan.telur.bebek,
  names.arg = DATA_UJI$Provinsi,
  col = "darkorchid4",
  main = "Distribusi Total Konsumsi Telur Ayam dan Telur Bebek Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Provinsi", 
  ylab = "Konsumsi Telur Ayam dan Telur Bebek",
  las = 2,
  cex.names = 0.65,
  cex.axis = 0.8
)

par(mar = c(5,4,4,2))

# Bar Plot Konsumsi Ikan Segar
par(mar = c(12, 4, 4, 2))
barplot(
  height = DATA_UJI$Konsumsi.ikan.segar,
  names.arg = DATA_UJI$Provinsi,
  col = "darkorchid4",
  main = "Distribusi Total Konsumsi Ikan Segar Per Kapita Per Tahun Menurut Provinsi (Ton) 2019",
  xlab = "Provinsi", 
  ylab = "Konsumsi Ikan Segar",
  las = 2,
  cex.names = 0.65,
  cex.axis = 0.8
)

par(mar = c(5,4,4,2))

# GGPLOT BOXPLOT
library(ggplot2)
library(tidyr)
library(dplyr)

data_long <- DATA_UJI %>%
  pivot_longer(
    cols = -Provinsi,
    names_to = "Jenis_Protein",
    values_to = "Konsumsi"
  )

ggplot(data_long,
       aes(x = Jenis_Protein,
           y = Konsumsi,
           color = Jenis_Protein)) +
  geom_boxplot() + 
  stat_summary(fun = mean, geom = "point", shape = 17, size = 3, color = "pink") +
  theme(axis.text.x = element_text(angle = 15, hjust = 1))

# UJI T SATU SAMPEL DAGING AYAM
uji_ayam <- t.test(
  DATA_UJI$Konsumsi.daging.ayam,
  mu = 5
)
print(uji_ayam)
## 
##  One Sample t-test
## 
## data:  DATA_UJI$Konsumsi.daging.ayam
## t = 3.0171, df = 33, p-value = 0.004888
## alternative hypothesis: true mean is not equal to 5
## 95 percent confidence interval:
##  5.483613 7.486387
## sample estimates:
## mean of x 
##     6.485
# UJI T SATU SAMPEL TELUR AYAM DAN TELUR BEBEK
uji_telur <- t.test(
  DATA_UJI$Konsumsi.telur.ayam.dan.telur.bebek,
  mu = 5
)
print(uji_telur)
## 
##  One Sample t-test
## 
## data:  DATA_UJI$Konsumsi.telur.ayam.dan.telur.bebek
## t = 3.9374, df = 33, p-value = 0.0004017
## alternative hypothesis: true mean is not equal to 5
## 95 percent confidence interval:
##  5.652009 7.046227
## sample estimates:
## mean of x 
##  6.349118
# UJI T SATU SAMPEL IKAN SEGAR
uji_ikan <- t.test(
  DATA_UJI$Konsumsi.ikan.segar,
  mu = 5
)
print(uji_ikan)
## 
##  One Sample t-test
## 
## data:  DATA_UJI$Konsumsi.ikan.segar
## t = 6.9512, df = 33, p-value = 6.048e-08
## alternative hypothesis: true mean is not equal to 5
## 95 percent confidence interval:
##  31.92222 54.20307
## sample estimates:
## mean of x 
##  43.06265
# UJI T SATU SAMPEL DAGING SAPI DAN KERBAU
uji_sapi <- t.test(
  DATA_UJI$Konsumsi.daging.sapi.dan.kerbau,
  mu = 5
)
print(uji_sapi)
## 
##  One Sample t-test
## 
## data:  DATA_UJI$Konsumsi.daging.sapi.dan.kerbau
## t = -38.378, df = 33, p-value < 2.2e-16
## alternative hypothesis: true mean is not equal to 5
## 95 percent confidence interval:
##  0.3317501 0.8017794
## sample estimates:
## mean of x 
## 0.5667647