library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
# Impor data
data <- read_excel("C:/Users/valem/Downloads/DATA_15_NEGARA_CLEANED.xlsx")

# Cek hasil impor
head(data)
## # A tibble: 6 × 27
##   NEGARA   INDIKATOR   `2001`   `2002`   `2003`   `2004`  `2005`  `2006`  `2007`
##   <chr>    <chr>        <dbl>    <dbl>    <dbl>    <dbl>   <dbl>   <dbl>   <dbl>
## 1 INDONES… Foreign … -1.86e+0  7.42e-2 -2.54e-1  7.38e-1  2.92e0  1.35e0  1.60e0
## 2 INDONES… Poverty …  1.84e+1  1.82e+1  1.74e+1  1.67e+1  1.6 e1  1.78e1  1.66e1
## 3 INDONES… Trade (%…  6.98e+1  5.91e+1  5.36e+1  5.98e+1  6.40e1  5.67e1  5.48e1
## 4 INDONES… Populati…  2.19e+8  2.22e+8  2.25e+8  2.28e+8  2.31e8  2.34e8  2.37e8
## 5 MALAYSIA Foreign …  5.97e-1  3.17e+0  2.92e+0  3.51e+0  2.73e0  4.73e0  4.69e0
## 6 MALAYSIA Poverty … NA       NA       NA       NA       NA      NA      NA     
## # ℹ 18 more variables: `2008` <dbl>, `2009` <dbl>, `2010` <dbl>, `2011` <dbl>,
## #   `2012` <dbl>, `2013` <dbl>, `2014` <dbl>, `2015` <dbl>, `2016` <dbl>,
## #   `2017` <dbl>, `2018` <dbl>, `2019` <dbl>, `2020` <dbl>, `2021` <dbl>,
## #   `2022` <dbl>, `2023` <dbl>, `2024` <dbl>, `2025` <dbl>
str(data)
## tibble [60 × 27] (S3: tbl_df/tbl/data.frame)
##  $ NEGARA   : chr [1:60] "INDONESIA" "INDONESIA" "INDONESIA" "INDONESIA" ...
##  $ INDIKATOR: chr [1:60] "Foreign direct investment, net inflows (% of GDP)" "Poverty headcount ratio at national poverty lines (% of population)" "Trade (% of GDP)" "Population, total" ...
##  $ 2001     : num [1:60] -1.86 1.84e+01 6.98e+01 2.19e+08 5.97e-01 ...
##  $ 2002     : num [1:60] 7.42e-02 1.82e+01 5.91e+01 2.22e+08 3.17 ...
##  $ 2003     : num [1:60] -2.54e-01 1.74e+01 5.36e+01 2.25e+08 2.92 ...
##  $ 2004     : num [1:60] 7.38e-01 1.67e+01 5.98e+01 2.28e+08 3.51 ...
##  $ 2005     : num [1:60] 2.92 1.60e+01 6.40e+01 2.31e+08 2.73 ...
##  $ 2006     : num [1:60] 1.35 1.78e+01 5.67e+01 2.34e+08 4.73 ...
##  $ 2007     : num [1:60] 1.60 1.66e+01 5.48e+01 2.37e+08 4.69 ...
##  $ 2008     : num [1:60] 1.83 1.54e+01 5.86e+01 2.40e+08 3.28 ...
##  $ 2009     : num [1:60] 9.04e-01 1.42e+01 4.55e+01 2.43e+08 5.67e-02 ...
##  $ 2010     : num [1:60] 2.03 1.33e+01 4.67e+01 2.46e+08 4.27 ...
##  $ 2011     : num [1:60] 2.30 1.25e+01 5.02e+01 2.49e+08 5.07 ...
##  $ 2012     : num [1:60] 2.31 1.20e+01 4.96e+01 2.53e+08 2.83 ...
##  $ 2013     : num [1:60] 2.55 1.14e+01 4.86e+01 2.56e+08 3.49 ...
##  $ 2014     : num [1:60] 2.82 1.13e+01 4.81e+01 2.59e+08 3.14 ...
##  $ 2015     : num [1:60] 2.30 1.12e+01 4.19e+01 2.62e+08 3.27 ...
##  $ 2016     : num [1:60] 4.87e-01 1.09e+01 3.74e+01 2.65e+08 4.47 ...
##  $ 2017     : num [1:60] 2.02 1.06e+01 3.94e+01 2.67e+08 2.94 ...
##  $ 2018     : num [1:60] 1.81 9.80 4.31e+01 2.70e+08 2.31 ...
##  $ 2019     : num [1:60] 2.23 9.40 3.76e+01 2.72e+08 2.51 ...
##  $ 2020     : num [1:60] 1.81 9.80 3.30e+01 2.75e+08 1.20 ...
##  $ 2021     : num [1:60] 1.79 1.01e+01 4.02e+01 2.77e+08 5.42 ...
##  $ 2022     : num [1:60] 1.87 9.50 4.55e+01 2.79e+08 3.68 ...
##  $ 2023     : num [1:60] 1.57 9.40 4.15e+01 2.81e+08 2.41 ...
##  $ 2024     : num [1:60] 1.74 9.00 4.28e+01 2.83e+08 4.20 ...
##  $ 2025     : num [1:60] 1.57 8.50 4.34e+01 2.86e+08 4.58 ...
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.