HR Analytics

Sameer Mathur

Data Visualization

Behavioral Modelling to Predict Renege

---

IMPORTING DATA

(READING AND PREPARING DATA)

Number of Rows and Columns

[1] 8995   17

Data Structure

'data.frame':   8995 obs. of  17 variables:
 $ CandidateRef            : int  2110407 2112635 2112838 2115021 2115125 2117167 2119124 2127572 2138169 2143362 ...
 $ DOJExtended             : Factor w/ 2 levels "No","Yes": 2 1 1 1 2 2 2 2 1 1 ...
 $ DurationToAcceptOffer   : int  14 18 3 26 1 17 37 16 1 6 ...
 $ NoticePeriod            : int  30 30 45 30 120 30 30 0 30 30 ...
 $ OfferedBand             : Factor w/ 4 levels "E0","E1","E2",..: 3 3 3 3 3 2 3 2 2 2 ...
 $ PercentHikeExpectedInCTC: num  -20.8 50 42.8 42.8 42.6 ...
 $ PercentHikeOfferedInCTC : num  13.2 320 42.8 42.8 42.6 ...
 $ PercentDifferenceCTC    : num  42.9 180 0 0 0 ...
 $ JoiningBonus            : Factor w/ 2 levels "No","Yes": 1 1 1 1 1 1 1 1 1 1 ...
 $ CandidateRelocateActual : Factor w/ 2 levels "No","Yes": 1 1 1 1 2 1 1 1 1 1 ...
 $ Gender                  : Factor w/ 2 levels "Female","Male": 1 2 2 2 2 2 2 1 1 2 ...
 $ CandidateSource         : Factor w/ 3 levels "Agency","Direct",..: 1 3 1 3 3 3 3 2 3 3 ...
 $ RexInYrs                : int  7 8 4 4 6 2 7 8 3 3 ...
 $ LOB                     : Factor w/ 9 levels "AXON","BFSI",..: 5 8 8 8 8 8 8 7 2 3 ...
 $ Location                : Factor w/ 11 levels "Ahmedabad","Bangalore",..: 9 3 9 9 9 9 9 9 5 3 ...
 $ Age                     : int  34 34 27 34 34 34 32 34 26 34 ...
 $ Status                  : Factor w/ 2 levels "Joined","Not Joined": 1 1 1 1 1 1 1 1 1 1 ...

Descriptive Statistics

                         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       1

DISCRETE DATA VISUALIZATION

(PIE CHART, BARPLOT)

Pie Chart of Percentage of Candidates who Joined / Not Joined

plot of chunk unnamed-chunk-5

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by Gender

plot of chunk unnamed-chunk-7

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by Extended Joining Date

plot of chunk unnamed-chunk-9

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by Offer Band

plot of chunk unnamed-chunk-11

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by Joining Bonus

plot of chunk unnamed-chunk-13

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by Candidate Referral Source

plot of chunk unnamed-chunk-15

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by City Location

plot of chunk unnamed-chunk-17

Bar Chart of Percentage of the candiadtes (Joined / Not joined) the Company by Line of Business (LOB)

plot of chunk unnamed-chunk-19

CONTINUOUS DATA VISUALIZATION

(BOXPLOT, SCATTERPLOT)

Boxplot of Age by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-21

Boxplot of Duration to Accept Offer by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-23

Boxplot of Notice Period by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-25

Boxplot of Percent Hike (CTC) Expected by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-27

Boxplot of Percent Hike (CTC) Offered by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-29

Boxplot of Experience by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-31

Scatter Plot of Experience and Duration to Accept Offer by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-33

Scatter Plot of Experience and Notice Period by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-35

Scatter Plot of Experience and Percent Hike (CTC) Expected by Candidate by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-37

Scatter Plot of Experience and Percent Hike (CTC) Offered by Candidate by Status (Joined / Not Joined)

plot of chunk unnamed-chunk-39