Data analytics - Case study 3
| StudentID | Gender | Testing Location | Parental Level of Education | Lunch | Test Preparation Course | Math Score | Reading Score | Writing Score |
| 4 | Male | Group A | Associates Degree | Free/Reduced | None | 47 | 57 | 44 |
| 6 | Female | Group B | Associates Degree | Standard | None | 71 | 83 | 78 |
| 40 | Male | Group B | Associates Degree | Free/Reduced | None | 57 | 56 | 57 |
| 43 | Female | Group B | Associates Degree | Standard | None | 53 | 58 | 65 |
| 46 | Male | Group B | Associates Degree | Standard | None | 65 | 54 | 57 |
| 47 | Female | Group A | Associates Degree | Standard | Completed | 55 | 65 | 62 |
| 63 | Male | Group A | Associates Degree | Free/Reduced | None | 62 | 61 | 55 |
| 69 | Male | Group B | Associates Degree | Free/Reduced | None | 61 | 58 | 56 |
| 73 | Female | Group A | Associates Degree | Free/Reduced | None | 41 | 51 | 48 |
| 76 | Male | Group B | Associates Degree | Free/Reduced | None | 44 | 41 | 38 |
| 81 | Female | Group B | Associates Degree | Standard | None | 47 | 49 | 50 |
| 109 | Female | Group B | Associates Degree | Free/Reduced | None | 52 | 76 | 70 |
| 113 | Male | Group A | Associates Degree | Standard | None | 54 | 53 | 47 |
| 122 | Male | Group B | Associates Degree | Standard | Completed | 91 | 89 | 92 |
| 153 | Female | Group B | Associates Degree | Standard | Completed | 59 | 70 | 66 |
| 159 | Female | Group B | Associates Degree | Standard | Completed | 61 | 86 | 87 |
| 161 | Male | Group B | Associates Degree | Free/Reduced | Completed | 82 | 78 | 74 |
| 204 | Female | Group B | Associates Degree | Standard | None | 57 | 69 | 68 |
| 222 | Male | Group B | Associates Degree | Standard | None | 87 | 85 | 73 |
| 225 | Female | Group B | Associates Degree | Standard | Completed | 52 | 66 | 73 |
| 286 | Male | Group B | Associates Degree | Standard | Completed | 81 | 82 | 82 |
| 296 | Male | Group B | Associates Degree | Free/Reduced | None | 67 | 62 | 60 |
| 304 | Male | Group B | Associates Degree | Standard | None | 80 | 76 | 64 |
| 309 | Female | Group B | Associates Degree | Free/Reduced | None | 53 | 71 | 67 |
| 311 | Female | Group B | Associates Degree | Standard | None | 73 | 76 | 80 |
| 334 | Male | Group B | Associates Degree | Standard | None | 90 | 78 | 81 |
| 357 | Male | Group A | Associates Degree | Standard | None | 63 | 61 | 61 |
| 381 | Female | Group B | Associates Degree | Standard | None | 80 | 86 | 83 |
| 407 | Male | Group B | Associates Degree | Standard | Completed | 65 | 65 | 63 |
| 408 | Female | Group B | Associates Degree | Standard | None | 82 | 80 | 77 |
| 444 | Female | Group B | Associates Degree | Standard | None | 73 | 83 | 76 |
| 450 | Male | Group B | Associates Degree | Standard | None | 81 | 73 | 72 |
| 475 | Female | Group B | Associates Degree | Standard | Completed | 90 | 90 | 91 |
| 485 | Female | Group B | Associates Degree | Standard | None | 49 | 52 | 54 |
| 490 | Male | Group A | Associates Degree | Free/Reduced | Completed | 79 | 82 | 82 |
| 491 | Female | Group A | Associates Degree | Free/Reduced | None | 65 | 85 | 76 |
| 502 | Female | Group B | Associates Degree | Standard | Completed | 94 | 87 | 92 |
| 540 | Male | Group A | Associates Degree | Standard | Completed | 97 | 92 | 86 |
| 553 | Female | Group B | Associates Degree | Standard | None | 40 | 48 | 50 |
| 559 | Female | Group B | Associates Degree | Free/Reduced | None | 53 | 70 | 70 |
| 566 | Male | Group B | Associates Degree | Standard | None | 48 | 43 | 45 |
| 576 | Male | Group A | Associates Degree | Free/Reduced | Completed | 40 | 55 | 53 |
| 610 | Female | Group B | Associates Degree | Standard | None | 58 | 63 | 65 |
| 615 | Female | Group A | Associates Degree | Standard | None | 82 | 93 | 93 |
| 627 | Male | Group B | Associates Degree | Free/Reduced | Completed | 69 | 70 | 63 |
| 654 | Female | Group A | Associates Degree | Standard | Completed | 65 | 70 | 74 |
| 716 | Female | Group B | Associates Degree | Free/Reduced | Completed | 76 | 94 | 87 |
| 731 | Female | Group B | Associates Degree | Free/Reduced | Completed | 68 | 77 | 80 |
| 742 | Female | Group A | Associates Degree | Free/Reduced | None | 37 | 57 | 56 |
| 839 | Male | Group B | Associates Degree | Free/Reduced | Completed | 58 | 57 | 53 |
| 868 | Male | Group B | Associates Degree | Standard | None | 61 | 42 | 41 |
| 873 | Male | Group B | Associates Degree | Standard | Completed | 82 | 84 | 78 |
| 915 | Female | Group B | Associates Degree | Free/Reduced | None | 46 | 61 | 55 |
| 924 | Female | Group B | Associates Degree | Free/Reduced | None | 54 | 65 | 65 |
| 937 | Male | Group A | Associates Degree | Standard | None | 67 | 57 | 53 |
| 1 | Female | Group B | Bachelors Degree | Standard | None | 72 | 72 | 74 |
| 78 | Male | Group A | Bachelors Degree | Standard | Completed | 80 | 78 | 81 |
| 117 | Female | Group B | Bachelors Degree | Free/Reduced | None | 75 | 85 | 82 |
| 130 | Female | Group A | Bachelors Degree | Standard | None | 51 | 49 | 51 |
| 152 | Male | Group A | Bachelors Degree | Standard | None | 77 | 67 | 68 |
| 200 | Female | Group B | Bachelors Degree | Free/Reduced | None | 78 | 79 | 76 |
| 233 | Female | Group B | Bachelors Degree | Standard | None | 67 | 86 | 83 |
| 280 | Male | Group B | Bachelors Degree | Free/Reduced | None | 73 | 56 | 57 |
| 289 | Male | Group B | Bachelors Degree | Free/Reduced | None | 88 | 75 | 76 |
| 312 | Male | Group B | Bachelors Degree | Standard | None | 66 | 60 | 57 |
| 319 | Male | Group B | Bachelors Degree | Standard | None | 63 | 71 | 69 |
| 351 | Female | Group B | Bachelors Degree | Standard | None | 52 | 65 | 69 |
| 356 | Female | Group B | Bachelors Degree | Standard | None | 61 | 72 | 70 |
| 366 | Male | Group A | Bachelors Degree | Free/Reduced | Completed | 49 | 58 | 60 |
| 380 | Male | Group A | Bachelors Degree | Standard | None | 66 | 64 | 62 |
| 465 | Male | Group A | Bachelors Degree | Standard | Completed | 75 | 58 | 62 |
| 508 | Male | Group B | Bachelors Degree | Free/Reduced | None | 55 | 59 | 54 |
| 552 | Male | Group B | Bachelors Degree | Free/Reduced | Completed | 87 | 90 | 88 |
| 565 | Male | Group B | Bachelors Degree | Free/Reduced | None | 48 | 51 | 46 |
| 572 | Male | Group A | Bachelors Degree | Standard | None | 91 | 96 | 92 |
| 622 | Male | Group B | Bachelors Degree | Free/Reduced | None | 62 | 63 | 56 |
| 633 | Female | Group B | Bachelors Degree | Standard | Completed | 66 | 74 | 81 |
| 646 | Female | Group B | Bachelors Degree | Standard | Completed | 65 | 81 | 81 |
| 668 | Female | Group B | Bachelors Degree | Free/Reduced | None | 77 | 85 | 87 |
| 698 | Female | Group A | Bachelors Degree | Standard | None | 59 | 72 | 70 |
| 703 | Male | Group A | Bachelors Degree | Standard | Completed | 87 | 84 | 87 |
| 706 | Male | Group A | Bachelors Degree | Free/Reduced | None | 62 | 72 | 65 |
| 810 | Male | Group B | Bachelors Degree | Standard | None | 59 | 54 | 51 |
| 817 | Female | Group A | Bachelors Degree | Standard | None | 45 | 59 | 64 |
| 833 | Male | Group A | Bachelors Degree | Standard | None | 64 | 60 | 58 |
| 856 | Female | Group B | Bachelors Degree | Standard | None | 97 | 97 | 96 |
| 970 | Female | Group B | Bachelors Degree | Standard | None | 75 | 84 | 80 |
| 10 | Female | Group B | High School | Free/Reduced | None | 38 | 60 | 50 |
| 13 | Female | Group B | High School | Standard | None | 65 | 81 | 73 |
| 82 | Male | Group B | High School | Free/Reduced | None | 49 | 45 | 45 |
| 104 | Male | Group B | High School | Standard | Completed | 60 | 44 | 47 |
| 126 | Female | Group B | High School | Standard | None | 87 | 95 | 86 |
| 144 | Male | Group A | High School | Standard | None | 57 | 43 | 47 |
| 169 | Female | Group B | High School | Standard | Completed | 68 | 83 | 78 |
| 171 | Male | Group A | High School | Standard | Completed | 72 | 73 | 74 |
| 177 | Female | Group B | High School | Free/Reduced | Completed | 46 | 54 | 58 |
| 219 | Male | Group B | High School | Free/Reduced | None | 66 | 77 | 70 |
| 248 | Female | Group B | High School | Standard | Completed | 58 | 70 | 68 |
| 249 | Female | Group B | High School | Standard | None | 65 | 64 | 62 |
| 343 | Female | Group B | High School | Standard | Completed | 69 | 76 | 74 |
| 361 | Female | Group B | High School | Standard | None | 58 | 62 | 59 |
| 396 | Male | Group A | High School | Free/Reduced | None | 48 | 45 | 41 |
| 397 | Female | Group B | High School | Free/Reduced | None | 50 | 67 | 63 |
| 449 | Male | Group B | High School | Standard | None | 47 | 46 | 42 |
| 460 | Male | Group B | High School | Standard | Completed | 72 | 65 | 68 |
| 468 | Male | Group A | High School | Free/Reduced | Completed | 72 | 67 | 65 |
| 469 | Female | Group A | High School | Free/Reduced | Completed | 77 | 88 | 85 |
| 481 | Male | Group B | High School | Standard | Completed | 73 | 71 | 68 |
| 484 | Male | Group A | High School | Standard | None | 59 | 52 | 46 |
| 495 | Female | Group B | High School | Standard | None | 54 | 64 | 68 |
| 507 | Male | Group A | High School | Standard | None | 68 | 70 | 66 |
| 520 | Female | Group B | High School | Free/Reduced | Completed | 67 | 78 | 79 |
| 535 | Male | Group B | High School | Standard | Completed | 73 | 69 | 68 |
| 569 | Male | Group B | High School | Free/Reduced | None | 63 | 48 | 47 |
| 578 | Female | Group B | High School | Standard | None | 81 | 91 | 89 |
| 587 | Female | Group A | High School | Standard | None | 55 | 73 | 73 |
| 597 | Male | Group B | High School | . | None | . | 24 | 15 |
| 632 | Male | Group B | High School | Standard | None | 79 | 60 | 65 |
| 636 | Male | Group A | High School | Standard | None | 71 | 74 | 64 |
| 637 | Female | Group B | High School | Free/Reduced | Completed | 67 | 80 | 81 |
| 645 | Male | Group B | High School | Standard | None | 70 | 65 | 60 |
| 649 | Female | Group B | High School | Standard | None | 50 | 53 | 55 |
| 652 | Female | Group A | High School | Standard | Completed | 68 | 80 | 76 |
| 682 | Male | Group B | High School | Standard | None | 60 | 68 | 60 |
| 683 | Male | Group B | High School | Standard | None | 62 | 55 | 54 |
| 689 | Male | Group A | High School | Free/Reduced | None | 53 | 58 | 44 |
| 764 | Female | Group B | High School | Standard | None | 62 | 62 | 63 |
| 766 | Female | Group B | High School | Standard | None | 74 | 72 | 72 |
| 768 | Male | Group B | High School | Standard | Completed | 76 | 62 | 60 |
| 771 | Male | Group B | High School | Standard | None | 52 | 48 | 49 |
| 777 | Female | Group B | High School | Standard | None | 66 | 72 | 70 |
| 783 | Female | Group B | High School | Free/Reduced | Completed | 76 | 85 | 82 |
| 791 | Female | Group B | High School | Standard | None | 48 | 62 | 60 |
| 795 | Female | Group B | High School | Standard | None | 42 | 52 | 51 |
| 812 | Male | Group A | High School | Free/Reduced | None | 45 | 47 | 49 |
| 819 | Female | Group B | High School | Free/Reduced | None | 60 | 72 | 68 |
| 824 | Female | Group B | High School | Free/Reduced | None | 71 | 87 | 82 |
| 834 | Female | Group B | High School | Standard | Completed | 77 | 82 | 89 |
| 838 | Female | Group A | High School | Standard | Completed | 75 | 82 | 79 |
| 843 | Female | Group B | High School | Free/Reduced | Completed | . | . | 36 |
| 852 | Female | Group A | High School | Standard | None | 61 | 68 | 63 |
| 859 | Male | Group B | High School | Standard | Completed | 52 | 49 | 46 |
| 871 | Male | Group B | High School | Standard | None | 59 | 58 | 47 |
| 883 | Female | Group B | High School | Free/Reduced | None | 64 | 73 | 71 |
| 897 | Male | Group B | High School | Free/Reduced | None | 36 | 29 | 27 |
| 903 | Female | Group A | High School | Free/Reduced | Completed | 34 | 48 | 41 |
| 907 | Male | Group B | High School | Standard | None | 57 | 48 | 51 |
| 945 | Female | Group B | High School | Standard | None | 58 | 68 | 61 |
| 947 | Male | Group B | High School | Standard | None | 82 | 82 | 80 |
| 973 | Female | Group A | High School | Free/Reduced | Completed | 53 | 50 | 60 |
| 981 | Female | Group B | . | Free/Reduced | None | . | 24 | . |
| 986 | Male | Group A | High School | Standard | None | 57 | 51 | 54 |
| 995 | Male | Group A | High School | Standard | None | 63 | 63 | 62 |