From the dataset below Create a new dataset (name of your choice) that meets the

Question

From the dataset below Create a new dataset (name of your choice) that meets the following condition:

Only data from students with low school performance <2

st.number age gender class.prep school.perform facebook.time 1 21 Female 812 2.42 286 2 21 Female 812 3.34 227 3 22 Female 953 3.68 39 4 21 Female 91 3.34 65 5 22 Female 1325 3.32 220 6 22 Male 462 2.68 148 7 21 Female 269 2.58 265 8 22 Female 524 2.27 71 9 21 Female 1301 2.67 119 10 21 Female 766 2.21 58 11 22 Female 517 2.08 98 12 21 Female 579 3.41 40 13 20 Female 294 2.76 177 14 20 Female 1141 2.88 36 15 21 Female 1183 3.86 217 16 21 Female 744 3.78 49 17 21 Male 960 3.08 227 18 21 Female 919 3.44 233 19 21 Male 353 3.24 100 20 21 Female 749 2.64 166 21 21 Female 1129 2.07 173 22 21 Male 222 3.44 220 23 21 Female 1051 2.66 57 24 22 Female 580 3.07 75 25 20 Male 1017 3.38 174 26 20 Female 821 3.37 40 27 21 Female 495 3.79 223 28 22 Female 551 2.46 116 29 21 Female 560 2.31 35 30 21 Male 993 2.03 140 31 22 Female 1151 3.3 104 32 21 Male 655 2.92 207 33 21 Female 378 3.02 39 34 20 Male 432 1.8 64 35 21 Male 782 2.77 347 36 20 Female 226 3.52 65 37 21 Male 124 3.08 34 38 21 Male 716 2.68 85 39 21 Female 676 2.9 232 40 20 Male 724 3.42 208 41 21 Female 1904 2.01 221 42 21 Female 1319 2.49 141 43 20 Male 1208 3.52 128 44 21 Male 439 3.41 148 45 21 Female 1243 3.8 42 46 22 Female 1317 3.64 57 47 21 Female 74 3.62 60 48 21 Female 862 3.83 54 49 21 Male 358 3.38 146 50 21 Female 575 3.91 72 51 22 Female 947 2.61 221 52 21 Male 724 2.91 53 53 21 Male 362 2.83 206 54 20 Male 1270 2.38 239 55 21 Male 752 2.93 130 56 21 Female 571 2.22 119 57 21 Female 406 3.59 140 58 21 Male 670 2.17 44 59 22 Male 1548 2.3 222 60 21 Female 620 1.14 235 61 21 Female 1356 3.52 200 62 21 Male 303 2.67 276 63 21 Female 128 3.6 141 64 20 Male 845 2.42 18 65 21 Female 660 1.57 74 66 22 Female 354 3.27 123 67 21 Female 1515 2.44 16 68 21 Male 1693 2.93 54 69 22 Male 668 1.9 108 70 21 Male 545 3.51 96 71 22 Female 1757 2.34 148 72 20 Female 1099 3.34 199 73 21 Female 540 2.03 128 74 21 Female 1841 2.89 51 75 22 Female 714 2.9 217 76 21 Male 1156 3.75 159 77 20 Male 1536 3.55 182 78 21 Female 263 3.31 157 79 21 Female 910 2.91 183 80 20 Female 710 1.36 149 81 21 Female 139 3 53 82 22 Male 565 3.48 53 83 22 Female 1027 2.85 32 84 22 Female 658 2.67 169 85 21 Male 665 3.2 139 86 21 Male 380 3.16 139 87 21 Male 1178 2.53 112 88 21 Female 557 3.37 106 89 21 Male 883 3.3 30 90 21 Female 586 2.55 71 91 21 Male 330 2.58 31 92 21 Male 612 2.22 62 93 21 Male 264 3.07 172 94 21 Male 610 2.33 302 95 21 Male 397 2.94 201 96 22 Male 471 3.39 140 97 21 Female 439 3.04 57 98 21 Female 100 3.08 13 99 22 Male 216 3.93 150 100 21 Male 1322 3.21 63 101 20 Male 954 2.35 146 102 22 Female 311 2.3 61 103 20 Female 1038 2.66 80 104 21 Female 871 2.85 157 105 22 Female 577 1.66 65 106 21 Male 776 3.15 114 107 21 Female 1150 1.64 104 108 21 Female 584 3.43 172 109 21 Male 1114 3.84 111 110 21 Female 755 2.64 136 111 21 Female 417 3.9 78 112 21 Female 611 2.9 354 113 21 Male 206 2.59 30 114 21 Female 338 3.29 237 115 21 Female 145 4 112 116 21 Female 233 3.92 228 117 21 Male 1321 3.54 12 118 21 Female 564 3.14 111 119 21 Female 1429 3.17 213 120 20 Male 613 3.61 38 121 21 Male 1022 3.13 62 122 22 Male 1068 2.84 91 123 21 Male 2401 2.57 161 124 21 Male 590 3.37 160 125 21 Female 297 3.25 161 126 21 Female 4 3.45 46 127 21 Female 1995 2.34 54 128 21 Male 930 3.19 253 129 20 Male 1116 3.18 144 130 21 Female 161 2.95 152 131 21 Female 1559 3.31 54 132 21 Female 454 1.66 50 133 21 Female 1090 3.16 40 134 22 Female 757 3.75 72 135 21 Female 462 3.44 286 136 20 Female 747 2.59 135 137 21 Female 780 2.31 206 138 21 Female 822 2.08 49 139 21 Female 1083 1.8 191 140 21 Female 967 3.46 115 141 21 Male 915 3.14 202 142 21 Female 1178 2.97 80 143 22 Male 995 3.11 136 144 21 Female 930 3.68 117 145 20 Male 1157 2.46 112 146 20 Male 261 2.72 6 147 22 Female 565 2.58 161 148 20 Female 394 3.17 111 149 21 Male 1001 3.24 164 150 22 Female 949 2.91 87 151 21 Female 778 1.92 76 152 21 Female 216 2.48 31 153 21 Female 1031 2.92 11 154 21 Male 548 2.1 82 155 21 Female 713 3.7 60 156 21 Female 105 2.51 66 157 21 Male 791 2.82 53 158 21 Male 21 2.45 151 159 21 Male 590 1.87 82 160 21 Male 886 3.74 95 161 21 Female 1077 2.97 99 162 21 Male 685 3.48 70 163 20 Male 807 2.82 166 164 21 Female 518 3.91 93 165 21 Female 1135 2.82 75 166 21 Male 1015 1.82 97 167 21 Female 1363 2.22 148 168 22 Female 836 2.75 150 169 21 Male 1823 3.01 5 170 21 Male 589 2.73 234 171 23 Female 880 2.97 113 172 22 Male 417 2.79 117 173 20 Male 173 3.06 24 174 21 Male 1167 3.41 74 175 20 Female 692 3.11 22 176 21 Female 1111 3.26 101 177 20 Female 8 3.59 71 178 21 Female 991 3.1 133 179 20 Female 522 2.58 45 180 21 Male 191 2.88 158 181 21 Female 1850 2.99 275 182 21 Female 291 3.04 101 183 22 Male 1111 2.54 65 184 21 Female 1069 3.98 203 185 22 Female 286 3.42 103 186 21 Female 927 2.52 87 187 22 Male 1173 3.75 182 188 21 Female 525 3.18 241 189 21 Female 296 2.52 99 190 21 Female 158 3.26 74 191 22 Female 1191 2.83 120 192 21 Female 757 3.88 130 193 21 Female 1122 3.37 219 194 21 Female 265 3.69 57 195 21 Male 416 3.26 1 196 22 Female 605 1.89 66 197 21 Female 1150 3.97 83 198 21 Male 2335 2.89 38 199 21 Female 1134 1.74 66 200 21 Male 623 3.1 267 201 22 Female 1599 2.22 171 202 21 Male 1709 2.66 138 203 21 Male 1307 2.23 151 204 21 Female 1397 2.63 2 205 21 Female 1366 2.5 53 206 21 Female 1075 3.16 229 207 22 Female 521 1.14 29 208 20 Female 1091 3.46 99 209 21 Female 1243 2.36 152 210 22 Female 693 2.46 141 211 21 Male 913 3.32 111 212 21 Male 453 3.68 70 213 21 Male 222 3.46 96 214 21 Male 1256 2.99 119 215 21 Female 1282 3.03 44 216 22 Female 680 2.84 160 217 20 Female 99 2.73 14 218 22 Male 881 3.37 252 219 20 Female 334 3.41 169 220 21 Female 446 3.5 198 221 22 Male 927 3.64 37 222 20 Female 1074 3.45 207 223 21 Female 593 3.29 1 224 20 Female 120 3.09 108 225 21 Male 57 2.56 52 226 22 Male 1277 2.88 190 227 21 Female 831 3.88 133 228 21 Male 534 1.03 85 229 21 Female 573 2.7 185 230 20 Female 717 3.1 96 231 21 Female 746 3.93 198 232 20 Female 681 2.65 131 233 20 Female 885 3.39 90 234 20 Female 955 3.03 89 235 21 Female 1617 3.57 126 236 21 Male 312 2.62 66 237 21 Male 766 2.72 117 238 21 Male 239 2.88 62 239 21 Female 732 2.13 172 240 21 Female 736 2.66 125 241 21 Female 215 3.34 94 242 20 Female 448 3.38 338 243 21 Male 743 2.92 106 244 20 Female 791 2.77 194 245 20 Male 123 3.56 271 246 21 Female 1247 3.55 183 247 21 Female 539 2.65 170 248 21 Male 1015 2.31 169 249 21 Female 905 2.85 89 250 21 Female 1191 2.51 93 251 21 Female 1286 2.65 179 252 21 Male 1478 2.87 70 253 21 Female 86 2.89 73 254 22 Male 325 2.72 197 255 21 Male 1512 3.36 228 256 22 Female 632 3.04 144 257 21 Female 1155 3.42 116 258 21 Male 551 1.87 93 259 22 Female 888 3.52 59 260 20 Female 1220 3.59 101 261 21 Male 1068 3.55 68 262 21 Male 1295 2.68 80 263 21 Female 399 1.99 199 264 20 Female 952 2.69 43 265 21 Male 659 3.65 104 266 20 Male 1587 2.65 41 267 20 Male 428 2.33 236 268 21 Female 431 3.92 44 269 20 Female 775 3.12 66 270 21 Female 963 3.48 129 271 21 Male 273 2.7 93 272 21 Female 120 2.17 61 273 21 Male 554 2.48 60 274 21 Female 897 2.63 38 275 21 Female 495 3.02 217 276 21 Male 1235 3.25 17 277 21 Female 1364 2.61 170 278 21 Male 517 2.98 96 279 22 Male 683 2.67 63 280 21 Female 33 3 87 281 21 Female 585 2.51 143 282 22 Male 917 3.46 174 283 21 Female 2077 2.81 6 284 21 Female 1434 2.37 140 285 21 Male 310 2.87 67 286 21 Male 631 2.45 28 287 21 Female 215 1.33 54 288 21 Female 499 3.47 94 289 21 Female 32 3.3 179 290 21 Male 875 2.98 163 291 21 Female 639 2.71 59 292 21 Male 73 2.08 142 293 21 Male 1293 2.29 118 294 22 Female 1407 3.48 167 295 20 Female 54 2.74 287 296 21 Male 22 2.47 112 297 21 Female 630 2.33 172 298 21 Male 1134 3.09 136 299 20 Female 767 2.83 131 300 21 Male 1391 2.75 69 301 21 Female 648 2.77 254 302 21 Male 832 2.5 73 303 21 Female 330 3.29 234 304 21 Female 396 3.04 203 305 22 Female 409 3.64 82 306 21 Female 1321 2.94 176 307 21 Female 583 2.99 124 308 20 Female 160 2.62 80 309 21 Female 294 1.95 367 310 21 Male 378 2.5 138 311 21 Male 808 2.99 70 312 21 Female 1594 2.46 199 313 20 Female 526 2.98 129 314 22 Female 769 3.46 67 315 21 Male 371 3.15 128 316 22 Female 932 2.62 166 317 21 Male 709 2.65 246 318 22 Female 430 3.1 24 319 21 Male 139 3.15 137 320 20 Female 848 2.26 20 321 22 Male 490 3.51 37 322 21 Female 1002 2.44 112 323 21 Male 367 3 123 324 21 Female 817 2.88 39 325 22 Female 519 2.93 111 326 21 Female 240 2.52 255 327 21 Male 1700 2.92 157 328 21 Female 60 3.65 166 329 20 Male 1223 2.96 235 330 20 Male 561 3.23 206 331 21 Male 1149 3.27 209 332 20 Female 451 3.35 170 333 21 Male 1123 2.9 126 334 21 Male 423 2.05 112 335 20 Male 1590 3.04 125 336 21 Female 964 3.1 71 337 22 Male 1158 1.38 91 338 21 Male 173 1.34 3 339 21 Male 1546 3.1 122 340 22 Male 348 3.04 136 341 21 Female 572 3.57 156 342 21 Female 1278 2.61 223 343 20 Male 898 2.87 67 344 21 Female 1479 2.85 161 345 21 Male 812 1.61 146 346 22 Female 689 3.12 241 347 22 Male 274 0.4 51 348 21 Female 100 3 133 349 22 Male 247 2.82 17 350 21 Female 395 3.01 149 351 20 Male 324 3.26 169 352 21 Female 441 3.34 105 353 22 Female 474 2.43 95 354 21 Female 477 1.5 157 355 21 Male 1845 2.6 259 356 21 Female 962 2.8 180 357 21 Female 1307 2.82 42 358 22 Female 1440 3.66 259 359 21 Male 743 2.55 275 360 21 Male 1013 1.48 146 361 21 Female 823 3.04 278 362 21 Male 881 2.28 26 363 21 Female 2372 2.46 77 364 22 Female 1439 3.71 136 365 21 Female 288 2.41 164 366 21 Female 814 2.67 81 367 21 Female 1466 3.48 138 368 21 Male 1169 3.82 114 369 21 Male 1040 2.8 97 370 22 Male 1176 2.98 108 371 21 Female 1075 1.89 153 372 21 Male 810 3.51 132 373 21 Female 1250 2.75 14 374 21 Male 271 3.31 211 375 20 Male 458 2.97 133 376 20 Female 227 1.33 234 377 21 Male 1018 3.52 180 378 21 Female 1999 2.29 103 379 20 Male 843 2.67 261 380 21 Female 203 1.54 98 381 21 Male 1024 3.76 123 382 21 Female 858 2.72 33 383 21 Male 554 2.14 224 384 21 Female 535 3.76 105 385 22 Male 1225 1.85 105 386 21 Male 1851 2.59 124 387 21 Female 436 3.61 92 388 21 Female 289 2.82 10 389 21 Female 136 3.11 87 390 21 Male 1410 2.67 77 391 21 Female 1300 2.07 268 392 20 Female 1234 3.2 129 393 20 Female 553 3.75 181 394 21 Male 216 2.36 187 395 21 Male 958 3.46 137 396 21 Male 112 1.55 146 397 22 Female 835 1.85 117 398 21 Male 86 2.21 98 399 21 Female 228 1.45 180 400 20 Female 103 3.02 264 401 22 Male 609 2.55 91 402 21 Male 935 3.55 242 403 20 Female 786 3.12 113 404 21 Male 90 3.06 155 405 21 Female 572 2.77 118 406 21 Female 487 3.29 168 407 22 Female 414 3.51 263 408 21 Male 968 3.49 92 409 21 Male 299 2.91 162 410 20 Female 1130 2.34 181 411 20 Female 1533 2.69 90 412 21 Female 131 2.96 137 413 21 Male 220 2.69 246 414 21 Female 349 2.47 234 415 21 Female 734 3.06 83 416 21 Male 1156 3.78 235 417 21 Male 588 2.22 110 418 22 Female 623 1.9 272 419 20 Male 166 2.67 96 420 21 Male 862 3.19 99 421 21 Female 674 3.82 80 422 22 Female 336 2.55 2 423 21 Female 388 2.05 107 424 21 Male 1407 3.55 91 425 21 Female 1490 3.31 240 426 21 Male 1318 2.73 113 427 21 Male 1055 3.31 25 428 21 Male 612 2.81 110 429 21 Male 451 3.97 70 430 21 Male 1085 3.17 123 431 20 Male 1383 1.8 159 432 21 Male 398 2.97 117 433 21 Female 827 3.04 97 434 21 Male 667 3.48 334 435 22 Male 790 2.3 7 436 21 Female 555 2.81 28 437 20 Female 109 2.47 216 438 21 Female 17 2.88 186 439 21 Male 383 3.13 139 440 20 Male 1568 3.07 87 441 21 Female 924 2.92 112 442 21 Female 1174 3.81 218 443 22 Female 181 2.95 31 444 20 Female 367 2.75 24 445 21 Male 1703 3.46 278 446 22 Female 1059 2.35 87 447 20 Male 776 3.45 187 448 21 Female 749 2.47 29 449 20 Male 453 2.37 42 450 21 Male 155 2.37 39 451 21 Female 635 2.81 228 452 22 Female 310 3.65 261 453 21 Female 994 3.48 81 454 21 Female 1028 3.91 114 455 21 Male 1270 3.28 160 456 22 Female 423 2.15 83 457 22 Male 1165 2.83 140 458 21 Male 1420 2.13 152 459 21 Male 646 3.98 116 460 21 Female 909 2.77 313 461 20 Female 1175 1.9 217 462 22 Male 818 3.33 164 463 22 Male 1200 2.13 169 464 21 Female 1161 2.26 129 465 21 Male 257 3.04 24 466 21 Male 736 2.28 27 467 20 Male 4 2.52 83 468 21 Female 489 3.43 20 469 21 Female 405 2.76 150 470 20 Male 414 2.47 94 471 21 Male 454 2.96 63 472 22 Male 969 2.97 64 473 21 Male 944 3.13 181 474 21 Female 254 3.01 153 475 21 Female 674 2.62 118 476 22 Male 343 3.05 310 477 21 Male 2152 2.5 117 478 21 Female 1117 3.31 158 479 22 Male 1805 3.87 20 480 21 Male 1360 3.13 88 481 21 Female 296 3.57 115 482 20 Female 490 2.67 87 483 23 Female 730 3.63 109 484 21 Female 1267 3.49 95 485 21 Male 205 3.64 117 486 21 Female 597 3.87 141 487 20 Male 548 3.74 189 488 22 Male 228 2.19 187 489 21 Female 61 2.75 202 490 21 Female 894 2.15 277 491 22 Male 956 1.74 162 492 21 Female 1295 1.93 148 493 20 Female 1513 2.99 187 494 21 Male 645 2.63 177 495 20 Female 324 1.73 207 496 21 Female 666 1.87 103 497 21 Female 478 2.83 109 498 21 Female 1149 3.5 120 499 21 Male 445 1.81 174 500 21 Female 269 2.46 307

Explanation / Answer

Sol:

I will be using excel spreed sheet to solve this. In the yes/no cell I wiil put the following formula.

=IF(E3<2,"Yes","No")

Only Select Yes

st.number age gender class.prep school.perform facebook.time Yes/No 34 20 Male 432 1.8 64 Yes 60 21 Female 620 1.14 235 Yes 65 21 Female 660 1.57 74 Yes 69 22 Male 668 1.9 108 Yes 80 20 Female 710 1.36 149 Yes 105 22 Female 577 1.66 65 Yes 107 21 Female 1150 1.64 104 Yes 132 21 Female 454 1.66 50 Yes 139 21 Female 1083 1.8 191 Yes 151 21 Female 778 1.92 76 Yes 159 21 Male 590 1.87 82 Yes 166 21 Male 1015 1.82 97 Yes 196 22 Female 605 1.89 66 Yes 199 21 Female 1134 1.74 66 Yes 207 22 Female 521 1.14 29 Yes 228 21 Male 534 1.03 85 Yes 258 21 Male 551 1.87 93 Yes 263 21 Female 399 1.99 199 Yes 287 21 Female 215 1.33 54 Yes 309 21 Female 294 1.95 367 Yes 337 22 Male 1158 1.38 91 Yes 338 21 Male 173 1.34 3 Yes 345 21 Male 812 1.61 146 Yes 347 22 Male 274 0.4 51 Yes 354 21 Female 477 1.5 157 Yes 360 21 Male 1013 1.48 146 Yes 371 21 Female 1075 1.89 153 Yes 376 20 Female 227 1.33 234 Yes 380 21 Female 203 1.54 98 Yes 385 22 Male 1225 1.85 105 Yes 396 21 Male 112 1.55 146 Yes 397 22 Female 835 1.85 117 Yes 399 21 Female 228 1.45 180 Yes 418 22 Female 623 1.9 272 Yes 431 20 Male 1383 1.8 159 Yes 461 20 Female 1175 1.9 217 Yes 491 22 Male 956 1.74 162 Yes 492 21 Female 1295 1.93 148 Yes 495 20 Female 324 1.73 207 Yes 496 21 Female 666 1.87 103 Yes 499 21 Male 445 1.81 174 Yes

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.