HR Analytics

Sameer Mathur

Data Summary and Tables

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 DISTRIBUTION

(ONE-WAY, TWO-WAY AND THREE-WAY CONTINGENCY TABLES)

Percentage of the candiadtes (Joined / Not joined)

Status
    Joined Not Joined 
      81.3       18.7

Percentage of the candiadtes (Joined / Not joined) by DOJ Extended

           Status
DOJExtended Joined Not Joined
        No   81.08      18.92
        Yes  81.55      18.45
        Sum 162.63      37.37

Number of the candiadtes (Joined / Not joined) by Notice Period

            Status
NoticePeriod Joined Not Joined  Sum
         0      726         51  777
         30    4393        765 5158
         45     397        129  526
         60    1285        470 1755
         75      75         35  110
         90     415        212  627
         120     22         20   42
         Sum   7313       1682 8995

Percentage of the candiadtes (Joined / Not joined) by Notice Period

            Status
NoticePeriod Joined Not Joined
         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.62
         Sum 514.05     185.95

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

            Status
JoiningBonus Joined Not Joined
         No   81.34      18.66
         Yes  80.58      19.42
         Sum 161.91      38.09

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

        Status
Gender   Joined Not Joined
  Female  82.40      17.60
  Male    81.07      18.93
  Sum    163.47      36.53

Percentage of the candiadtes (Joined / Not joined) by Candidate Source

                   Status
CandidateSource     Joined Not Joined
  Agency             75.82      24.18
  Direct             82.00      18.00
  Employee Referral  88.00      12.00
  Sum               245.83      54.17

Percentage of the candiadtes (Joined / Not joined) by Offered Band

           Status
OfferedBand Joined Not Joined
        E0   76.30      23.70
        E1   81.30      18.70
        E2   80.97      19.03
        E3   85.15      14.85
        Sum 323.72      76.28

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

            Status
LOB          Joined Not Joined
  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.00
  Sum        739.48     160.52

Number of the candiadtes (Joined / Not joined) by Location

           Status
Location    Joined Not Joined  Sum
  Ahmedabad      5          1    6
  Bangalore   1742        488 2230
  Chennai     2486        664 3150
  Cochin         7          1    8
  Gurgaon      118         28  146
  Hyderabad    266         75  341
  Kolkata      100         29  129
  Mumbai       176         21  197
  Noida       2362        365 2727
  Others        13          0   13
  Pune          38         10   48
  Sum         7313       1682 8995

Percentage of the candiadtes (Joined / Not joined) by Location

           Status
Location    Joined Not Joined
  Ahmedabad  83.33      16.67
  Bangalore  78.12      21.88
  Chennai    78.92      21.08
  Cochin     87.50      12.50
  Gurgaon    80.82      19.18
  Hyderabad  78.01      21.99
  Kolkata    77.52      22.48
  Mumbai     89.34      10.66
  Noida      86.62      13.38
  Others    100.00       0.00
  Pune       79.17      20.83
  Sum       919.34     180.66

CONTINUOUS DATA DISTRIBUTION

(SUMMARY TABLES)

Average Age of the Candidates (Joined / Not joined)

       Status AverageAgeofCandidates
1:     Joined                  30.00
2: Not Joined                  29.52

Average Age and Notice Period of the Candidates (Joined / Not joined)

       Status AverageAgeofCandidates AverageNoticePeriod
1:     Joined                  30.00               37.24
2: Not Joined                  29.52               48.19

Average Age of the Candidates (Joined / Not joined) by Gender (Male / Female)

       Status Gender AverageAgeofCandidates
1:     Joined Female                  29.09
2:     Joined   Male                  30.20
3: Not Joined Female                  28.02
4: Not Joined   Male                  29.81

Average (Age and Relevant Years of Experience) of the candidates (Joined / Not joined) by Gender (Male / Female)

       Status Gender AverageAgeofCandidates YearsOfExperience
1:     Joined Female                  29.09              3.45
2:     Joined   Male                  30.20              4.35
3: Not Joined Female                  28.02              3.61
4: Not Joined   Male                  29.81              4.60

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 AverageAgeofCandidates YearsOfExperience
1:     Joined Female                  29.09              3.45
2:     Joined   Male                  30.20              4.35
3: Not Joined Female                  28.02              3.61
4: Not Joined   Male                  29.81              4.60
   DurationtoAcceptOffer
1:                 19.43
2:                 20.88
3:                 24.10
4:                 25.12

Average (Age and Notice Period) of the candidates (Joined / Not joined) by Gender (Male / Female)

       Status Gender AverageAgeofCandidates NoticePeriod
1:     Joined Female                  29.09        35.48
2:     Joined   Male                  30.20        37.62
3: Not Joined Female                  28.02        46.65
4: Not Joined   Male                  29.81        48.49