Setting up the directory, reading the csv file into R and Viewing the data file

setwd("~/SIP/SIP Phase 2/R Programming/Udemy Class Material/Week 1")
dean.df <- read.csv(paste("Data Deans Dilemma.csv", sep=""))
View(dean.df)

Table showing the mean salaries of males and females who were placed

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

Avg. salary of males placed is 284241.9 and females is 253068

t-test for the Hypothesis “The average salary of the male MBAs is higher than the average salary of female MBAs.”

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

p-value is 2.2e-16 which is less than 0.05

Therefore, the hypothesis that the avg. salaries of males and females has no significant difference can be rejected.