library(readr)
library(ggplot2)

hr <- read_csv('https://raw.githubusercontent.com/aiplanethub/Datasets/refs/heads/master/HR_comma_sep.csv')
## Rows: 14999 Columns: 10
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (2): Department, salary
## dbl (8): satisfaction_level, last_evaluation, number_project, average_montly...
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Correlation 1: Satisfaction Level vs Last Evaluation

cor.test(hr$satisfaction_level, hr$last_evaluation)
## 
##  Pearson's product-moment correlation
## 
## data:  hr$satisfaction_level and hr$last_evaluation
## t = 12.933, df = 14997, p-value < 2.2e-16
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.08916727 0.12082195
## sample estimates:
##       cor 
## 0.1050212

p-value interpretation: The p-value is very small, therefore the correlation between satisfaction level and last evaluation is significant.

correlation estimate interpretation: The correlation is positive and weak.

non-technical interpretation: Higher employee satisfaction is associated with slightly higher performance evaluations.

ggplot(hr, aes(x = number_project, y = average_montly_hours)) +
  geom_point() +
  geom_smooth(method = "lm", se = FALSE, color = "red") +
  labs(title = "More Projects Lead to More Working Hours",
       x = "Number of Projects",
       y = "Average Monthly Hours")
## `geom_smooth()` using formula = 'y ~ x'

Correlation 2: Number of Projects vs Average Monthly Hours

cor.test(hr$number_project, hr$average_montly_hours)
## 
##  Pearson's product-moment correlation
## 
## data:  hr$number_project and hr$average_montly_hours
## t = 56.219, df = 14997, p-value < 2.2e-16
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.4039037 0.4303411
## sample estimates:
##       cor 
## 0.4172106

p-value interpretation: The p-value is very small, therefore the correlation between number of projects and average monthly hours is significant.

correlation estimate interpretation: The correlation is positive and moderate.

non-technical interpretation: Employees with more projects tend to work more hours.

ggplot(hr, aes(x = number_project, y = average_montly_hours)) +
  geom_point() +
  geom_smooth(method = "lm", se = FALSE, color = "red") +
  labs(title = "More Projects Lead to More Working Hours",
       x = "Number of Projects",
       y = "Average Monthly Hours")
## `geom_smooth()` using formula = 'y ~ x'

Correlation 3: Time at Company vs Number of Projects

cor.test(hr$time_spend_company, hr$number_project)
## 
##  Pearson's product-moment correlation
## 
## data:  hr$time_spend_company and hr$number_project
## t = 24.579, df = 14997, p-value < 2.2e-16
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.1813532 0.2121217
## sample estimates:
##       cor 
## 0.1967859

p-value interpretation: The p-value is very small, therefore the correlation between time spent at the company and number of projects is significant.

correlation estimate interpretation: The correlation is positive and weak.

non-technical interpretation: Employees who stay longer at the company tend to have slightly more projects.

ggplot(hr, aes(x = time_spend_company, y = number_project)) +
  geom_point() +
  geom_smooth(method = "lm", se = FALSE, color = "red") +
  labs(title = "Years at Company vs Project Load",
       x = "Time Spent at Company",
       y = "Number of Projects")
## `geom_smooth()` using formula = 'y ~ x'

Correlation 4: Satisfaction Level vs Average Monthly Hours

cor.test(hr$satisfaction_level, hr$average_montly_hours)
## 
##  Pearson's product-moment correlation
## 
## data:  hr$satisfaction_level and hr$average_montly_hours
## t = -2.4556, df = 14997, p-value = 0.01408
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  -0.036040356 -0.004045605
## sample estimates:
##         cor 
## -0.02004811

p-value interpretation: The p-value is small, therefore the correlation between satisfaction level and average monthly hours is significant.

correlation estimate interpretation: The correlation is negative and very weak.

non-technical interpretation: Employees who work more hours tend to have slightly lower satisfaction.

ggplot(hr, aes(x = satisfaction_level, y = average_montly_hours)) +
  geom_point() +
  geom_smooth(method = "lm", se = FALSE, color = "red") +
  labs(title = "More Work Hours May Lower Employee Satisfaction",
       x = "Satisfaction Level",
       y = "Average Monthly Hours")
## `geom_smooth()` using formula = 'y ~ x'