Data analytics - Case study 3

profileksmith21
TexasSTAARFilterANOVAWeek7Data-3case3.csv
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