setwd("C:/Users/Dell/Downloads/Sameer Mathur")
dean.df<-read.csv("Deans Dilemma.csv")
View(dean.df)Table showing the mean salary of males and females, who were placed.
placed<- subset(dean.df,Placement=="Placed",select = c(SlNo,Placement,Salary,Gender))
placed## SlNo Placement Salary Gender
## 1 1 Placed 270000 M
## 2 2 Placed 200000 M
## 3 3 Placed 240000 M
## 4 4 Placed 250000 M
## 5 5 Placed 180000 M
## 6 6 Placed 300000 M
## 7 7 Placed 260000 F
## 8 8 Placed 235000 M
## 9 9 Placed 425000 M
## 10 10 Placed 240000 F
## 12 12 Placed 250000 M
## 13 13 Placed 180000 M
## 14 14 Placed 428000 M
## 15 15 Placed 450000 M
## 17 17 Placed 300000 M
## 18 18 Placed 240000 M
## 19 19 Placed 252000 M
## 21 21 Placed 280000 M
## 22 22 Placed 231000 M
## 23 23 Placed 224000 M
## 24 24 Placed 120000 M
## 25 25 Placed 260000 M
## 26 26 Placed 300000 M
## 27 27 Placed 120000 M
## 28 28 Placed 120000 M
## 29 29 Placed 250000 M
## 30 30 Placed 180000 F
## 31 31 Placed 218000 F
## 32 32 Placed 360000 M
## 33 33 Placed 150000 M
## 34 34 Placed 250000 F
## 35 35 Placed 200000 F
## 36 36 Placed 300000 M
## 37 37 Placed 330000 M
## 38 38 Placed 265000 M
## 39 39 Placed 340000 M
## 41 41 Placed 177600 F
## 44 44 Placed 236000 M
## 45 45 Placed 265000 M
## 46 46 Placed 200000 M
## 47 47 Placed 393000 F
## 48 48 Placed 360000 F
## 49 49 Placed 300000 F
## 50 50 Placed 250000 M
## 51 51 Placed 360000 M
## 52 52 Placed 180000 F
## 53 53 Placed 180000 F
## 54 54 Placed 270000 M
## 55 55 Placed 240000 M
## 56 56 Placed 300000 M
## 57 57 Placed 265000 M
## 58 58 Placed 350000 M
## 60 60 Placed 250000 F
## 61 61 Placed 180000 F
## 62 62 Placed 278000 F
## 63 63 Placed 150000 M
## 65 65 Placed 260000 F
## 66 66 Placed 180000 M
## 67 67 Placed 300000 F
## 69 69 Placed 400000 M
## 70 70 Placed 320000 F
## 71 71 Placed 240000 F
## 72 72 Placed 411000 M
## 73 73 Placed 287000 F
## 74 74 Placed 198000 F
## 76 76 Placed 300000 M
## 77 77 Placed 200000 F
## 78 78 Placed 180000 F
## 80 80 Placed 204000 M
## 81 81 Placed 250000 M
## 83 83 Placed 200000 F
## 84 84 Placed 275000 M
## 85 85 Placed 192000 M
## 86 86 Placed 240000 F
## 87 87 Placed 300000 F
## 90 90 Placed 450000 M
## 91 91 Placed 216000 F
## 92 92 Placed 220000 M
## 93 93 Placed 216000 M
## 95 95 Placed 300000 M
## 96 96 Placed 240000 M
## 97 97 Placed 360000 M
## 99 99 Placed 268000 M
## 101 101 Placed 265000 M
## 102 102 Placed 260000 M
## 103 103 Placed 240000 M
## 104 104 Placed 300000 M
## 105 105 Placed 240000 F
## 106 106 Placed 180000 M
## 107 107 Placed 240000 M
## 108 108 Placed 400000 M
## 110 110 Placed 180000 M
## 111 111 Placed 250000 M
## 113 113 Placed 295000 F
## 114 114 Placed 180000 M
## 115 115 Placed 300000 F
## 116 116 Placed 240000 M
## 117 117 Placed 120000 M
## 118 118 Placed 250000 M
## 119 119 Placed 275000 M
## 120 120 Placed 275000 M
## 121 121 Placed 150000 F
## 122 122 Placed 275000 M
## 123 123 Placed 300000 M
## 124 124 Placed 240000 M
## 125 125 Placed 336000 M
## 126 126 Placed 360000 M
## 127 127 Placed 280000 M
## 129 129 Placed 325000 M
## 130 130 Placed 204000 M
## 131 131 Placed 240000 M
## 132 132 Placed 240000 M
## 133 133 Placed 336000 F
## 134 134 Placed 218000 M
## 135 135 Placed 216000 M
## 136 136 Placed 336000 M
## 137 137 Placed 190000 F
## 138 138 Placed 230000 F
## 139 139 Placed 390000 M
## 140 140 Placed 500000 M
## 141 141 Placed 270000 M
## 142 142 Placed 150000 F
## 143 143 Placed 240000 F
## 145 145 Placed 276000 F
## 146 146 Placed 300000 M
## 147 147 Placed 168000 M
## 148 148 Placed 300000 M
## 150 150 Placed 270000 M
## 151 151 Placed 360000 M
## 152 152 Placed 300000 M
## 153 153 Placed 400000 F
## 154 154 Placed 220000 M
## 155 155 Placed 180000 M
## 156 156 Placed 180000 M
## 157 157 Placed 210000 F
## 158 158 Placed 210000 F
## 159 159 Placed 300000 F
## 160 160 Placed 290000 F
## 161 161 Placed 180000 M
## 163 163 Placed 230000 F
## 164 164 Placed 282000 M
## 165 165 Placed 260000 M
## 167 167 Placed 180000 M
## 168 168 Placed 260000 M
## 169 169 Placed 400000 M
## 170 170 Placed 420000 M
## 171 171 Placed 144000 M
## 172 172 Placed 300000 F
## 173 173 Placed 150000 F
## 174 174 Placed 220000 F
## 177 177 Placed 380000 M
## 178 178 Placed 290000 M
## 179 179 Placed 300000 F
## 180 180 Placed 252000 F
## 181 181 Placed 280000 M
## 182 182 Placed 240000 M
## 183 183 Placed 360000 M
## 185 185 Placed 180000 M
## 186 186 Placed 450000 F
## 187 187 Placed 200000 M
## 188 188 Placed 300000 M
## 189 189 Placed 350000 M
## 190 190 Placed 550000 M
## 192 192 Placed 250000 M
## 193 193 Placed 250000 F
## 195 195 Placed 250000 M
## 196 196 Placed 280000 F
## 197 197 Placed 250000 M
## 198 198 Placed 216000 F
## 199 199 Placed 204000 M
## 200 200 Placed 300000 M
## 201 201 Placed 240000 M
## 202 202 Placed 276000 M
## 203 203 Placed 940000 M
## 205 205 Placed 250000 F
## 206 206 Placed 300000 M
## 207 207 Placed 180000 F
## 208 208 Placed 236000 F
## 209 209 Placed 240000 M
## 210 210 Placed 250000 M
## 211 211 Placed 350000 F
## 212 212 Placed 210000 M
## 213 213 Placed 210000 F
## 214 214 Placed 250000 F
## 215 215 Placed 400000 M
## 216 216 Placed 300000 M
## 217 217 Placed 480000 M
## 218 218 Placed 250000 M
## 219 219 Placed 320000 M
## 221 221 Placed 385000 M
## 222 222 Placed 360000 F
## 223 223 Placed 300000 M
## 224 224 Placed 375000 F
## 225 225 Placed 250000 M
## 227 227 Placed 250000 F
## 228 228 Placed 275000 F
## 229 229 Placed 200000 F
## 230 230 Placed 150000 F
## 232 232 Placed 300000 M
## 233 233 Placed 225000 M
## 234 234 Placed 120000 F
## 235 235 Placed 250000 F
## 237 237 Placed 220000 M
## 238 238 Placed 265000 M
## 239 239 Placed 265000 M
## 242 242 Placed 260000 M
## 243 243 Placed 300000 M
## 244 244 Placed 180000 M
## 245 245 Placed 530000 M
## 246 246 Placed 156000 M
## 247 247 Placed 263000 M
## 249 249 Placed 400000 M
## 250 250 Placed 233000 M
## 251 251 Placed 300000 M
## 253 253 Placed 240000 F
## 254 254 Placed 180000 M
## 255 255 Placed 350000 M
## 256 256 Placed 198000 M
## 257 257 Placed 250000 F
## 259 259 Placed 690000 M
## 260 260 Placed 270000 M
## 261 261 Placed 240000 F
## 262 262 Placed 300000 M
## 263 263 Placed 340000 M
## 264 264 Placed 250000 M
## 265 265 Placed 390000 M
## 267 267 Placed 255000 M
## 268 268 Placed 300000 M
## 270 270 Placed 150000 M
## 271 271 Placed 300000 M
## 273 273 Placed 270000 M
## 274 274 Placed 240000 F
## 275 275 Placed 180000 M
## 276 276 Placed 285000 M
## 277 277 Placed 400000 M
## 278 278 Placed 500000 M
## 279 279 Placed 250000 F
## 280 280 Placed 300000 M
## 281 281 Placed 240000 F
## 282 282 Placed 300000 M
## 283 283 Placed 240000 M
## 286 286 Placed 240000 M
## 292 292 Placed 476000 M
## 293 293 Placed 290000 M
## 294 294 Placed 690000 M
## 295 295 Placed 300000 M
## 296 296 Placed 250000 M
## 297 297 Placed 162000 F
## 299 299 Placed 260000 F
## 300 300 Placed 500000 M
## 302 302 Placed 220000 F
## 303 303 Placed 270000 M
## 304 304 Placed 650000 F
## 305 305 Placed 350000 M
## 306 306 Placed 300000 M
## 308 308 Placed 265000 M
## 309 309 Placed 180000 M
## 311 311 Placed 300000 F
## 312 312 Placed 300000 F
## 313 313 Placed 300000 F
## 314 314 Placed 220000 F
## 316 316 Placed 240000 M
## 319 319 Placed 276000 M
## 320 320 Placed 250000 M
## 321 321 Placed 180000 F
## 323 323 Placed 252000 F
## 325 325 Placed 280000 M
## 327 327 Placed 350000 F
## 331 331 Placed 216000 F
## 333 333 Placed 264000 M
## 334 334 Placed 270000 M
## 335 335 Placed 300000 F
## 337 337 Placed 275000 M
## 339 339 Placed 300000 M
## 340 340 Placed 250000 M
## 341 341 Placed 260000 F
## 342 342 Placed 185000 F
## 343 343 Placed 216000 F
## 345 345 Placed 265000 M
## 346 346 Placed 300000 M
## 347 347 Placed 325000 M
## 348 348 Placed 267000 M
## 349 349 Placed 264000 F
## 351 351 Placed 240000 M
## 353 353 Placed 260000 M
## 354 354 Placed 240000 F
## 356 356 Placed 250000 M
## 357 357 Placed 180000 F
## 358 358 Placed 366000 F
## 359 359 Placed 210000 F
## 360 360 Placed 250000 M
## 361 361 Placed 250000 M
## 362 362 Placed 426000 M
## 363 363 Placed 270000 M
## 365 365 Placed 300000 M
## 366 366 Placed 132000 M
## 367 367 Placed 144000 F
## 368 368 Placed 220000 M
## 369 369 Placed 216000 M
## 370 370 Placed 400000 M
## 371 371 Placed 275000 M
## 372 372 Placed 295000 M
## 373 373 Placed 360000 M
## 374 374 Placed 204000 F
## 378 378 Placed 350000 M
## 380 380 Placed 300000 F
## 381 381 Placed 180000 M
## 385 385 Placed 252000 M
## 387 387 Placed 162000 M
## 388 388 Placed 450000 M
## 389 389 Placed 240000 M
## 390 390 Placed 300000 FAverage salary of male and female MBAs who were placed.
aggregate(placed$Salary,list(Gender=placed$Gender),mean)## Gender x
## 1 F 253068.0
## 2 M 284241.9Running a t-test for the Hypothesis “The average salary of the male MBAs is higher than the average salary of female MBAs.”
t.test(Salary~Gender,placed)##
## Welch Two Sample t-test
##
## data: Salary by Gender
## t = -3.0757, df = 243.03, p-value = 0.00234
## alternative hypothesis: true difference in means is not equal to 0
## 95 percent confidence interval:
## -51138.42 -11209.22
## sample estimates:
## mean in group F mean in group M
## 253068.0 284241.9Thus from the result of this test we can conclude that the average salary of the male MBAs is higher than the average salary of female MBAs.