library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
data_negara <- read_excel("C:/Users/Advan/OneDrive/Dokumen/DATA 15 NEGARA DENGAN 4 INDIKATOR.xlsx")
## New names:
## • `` -> `...1`
## • `` -> `...2`
## • `` -> `...3`
## • `` -> `...4`
## • `` -> `...5`
## • `` -> `...6`
## • `` -> `...7`
## • `` -> `...9`
## • `` -> `...10`
## • `` -> `...11`
## • `` -> `...12`
## • `` -> `...13`
## • `` -> `...14`
## • `` -> `...15`
## • `` -> `...16`
## • `` -> `...17`
## • `` -> `...18`
## • `` -> `...19`
## • `` -> `...20`
## • `` -> `...21`
## • `` -> `...22`
## • `` -> `...23`
## • `` -> `...24`
## • `` -> `...25`
## • `` -> `...26`
## • `` -> `...27`
## • `` -> `...28`
## • `` -> `...29`

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:

head(data_negara)
## # A tibble: 6 × 29
##   ...1    ...2  ...3  ...4  ...5  ...6  ...7  PENGARUH INVESTASI A…¹ ...9  ...10
##   <chr>   <chr> <chr> <chr> <chr> <chr> <chr> <chr>                  <chr> <chr>
## 1 <NA>    <NA>  <NA>  <NA>  <NA>  <NA>  <NA>  <NA>                   <NA>  <NA> 
## 2 NEGARA  INDI… TAHUN <NA>  <NA>  <NA>  <NA>  <NA>                   <NA>  <NA> 
## 3 <NA>    <NA>  2001  2002  2003  2004  2005  2006                   2007  2008 
## 4 Indone… Manu… 30.7… 31.9… 28.2… 28.0… 27.4… 27.537574080245403     27.0… 27.8…
## 5 <NA>    Fore… -1.8… 7.41… -0.2… 0.73… 2.91… 1.3479426406893089     1.60… 1.82…
## 6 <NA>    Dome… ..    ..    ..    ..    ..    ..                     ..    ..   
## # ℹ abbreviated name:
## #   ¹​`PENGARUH INVESTASI ASING LANGSUNG, KREDIT DOMESTIK SEKTOR SWASTA , DAN KETERBUKAAN\r\nPERDAGANGAN TERHADAP NILAI TAMBAH SEKTOR MANUFAKTUR DI NEGARA-NEGARA ASIA PASIFIK\r\nPERIODE 2000-2025`
## # ℹ 19 more variables: ...11 <chr>, ...12 <chr>, ...13 <chr>, ...14 <chr>,
## #   ...15 <chr>, ...16 <dbl>, ...17 <dbl>, ...18 <dbl>, ...19 <dbl>,
## #   ...20 <dbl>, ...21 <dbl>, ...22 <dbl>, ...23 <chr>, ...24 <chr>,
## #   ...25 <chr>, ...26 <chr>, ...27 <chr>, ...28 <lgl>, ...29 <chr>
str(data_negara)
## tibble [68 × 29] (S3: tbl_df/tbl/data.frame)
##  $ ...1                                                                                                                                                                                        : chr [1:68] NA "NEGARA" NA "Indonesia" ...
##  $ ...2                                                                                                                                                                                        : chr [1:68] NA "INDIKATOR" NA "Manufacturing, value added (% of GDP)" ...
##  $ ...3                                                                                                                                                                                        : chr [1:68] NA "TAHUN" "2001" "30.754597217312284" ...
##  $ ...4                                                                                                                                                                                        : chr [1:68] NA NA "2002" "31.953278494070865" ...
##  $ ...5                                                                                                                                                                                        : chr [1:68] NA NA "2003" "28.252841844456896" ...
##  $ ...6                                                                                                                                                                                        : chr [1:68] NA NA "2004" "28.065826585653564" ...
##  $ ...7                                                                                                                                                                                        : chr [1:68] NA NA "2005" "27.407507480045911" ...
##  $ PENGARUH INVESTASI ASING LANGSUNG, KREDIT DOMESTIK SEKTOR SWASTA , DAN KETERBUKAAN
## PERDAGANGAN TERHADAP NILAI TAMBAH SEKTOR MANUFAKTUR DI NEGARA-NEGARA ASIA PASIFIK
## PERIODE 2000-2025: chr [1:68] NA NA "2006" "27.537574080245403" ...
##  $ ...9                                                                                                                                                                                        : chr [1:68] NA NA "2007" "27.048412748793112" ...
##  $ ...10                                                                                                                                                                                       : chr [1:68] NA NA "2008" "27.814272985430271" ...
##  $ ...11                                                                                                                                                                                       : chr [1:68] NA NA "2009" "26.355474527106409" ...
##  $ ...12                                                                                                                                                                                       : chr [1:68] NA NA "2010" "22.038628592443814" ...
##  $ ...13                                                                                                                                                                                       : chr [1:68] NA NA "2011" "21.760854503847554" ...
##  $ ...14                                                                                                                                                                                       : chr [1:68] NA NA "2012" "21.450955055387517" ...
##  $ ...15                                                                                                                                                                                       : chr [1:68] NA NA "2013" "21.028688681721835" ...
##  $ ...16                                                                                                                                                                                       : num [1:68] NA NA 2014 21.08 2.82 ...
##  $ ...17                                                                                                                                                                                       : num [1:68] NA NA 2015 21 2.3 ...
##  $ ...18                                                                                                                                                                                       : num [1:68] NA NA 2016 20.523 0.487 ...
##  $ ...19                                                                                                                                                                                       : num [1:68] NA NA 2017 20.16 2.02 ...
##  $ ...20                                                                                                                                                                                       : num [1:68] NA NA 2018 19.86 1.81 ...
##  $ ...21                                                                                                                                                                                       : num [1:68] NA NA 2019 19.7 2.23 ...
##  $ ...22                                                                                                                                                                                       : num [1:68] NA NA 2020 19.87 1.81 ...
##  $ ...23                                                                                                                                                                                       : chr [1:68] NA NA "2021" "19.243407781773843" ...
##  $ ...24                                                                                                                                                                                       : chr [1:68] NA NA "2022" "18.336177108032878" ...
##  $ ...25                                                                                                                                                                                       : chr [1:68] NA NA "2023" "18.667448791678268" ...
##  $ ...26                                                                                                                                                                                       : chr [1:68] NA NA "2024" "18.984004004374039" ...
##  $ ...27                                                                                                                                                                                       : chr [1:68] NA NA "2025" "19.065109980882667" ...
##  $ ...28                                                                                                                                                                                       : logi [1:68] NA NA NA NA NA NA ...
##  $ ...29                                                                                                                                                                                       : chr [1:68] NA "Penjelasan hubungan antarvariabel:\r\n1. Investasi asing langsung dapat meningkatkan kapasitas produksi, teknol"| __truncated__ NA NA ...
View(data_negara)

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.