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`
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)
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.