library(readxl)

data <- read_excel("D:/TUGAS/TUGAS APLIKASI KOMPUTER.xlsx")

View(data)

head(data)
## # A tibble: 6 × 30
##   NEGARA   `NEGARA Code` `Series Name` `Series Code` `1998` `1999` `2000` `2001`
##   <chr>    <chr>         <chr>         <chr>         <chr>  <chr>  <chr>  <chr> 
## 1 United … ARE           Access to cl… EG.CFT.ACCS.… ..     ..     99     99    
## 2 United … ARE           Access to cl… EG.CFT.ACCS.… ..     ..     99     99    
## 3 United … ARE           Access to cl… EG.CFT.ACCS.… ..     ..     99     100   
## 4 United … ARE           Access to el… EG.ELC.ACCS.… 100    100    100    100   
## 5 United … ARE           Access to el… EG.ELC.ACCS.… 100    100    100    100   
## 6 Singapo… SGP           S+C7ingapore  EG.CFT.ACCS.… ..     ..     100    100   
## # ℹ 22 more variables: `2002` <chr>, `2003` <chr>, `2004` <chr>, `2005` <chr>,
## #   `2006` <chr>, `2007` <chr>, `2008` <chr>, `2009` <chr>, `2010` <chr>,
## #   `2011` <chr>, `2012` <chr>, `2013` <chr>, `2014` <chr>, `2015` <chr>,
## #   `2016` <chr>, `2017` <chr>, `2018` <chr>, `2019` <chr>, `2020` <chr>,
## #   `2021` <chr>, `2022` <chr>, `2023` <chr>
names(data)
##  [1] "NEGARA"      "NEGARA Code" "Series Name" "Series Code" "1998"       
##  [6] "1999"        "2000"        "2001"        "2002"        "2003"       
## [11] "2004"        "2005"        "2006"        "2007"        "2008"       
## [16] "2009"        "2010"        "2011"        "2012"        "2013"       
## [21] "2014"        "2015"        "2016"        "2017"        "2018"       
## [26] "2019"        "2020"        "2021"        "2022"        "2023"

R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

summary(cars)
##      speed           dist       
##  Min.   : 4.0   Min.   :  2.00  
##  1st Qu.:12.0   1st Qu.: 26.00  
##  Median :15.0   Median : 36.00  
##  Mean   :15.4   Mean   : 42.98  
##  3rd Qu.:19.0   3rd Qu.: 56.00  
##  Max.   :25.0   Max.   :120.00

Including Plots

You can also embed plots, for example:

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot. library(readxl)