library(tidyverse)
library(PerformanceAnalytics)
d <- readxl::read_excel("C:/Users/tranh/Downloads/thongke/Mohinhngaunhien.xlsx")
my_data <- d[, c(2,3,4,5,6)]
my_data <- data.frame(sapply(my_data, as.numeric))
chart.Correlation(my_data, histogram=TRUE, pch=19)

corr <- cor(my_data)
round(corr, 2)
## FDI TO IR ER INF
## FDI 1.00 0.13 -0.23 0.34 -0.07
## TO 0.13 1.00 -0.06 0.23 -0.10
## IR -0.23 -0.06 1.00 -0.60 0.48
## ER 0.34 0.23 -0.60 1.00 -0.30
## INF -0.07 -0.10 0.48 -0.30 1.00
library(corrplot)
my_data<- cor(my_data)
corrplot(my_data, type = "upper", order = "hclust", tl.col = "black", tl.srt = 45)

heatmap(x = my_data, col = colorRampPalette(c("blue", "white", "red"))(20), symm = TRUE)
