Quiz2

#Import Data

library(readxl)
data <- read_excel("C:/Users/Dewi Wuri/Downloads/car sales.xlsx")
data

## # A tibble: 23,906 × 16
##    Car_id Date                `Customer Name` Gender `Annual Income` Dealer_Name
##    <chr>  <dttm>              <chr>           <chr>            <dbl> <chr>      
##  1 C_CND… 2022-01-02 00:00:00 Geraldine       Male             13500 Buddy Stor…
##  2 C_CND… 2022-01-02 00:00:00 Gia             Male           1480000 C & M Moto…
##  3 C_CND… 2022-01-02 00:00:00 Gianna          Male           1035000 Capitol KIA
##  4 C_CND… 2022-01-02 00:00:00 Giselle         Male             13500 Chrysler o…
##  5 C_CND… 2022-01-02 00:00:00 Grace           Male           1465000 Chrysler P…
##  6 C_CND… 2022-01-02 00:00:00 Guadalupe       Male            850000 Classic Ch…
##  7 C_CND… 2022-01-02 00:00:00 Hailey          Male           1600000 Clay Johns…
##  8 C_CND… 2022-01-02 00:00:00 Graham          Male             13500 U-Haul CO  
##  9 C_CND… 2022-01-02 00:00:00 Naomi           Male            815000 Rabun Used…
## 10 C_CND… 2022-01-02 00:00:00 Grayson         Female           13500 Rabun Used…
## # ℹ 23,896 more rows
## # ℹ 10 more variables: Company <chr>, Model <chr>, Engine <chr>,
## #   Transmission <chr>, Color <chr>, `Price ($)` <dbl>, Dealer_No <chr>,
## #   `Body Style` <chr>, Phone <dbl>, Dealer_Region <chr>

#Visualisasi 1

library(ggplot2)
ggplot(data=data)+
  geom_bar(mapping = aes(x=Company, fill=Date))

## Warning: The following aesthetics were dropped during statistical transformation: fill.
## ℹ This can happen when ggplot fails to infer the correct grouping structure in
##   the data.
## ℹ Did you forget to specify a `group` aesthetic or to convert a numerical
##   variable into a factor?

#Visualisasi 2

library(ggplot2)
ggplot(data=data)+
  geom_bar(mapping = aes(x="Body Style", fill= Company))

#Visualisasi 3

library(ggplot2)
ggplot(data=data)+
  geom_bar(mapping = aes(x="Dealer_Region", fill= Company))

#Visualisasi 4

library(ggplot2)
ggplot(data=data)+
  geom_bar(mapping = aes(x="Gender", fill= Company))

#Visualisasi 5

library(ggplot2)
ggplot(data=data)+
  geom_bar(mapping = aes(x="Model", fill= Company))