EDA (HR Data)
Prof. Sameer Mathur
LOADING DATA INTO R ENVIRONMENT
Loading the Data
Number of rows & columns in the dataframe
## [1] 8995 17Column names of the dataframe
## [1] "CandidateRef" "DOJExtended"
## [3] "DurationToAcceptOffer" "NoticePeriod"
## [5] "OfferedBand" "PercentHikeExpectedInCTC"
## [7] "PercentHikeOfferedInCTC" "PercentDifferenceCTC"
## [9] "JoiningBonus" "CandidateRelocateActual"
## [11] "Gender" "CandidateSource"
## [13] "RexInYrs" "LOB"
## [15] "Location" "Age"
## [17] "Status"Descriptive Statistics of the dataframe
## vars n mean sd median
## CandidateRef 1 8995 2843647.38 486344.77 2807482
## DOJExtended* 2 8995 1.47 0.50 1
## DurationToAcceptOffer 3 8995 21.43 25.81 10
## NoticePeriod 4 8995 39.29 22.22 30
## OfferedBand* 5 8995 2.39 0.63 2
## PercentHikeExpectedInCTC 6 8995 43.86 29.79 40
## PercentHikeOfferedInCTC 7 8995 40.66 36.06 36
## PercentDifferenceCTC 8 8995 -1.57 19.61 0
## JoiningBonus* 9 8995 1.05 0.21 1
## CandidateRelocateActual* 10 8995 1.14 0.35 1
## Gender* 11 8995 1.83 0.38 2
## CandidateSource* 12 8995 1.89 0.67 2
## RexInYrs 13 8995 4.24 2.55 4
## LOB* 14 8995 5.18 2.38 5
## Location* 15 8995 4.94 3.00 3
## Age 16 8995 29.91 4.10 29
## Status* 17 8995 1.19 0.39 1DISCRETE DATA DISTRIBUTION
Percentage of the candidates (Joined / Not joined)
## Status
## Joined NotJoined
## 81.3 18.7Bar Chart for % of the Candidates Who Joined / Did Not Join the Company
Percentage of the candidates Joined / Did Not Join the Company, Split by DOJ extended
## Status
## DOJExtended Joined NotJoined
## No 81.08 18.92
## Yes 81.55 18.45Bar Chart for % of Candidates Who Did Not Join, Split by DOJ Extended
Percentage of Candidates Who (Joined / Did Not Join), split by Notice Period
## Status
## NoticePeriod Joined NotJoined
## 0 93.44 6.56
## 30 85.17 14.83
## 45 75.48 24.52
## 60 73.22 26.78
## 75 68.18 31.82
## 90 66.19 33.81
## 120 52.38 47.62Bar Chart for % of Candidates, Who Did Not Join, Split by Notice Period
Percentage of the Candidates Who (Joined / Did Not Join), split by Joining Bonus
## Status
## JoiningBonus Joined NotJoined
## No 81.34 18.66
## Yes 80.58 19.42Bar Chart for % of Candidates, Who Did Not Join, Split by Joining Bonus
Percentage of the Candidates Who (Joined / Did Not Join), Split by Gender
## Status
## Gender Joined NotJoined
## Female 82.40 17.60
## Male 81.07 18.93Bar Chart for % of the Candidates Who Did Not join, Split by Gender
Percentage of the Candidates Who (Joined / Did Not Join), Split by Candidate Source
## Status
## CandidateSource Joined NotJoined
## Agency 75.82 24.18
## Direct 82.00 18.00
## Employee Referral 88.00 12.00Bar Chart for % of Candidates Who Did Not Join the Company, Split by Candidate Source
Percentage of the Candidates Who (Joined / Did Not Join), Split by Offered Band
## Status
## OfferedBand Joined NotJoined
## E0 76.30 23.70
## E1 81.30 18.70
## E2 80.97 19.03
## E3 85.15 14.85Bar Chart for % Candidates Who Did Not Join, Split by Offered Band
Percentage of the Candidates Who (Joined / Did Not join), Split by Line of Business (LOB)
## Status
## LOB Joined NotJoined
## AXON 77.46 22.54
## BFSI 75.86 24.14
## CSMP 81.52 18.48
## EAS 73.41 26.59
## ERS 78.11 21.89
## ETS 83.07 16.93
## Healthcare 82.26 17.74
## INFRA 87.79 12.21
## MMS 100.00 0.00Bar Chart for % of the Candidates Who Did Not join, Split by Line of Business (LOB)
CONTINUOUS DATA DISTRIBUTION
Average Age of the Candidates (Joined / Did Not join)
## Status AverageAgeofCandidates
## 1: Joined 30.00
## 2: NotJoined 29.52Mean Plot for the Age, Split by Status
Boxplot of Age, Split by Status (Joined / Did Not Join)
Average Notice Period of the Candidates, Split by Status (Joined / Did Not join)
## Status AverageNoticePeriod
## 1: Joined 37.24
## 2: NotJoined 48.19Mean Plot for Notice Period, Split by Status (Joined / Did Not join)
Boxplot for Notice Period of the Candidates, Split by Status (Joined / Did Not join)
Average (Relevant Years of Experience) of the candidates (Joined / Not joined)
## Status YearsOfExperience
## 1: Joined 4.19
## 2: NotJoined 4.44Mean Plot for the above
Boxplot of Relevant Years of Experience of the candidates (Joined / Not joined)
Average of DurationToAcceptOffer (Number of days taken by the candidate to accept the offer) of candidates (Joined / Not joined)
## Status DurationToAcceptOffer
## 1: Joined 20.62
## 2: NotJoined 24.96Mean Plot for the above
Average (Age, Relevant Years of Experience and Number of days taken by the candidate to accept the offer) of candidates (Joined / Not joined) by Gender (Male / Female)
## Status Gender AgeofCandidates YearsOfExperience DurationtoAcceptOffer
## 1: Joined Female 29.09 3.45 19.43
## 2: Joined Male 30.20 4.35 20.88
## 3: NotJoined Female 28.02 3.61 24.10
## 4: NotJoined Male 29.81 4.60 25.12
## NoticePeriod
## 1: 35.48
## 2: 37.62
## 3: 46.65
## 4: 48.49CORRELATION
Correlation Matrix for all the Continuous Variable
## DurationToAcceptOffer NoticePeriod RexInYrs Age
## DurationToAcceptOffer 1.00 0.36 0.11 0.02
## NoticePeriod 0.36 1.00 0.18 0.00
## RexInYrs 0.11 0.18 1.00 0.57
## Age 0.02 0.00 0.57 1.00
## PercentHikeExpectedInCTC 0.02 -0.01 -0.22 -0.14
## PercentHikeOfferedInCTC 0.01 -0.01 -0.11 -0.08
## PercentDifferenceCTC -0.01 -0.02 0.08 0.04
## PercentHikeExpectedInCTC PercentHikeOfferedInCTC
## DurationToAcceptOffer 0.02 0.01
## NoticePeriod -0.01 -0.01
## RexInYrs -0.22 -0.11
## Age -0.14 -0.08
## PercentHikeExpectedInCTC 1.00 0.67
## PercentHikeOfferedInCTC 0.67 1.00
## PercentDifferenceCTC -0.16 0.60
## PercentDifferenceCTC
## DurationToAcceptOffer -0.01
## NoticePeriod -0.02
## RexInYrs 0.08
## Age 0.04
## PercentHikeExpectedInCTC -0.16
## PercentHikeOfferedInCTC 0.60
## PercentDifferenceCTC 1.00
##
## n= 8995
##
##
## P
## DurationToAcceptOffer NoticePeriod RexInYrs Age
## DurationToAcceptOffer 0.0000 0.0000 0.0562
## NoticePeriod 0.0000 0.0000 0.6376
## RexInYrs 0.0000 0.0000 0.0000
## Age 0.0562 0.6376 0.0000
## PercentHikeExpectedInCTC 0.0743 0.6178 0.0000 0.0000
## PercentHikeOfferedInCTC 0.4883 0.2019 0.0000 0.0000
## PercentDifferenceCTC 0.3730 0.1531 0.0000 0.0003
## PercentHikeExpectedInCTC PercentHikeOfferedInCTC
## DurationToAcceptOffer 0.0743 0.4883
## NoticePeriod 0.6178 0.2019
## RexInYrs 0.0000 0.0000
## Age 0.0000 0.0000
## PercentHikeExpectedInCTC 0.0000
## PercentHikeOfferedInCTC 0.0000
## PercentDifferenceCTC 0.0000 0.0000
## PercentDifferenceCTC
## DurationToAcceptOffer 0.3730
## NoticePeriod 0.1531
## RexInYrs 0.0000
## Age 0.0003
## PercentHikeExpectedInCTC 0.0000
## PercentHikeOfferedInCTC 0.0000
## PercentDifferenceCTCPlotting Correlation Matrix
SCATTER PLOTS
Scatter Plot of Experience and Duration to Accept Offer by Status (Joined / Not Joined)
Scatter Plot of Experience and Notice Period by Status (Joined / Not Joined)
Scatter Plot of Experience and Percent Hike (CTC) Expected by Candidate by Status (Joined / Not Joined)
Scatter Plot of Experience and Percent Hike (CTC) Offered by Candidate by Status (Joined / Not Joined)
