# excel file
data <- read_excel("../00_data/Salaries.xlsx")
data
## # A tibble: 397 Ă— 6
## rank discipline yrs.since.phd yrs.service sex salary
## <chr> <chr> <dbl> <dbl> <chr> <dbl>
## 1 Prof B 19 18 Male 139750
## 2 Prof B 20 16 Male 173200
## 3 AsstProf B 4 3 Male 79750
## 4 Prof B 45 39 Male 115000
## 5 Prof B 40 41 Male 141500
## 6 AssocProf B 6 6 Male 97000
## 7 Prof B 30 23 Male 175000
## 8 Prof B 45 45 Male 147765
## 9 Prof B 21 20 Male 119250
## 10 Prof B 18 18 Female 129000
## # ℹ 387 more rows
The longer a professor has taught, the more he/she gets paid.
ggplot(data = data) +
geom_point (mapping = aes(x = salary, y = yrs.service))
There seems to be preliminary evidence of a positive relationship between professors’ salary and their years of service.