# Install paket (jalankan sekali saja)
# install.packages(c("readxl", "plm", "dplyr"))

library(readxl)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(plm)
## 
## Attaching package: 'plm'
## The following objects are masked from 'package:dplyr':
## 
##     between, lag, lead
# Lokasi file
file <- "C:/Users/ADVAN/OneDrive/Dokumen/Data_Panel_WDI.xlsx"

# Lihat nama sheet
excel_sheets(file)
## [1] "Panel_Lengkap"      "Panel_Data_Lengkap" "Ketersediaan_Data" 
## [4] "Keterangan"
# Impor data
data_lengkap <- read_excel(file, sheet = "Panel_Lengkap")        # semua data (ada NA)
data         <- read_excel(file, sheet = "Panel_Data_Lengkap")   # tanpa NA (untuk regresi)

# Cek data
str(data)
## tibble [29 × 8] (S3: tbl_df/tbl/data.frame)
##  $ Negara                   : chr [1:29] "Cambodia" "Cambodia" "China" "China" ...
##  $ Kode                     : chr [1:29] "KHM" "KHM" "CHN" "CHN" ...
##  $ Tahun                    : num [1:29] 2008 2009 2000 2010 2020 ...
##  $ Y_Kemiskinan             : num [1:29] 34 23.9 49.8 17.2 0 16.7 17.8 15.4 14.2 13.3 ...
##  $ X1_Melek_Huruf           : num [1:29] 76.9 76.1 90.9 95.1 96.7 ...
##  $ X2_TPT                   : num [1:29] 0.825 0.579 3.26 4.53 5 ...
##  $ X3_PDRB_per_kapita       : num [1:29] 5.86 2.45 7.72 10.06 2.1 ...
##  $ X4_Pengeluaran_Pemerintah: num [1:29] 5.76 6.3 16.98 14.84 17.6 ...
head(data)
## # A tibble: 6 × 8
##   Negara    Kode  Tahun Y_Kemiskinan X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
##   <chr>     <chr> <dbl>        <dbl>          <dbl>  <dbl>              <dbl>
## 1 Cambodia  KHM    2008         34             76.9  0.825               5.86
## 2 Cambodia  KHM    2009         23.9           76.1  0.579               2.45
## 3 China     CHN    2000         49.8           90.9  3.26                7.72
## 4 China     CHN    2010         17.2           95.1  4.53               10.1 
## 5 China     CHN    2020          0             96.7  5                   2.10
## 6 Indonesia IDN    2004         16.7           90.4  7.30                3.70
## # ℹ 1 more variable: X4_Pengeluaran_Pemerintah <dbl>
summary(data)
##        Negara          Kode        Tahun       Y_Kemiskinan   X1_Melek_Huruf 
##  Length   :29   Length   :29   Min.   :2000   Min.   : 0.00   Min.   :37.60  
##  N.unique : 7   N.unique : 7   1st Qu.:2008   1st Qu.: 8.60   1st Qu.:91.27  
##  N.blank  : 0   N.blank  : 0   Median :2013   Median :11.30   Median :92.81  
##  Min.nchar: 5   Min.nchar: 3   Mean   :2012   Mean   :16.54   Mean   :89.11  
##  Max.nchar:11   Max.nchar: 3   3rd Qu.:2018   3rd Qu.:17.20   3rd Qu.:95.22  
##                                Max.   :2022   Max.   :50.40   Max.   :96.74  
##      X2_TPT      X3_PDRB_per_kapita X4_Pengeluaran_Pemerintah
##  Min.   :0.249   Min.   :-2.894     Min.   :  5.763          
##  1st Qu.:0.825   1st Qu.: 2.760     1st Qu.:  9.021          
##  Median :3.386   Median : 3.908     Median :  9.749          
##  Mean   :3.279   Mean   : 4.250     Mean   : 19.424          
##  3rd Qu.:4.530   3rd Qu.: 5.857     3rd Qu.: 16.363          
##  Max.   :7.551   Max.   :10.059     Max.   :136.374
# Ubah tipe data
data$Negara <- as.factor(data$Negara)
data$Tahun  <- as.integer(data$Tahun)

# Jadikan data panel
panel <- pdata.frame(data, index = c("Negara", "Tahun"))
pdim(panel)
## Unbalanced Panel: n = 7, T = 1-11, N = 29
# Model regresi panel
cem <- plm(Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + X4_Pengeluaran_Pemerintah,
           data = panel, model = "pooling")   # Common Effect

fem <- plm(Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + X4_Pengeluaran_Pemerintah,
           data = panel, model = "within")    # Fixed Effect

rem <- plm(Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + X4_Pengeluaran_Pemerintah,
           data = panel, model = "random")    # Random Effect

summary(cem)
## Pooling Model
## 
## Call:
## plm(formula = Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + 
##     X4_Pengeluaran_Pemerintah, data = panel, model = "pooling")
## 
## Unbalanced Panel: n = 7, T = 1-11, N = 29
## 
## Residuals:
##    Min. 1st Qu.  Median 3rd Qu.    Max. 
## -12.320  -4.116  -1.960   0.517  29.679 
## 
## Coefficients:
##                           Estimate Std. Error t-value Pr(>|t|)   
## (Intercept)               98.21491   33.77095  2.9083 0.007709 **
## X1_Melek_Huruf            -0.95485    0.34468 -2.7702 0.010639 * 
## X2_TPT                     0.34634    0.84721  0.4088 0.686313   
## X3_PDRB_per_kapita         1.46959    0.81971  1.7928 0.085616 . 
## X4_Pengeluaran_Pemerintah -0.20441    0.16260 -1.2571 0.220816   
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    4948.2
## Residual Sum of Squares: 2470.1
## R-Squared:      0.5008
## Adj. R-Squared: 0.41761
## F-statistic: 6.01934 on 4 and 24 DF, p-value: 0.0016786
summary(fem)
## Oneway (individual) effect Within Model
## 
## Call:
## plm(formula = Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + 
##     X4_Pengeluaran_Pemerintah, data = panel, model = "within")
## 
## Unbalanced Panel: n = 7, T = 1-11, N = 29
## 
## Residuals:
##    Min. 1st Qu.  Median 3rd Qu.    Max. 
## -10.549  -4.598  -0.387   1.812  26.017 
## 
## Coefficients:
##                           Estimate Std. Error t-value Pr(>|t|)  
## X1_Melek_Huruf            -2.74859    1.28124 -2.1453  0.04582 *
## X2_TPT                    -1.66568    2.37957 -0.7000  0.49288  
## X3_PDRB_per_kapita         1.18560    0.95697  1.2389  0.23129  
## X4_Pengeluaran_Pemerintah -1.72908    0.69452 -2.4896  0.02279 *
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    2547.1
## Residual Sum of Squares: 1610.2
## R-Squared:      0.36784
## Adj. R-Squared: 0.016644
## F-statistic: 2.61848 on 4 and 18 DF, p-value: 0.069496
summary(rem)
## Oneway (individual) effect Random Effect Model 
##    (Swamy-Arora's transformation)
## 
## Call:
## plm(formula = Y_Kemiskinan ~ X1_Melek_Huruf + X2_TPT + X3_PDRB_per_kapita + 
##     X4_Pengeluaran_Pemerintah, data = panel, model = "random")
## 
## Unbalanced Panel: n = 7, T = 1-11, N = 29
## 
## Effects:
##                  var std.dev share
## idiosyncratic 89.453   9.458 0.688
## individual    40.474   6.362 0.312
## theta:
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.1702  0.3487  0.5347  0.4706  0.5910  0.5910 
## 
## Residuals:
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## -8.5820 -4.9507 -1.8171  0.1120  0.0365 28.4400 
## 
## Coefficients:
##                            Estimate Std. Error z-value Pr(>|z|)   
## (Intercept)               112.57584   43.34531  2.5972 0.009399 **
## X1_Melek_Huruf             -1.11903    0.44619 -2.5080 0.012143 * 
## X2_TPT                      0.77709    1.35101  0.5752 0.565160   
## X3_PDRB_per_kapita          1.52137    0.86664  1.7555 0.079177 . 
## X4_Pengeluaran_Pemerintah  -0.29147    0.20886 -1.3955 0.162866   
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Total Sum of Squares:    4201.7
## Residual Sum of Squares: 2229.1
## R-Squared:      0.46968
## Adj. R-Squared: 0.38129
## Chisq: 15.7647 on 4 DF, p-value: 0.0033517

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
# 1. Install readxl jika belum ada
if (!require("readxl")) install.packages("readxl")
library(readxl)

# 2. Cek dulu apakah file ditemukan
file <- "C:/Users/ADVAN/OneDrive/Dokumen/Data_Panel_WDI.xlsx"
file.exists(file)      # harus TRUE
## [1] TRUE
# 3. Jika FALSE, pilih file lewat dialog (path otomatis benar)
# file <- file.choose()

# 4. Impor
excel_sheets(file)
## [1] "Panel_Lengkap"      "Panel_Data_Lengkap" "Ketersediaan_Data" 
## [4] "Keterangan"
data <- read_excel(file, sheet = "Panel_Data_Lengkap")
head(data)
## # A tibble: 6 × 8
##   Negara    Kode  Tahun Y_Kemiskinan X1_Melek_Huruf X2_TPT X3_PDRB_per_kapita
##   <chr>     <chr> <dbl>        <dbl>          <dbl>  <dbl>              <dbl>
## 1 Cambodia  KHM    2008         34             76.9  0.825               5.86
## 2 Cambodia  KHM    2009         23.9           76.1  0.579               2.45
## 3 China     CHN    2000         49.8           90.9  3.26                7.72
## 4 China     CHN    2010         17.2           95.1  4.53               10.1 
## 5 China     CHN    2020          0             96.7  5                   2.10
## 6 Indonesia IDN    2004         16.7           90.4  7.30                3.70
## # ℹ 1 more variable: X4_Pengeluaran_Pemerintah <dbl>

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.