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)
data <- read_excel(file.choose(), sheet = “Dataset Panel”)
View(data)
str(data)
head(data)
data <- data %>% mutate( Country = as.factor(Country), Year = as.integer(Year) ) %>% arrange(Country, Year)
colSums(is.na(data))
nrow(data)
length(unique(data$Country))
range(data$Year)
sum(duplicated(data[c(“Country”, “Year”)]))
pdata <- pdata.frame( data, index = c(“Country”, “Year”) )
pdim(pdata)
is.pbalanced(pdata)
deskriptif <- psych::describe( data[, c(“Y_FDI”, “X1_GDP_Growth”, “X2_Inflation”, “X3_Trade”, “X4_Exchange_Rate”)] )
print(deskriptif)
korelasi <- cor( data[, c(“Y_FDI”, “X1_GDP_Growth”, “X2_Inflation”, “X3_Trade”, “X4_Exchange_Rate”)], use = “complete.obs” )
print(korelasi)
model_cem <- plm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = pdata, model = “pooling” )
summary(model_cem)
model_fem <- plm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = pdata, model = “within”, effect = “individual” )
summary(model_fem)
model_rem <- plm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = pdata, model = “random”, effect = “individual” )
summary(model_rem)
uji_chow <- pFtest(model_fem, model_cem)
print(uji_chow)
uji_hausman <- phtest(model_fem, model_rem)
print(uji_hausman)
uji_lm <- plmtest( model_cem, effect = “individual”, type = “bp” )
print(uji_lm)
model_ols <- lm( Y_FDI ~ X1_GDP_Growth + X2_Inflation + X3_Trade + X4_Exchange_Rate, data = data )
install.packages(“car”) library(car)
vif(model_ols)
bptest(model_fem)
pbgtest(model_fem)
coeftest( model_fem, vcov = vcovHC( model_fem, method = “arellano”, type = “HC1”, cluster = “group” ) )
summary(model_cem) summary(model_fem) summary(model_rem)
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()
write.csv( data, “Data_Panel_FDI_Bersih.csv”, row.names = FALSE )
cat(“ANALISIS DATA PANEL SELESAI”)