==========================================

ANALISIS DATA PANEL FDI ASIA PASIFIK

PERIODE 2000-2024

15 NEGARA

==========================================

1. INSTALL DAN AKTIFKAN PACKAGE

packages <- c(“readxl”, “dplyr”, “plm”, “lmtest”, “sandwich”, “psych”, “ggplot2”)

install.packages(setdiff(packages, rownames(installed.packages())))

library(readxl) library(dplyr) library(plm) library(lmtest) library(sandwich) library(psych) library(ggplot2)

2. IMPORT DATA EXCEL

data <- read_excel(file.choose(), sheet = “Dataset Panel”)

Melihat data

View(data)

Struktur data

str(data)

Melihat 6 baris pertama

head(data)

3. MEMBERSIHKAN DATA

data <- data %>% mutate( Country = as.factor(Country), Year = as.integer(Year) ) %>% arrange(Country, Year)

Mengecek data kosong

colSums(is.na(data))

Mengecek jumlah observasi

nrow(data)

Mengecek jumlah negara

length(unique(data$Country))

Mengecek periode tahun

range(data$Year)

Mengecek duplikasi negara dan tahun

sum(duplicated(data[c(“Country”, “Year”)]))

4. MEMBENTUK DATA PANEL

pdata <- pdata.frame( data, index = c(“Country”, “Year”) )

Informasi struktur panel

pdim(pdata)

Mengecek keseimbangan panel

is.pbalanced(pdata)

5. STATISTIK DESKRIPTIF

deskriptif <- psych::describe( data[, c(“Y_FDI”, “X1_GDP_Growth”, “X2_Inflation”, “X3_Trade”, “X4_Exchange_Rate”)] )

print(deskriptif)

Korelasi antarvariabel

korelasi <- cor( data[, c(“Y_FDI”, “X1_GDP_Growth”, “X2_Inflation”, “X3_Trade”, “X4_Exchange_Rate”)], use = “complete.obs” )

print(korelasi)

6. REGRESI COMMON EFFECT MODEL (CEM)

model_cem <- plm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = pdata, model = “pooling” )

summary(model_cem)

7. REGRESI FIXED EFFECT MODEL (FEM)

model_fem <- plm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = pdata, model = “within”, effect = “individual” )

summary(model_fem)

8. REGRESI RANDOM EFFECT MODEL (REM)

model_rem <- plm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = pdata, model = “random”, effect = “individual” )

summary(model_rem)

9. UJI CHOW

Memilih CEM atau FEM

uji_chow <- pFtest(model_fem, model_cem)

print(uji_chow)

10. UJI HAUSMAN

Memilih FEM atau REM

uji_hausman <- phtest(model_fem, model_rem)

print(uji_hausman)

11. UJI LM BREUSCH-PAGAN

Memilih CEM atau REM

uji_lm <- plmtest( model_cem, effect = “individual”, type = “bp” )

print(uji_lm)

12. UJI MULTIKOLINEARITAS

model_ols <- lm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = data )

VIF

install.packages(“car”) library(car)

vif(model_ols)

13. UJI HETEROSKEDASTISITAS

bptest(model_fem)

14. UJI AUTOKORELASI

pbgtest(model_fem)

15. REGRESI DENGAN ROBUST STANDARD ERROR

Contoh untuk Fixed Effect Model

coeftest( model_fem, vcov = vcovHC( model_fem, method = “arellano”, type = “HC1”, cluster = “group” ) )

16. MENAMPILKAN HASIL MODEL

summary(model_cem) summary(model_fem) summary(model_rem)

17. GRAFIK PERKEMBANGAN FDI

ggplot(data, aes(x = Year, y = Y_FDI, color = Country, group = Country)) + geom_line() + labs( title = “Perkembangan FDI Negara Asia Pasifik”, x = “Tahun”, y = “FDI”, color = “Negara” ) + theme_minimal()

18. MENYIMPAN DATA HASIL PENGOLAHAN

write.csv( data, “Data_Panel_FDI_Bersih.csv”, row.names = FALSE )

cat(“ANALISIS DATA PANEL SELESAI”)