Deans Dilema
Krushali Shah
January 6, 2018
setwd("C:/Users/Dell/Downloads/Sameer Mathur")
dean.df<- read.csv("Deans Dilemma.csv")
View(dean.df)summary(dean.df)## SlNo Gender Gender.B Percent_SSC Board_SSC
## Min. : 1.0 F:127 Min. :0.0000 Min. :37.00 CBSE :113
## 1st Qu.: 98.5 M:264 1st Qu.:0.0000 1st Qu.:56.00 ICSE : 77
## Median :196.0 Median :0.0000 Median :64.50 Others:201
## Mean :196.0 Mean :0.3248 Mean :64.65
## 3rd Qu.:293.5 3rd Qu.:1.0000 3rd Qu.:74.00
## Max. :391.0 Max. :1.0000 Max. :87.20
##
## Board_CBSE Board_ICSE Percent_HSC Board_HSC
## Min. :0.000 Min. :0.0000 Min. :40.0 CBSE : 96
## 1st Qu.:0.000 1st Qu.:0.0000 1st Qu.:54.0 ISC : 48
## Median :0.000 Median :0.0000 Median :63.0 Others:247
## Mean :0.289 Mean :0.1969 Mean :63.8
## 3rd Qu.:1.000 3rd Qu.:0.0000 3rd Qu.:72.0
## Max. :1.000 Max. :1.0000 Max. :94.7
##
## Stream_HSC Percent_Degree Course_Degree
## Arts : 18 Min. :35.00 Arts : 13
## Commerce:222 1st Qu.:57.52 Commerce :117
## Science :151 Median :63.00 Computer Applications: 32
## Mean :62.98 Engineering : 37
## 3rd Qu.:69.00 Management :163
## Max. :89.00 Others : 5
## Science : 24
## Degree_Engg Experience_Yrs Entrance_Test S.TEST
## Min. :0.00000 Min. :0.0000 MAT :265 Min. :0.0000
## 1st Qu.:0.00000 1st Qu.:0.0000 None : 67 1st Qu.:1.0000
## Median :0.00000 Median :0.0000 K-MAT : 24 Median :1.0000
## Mean :0.09463 Mean :0.4783 CAT : 22 Mean :0.8286
## 3rd Qu.:0.00000 3rd Qu.:1.0000 PGCET : 8 3rd Qu.:1.0000
## Max. :1.00000 Max. :3.0000 GCET : 2 Max. :1.0000
## (Other): 3
## Percentile_ET S.TEST.SCORE Percent_MBA
## Min. : 0.00 Min. : 0.00 Min. :50.83
## 1st Qu.:41.19 1st Qu.:41.19 1st Qu.:57.20
## Median :62.00 Median :62.00 Median :61.01
## Mean :54.93 Mean :54.93 Mean :61.67
## 3rd Qu.:78.00 3rd Qu.:78.00 3rd Qu.:66.02
## Max. :98.69 Max. :98.69 Max. :77.89
##
## Specialization_MBA Marks_Communication Marks_Projectwork
## Marketing & Finance:222 Min. :50.00 Min. :50.00
## Marketing & HR :156 1st Qu.:53.00 1st Qu.:64.00
## Marketing & IB : 13 Median :58.00 Median :69.00
## Mean :60.54 Mean :68.36
## 3rd Qu.:67.00 3rd Qu.:74.00
## Max. :88.00 Max. :87.00
##
## Marks_BOCA Placement Placement_B Salary
## Min. :50.00 Not Placed: 79 Min. :0.000 Min. : 0
## 1st Qu.:57.00 Placed :312 1st Qu.:1.000 1st Qu.:172800
## Median :63.00 Median :1.000 Median :240000
## Mean :64.38 Mean :0.798 Mean :219078
## 3rd Qu.:72.50 3rd Qu.:1.000 3rd Qu.:300000
## Max. :96.00 Max. :1.000 Max. :940000
## library(psych)
describe(dean.df)## vars n mean sd median trimmed
## SlNo 1 391 196.00 113.02 196.00 196.00
## Gender* 2 391 1.68 0.47 2.00 1.72
## Gender.B 3 391 0.32 0.47 0.00 0.28
## Percent_SSC 4 391 64.65 10.96 64.50 64.76
## Board_SSC* 5 391 2.23 0.87 3.00 2.28
## Board_CBSE 6 391 0.29 0.45 0.00 0.24
## Board_ICSE 7 391 0.20 0.40 0.00 0.12
## Percent_HSC 8 391 63.80 11.42 63.00 63.34
## Board_HSC* 9 391 2.39 0.85 3.00 2.48
## Stream_HSC* 10 391 2.34 0.56 2.00 2.36
## Percent_Degree 11 391 62.98 8.92 63.00 62.91
## Course_Degree* 12 391 3.85 1.61 4.00 3.81
## Degree_Engg 13 391 0.09 0.29 0.00 0.00
## Experience_Yrs 14 391 0.48 0.67 0.00 0.36
## Entrance_Test* 15 391 5.85 1.35 6.00 6.08
## S.TEST 16 391 0.83 0.38 1.00 0.91
## Percentile_ET 17 391 54.93 31.17 62.00 56.87
## S.TEST.SCORE 18 391 54.93 31.17 62.00 56.87
## Percent_MBA 19 391 61.67 5.85 61.01 61.45
## Specialization_MBA* 20 391 1.47 0.56 1.00 1.42
## Marks_Communication 21 391 60.54 8.82 58.00 59.68
## Marks_Projectwork 22 391 68.36 7.15 69.00 68.60
## Marks_BOCA 23 391 64.38 9.58 63.00 64.08
## Placement* 24 391 1.80 0.40 2.00 1.87
## Placement_B 25 391 0.80 0.40 1.00 0.87
## Salary 26 391 219078.26 138311.65 240000.00 217011.50
## mad min max range skew kurtosis
## SlNo 145.29 1.00 391.00 390.00 0.00 -1.21
## Gender* 0.00 1.00 2.00 1.00 -0.75 -1.45
## Gender.B 0.00 0.00 1.00 1.00 0.75 -1.45
## Percent_SSC 12.60 37.00 87.20 50.20 -0.06 -0.72
## Board_SSC* 0.00 1.00 3.00 2.00 -0.45 -1.53
## Board_CBSE 0.00 0.00 1.00 1.00 0.93 -1.14
## Board_ICSE 0.00 0.00 1.00 1.00 1.52 0.31
## Percent_HSC 13.34 40.00 94.70 54.70 0.29 -0.67
## Board_HSC* 0.00 1.00 3.00 2.00 -0.83 -1.13
## Stream_HSC* 0.00 1.00 3.00 2.00 -0.12 -0.72
## Percent_Degree 8.90 35.00 89.00 54.00 0.05 0.24
## Course_Degree* 1.48 1.00 7.00 6.00 0.00 -1.08
## Degree_Engg 0.00 0.00 1.00 1.00 2.76 5.63
## Experience_Yrs 0.00 0.00 3.00 3.00 1.27 1.17
## Entrance_Test* 0.00 1.00 9.00 8.00 -2.52 7.04
## S.TEST 0.00 0.00 1.00 1.00 -1.74 1.02
## Percentile_ET 25.20 0.00 98.69 98.69 -0.74 -0.69
## S.TEST.SCORE 25.20 0.00 98.69 98.69 -0.74 -0.69
## Percent_MBA 6.39 50.83 77.89 27.06 0.34 -0.52
## Specialization_MBA* 0.00 1.00 3.00 2.00 0.70 -0.56
## Marks_Communication 8.90 50.00 88.00 38.00 0.74 -0.25
## Marks_Projectwork 7.41 50.00 87.00 37.00 -0.26 -0.27
## Marks_BOCA 11.86 50.00 96.00 46.00 0.29 -0.85
## Placement* 0.00 1.00 2.00 1.00 -1.48 0.19
## Placement_B 0.00 0.00 1.00 1.00 -1.48 0.19
## Salary 88956.00 0.00 940000.00 940000.00 0.24 1.74
## se
## SlNo 5.72
## Gender* 0.02
## Gender.B 0.02
## Percent_SSC 0.55
## Board_SSC* 0.04
## Board_CBSE 0.02
## Board_ICSE 0.02
## Percent_HSC 0.58
## Board_HSC* 0.04
## Stream_HSC* 0.03
## Percent_Degree 0.45
## Course_Degree* 0.08
## Degree_Engg 0.01
## Experience_Yrs 0.03
## Entrance_Test* 0.07
## S.TEST 0.02
## Percentile_ET 1.58
## S.TEST.SCORE 1.58
## Percent_MBA 0.30
## Specialization_MBA* 0.03
## Marks_Communication 0.45
## Marks_Projectwork 0.36
## Marks_BOCA 0.48
## Placement* 0.02
## Placement_B 0.02
## Salary 6994.72Calculating the median salary of all the students in the data sample.
median(dean.df$Salary)## [1] 240000Calculating the percentage of students who were placed, correct to 2 decimal places.
mytable <- with(dean.df,table(Placement))
round(prop.table(mytable)*100, digits = 2)## Placement
## Not Placed Placed
## 20.2 79.8Creating a dataframe called placed, that contains a subset of only those students who were successfully placed.
placed<- subset(dean.df,Placement == "Placed", select = c(SlNo,Gender,Placement,Salary,Percent_MBA))
placed## SlNo Gender Placement Salary Percent_MBA
## 1 1 M Placed 270000 58.80
## 2 2 M Placed 200000 66.28
## 3 3 M Placed 240000 52.91
## 4 4 M Placed 250000 57.80
## 5 5 M Placed 180000 59.43
## 6 6 M Placed 300000 56.81
## 7 7 F Placed 260000 59.80
## 8 8 M Placed 235000 57.23
## 9 9 M Placed 425000 55.50
## 10 10 F Placed 240000 63.83
## 12 12 M Placed 250000 54.01
## 13 13 M Placed 180000 51.58
## 14 14 M Placed 428000 66.92
## 15 15 M Placed 450000 58.21
## 17 17 M Placed 300000 58.94
## 18 18 M Placed 240000 54.78
## 19 19 M Placed 252000 62.14
## 21 21 M Placed 280000 63.26
## 22 22 M Placed 231000 61.29
## 23 23 M Placed 224000 62.51
## 24 24 M Placed 120000 52.21
## 25 25 M Placed 260000 60.85
## 26 26 M Placed 300000 60.77
## 27 27 M Placed 120000 51.75
## 28 28 M Placed 120000 58.56
## 29 29 M Placed 250000 63.70
## 30 30 F Placed 180000 65.04
## 31 31 F Placed 218000 68.63
## 32 32 M Placed 360000 57.68
## 33 33 M Placed 150000 54.96
## 34 34 F Placed 250000 64.19
## 35 35 F Placed 200000 64.66
## 36 36 M Placed 300000 62.54
## 37 37 M Placed 330000 52.41
## 38 38 M Placed 265000 56.61
## 39 39 M Placed 340000 61.83
## 41 41 F Placed 177600 64.08
## 44 44 M Placed 236000 77.89
## 45 45 M Placed 265000 56.70
## 46 46 M Placed 200000 57.74
## 47 47 F Placed 393000 69.06
## 48 48 F Placed 360000 68.81
## 49 49 F Placed 300000 63.62
## 50 50 M Placed 250000 53.42
## 51 51 M Placed 360000 74.01
## 52 52 F Placed 180000 65.33
## 53 53 F Placed 180000 62.80
## 54 54 M Placed 270000 58.53
## 55 55 M Placed 240000 57.55
## 56 56 M Placed 300000 60.76
## 57 57 M Placed 265000 57.69
## 58 58 M Placed 350000 64.15
## 60 60 F Placed 250000 56.70
## 61 61 F Placed 180000 58.32
## 62 62 F Placed 278000 62.21
## 63 63 M Placed 150000 57.61
## 65 65 F Placed 260000 72.78
## 66 66 M Placed 180000 62.77
## 67 67 F Placed 300000 62.74
## 69 69 M Placed 400000 68.85
## 70 70 F Placed 320000 55.47
## 71 71 F Placed 240000 56.86
## 72 72 M Placed 411000 62.56
## 73 73 F Placed 287000 66.72
## 74 74 F Placed 198000 69.76
## 76 76 M Placed 300000 62.90
## 77 77 F Placed 200000 69.70
## 78 78 F Placed 180000 66.53
## 80 80 M Placed 204000 54.55
## 81 81 M Placed 250000 62.46
## 83 83 F Placed 200000 62.98
## 84 84 M Placed 275000 62.27
## 85 85 M Placed 192000 62.65
## 86 86 F Placed 240000 57.83
## 87 87 F Placed 300000 60.91
## 90 90 M Placed 450000 71.04
## 91 91 F Placed 216000 65.56
## 92 92 M Placed 220000 52.71
## 93 93 M Placed 216000 55.10
## 95 95 M Placed 300000 67.31
## 96 96 M Placed 240000 66.88
## 97 97 M Placed 360000 63.59
## 99 99 M Placed 268000 57.99
## 101 101 M Placed 265000 56.66
## 102 102 M Placed 260000 57.24
## 103 103 M Placed 240000 67.53
## 104 104 M Placed 300000 62.48
## 105 105 F Placed 240000 59.69
## 106 106 M Placed 180000 52.82
## 107 107 M Placed 240000 64.75
## 108 108 M Placed 400000 57.76
## 110 110 M Placed 180000 52.43
## 111 111 M Placed 250000 76.72
## 113 113 F Placed 295000 69.35
## 114 114 M Placed 180000 59.50
## 115 115 F Placed 300000 62.89
## 116 116 M Placed 240000 58.78
## 117 117 M Placed 120000 57.10
## 118 118 M Placed 250000 59.10
## 119 119 M Placed 275000 58.46
## 120 120 M Placed 275000 60.99
## 121 121 F Placed 150000 59.24
## 122 122 M Placed 275000 68.07
## 123 123 M Placed 300000 60.03
## 124 124 M Placed 240000 58.75
## 125 125 M Placed 336000 69.81
## 126 126 M Placed 360000 65.45
## 127 127 M Placed 280000 62.40
## 129 129 M Placed 325000 60.43
## 130 130 M Placed 204000 60.76
## 131 131 M Placed 240000 66.94
## 132 132 M Placed 240000 68.53
## 133 133 F Placed 336000 61.41
## 134 134 M Placed 218000 59.75
## 135 135 M Placed 216000 55.02
## 136 136 M Placed 336000 67.20
## 137 137 F Placed 190000 67.00
## 138 138 F Placed 230000 64.27
## 139 139 M Placed 390000 51.24
## 140 140 M Placed 500000 57.65
## 141 141 M Placed 270000 59.42
## 142 142 F Placed 150000 67.99
## 143 143 F Placed 240000 62.35
## 145 145 F Placed 276000 62.01
## 146 146 M Placed 300000 70.20
## 147 147 M Placed 168000 60.44
## 148 148 M Placed 300000 66.69
## 150 150 M Placed 270000 59.81
## 151 151 M Placed 360000 55.60
## 152 152 M Placed 300000 62.00
## 153 153 F Placed 400000 76.18
## 154 154 M Placed 220000 57.03
## 155 155 M Placed 180000 59.08
## 156 156 M Placed 180000 58.85
## 157 157 F Placed 210000 64.36
## 158 158 F Placed 210000 62.36
## 159 159 F Placed 300000 68.03
## 160 160 F Placed 290000 66.86
## 161 161 M Placed 180000 62.79
## 163 163 F Placed 230000 59.47
## 164 164 M Placed 282000 64.63
## 165 165 M Placed 260000 53.57
## 167 167 M Placed 180000 66.50
## 168 168 M Placed 260000 54.97
## 169 169 M Placed 400000 56.51
## 170 170 M Placed 420000 62.16
## 171 171 M Placed 144000 54.35
## 172 172 F Placed 300000 64.44
## 173 173 F Placed 150000 69.03
## 174 174 F Placed 220000 57.31
## 177 177 M Placed 380000 60.44
## 178 178 M Placed 290000 59.99
## 179 179 F Placed 300000 61.31
## 180 180 F Placed 252000 55.42
## 181 181 M Placed 280000 63.39
## 182 182 M Placed 240000 65.83
## 183 183 M Placed 360000 58.23
## 185 185 M Placed 180000 65.69
## 186 186 F Placed 450000 67.83
## 187 187 M Placed 200000 73.52
## 188 188 M Placed 300000 58.31
## 189 189 M Placed 350000 53.37
## 190 190 M Placed 550000 56.11
## 192 192 M Placed 250000 63.36
## 193 193 F Placed 250000 54.80
## 195 195 M Placed 250000 53.94
## 196 196 F Placed 280000 63.08
## 197 197 M Placed 250000 55.01
## 198 198 F Placed 216000 60.50
## 199 199 M Placed 204000 52.42
## 200 200 M Placed 300000 70.85
## 201 201 M Placed 240000 67.05
## 202 202 M Placed 276000 70.48
## 203 203 M Placed 940000 64.34
## 205 205 F Placed 250000 71.49
## 206 206 M Placed 300000 59.99
## 207 207 F Placed 180000 57.98
## 208 208 F Placed 236000 71.00
## 209 209 M Placed 240000 56.70
## 210 210 M Placed 250000 61.26
## 211 211 F Placed 350000 73.33
## 212 212 M Placed 210000 59.50
## 213 213 F Placed 210000 68.20
## 214 214 F Placed 250000 58.40
## 215 215 M Placed 400000 76.26
## 216 216 M Placed 300000 70.71
## 217 217 M Placed 480000 61.79
## 218 218 M Placed 250000 68.55
## 219 219 M Placed 320000 67.54
## 221 221 M Placed 385000 69.94
## 222 222 F Placed 360000 60.78
## 223 223 M Placed 300000 53.49
## 224 224 F Placed 375000 73.87
## 225 225 M Placed 250000 60.98
## 227 227 F Placed 250000 67.13
## 228 228 F Placed 275000 58.73
## 229 229 F Placed 200000 65.63
## 230 230 F Placed 150000 61.58
## 232 232 M Placed 300000 60.95
## 233 233 M Placed 225000 60.41
## 234 234 F Placed 120000 60.00
## 235 235 F Placed 250000 71.77
## 237 237 M Placed 220000 54.43
## 238 238 M Placed 265000 57.24
## 239 239 M Placed 265000 56.94
## 242 242 M Placed 260000 61.29
## 243 243 M Placed 300000 60.39
## 244 244 M Placed 180000 51.73
## 245 245 M Placed 530000 59.54
## 246 246 M Placed 156000 56.75
## 247 247 M Placed 263000 58.95
## 249 249 M Placed 400000 63.23
## 250 250 M Placed 233000 55.14
## 251 251 M Placed 300000 62.28
## 253 253 F Placed 240000 64.08
## 254 254 M Placed 180000 58.54
## 255 255 M Placed 350000 62.89
## 256 256 M Placed 198000 55.67
## 257 257 F Placed 250000 68.55
## 259 259 M Placed 690000 61.30
## 260 260 M Placed 270000 58.87
## 261 261 F Placed 240000 65.25
## 262 262 M Placed 300000 69.08
## 263 263 M Placed 340000 62.48
## 264 264 M Placed 250000 53.20
## 265 265 M Placed 390000 59.84
## 267 267 M Placed 255000 52.72
## 268 268 M Placed 300000 55.03
## 270 270 M Placed 150000 60.59
## 271 271 M Placed 300000 72.29
## 273 273 M Placed 270000 59.71
## 274 274 F Placed 240000 53.47
## 275 275 M Placed 180000 62.72
## 276 276 M Placed 285000 66.06
## 277 277 M Placed 400000 69.67
## 278 278 M Placed 500000 66.46
## 279 279 F Placed 250000 65.52
## 280 280 M Placed 300000 56.78
## 281 281 F Placed 240000 67.06
## 282 282 M Placed 300000 71.86
## 283 283 M Placed 240000 70.10
## 286 286 M Placed 240000 52.38
## 292 292 M Placed 476000 66.39
## 293 293 M Placed 290000 66.04
## 294 294 M Placed 690000 72.97
## 295 295 M Placed 300000 52.64
## 296 296 M Placed 250000 64.79
## 297 297 F Placed 162000 59.32
## 299 299 F Placed 260000 66.90
## 300 300 M Placed 500000 66.23
## 302 302 F Placed 220000 57.90
## 303 303 M Placed 270000 58.67
## 304 304 F Placed 650000 70.81
## 305 305 M Placed 350000 68.07
## 306 306 M Placed 300000 62.00
## 308 308 M Placed 265000 56.60
## 309 309 M Placed 180000 54.04
## 311 311 F Placed 300000 64.28
## 312 312 F Placed 300000 66.00
## 313 313 F Placed 300000 68.68
## 314 314 F Placed 220000 59.15
## 316 316 M Placed 240000 54.12
## 319 319 M Placed 276000 61.82
## 320 320 M Placed 250000 66.28
## 321 321 F Placed 180000 67.96
## 323 323 F Placed 252000 71.43
## 325 325 M Placed 280000 64.86
## 327 327 F Placed 350000 66.63
## 331 331 F Placed 216000 66.61
## 333 333 M Placed 264000 61.01
## 334 334 M Placed 270000 57.34
## 335 335 F Placed 300000 56.63
## 337 337 M Placed 275000 58.95
## 339 339 M Placed 300000 54.50
## 340 340 M Placed 250000 54.48
## 341 341 F Placed 260000 69.71
## 342 342 F Placed 185000 71.96
## 343 343 F Placed 216000 63.91
## 345 345 M Placed 265000 55.80
## 346 346 M Placed 300000 52.81
## 347 347 M Placed 325000 56.12
## 348 348 M Placed 267000 53.37
## 349 349 F Placed 264000 62.95
## 351 351 M Placed 240000 60.11
## 353 353 M Placed 260000 58.30
## 354 354 F Placed 240000 69.12
## 356 356 M Placed 250000 56.98
## 357 357 F Placed 180000 63.42
## 358 358 F Placed 366000 69.52
## 359 359 F Placed 210000 67.69
## 360 360 M Placed 250000 52.64
## 361 361 M Placed 250000 56.81
## 362 362 M Placed 426000 60.39
## 363 363 M Placed 270000 60.04
## 365 365 M Placed 300000 71.55
## 366 366 M Placed 132000 56.45
## 367 367 F Placed 144000 62.92
## 368 368 M Placed 220000 55.40
## 369 369 M Placed 216000 56.49
## 370 370 M Placed 400000 74.49
## 371 371 M Placed 275000 53.62
## 372 372 M Placed 295000 69.72
## 373 373 M Placed 360000 65.80
## 374 374 F Placed 204000 60.23
## 378 378 M Placed 350000 66.22
## 380 380 F Placed 300000 77.30
## 381 381 M Placed 180000 53.19
## 385 385 M Placed 252000 61.00
## 387 387 M Placed 162000 58.63
## 388 388 M Placed 450000 59.50
## 389 389 M Placed 240000 61.63
## 390 390 F Placed 300000 70.17Finding the median salary of students who were placed.
median(placed$Salary)## [1] 260000Creating a table showing the mean salary of males and females, who were placed.
aggregate(placed$Salary,list(placed$Gender),mean)## Group.1 x
## 1 F 253068.0
## 2 M 284241.9Generating a histogram showing a breakup of the MBA performance of the students who were placed.
hist(placed$Percent_MBA , main = "MBA performance of place students", xlab = "MBA Percentage", ylab = "Count",col = "gray")
Creating a dataframe called notplaced, that contains a subset of only those students who were NOT placed after their MBA.
notplaced<- subset(dean.df, Placement=="Not Placed", select = c(SlNo,Placement,Percent_MBA))
notplaced## SlNo Placement Percent_MBA
## 11 11 Not Placed 69.78
## 16 16 Not Placed 53.29
## 20 20 Not Placed 54.65
## 40 40 Not Placed 67.28
## 42 42 Not Placed 51.75
## 43 43 Not Placed 56.34
## 59 59 Not Placed 51.29
## 64 64 Not Placed 52.56
## 68 68 Not Placed 51.45
## 75 75 Not Placed 51.21
## 79 79 Not Placed 71.63
## 82 82 Not Placed 56.11
## 88 88 Not Placed 56.19
## 89 89 Not Placed 65.49
## 94 94 Not Placed 61.31
## 98 98 Not Placed 60.29
## 100 100 Not Placed 56.45
## 109 109 Not Placed 72.00
## 112 112 Not Placed 54.76
## 128 128 Not Placed 71.15
## 144 144 Not Placed 67.13
## 149 149 Not Placed 55.83
## 162 162 Not Placed 58.00
## 166 166 Not Placed 55.41
## 175 175 Not Placed 59.47
## 176 176 Not Placed 64.95
## 184 184 Not Placed 55.30
## 191 191 Not Placed 56.09
## 194 194 Not Placed 60.64
## 204 204 Not Placed 58.81
## 220 220 Not Placed 64.15
## 226 226 Not Placed 62.29
## 231 231 Not Placed 62.83
## 236 236 Not Placed 57.32
## 240 240 Not Placed 61.90
## 241 241 Not Placed 61.22
## 248 248 Not Placed 58.52
## 252 252 Not Placed 52.32
## 258 258 Not Placed 55.87
## 266 266 Not Placed 65.99
## 269 269 Not Placed 61.87
## 272 272 Not Placed 65.13
## 284 284 Not Placed 74.56
## 285 285 Not Placed 54.99
## 287 287 Not Placed 75.71
## 288 288 Not Placed 57.16
## 289 289 Not Placed 58.79
## 290 290 Not Placed 65.48
## 291 291 Not Placed 69.28
## 298 298 Not Placed 67.44
## 301 301 Not Placed 60.69
## 307 307 Not Placed 72.14
## 310 310 Not Placed 60.02
## 315 315 Not Placed 63.83
## 317 317 Not Placed 59.81
## 318 318 Not Placed 61.66
## 322 322 Not Placed 57.29
## 324 324 Not Placed 62.93
## 326 326 Not Placed 56.13
## 328 328 Not Placed 66.94
## 329 329 Not Placed 63.94
## 330 330 Not Placed 62.50
## 332 332 Not Placed 66.18
## 336 336 Not Placed 64.74
## 338 338 Not Placed 65.28
## 344 344 Not Placed 63.53
## 350 350 Not Placed 58.44
## 352 352 Not Placed 72.21
## 355 355 Not Placed 51.48
## 364 364 Not Placed 53.39
## 375 375 Not Placed 62.42
## 376 376 Not Placed 60.22
## 377 377 Not Placed 52.36
## 379 379 Not Placed 56.00
## 382 382 Not Placed 50.83
## 383 383 Not Placed 56.81
## 384 384 Not Placed 59.14
## 386 386 Not Placed 67.94
## 391 391 Not Placed 60.36Drawing two histograms side-by-side, visually comparing the MBA performance of Placed and Not Placed students
par(mfrow=c(1,2))
hist(placed$Percent_MBA , main = "MBA performance of place students", xlab = "MBA Percentage", ylab = "Count",col = "gray")
hist(notplaced$Percent_MBA , main = "MBA performance of place students", xlab = "MBA Percentage", ylab = "Count",col = "gray")
Drawing two boxplots, one below the other, comparing the distribution of salaries of males and females who were placed.
boxplot(Salary~Gender,data = placed,horizontal=TRUE,yaxt="n",main="Comparison of salaries of males and females",xlab="Salary",ylab="Gender")
axis(side = 2,at=c(1,2),labels = c("Females","Males"))
Creating a dataframe called placedET, representing students who were placed after the MBA and who also gave some MBA entrance test before admission into the MBA program.
placedET<-subset(dean.df, Placement=="Placed" & Entrance_Test!= "None",select=c(SlNo,Placement,Entrance_Test,Salary,Percent_MBA,Percentile_ET))
placedET## SlNo Placement Entrance_Test Salary Percent_MBA Percentile_ET
## 1 1 Placed MAT 270000 58.80 55.00
## 2 2 Placed MAT 200000 66.28 86.50
## 4 4 Placed MAT 250000 57.80 75.00
## 5 5 Placed MAT 180000 59.43 66.00
## 8 8 Placed MAT 235000 57.23 43.12
## 9 9 Placed MAT 425000 55.50 96.80
## 12 12 Placed MAT 250000 54.01 79.00
## 13 13 Placed MAT 180000 51.58 55.00
## 15 15 Placed CAT 450000 58.21 33.00
## 19 19 Placed MAT 252000 62.14 67.00
## 21 21 Placed CAT 280000 63.26 70.00
## 22 22 Placed MAT 231000 61.29 91.34
## 23 23 Placed MAT 224000 62.51 35.00
## 24 24 Placed MAT 120000 52.21 54.00
## 25 25 Placed MAT 260000 60.85 62.00
## 26 26 Placed MAT 300000 60.77 75.00
## 28 28 Placed MAT 120000 58.56 49.00
## 29 29 Placed MAT 250000 63.70 60.00
## 30 30 Placed MAT 180000 65.04 62.00
## 31 31 Placed MAT 218000 68.63 68.00
## 33 33 Placed MAT 150000 54.96 76.00
## 34 34 Placed MAT 250000 64.19 48.00
## 35 35 Placed MAT 200000 64.66 72.00
## 36 36 Placed MAT 300000 62.54 60.00
## 37 37 Placed K-MAT 330000 52.41 79.00
## 38 38 Placed PGCET 265000 56.61 0.00
## 39 39 Placed CAT 340000 61.83 70.00
## 41 41 Placed MAT 177600 64.08 68.00
## 44 44 Placed MAT 236000 77.89 50.48
## 45 45 Placed MAT 265000 56.70 50.00
## 47 47 Placed MAT 393000 69.06 95.00
## 48 48 Placed MAT 360000 68.81 55.53
## 49 49 Placed MAT 300000 63.62 92.00
## 51 51 Placed MAT 360000 74.01 97.40
## 52 52 Placed MAT 180000 65.33 76.00
## 53 53 Placed MAT 180000 62.80 74.00
## 55 55 Placed MAT 240000 57.55 94.00
## 56 56 Placed CAT 300000 60.76 41.38
## 57 57 Placed MAT 265000 57.69 68.00
## 58 58 Placed MAT 350000 64.15 73.35
## 60 60 Placed MAT 250000 56.70 52.00
## 61 61 Placed MAT 180000 58.32 64.00
## 62 62 Placed MAT 278000 62.21 50.89
## 63 63 Placed MAT 150000 57.61 83.00
## 65 65 Placed MAT 260000 72.78 88.00
## 66 66 Placed MAT 180000 62.77 68.44
## 67 67 Placed MAT 300000 62.74 71.00
## 69 69 Placed PGCET 400000 68.85 0.00
## 70 70 Placed MAT 320000 55.47 58.00
## 71 71 Placed MAT 240000 56.86 53.70
## 72 72 Placed MAT 411000 62.56 93.00
## 73 73 Placed MAT 287000 66.72 60.00
## 74 74 Placed MAT 198000 69.76 65.00
## 76 76 Placed MAT 300000 62.90 95.00
## 77 77 Placed MAT 200000 69.70 89.00
## 78 78 Placed MAT 180000 66.53 58.00
## 80 80 Placed MAT 204000 54.55 78.00
## 81 81 Placed MAT 250000 62.46 64.00
## 83 83 Placed MAT 200000 62.98 65.00
## 84 84 Placed MAT 275000 62.27 97.33
## 85 85 Placed MAT 192000 62.65 67.00
## 87 87 Placed CAT 300000 60.91 53.00
## 90 90 Placed MAT 450000 71.04 87.00
## 91 91 Placed MAT 216000 65.56 78.00
## 92 92 Placed MAT 220000 52.71 71.00
## 95 95 Placed CAT 300000 67.31 68.00
## 96 96 Placed MAT 240000 66.88 68.00
## 97 97 Placed MAT 360000 63.59 80.00
## 99 99 Placed MAT 268000 57.99 74.00
## 101 101 Placed MAT 265000 56.66 57.60
## 102 102 Placed MAT 260000 57.24 60.00
## 104 104 Placed MAT 300000 62.48 61.60
## 105 105 Placed MAT 240000 59.69 59.00
## 107 107 Placed MAT 240000 64.75 44.56
## 108 108 Placed CAT 400000 57.76 13.00
## 111 111 Placed CAT 250000 76.72 78.00
## 114 114 Placed MAT 180000 59.50 68.50
## 116 116 Placed MAT 240000 58.78 61.00
## 117 117 Placed MAT 120000 57.10 89.69
## 119 119 Placed MAT 275000 58.46 68.92
## 120 120 Placed MAT 275000 60.99 68.71
## 121 121 Placed MAT 150000 59.24 79.00
## 122 122 Placed MAT 275000 68.07 70.00
## 124 124 Placed MAT 240000 58.75 41.00
## 126 126 Placed MAT 360000 65.45 89.00
## 127 127 Placed MAT 280000 62.40 46.92
## 129 129 Placed GCET 325000 60.43 50.00
## 130 130 Placed GCET 204000 60.76 40.00
## 131 131 Placed MAT 240000 66.94 95.00
## 132 132 Placed MAT 240000 68.53 95.50
## 133 133 Placed K-MAT 336000 61.41 96.00
## 134 134 Placed MAT 218000 59.75 86.00
## 136 136 Placed MAT 336000 67.20 84.27
## 137 137 Placed MAT 190000 67.00 74.00
## 138 138 Placed MAT 230000 64.27 61.00
## 139 139 Placed K-MAT 390000 51.24 94.30
## 140 140 Placed MAT 500000 57.65 69.00
## 141 141 Placed MAT 270000 59.42 86.04
## 142 142 Placed MAT 150000 67.99 75.00
## 143 143 Placed MAT 240000 62.35 67.00
## 145 145 Placed MAT 276000 62.01 40.00
## 146 146 Placed MAT 300000 70.20 86.00
## 147 147 Placed MAT 168000 60.44 82.00
## 148 148 Placed MAT 300000 66.69 84.00
## 150 150 Placed G-MAT 270000 59.81 0.00
## 152 152 Placed MAT 300000 62.00 55.00
## 153 153 Placed MAT 400000 76.18 78.74
## 154 154 Placed MAT 220000 57.03 67.00
## 155 155 Placed MAT 180000 59.08 75.00
## 156 156 Placed MAT 180000 58.85 64.00
## 157 157 Placed MAT 210000 64.36 58.00
## 158 158 Placed MAT 210000 62.36 62.00
## 159 159 Placed MAT 300000 68.03 92.00
## 160 160 Placed MAT 290000 66.86 92.00
## 161 161 Placed MAT 180000 62.79 67.00
## 163 163 Placed MAT 230000 59.47 72.00
## 164 164 Placed MAT 282000 64.63 47.41
## 165 165 Placed CAT 260000 53.57 29.00
## 167 167 Placed CAT 180000 66.50 56.39
## 168 168 Placed MAT 260000 54.97 53.88
## 169 169 Placed CAT 400000 56.51 79.00
## 170 170 Placed MAT 420000 62.16 95.46
## 172 172 Placed MAT 300000 64.44 66.00
## 173 173 Placed MAT 150000 69.03 93.91
## 174 174 Placed MAT 220000 57.31 70.00
## 177 177 Placed MAT 380000 60.44 78.00
## 179 179 Placed MAT 300000 61.31 57.50
## 180 180 Placed K-MAT 252000 55.42 67.00
## 181 181 Placed K-MAT 280000 63.39 58.00
## 182 182 Placed MAT 240000 65.83 85.00
## 183 183 Placed MAT 360000 58.23 55.00
## 185 185 Placed MAT 180000 65.69 71.00
## 186 186 Placed K-MAT 450000 67.83 95.00
## 187 187 Placed MAT 200000 73.52 80.00
## 188 188 Placed MAT 300000 58.31 84.00
## 193 193 Placed MAT 250000 54.80 57.20
## 195 195 Placed MAT 250000 53.94 58.00
## 196 196 Placed MAT 280000 63.08 72.15
## 197 197 Placed MAT 250000 55.01 53.70
## 198 198 Placed MAT 216000 60.50 89.00
## 199 199 Placed MAT 204000 52.42 39.00
## 200 200 Placed MAT 300000 70.85 96.00
## 201 201 Placed MAT 240000 67.05 80.00
## 202 202 Placed MAT 276000 70.48 97.00
## 203 203 Placed MAT 940000 64.34 82.66
## 205 205 Placed MAT 250000 71.49 55.67
## 206 206 Placed PGCET 300000 59.99 85.00
## 207 207 Placed K-MAT 180000 57.98 14.99
## 208 208 Placed MAT 236000 71.00 80.40
## 209 209 Placed MAT 240000 56.70 60.00
## 210 210 Placed MAT 250000 61.26 64.00
## 211 211 Placed MAT 350000 73.33 75.00
## 213 213 Placed MAT 210000 68.20 70.00
## 214 214 Placed MAT 250000 58.40 55.50
## 215 215 Placed MAT 400000 76.26 81.20
## 216 216 Placed K-MAT 300000 70.71 84.00
## 217 217 Placed K-MAT 480000 61.79 86.00
## 218 218 Placed MAT 250000 68.55 90.00
## 219 219 Placed K-MAT 320000 67.54 89.95
## 221 221 Placed CAT 385000 69.94 65.00
## 222 222 Placed MAT 360000 60.78 80.00
## 223 223 Placed MAT 300000 53.49 74.40
## 225 225 Placed MAT 250000 60.98 65.00
## 227 227 Placed MAT 250000 67.13 94.00
## 228 228 Placed MAT 275000 58.73 43.00
## 229 229 Placed MAT 200000 65.63 55.60
## 230 230 Placed MAT 150000 61.58 78.00
## 232 232 Placed CAT 300000 60.95 65.00
## 233 233 Placed MAT 225000 60.41 56.00
## 235 235 Placed MAT 250000 71.77 96.00
## 237 237 Placed MAT 220000 54.43 58.00
## 239 239 Placed MAT 265000 56.94 56.00
## 242 242 Placed MAT 260000 61.29 60.00
## 243 243 Placed MAT 300000 60.39 89.00
## 244 244 Placed MAT 180000 51.73 39.00
## 245 245 Placed K-MAT 530000 59.54 65.00
## 246 246 Placed MAT 156000 56.75 66.60
## 247 247 Placed MAT 263000 58.95 40.00
## 249 249 Placed MAT 400000 63.23 72.00
## 250 250 Placed MAT 233000 55.14 85.00
## 251 251 Placed MAT 300000 62.28 83.00
## 253 253 Placed MAT 240000 64.08 57.00
## 254 254 Placed MAT 180000 58.54 64.25
## 256 256 Placed MAT 198000 55.67 40.00
## 259 259 Placed MAT 690000 61.30 56.00
## 260 260 Placed MAT 270000 58.87 83.00
## 261 261 Placed MAT 240000 65.25 98.00
## 263 263 Placed MAT 340000 62.48 86.00
## 264 264 Placed MAT 250000 53.20 70.00
## 267 267 Placed MAT 255000 52.72 80.00
## 268 268 Placed MAT 300000 55.03 93.40
## 270 270 Placed MAT 150000 60.59 62.00
## 271 271 Placed MAT 300000 72.29 75.00
## 273 273 Placed MAT 270000 59.71 49.70
## 275 275 Placed MAT 180000 62.72 57.63
## 276 276 Placed MAT 285000 66.06 75.20
## 278 278 Placed MAT 500000 66.46 75.00
## 279 279 Placed MAT 250000 65.52 53.04
## 283 283 Placed K-MAT 240000 70.10 88.00
## 286 286 Placed MAT 240000 52.38 63.00
## 292 292 Placed CAT 476000 66.39 80.00
## 293 293 Placed MAT 290000 66.04 63.79
## 294 294 Placed K-MAT 690000 72.97 95.50
## 295 295 Placed MAT 300000 52.64 84.00
## 296 296 Placed MAT 250000 64.79 49.00
## 297 297 Placed MAT 162000 59.32 67.00
## 300 300 Placed MAT 500000 66.23 64.00
## 302 302 Placed MAT 220000 57.90 55.00
## 303 303 Placed K-MAT 270000 58.67 76.20
## 304 304 Placed MAT 650000 70.81 89.00
## 305 305 Placed MAT 350000 68.07 73.00
## 306 306 Placed MAT 300000 62.00 44.20
## 308 308 Placed MAT 265000 56.60 57.00
## 309 309 Placed MAT 180000 54.04 35.00
## 311 311 Placed K-MAT 300000 64.28 62.00
## 313 313 Placed XAT 300000 68.68 74.00
## 316 316 Placed PGCET 240000 54.12 0.00
## 319 319 Placed MAT 276000 61.82 60.00
## 323 323 Placed MAT 252000 71.43 82.00
## 325 325 Placed MAT 280000 64.86 95.00
## 327 327 Placed CAT 350000 66.63 60.00
## 333 333 Placed MAT 264000 61.01 72.00
## 334 334 Placed MAT 270000 57.34 93.40
## 335 335 Placed MAT 300000 56.63 80.00
## 337 337 Placed MAT 275000 58.95 84.00
## 339 339 Placed K-MAT 300000 54.50 85.00
## 340 340 Placed MAT 250000 54.48 78.00
## 341 341 Placed MAT 260000 69.71 59.32
## 342 342 Placed MAT 185000 71.96 88.00
## 343 343 Placed MAT 216000 63.91 79.00
## 345 345 Placed MAT 265000 55.80 73.00
## 346 346 Placed MAT 300000 52.81 87.55
## 347 347 Placed K-MAT 325000 56.12 84.00
## 348 348 Placed MAT 267000 53.37 83.00
## 351 351 Placed MAT 240000 60.11 61.28
## 353 353 Placed MAT 260000 58.30 66.00
## 354 354 Placed CAT 240000 69.12 63.00
## 356 356 Placed K-MAT 250000 56.98 63.00
## 357 357 Placed CAT 180000 63.42 60.00
## 359 359 Placed MAT 210000 67.69 80.00
## 360 360 Placed MAT 250000 52.64 48.00
## 361 361 Placed MAT 250000 56.81 62.00
## 362 362 Placed MAT 426000 60.39 26.53
## 363 363 Placed MAT 270000 60.04 98.00
## 365 365 Placed MAT 300000 71.55 88.56
## 366 366 Placed K-MAT 132000 56.45 64.00
## 367 367 Placed MAT 144000 62.92 92.66
## 369 369 Placed MAT 216000 56.49 67.00
## 370 370 Placed MAT 400000 74.49 91.00
## 371 371 Placed MAT 275000 53.62 74.00
## 372 372 Placed MAT 295000 69.72 59.00
## 373 373 Placed CAT 360000 65.80 73.00
## 374 374 Placed MAT 204000 60.23 70.00
## 378 378 Placed K-MAT 350000 66.22 66.00
## 380 380 Placed MAT 300000 77.30 96.16
## 381 381 Placed MAT 180000 53.19 0.00
## 385 385 Placed G-SAT 252000 61.00 0.00
## 387 387 Placed MAT 162000 58.63 34.53
## 388 388 Placed MAT 450000 59.50 50.53
## 389 389 Placed MAT 240000 61.63 60.00
## 390 390 Placed MAT 300000 70.17 77.00Drawing a Scatter Plot Matrix for 3 variables – {Salary, Percent_MBA, Percentile_ET} using the dataframe placedET.
library(car)##
## Attaching package: 'car'## The following object is masked from 'package:psych':
##
## logitscatterplotMatrix(formula=~ Salary + Percent_MBA + Percentile_ET,cex=0.6,data=placedET)