Reading data into R
setwd("C:/Users/vaibhav/Desktop/DataSets")
dean.df<-read.csv("DataDeansDilemma.csv")
View(dean.df)Summary of Data
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.72Median Salary of all the students
median(dean.df$Salary)## [1] 240000Percentage of students placed
my.table<-with(dean.df,table(Placement))
r<-prop.table(my.table)
round(r*100,2)## Placement
## Not Placed Placed
## 20.2 79.8Using R to create a dataframe called placed, that contains a subset of only those students who were successfully placed.
placed.df<-subset(dean.df,Placement=="Placed" ,select=c(SlNo,Gender,Placement,Salary,Percent_MBA))
placed.df## 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.17Using R to find the median salary of students who were placed.
median(placed.df$Salary)## [1] 260000Use R to create a table showing the mean salary of males and females, who were placed.
aggregate(placed.df$Salary,list(placed.df$Gender),mean)## Group.1 x
## 1 F 253068.0
## 2 M 284241.9Using R to generate the following histogram showing a breakup of the MBA performance of the students who were placed
hist(placed.df$Percent_MBA,main="MBA Perfomance of placed students",xlab="MBA Percentage",ylab="Count",col="grey")
Creatin a dataframe called notplaced, that contains a subset of only those students who were NOT placed after their MBA.
notplaced.df<-subset(dean.df,Placement=="Not Placed",select=c(SlNo,Gender,Placement,Salary,Percent_MBA))
notplaced.df## SlNo Gender Placement Salary Percent_MBA
## 11 11 F Not Placed 0 69.78
## 16 16 F Not Placed 0 53.29
## 20 20 M Not Placed 0 54.65
## 40 40 F Not Placed 0 67.28
## 42 42 F Not Placed 0 51.75
## 43 43 M Not Placed 0 56.34
## 59 59 M Not Placed 0 51.29
## 64 64 M Not Placed 0 52.56
## 68 68 M Not Placed 0 51.45
## 75 75 M Not Placed 0 51.21
## 79 79 F Not Placed 0 71.63
## 82 82 F Not Placed 0 56.11
## 88 88 M Not Placed 0 56.19
## 89 89 F Not Placed 0 65.49
## 94 94 M Not Placed 0 61.31
## 98 98 M Not Placed 0 60.29
## 100 100 F Not Placed 0 56.45
## 109 109 M Not Placed 0 72.00
## 112 112 F Not Placed 0 54.76
## 128 128 F Not Placed 0 71.15
## 144 144 F Not Placed 0 67.13
## 149 149 M Not Placed 0 55.83
## 162 162 M Not Placed 0 58.00
## 166 166 M Not Placed 0 55.41
## 175 175 M Not Placed 0 59.47
## 176 176 F Not Placed 0 64.95
## 184 184 M Not Placed 0 55.30
## 191 191 M Not Placed 0 56.09
## 194 194 M Not Placed 0 60.64
## 204 204 M Not Placed 0 58.81
## 220 220 M Not Placed 0 64.15
## 226 226 F Not Placed 0 62.29
## 231 231 F Not Placed 0 62.83
## 236 236 F Not Placed 0 57.32
## 240 240 M Not Placed 0 61.90
## 241 241 M Not Placed 0 61.22
## 248 248 M Not Placed 0 58.52
## 252 252 M Not Placed 0 52.32
## 258 258 M Not Placed 0 55.87
## 266 266 M Not Placed 0 65.99
## 269 269 M Not Placed 0 61.87
## 272 272 M Not Placed 0 65.13
## 284 284 F Not Placed 0 74.56
## 285 285 M Not Placed 0 54.99
## 287 287 M Not Placed 0 75.71
## 288 288 M Not Placed 0 57.16
## 289 289 F Not Placed 0 58.79
## 290 290 M Not Placed 0 65.48
## 291 291 F Not Placed 0 69.28
## 298 298 F Not Placed 0 67.44
## 301 301 M Not Placed 0 60.69
## 307 307 F Not Placed 0 72.14
## 310 310 M Not Placed 0 60.02
## 315 315 F Not Placed 0 63.83
## 317 317 M Not Placed 0 59.81
## 318 318 F Not Placed 0 61.66
## 322 322 F Not Placed 0 57.29
## 324 324 F Not Placed 0 62.93
## 326 326 M Not Placed 0 56.13
## 328 328 F Not Placed 0 66.94
## 329 329 M Not Placed 0 63.94
## 330 330 F Not Placed 0 62.50
## 332 332 M Not Placed 0 66.18
## 336 336 M Not Placed 0 64.74
## 338 338 M Not Placed 0 65.28
## 344 344 F Not Placed 0 63.53
## 350 350 M Not Placed 0 58.44
## 352 352 F Not Placed 0 72.21
## 355 355 M Not Placed 0 51.48
## 364 364 M Not Placed 0 53.39
## 375 375 F Not Placed 0 62.42
## 376 376 M Not Placed 0 60.22
## 377 377 M Not Placed 0 52.36
## 379 379 M Not Placed 0 56.00
## 382 382 M Not Placed 0 50.83
## 383 383 F Not Placed 0 56.81
## 384 384 M Not Placed 0 59.14
## 386 386 M Not Placed 0 67.94
## 391 391 M Not Placed 0 60.36Drawing two histograms side-by-side, visually comparing the MBA performance of Placed and Not Placed students
par(mfrow=c(1,2))
with(placed.df,hist(placed.df$Percent_MBA,main="MBA Perfomance of placed students",xlab="MBA Percentage",ylab="Count",col="grey"))
with(notplaced.df,hist(notplaced.df$Percent_MBA,main="MBA Perfomance of not placed students",xlab="MBA Percentage",ylab="Count",col="grey"))
par(mfrow=c(1,1))Using R to draw two boxplots, one below the other, comparing the distribution of salaries of males and females who were placed
boxplot(placed.df$Salary~placed.df$Gender,horizontal=TRUE,main="Comparision of salaries of Male and female",xlab="Salary",ylab="Gender",yaxt="n")
axis(side=2,at=c(1,2),labels=c("Female","Male"))
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.df<-subset(dean.df,Placement=="Placed"& S.TEST=="1" ,select=c(SlNo,Gender,S.TEST,Entrance_Test,Percentile_ET,Placement,Salary,Percent_MBA))
placedET.df## SlNo Gender S.TEST Entrance_Test Percentile_ET Placement Salary
## 1 1 M 1 MAT 55.00 Placed 270000
## 2 2 M 1 MAT 86.50 Placed 200000
## 4 4 M 1 MAT 75.00 Placed 250000
## 5 5 M 1 MAT 66.00 Placed 180000
## 8 8 M 1 MAT 43.12 Placed 235000
## 9 9 M 1 MAT 96.80 Placed 425000
## 12 12 M 1 MAT 79.00 Placed 250000
## 13 13 M 1 MAT 55.00 Placed 180000
## 15 15 M 1 CAT 33.00 Placed 450000
## 19 19 M 1 MAT 67.00 Placed 252000
## 21 21 M 1 CAT 70.00 Placed 280000
## 22 22 M 1 MAT 91.34 Placed 231000
## 23 23 M 1 MAT 35.00 Placed 224000
## 24 24 M 1 MAT 54.00 Placed 120000
## 25 25 M 1 MAT 62.00 Placed 260000
## 26 26 M 1 MAT 75.00 Placed 300000
## 28 28 M 1 MAT 49.00 Placed 120000
## 29 29 M 1 MAT 60.00 Placed 250000
## 30 30 F 1 MAT 62.00 Placed 180000
## 31 31 F 1 MAT 68.00 Placed 218000
## 33 33 M 1 MAT 76.00 Placed 150000
## 34 34 F 1 MAT 48.00 Placed 250000
## 35 35 F 1 MAT 72.00 Placed 200000
## 36 36 M 1 MAT 60.00 Placed 300000
## 37 37 M 1 K-MAT 79.00 Placed 330000
## 38 38 M 1 PGCET 0.00 Placed 265000
## 39 39 M 1 CAT 70.00 Placed 340000
## 41 41 F 1 MAT 68.00 Placed 177600
## 44 44 M 1 MAT 50.48 Placed 236000
## 45 45 M 1 MAT 50.00 Placed 265000
## 47 47 F 1 MAT 95.00 Placed 393000
## 48 48 F 1 MAT 55.53 Placed 360000
## 49 49 F 1 MAT 92.00 Placed 300000
## 51 51 M 1 MAT 97.40 Placed 360000
## 52 52 F 1 MAT 76.00 Placed 180000
## 53 53 F 1 MAT 74.00 Placed 180000
## 55 55 M 1 MAT 94.00 Placed 240000
## 56 56 M 1 CAT 41.38 Placed 300000
## 57 57 M 1 MAT 68.00 Placed 265000
## 58 58 M 1 MAT 73.35 Placed 350000
## 60 60 F 1 MAT 52.00 Placed 250000
## 61 61 F 1 MAT 64.00 Placed 180000
## 62 62 F 1 MAT 50.89 Placed 278000
## 63 63 M 1 MAT 83.00 Placed 150000
## 65 65 F 1 MAT 88.00 Placed 260000
## 66 66 M 1 MAT 68.44 Placed 180000
## 67 67 F 1 MAT 71.00 Placed 300000
## 69 69 M 1 PGCET 0.00 Placed 400000
## 70 70 F 1 MAT 58.00 Placed 320000
## 71 71 F 1 MAT 53.70 Placed 240000
## 72 72 M 1 MAT 93.00 Placed 411000
## 73 73 F 1 MAT 60.00 Placed 287000
## 74 74 F 1 MAT 65.00 Placed 198000
## 76 76 M 1 MAT 95.00 Placed 300000
## 77 77 F 1 MAT 89.00 Placed 200000
## 78 78 F 1 MAT 58.00 Placed 180000
## 80 80 M 1 MAT 78.00 Placed 204000
## 81 81 M 1 MAT 64.00 Placed 250000
## 83 83 F 1 MAT 65.00 Placed 200000
## 84 84 M 1 MAT 97.33 Placed 275000
## 85 85 M 1 MAT 67.00 Placed 192000
## 87 87 F 1 CAT 53.00 Placed 300000
## 90 90 M 1 MAT 87.00 Placed 450000
## 91 91 F 1 MAT 78.00 Placed 216000
## 92 92 M 1 MAT 71.00 Placed 220000
## 95 95 M 1 CAT 68.00 Placed 300000
## 96 96 M 1 MAT 68.00 Placed 240000
## 97 97 M 1 MAT 80.00 Placed 360000
## 99 99 M 1 MAT 74.00 Placed 268000
## 101 101 M 1 MAT 57.60 Placed 265000
## 102 102 M 1 MAT 60.00 Placed 260000
## 104 104 M 1 MAT 61.60 Placed 300000
## 105 105 F 1 MAT 59.00 Placed 240000
## 107 107 M 1 MAT 44.56 Placed 240000
## 108 108 M 1 CAT 13.00 Placed 400000
## 111 111 M 1 CAT 78.00 Placed 250000
## 114 114 M 1 MAT 68.50 Placed 180000
## 116 116 M 1 MAT 61.00 Placed 240000
## 117 117 M 1 MAT 89.69 Placed 120000
## 119 119 M 1 MAT 68.92 Placed 275000
## 120 120 M 1 MAT 68.71 Placed 275000
## 121 121 F 1 MAT 79.00 Placed 150000
## 122 122 M 1 MAT 70.00 Placed 275000
## 124 124 M 1 MAT 41.00 Placed 240000
## 126 126 M 1 MAT 89.00 Placed 360000
## 127 127 M 1 MAT 46.92 Placed 280000
## 129 129 M 1 GCET 50.00 Placed 325000
## 130 130 M 1 GCET 40.00 Placed 204000
## 131 131 M 1 MAT 95.00 Placed 240000
## 132 132 M 1 MAT 95.50 Placed 240000
## 133 133 F 1 K-MAT 96.00 Placed 336000
## 134 134 M 1 MAT 86.00 Placed 218000
## 136 136 M 1 MAT 84.27 Placed 336000
## 137 137 F 1 MAT 74.00 Placed 190000
## 138 138 F 1 MAT 61.00 Placed 230000
## 139 139 M 1 K-MAT 94.30 Placed 390000
## 140 140 M 1 MAT 69.00 Placed 500000
## 141 141 M 1 MAT 86.04 Placed 270000
## 142 142 F 1 MAT 75.00 Placed 150000
## 143 143 F 1 MAT 67.00 Placed 240000
## 145 145 F 1 MAT 40.00 Placed 276000
## 146 146 M 1 MAT 86.00 Placed 300000
## 147 147 M 1 MAT 82.00 Placed 168000
## 148 148 M 1 MAT 84.00 Placed 300000
## 150 150 M 1 G-MAT 0.00 Placed 270000
## 152 152 M 1 MAT 55.00 Placed 300000
## 153 153 F 1 MAT 78.74 Placed 400000
## 154 154 M 1 MAT 67.00 Placed 220000
## 155 155 M 1 MAT 75.00 Placed 180000
## 156 156 M 1 MAT 64.00 Placed 180000
## 157 157 F 1 MAT 58.00 Placed 210000
## 158 158 F 1 MAT 62.00 Placed 210000
## 159 159 F 1 MAT 92.00 Placed 300000
## 160 160 F 1 MAT 92.00 Placed 290000
## 161 161 M 1 MAT 67.00 Placed 180000
## 163 163 F 1 MAT 72.00 Placed 230000
## 164 164 M 1 MAT 47.41 Placed 282000
## 165 165 M 1 CAT 29.00 Placed 260000
## 167 167 M 1 CAT 56.39 Placed 180000
## 168 168 M 1 MAT 53.88 Placed 260000
## 169 169 M 1 CAT 79.00 Placed 400000
## 170 170 M 1 MAT 95.46 Placed 420000
## 172 172 F 1 MAT 66.00 Placed 300000
## 173 173 F 1 MAT 93.91 Placed 150000
## 174 174 F 1 MAT 70.00 Placed 220000
## 177 177 M 1 MAT 78.00 Placed 380000
## 179 179 F 1 MAT 57.50 Placed 300000
## 180 180 F 1 K-MAT 67.00 Placed 252000
## 181 181 M 1 K-MAT 58.00 Placed 280000
## 182 182 M 1 MAT 85.00 Placed 240000
## 183 183 M 1 MAT 55.00 Placed 360000
## 185 185 M 1 MAT 71.00 Placed 180000
## 186 186 F 1 K-MAT 95.00 Placed 450000
## 187 187 M 1 MAT 80.00 Placed 200000
## 188 188 M 1 MAT 84.00 Placed 300000
## 193 193 F 1 MAT 57.20 Placed 250000
## 195 195 M 1 MAT 58.00 Placed 250000
## 196 196 F 1 MAT 72.15 Placed 280000
## 197 197 M 1 MAT 53.70 Placed 250000
## 198 198 F 1 MAT 89.00 Placed 216000
## 199 199 M 1 MAT 39.00 Placed 204000
## 200 200 M 1 MAT 96.00 Placed 300000
## 201 201 M 1 MAT 80.00 Placed 240000
## 202 202 M 1 MAT 97.00 Placed 276000
## 203 203 M 1 MAT 82.66 Placed 940000
## 205 205 F 1 MAT 55.67 Placed 250000
## 206 206 M 1 PGCET 85.00 Placed 300000
## 207 207 F 1 K-MAT 14.99 Placed 180000
## 208 208 F 1 MAT 80.40 Placed 236000
## 209 209 M 1 MAT 60.00 Placed 240000
## 210 210 M 1 MAT 64.00 Placed 250000
## 211 211 F 1 MAT 75.00 Placed 350000
## 213 213 F 1 MAT 70.00 Placed 210000
## 214 214 F 1 MAT 55.50 Placed 250000
## 215 215 M 1 MAT 81.20 Placed 400000
## 216 216 M 1 K-MAT 84.00 Placed 300000
## 217 217 M 1 K-MAT 86.00 Placed 480000
## 218 218 M 1 MAT 90.00 Placed 250000
## 219 219 M 1 K-MAT 89.95 Placed 320000
## 221 221 M 1 CAT 65.00 Placed 385000
## 222 222 F 1 MAT 80.00 Placed 360000
## 223 223 M 1 MAT 74.40 Placed 300000
## 225 225 M 1 MAT 65.00 Placed 250000
## 227 227 F 1 MAT 94.00 Placed 250000
## 228 228 F 1 MAT 43.00 Placed 275000
## 229 229 F 1 MAT 55.60 Placed 200000
## 230 230 F 1 MAT 78.00 Placed 150000
## 232 232 M 1 CAT 65.00 Placed 300000
## 233 233 M 1 MAT 56.00 Placed 225000
## 235 235 F 1 MAT 96.00 Placed 250000
## 237 237 M 1 MAT 58.00 Placed 220000
## 239 239 M 1 MAT 56.00 Placed 265000
## 242 242 M 1 MAT 60.00 Placed 260000
## 243 243 M 1 MAT 89.00 Placed 300000
## 244 244 M 1 MAT 39.00 Placed 180000
## 245 245 M 1 K-MAT 65.00 Placed 530000
## 246 246 M 1 MAT 66.60 Placed 156000
## 247 247 M 1 MAT 40.00 Placed 263000
## 249 249 M 1 MAT 72.00 Placed 400000
## 250 250 M 1 MAT 85.00 Placed 233000
## 251 251 M 1 MAT 83.00 Placed 300000
## 253 253 F 1 MAT 57.00 Placed 240000
## 254 254 M 1 MAT 64.25 Placed 180000
## 256 256 M 1 MAT 40.00 Placed 198000
## 259 259 M 1 MAT 56.00 Placed 690000
## 260 260 M 1 MAT 83.00 Placed 270000
## 261 261 F 1 MAT 98.00 Placed 240000
## 263 263 M 1 MAT 86.00 Placed 340000
## 264 264 M 1 MAT 70.00 Placed 250000
## 267 267 M 1 MAT 80.00 Placed 255000
## 268 268 M 1 MAT 93.40 Placed 300000
## 270 270 M 1 MAT 62.00 Placed 150000
## 271 271 M 1 MAT 75.00 Placed 300000
## 273 273 M 1 MAT 49.70 Placed 270000
## 275 275 M 1 MAT 57.63 Placed 180000
## 276 276 M 1 MAT 75.20 Placed 285000
## 278 278 M 1 MAT 75.00 Placed 500000
## 279 279 F 1 MAT 53.04 Placed 250000
## 283 283 M 1 K-MAT 88.00 Placed 240000
## 286 286 M 1 MAT 63.00 Placed 240000
## 292 292 M 1 CAT 80.00 Placed 476000
## 293 293 M 1 MAT 63.79 Placed 290000
## 294 294 M 1 K-MAT 95.50 Placed 690000
## 295 295 M 1 MAT 84.00 Placed 300000
## 296 296 M 1 MAT 49.00 Placed 250000
## 297 297 F 1 MAT 67.00 Placed 162000
## 300 300 M 1 MAT 64.00 Placed 500000
## 302 302 F 1 MAT 55.00 Placed 220000
## 303 303 M 1 K-MAT 76.20 Placed 270000
## 304 304 F 1 MAT 89.00 Placed 650000
## 305 305 M 1 MAT 73.00 Placed 350000
## 306 306 M 1 MAT 44.20 Placed 300000
## 308 308 M 1 MAT 57.00 Placed 265000
## 309 309 M 1 MAT 35.00 Placed 180000
## 311 311 F 1 K-MAT 62.00 Placed 300000
## 313 313 F 1 XAT 74.00 Placed 300000
## 316 316 M 1 PGCET 0.00 Placed 240000
## 319 319 M 1 MAT 60.00 Placed 276000
## 323 323 F 1 MAT 82.00 Placed 252000
## 325 325 M 1 MAT 95.00 Placed 280000
## 327 327 F 1 CAT 60.00 Placed 350000
## 333 333 M 1 MAT 72.00 Placed 264000
## 334 334 M 1 MAT 93.40 Placed 270000
## 335 335 F 1 MAT 80.00 Placed 300000
## 337 337 M 1 MAT 84.00 Placed 275000
## 339 339 M 1 K-MAT 85.00 Placed 300000
## 340 340 M 1 MAT 78.00 Placed 250000
## 341 341 F 1 MAT 59.32 Placed 260000
## 342 342 F 1 MAT 88.00 Placed 185000
## 343 343 F 1 MAT 79.00 Placed 216000
## 345 345 M 1 MAT 73.00 Placed 265000
## 346 346 M 1 MAT 87.55 Placed 300000
## 347 347 M 1 K-MAT 84.00 Placed 325000
## 348 348 M 1 MAT 83.00 Placed 267000
## 351 351 M 1 MAT 61.28 Placed 240000
## 353 353 M 1 MAT 66.00 Placed 260000
## 354 354 F 1 CAT 63.00 Placed 240000
## 356 356 M 1 K-MAT 63.00 Placed 250000
## 357 357 F 1 CAT 60.00 Placed 180000
## 359 359 F 1 MAT 80.00 Placed 210000
## 360 360 M 1 MAT 48.00 Placed 250000
## 361 361 M 1 MAT 62.00 Placed 250000
## 362 362 M 1 MAT 26.53 Placed 426000
## 363 363 M 1 MAT 98.00 Placed 270000
## 365 365 M 1 MAT 88.56 Placed 300000
## 366 366 M 1 K-MAT 64.00 Placed 132000
## 367 367 F 1 MAT 92.66 Placed 144000
## 369 369 M 1 MAT 67.00 Placed 216000
## 370 370 M 1 MAT 91.00 Placed 400000
## 371 371 M 1 MAT 74.00 Placed 275000
## 372 372 M 1 MAT 59.00 Placed 295000
## 373 373 M 1 CAT 73.00 Placed 360000
## 374 374 F 1 MAT 70.00 Placed 204000
## 378 378 M 1 K-MAT 66.00 Placed 350000
## 380 380 F 1 MAT 96.16 Placed 300000
## 381 381 M 1 MAT 0.00 Placed 180000
## 385 385 M 1 G-SAT 0.00 Placed 252000
## 387 387 M 1 MAT 34.53 Placed 162000
## 388 388 M 1 MAT 50.53 Placed 450000
## 389 389 M 1 MAT 60.00 Placed 240000
## 390 390 F 1 MAT 77.00 Placed 300000
## Percent_MBA
## 1 58.80
## 2 66.28
## 4 57.80
## 5 59.43
## 8 57.23
## 9 55.50
## 12 54.01
## 13 51.58
## 15 58.21
## 19 62.14
## 21 63.26
## 22 61.29
## 23 62.51
## 24 52.21
## 25 60.85
## 26 60.77
## 28 58.56
## 29 63.70
## 30 65.04
## 31 68.63
## 33 54.96
## 34 64.19
## 35 64.66
## 36 62.54
## 37 52.41
## 38 56.61
## 39 61.83
## 41 64.08
## 44 77.89
## 45 56.70
## 47 69.06
## 48 68.81
## 49 63.62
## 51 74.01
## 52 65.33
## 53 62.80
## 55 57.55
## 56 60.76
## 57 57.69
## 58 64.15
## 60 56.70
## 61 58.32
## 62 62.21
## 63 57.61
## 65 72.78
## 66 62.77
## 67 62.74
## 69 68.85
## 70 55.47
## 71 56.86
## 72 62.56
## 73 66.72
## 74 69.76
## 76 62.90
## 77 69.70
## 78 66.53
## 80 54.55
## 81 62.46
## 83 62.98
## 84 62.27
## 85 62.65
## 87 60.91
## 90 71.04
## 91 65.56
## 92 52.71
## 95 67.31
## 96 66.88
## 97 63.59
## 99 57.99
## 101 56.66
## 102 57.24
## 104 62.48
## 105 59.69
## 107 64.75
## 108 57.76
## 111 76.72
## 114 59.50
## 116 58.78
## 117 57.10
## 119 58.46
## 120 60.99
## 121 59.24
## 122 68.07
## 124 58.75
## 126 65.45
## 127 62.40
## 129 60.43
## 130 60.76
## 131 66.94
## 132 68.53
## 133 61.41
## 134 59.75
## 136 67.20
## 137 67.00
## 138 64.27
## 139 51.24
## 140 57.65
## 141 59.42
## 142 67.99
## 143 62.35
## 145 62.01
## 146 70.20
## 147 60.44
## 148 66.69
## 150 59.81
## 152 62.00
## 153 76.18
## 154 57.03
## 155 59.08
## 156 58.85
## 157 64.36
## 158 62.36
## 159 68.03
## 160 66.86
## 161 62.79
## 163 59.47
## 164 64.63
## 165 53.57
## 167 66.50
## 168 54.97
## 169 56.51
## 170 62.16
## 172 64.44
## 173 69.03
## 174 57.31
## 177 60.44
## 179 61.31
## 180 55.42
## 181 63.39
## 182 65.83
## 183 58.23
## 185 65.69
## 186 67.83
## 187 73.52
## 188 58.31
## 193 54.80
## 195 53.94
## 196 63.08
## 197 55.01
## 198 60.50
## 199 52.42
## 200 70.85
## 201 67.05
## 202 70.48
## 203 64.34
## 205 71.49
## 206 59.99
## 207 57.98
## 208 71.00
## 209 56.70
## 210 61.26
## 211 73.33
## 213 68.20
## 214 58.40
## 215 76.26
## 216 70.71
## 217 61.79
## 218 68.55
## 219 67.54
## 221 69.94
## 222 60.78
## 223 53.49
## 225 60.98
## 227 67.13
## 228 58.73
## 229 65.63
## 230 61.58
## 232 60.95
## 233 60.41
## 235 71.77
## 237 54.43
## 239 56.94
## 242 61.29
## 243 60.39
## 244 51.73
## 245 59.54
## 246 56.75
## 247 58.95
## 249 63.23
## 250 55.14
## 251 62.28
## 253 64.08
## 254 58.54
## 256 55.67
## 259 61.30
## 260 58.87
## 261 65.25
## 263 62.48
## 264 53.20
## 267 52.72
## 268 55.03
## 270 60.59
## 271 72.29
## 273 59.71
## 275 62.72
## 276 66.06
## 278 66.46
## 279 65.52
## 283 70.10
## 286 52.38
## 292 66.39
## 293 66.04
## 294 72.97
## 295 52.64
## 296 64.79
## 297 59.32
## 300 66.23
## 302 57.90
## 303 58.67
## 304 70.81
## 305 68.07
## 306 62.00
## 308 56.60
## 309 54.04
## 311 64.28
## 313 68.68
## 316 54.12
## 319 61.82
## 323 71.43
## 325 64.86
## 327 66.63
## 333 61.01
## 334 57.34
## 335 56.63
## 337 58.95
## 339 54.50
## 340 54.48
## 341 69.71
## 342 71.96
## 343 63.91
## 345 55.80
## 346 52.81
## 347 56.12
## 348 53.37
## 351 60.11
## 353 58.30
## 354 69.12
## 356 56.98
## 357 63.42
## 359 67.69
## 360 52.64
## 361 56.81
## 362 60.39
## 363 60.04
## 365 71.55
## 366 56.45
## 367 62.92
## 369 56.49
## 370 74.49
## 371 53.62
## 372 69.72
## 373 65.80
## 374 60.23
## 378 66.22
## 380 77.30
## 381 53.19
## 385 61.00
## 387 58.63
## 388 59.50
## 389 61.63
## 390 70.17Draw 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(~Salary+Percent_MBA+Percentile_ET,data=placedET.df,diagonal="density")