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.