Description
Instructions:
Download the data file linked on Canvas
Load the CSV file into a table in MySQL
From Microsoft PowerBI connect to your MySQL database instance
Connect to the table you imported into your MySQL database
Transform the table to be similar to the one in Assignment 1
Load the transformed table into PowerBI
Create new measures to compute the average of the 3 scores per other columns
Create a visual report of the measures with bar graphs
What to turn in:
Turn in a document with screenshots for the steps mentioned above including the visual report created with PowerBI
Unformatted Attachment Preview
gender
female
male
male
male
female
male
male
female
male
male
male
female
female
male
female
male
male
male
female
male
female
male
male
male
female
female
male
male
male
male
female
female
male
male
male
female
female
male
female
female
female
male
female
female
female
female
female
male
race/ethnicity
parental level
lunch
of education
test preparation
mathcourse
scorereading score
writing score
group B high schoolfree/reduced
none
21
40
30
group D bachelor’s degree
free/reduced
none
71
68
65
group B high schoolfree/reduced
none
59
52
54
group B high schoolstandard none
50
51
46
group D high schoolfree/reduced
none
44
63
60
group D bachelor’s degree
standard none
85
76
76
group E some college
standard completed
95
81
81
group B some college
standard none
80
96
94
group B high schoolstandard none
56
53
48
group B some high school
free/reduced
none
42
46
37
group C associate’s free/reduced
degree
none
77
75
77
group C high schoolstandard none
56
60
60
group D high schoolfree/reduced
completed
58
71
70
group C some college
standard completed
74
66
68
group E some high school
free/reduced
completed
51
60
63
group C bachelor’s degree
standard none
56
58
50
group D associate’s free/reduced
degree
completed
58
65
62
group B some high school
free/reduced
none
60
69
58
group D associate’s standard
degree
none
55
62
66
group C some high school
standard none
67
55
54
group E some high school
standard completed
75
71
75
group D some high school
standard none
42
35
30
group D some college
standard completed
67
52
57
group D some high school
free/reduced
none
65
56
56
group C bachelor’s degree
standard none
92
85
93
group B high schoolfree/reduced
completed
46
65
65
group D some college
free/reduced
none
37
39
40
group D associate’s standard
degree
none
65
62
59
group D some college
free/reduced
completed
59
55
56
group D some college
free/reduced
none
83
82
82
group D some college
standard none
77
79
80
group A high schoolstandard completed
74
79
77
group C associate’s free/reduced
degree
completed
51
59
58
group D bachelor’s degree
standard none
81
79
79
group C associate’s standard
degree
completed
67
65
70
group D high schoolstandard none
61
64
70
group C associate’s standard
degree
none
88
88
82
group C some high school
standard completed
86
82
79
group B some college
standard completed
63
71
76
group D master’s degree
standard none
44
59
59
group C some college
free/reduced
none
37
42
42
group C associate’s free/reduced
degree
none
77
78
76
group D some high school
free/reduced
completed
54
67
67
group C some high school
free/reduced
completed
68
87
83
group A bachelor’s degree
free/reduced
completed
41
44
47
group C high schoolfree/reduced
completed
45
56
53
group C associate’s standard
degree
none
71
76
73
group B associate’s standard
degree
none
72
60
57
female
male
male
female
female
female
female
female
female
female
male
male
male
female
male
female
male
female
female
male
female
male
female
male
male
female
female
female
female
male
female
male
male
female
male
male
female
male
female
male
female
male
female
female
female
female
male
male
male
group D
group C
group E
group B
group E
group C
group B
group C
group B
group C
group C
group B
group C
group C
group A
group D
group B
group D
group D
group C
group C
group A
group C
group D
group D
group C
group B
group C
group C
group D
group D
group B
group E
group B
group D
group A
group B
group B
group D
group D
group C
group C
group B
group B
group C
group A
group C
group B
group E
some college
free/reduced
completed
associate’s standard
degree
none
some high school
standard none
master’s degree
standard none
some college
standard none
bachelor’s degree
standard completed
associate’s free/reduced
degree
none
associate’s standard
degree
none
some high school
standard none
high schoolfree/reduced
completed
some college
free/reduced
completed
some high school
standard none
high schoolfree/reduced
none
some high school
free/reduced
none
bachelor’s degree
standard none
high schoolfree/reduced
none
some college
standard completed
some college
standard none
high schoolstandard none
some college
free/reduced
none
bachelor’s degree
standard completed
some high school
standard none
associate’s standard
degree
completed
associate’s free/reduced
degree
none
some high school
standard none
associate’s standard
degree
none
some college
standard none
high schoolstandard none
master’s degree
standard none
high schoolfree/reduced
none
some high school
free/reduced
completed
associate’s standard
degree
none
some college
standard completed
associate’s free/reduced
degree
none
associate’s free/reduced
degree
completed
high schoolstandard none
master’s degree
free/reduced
completed
some college
standard completed
master’s degree
standard completed
some high school
free/reduced
completed
high schoolstandard none
some college
standard completed
some high school
standard none
some high school
standard none
high schoolstandard completed
some high school
standard none
some college
free/reduced
none
bachelor’s degree
free/reduced
completed
some high school
standard none
59
92
75
93
90
76
59
44
44
72
59
66
44
58
51
10
74
76
89
47
69
74
54
52
93
71
77
51
100
68
46
56
85
52
81
47
60
76
86
52
87
66
37
63
81
69
64
87
82
67
84
67
93
79
78
68
50
42
77
49
60
49
76
50
18
80
86
95
50
85
61
64
56
87
88
80
70
89
63
55
60
83
67
88
31
85
63
93
46
100
66
46
70
98
83
66
92
86
77
79
60
99
80
91
63
56
45
78
48
56
41
63
47
19
75
86
93
47
82
51
60
53
84
88
74
61
100
56
61
59
88
65
86
29
80
67
92
49
94
63
43
67
98
82
57
91
78
female
female
male
male
female
female
male
female
female
male
male
female
male
male
female
male
female
male
female
male
female
female
female
male
male
male
male
male
female
male
male
female
female
male
female
female
female
female
male
female
male
female
male
female
female
female
male
male
male
group D
group D
group D
group B
group C
group D
group C
group D
group E
group B
group D
group C
group C
group E
group B
group B
group C
group C
group B
group D
group B
group C
group B
group D
group D
group A
group B
group B
group C
group D
group D
group C
group B
group E
group E
group D
group D
group B
group C
group B
group C
group B
group C
group D
group C
group C
group D
group B
group C
bachelor’s degree
free/reduced
completed
some college
free/reduced
none
some college
free/reduced
none
some high school
standard completed
some high school
standard none
bachelor’s degree
standard none
associate’s standard
degree
completed
associate’s free/reduced
degree
completed
some high school
free/reduced
completed
some high school
free/reduced
none
associate’s standard
degree
completed
high schoolstandard completed
associate’s standard
degree
none
some high school
standard completed
bachelor’s degree
standard none
some high school
standard none
high schoolstandard none
some high school
standard completed
some college
free/reduced
completed
some high school
free/reduced
none
some high school
standard completed
high schoolstandard completed
high schoolfree/reduced
none
associate’s standard
degree
completed
master’s degree
standard completed
high schoolstandard none
bachelor’s degree
free/reduced
none
high schoolstandard none
associate’s standard
degree
none
some college
standard none
some college
standard none
associate’s standard
degree
none
some college
standard none
some college
standard none
some high school
standard completed
high schoolstandard completed
associate’s standard
degree
none
some high school
free/reduced
none
some high school
standard none
high schoolstandard completed
some college
standard completed
some high school
standard completed
bachelor’s degree
standard none
some high school
standard none
some college
standard none
associate’s standard
degree
none
high schoolfree/reduced
none
high schoolstandard none
bachelor’s degree
standard none
52
54
77
88
47
60
71
62
60
58
65
89
66
94
70
61
63
74
74
44
82
75
43
86
80
71
43
87
83
83
52
68
64
65
67
84
86
56
59
67
90
70
64
53
80
79
58
75
77
69
71
80
88
48
64
68
76
76
57
65
97
69
84
80
52
84
63
94
46
93
87
58
89
83
64
34
75
91
88
49
73
73
54
70
91
88
68
54
84
94
81
54
61
85
85
55
72
63
66
77
73
85
49
63
65
85
70
45
63
100
63
78
83
48
75
62
93
46
88
87
50
87
79
58
38
76
89
76
44
78
70
50
75
100
86
64
50
83
92
80
56
64
90
81
51
61
68
female
female
male
male
female
female
female
male
male
male
female
male
female
male
female
female
male
male
male
female
female
female
female
female
female
male
male
male
female
female
female
female
female
female
male
female
female
male
male
male
female
male
female
female
male
female
male
male
female
group D
group B
group C
group B
group D
group A
group C
group B
group B
group B
group A
group A
group C
group B
group D
group D
group C
group C
group B
group C
group C
group B
group E
group C
group C
group D
group C
group D
group B
group E
group D
group D
group E
group C
group D
group E
group A
group B
group C
group B
group D
group B
group C
group C
group C
group C
group B
group C
group C
bachelor’s degree
free/reduced
none
associate’s free/reduced
degree
none
associate’s free/reduced
degree
none
some high school
free/reduced
completed
some college
standard none
associate’s free/reduced
degree
completed
associate’s free/reduced
degree
none
some college
standard completed
some high school
standard none
associate’s free/reduced
degree
none
associate’s standard
degree
none
some college
standard none
bachelor’s degree
standard none
high schoolstandard none
master’s degree
standard none
master’s degree
free/reduced
none
some high school
standard none
associate’s free/reduced
degree
none
high schoolfree/reduced
completed
some high school
free/reduced
none
associate’s free/reduced
degree
none
some high school
standard none
high schoolstandard none
associate’s standard
degree
completed
bachelor’s degree
free/reduced
completed
associate’s free/reduced
degree
none
high schoolfree/reduced
none
some college
standard none
some high school
standard completed
some college
standard completed
some college
free/reduced
none
master’s degree
free/reduced
completed
some college
standard completed
some high school
free/reduced
none
some college
standard completed
master’s degree
standard none
some college
standard completed
associate’s standard
degree
completed
some college
free/reduced
none
some college
standard none
some college
free/reduced
none
some college
free/reduced
none
high schoolstandard none
some college
free/reduced
completed
associate’s free/reduced
degree
none
high schoolfree/reduced
none
associate’s standard
degree
none
some college
standard completed
some high school
standard none
74
46
60
61
75
79
59
67
86
76
55
72
77
72
78
36
77
27
53
47
43
74
97
76
56
83
63
56
52
73
38
49
77
42
91
100
81
92
86
54
45
76
59
56
85
33
59
70
67
85
61
51
74
78
89
67
79
71
70
64
71
84
67
88
50
74
36
57
62
51
74
93
88
65
80
60
57
62
72
43
61
86
51
85
100
91
86
79
50
51
64
66
73
77
54
48
58
74
89
56
45
65
75
94
66
73
77
63
62
65
79
68
89
49
69
24
51
61
52
69
96
84
68
79
52
49
59
79
53
67
83
50
90
100
90
90
74
46
52
58
66
72
73
48
48
61
66
male
female
female
female
female
female
female
female
female
male
female
female
male
male
male
female
female
female
female
male
male
male
male
female
female
male
female
male
female
male
male
female
female
male
female
male
male
female
female
male
male
male
male
male
male
female
male
male
female
group D
group B
group E
group C
group E
group E
group C
group C
group C
group D
group A
group B
group D
group D
group D
group E
group D
group C
group B
group C
group B
group C
group D
group D
group A
group D
group C
group C
group D
group A
group E
group C
group C
group E
group C
group C
group B
group C
group C
group A
group D
group A
group D
group A
group D
group E
group C
group C
group B
some college
standard none
high schoolstandard completed
master’s degree
free/reduced
none
high schoolstandard none
high schoolstandard none
some college
standard completed
high schoolfree/reduced
none
master’s degree
free/reduced
completed
associate’s standard
degree
none
some college
standard none
some high school
standard none
master’s degree
free/reduced
none
some high school
standard none
some high school
standard none
associate’s standard
degree
completed
associate’s free/reduced
degree
completed
high schoolstandard completed
associate’s free/reduced
degree
completed
some college
standard completed
some high school
free/reduced
none
some high school
free/reduced
none
bachelor’s degree
free/reduced
none
associate’s free/reduced
degree
none
some college
standard none
high schoolstandard completed
high schoolfree/reduced
none
some high school
standard none
some college
free/reduced
none
some high school
standard none
some college
standard none
some college
standard none
associate’s standard
degree
completed
master’s degree
standard none
high schoolstandard completed
some high school
standard completed
high schoolstandard none
master’s degree
standard completed
master’s degree
free/reduced
none
associate’s free/reduced
degree
completed
some high school
free/reduced
none
high schoolstandard completed
some high school
standard none
some high school
standard none
high schoolstandard none
some high school
standard none
associate’s standard
degree
none
some high school
free/reduced
none
associate’s standard
degree
none
some college
standard completed
71
85
88
45
85
88
20
53
52
71
50
68
89
74
77
58
66
61
92
67
46
93
60
79
68
44
52
71
52
51
100
81
85
88
50
85
90
74
61
35
92
65
60
62
62
76
54
81
66
54
97
93
54
94
95
39
70
68
78
70
84
71
75
68
60
71
80
88
59
48
84
64
85
73
46
58
77
62
44
95
96
96
75
59
88
89
81
72
45
90
66
63
68
51
87
57
77
84
60
100
93
61
96
99
34
71
58
69
64
87
72
71
69
67
72
79
93
61
48
78
62
79
79
40
56
74
66
46
87
99
95
84
70
79
95
88
78
33
82
60
62
59
55
81
55
71
89
female
female
male
male
female
female
male
female
male
female
male
female
male
female
female
male
female
male
female
male
female
male
female
male
male
female
female
male
male
male
male
male
male
male
female
male
male
male
female
male
female
male
male
female
female
male
male
female
female
group C
group C
group C
group D
group C
group E
group C
group D
group C
group D
group C
group B
group B
group C
group E
group B
group C
group B
group B
group B
group C
group E
group B
group C
group D
group E
group C
group A
group C
group A
group E
group C
group C
group D
group B
group E
group C
group D
group B
group C
group A
group E
group D
group A
group A
group D
group D
group E
group E
high schoolfree/reduced
none
some high school
free/reduced
completed
bachelor’s degree
free/reduced
none
some college
free/reduced
none
high schoolfree/reduced
none
some high school
free/reduced
none
master’s degree
standard none
some high school
free/reduced
none
some high school
standard none
associate’s standard
degree
none
high schoolfree/reduced
completed
some high school
standard none
bachelor’s degree
free/reduced
none
some college
free/reduced
completed
some college
standard none
some college
standard none
master’s degree
standard none
some high school
standard completed
bachelor’s degree
standard completed
some high school
standard none
some high school
standard completed
some high school
standard completed
high schoolstandard none
associate’s standard
degree
none
associate’s standard
degree
completed
some high school
free/reduced
completed
high schoolfree/reduced
none
some high school
standard none
high schoolstandard none
some college
standard none
high schoolstandard completed
associate’s standard
degree
completed
some college
free/reduced
none
some college
standard completed
some high school
free/reduced
none
high schoolstandard none
some college
free/reduced
none
some college
free/reduced
none
some high school
standard none
some high school
standard completed
some college
standard none
high schoolstandard none
some high school
free/reduced
none
some high school
standard none
some college
free/reduced
completed
high schoolfree/reduced
none
some high school
free/reduced
none
high schoolstandard none
bachelor’s degree
standard completed
42
52
63
67
29
61
75
55
87
56
38
55
66
60
68
59
94
67
56
51
77
88
65
80
56
56
38
66
92
74
85
62
51
79
54
73
74
71
74
76
66
73
61
73
77
53
35
66
75
42
70
58
73
41
64
75
65
84
68
47
67
63
78
74
45
94
59
77
35
87
84
67
74
58
62
55
68
74
73
74
83
50
80
72
68
77
65
81
79
81
66
70
93
94
54
39
72
83
40
67
49
68
40
63
71
60
80
67
35
66
66
75
69
49
93
61
74
33
88
81
60
73
49
66
49
58
68
64
72
80
44
83
65
60
72
70
79
71
83
59
67
91
89
51
35
64
82
male
female
male
male
female
female
male
male
female
female
male
female
male
female
male
male
female
female
male
female
male
male
female
female
male
female
female
male
male
female
male
male
male
female
male
female
male
male
male
male
female
female
female
female
female
female
female
female
female
group C
group B
group C
group C
group B
group B
group D
group C
group C
group D
group C
group B
group C
group C
group C
group B
group D
group C
group D
group C
group A
group C
group C
group B
group A
group D
group D
group C
group E
group C
group B
group B
group D
group E
group D
group D
group D
group C
group A
group B
group D
group C
group A
group B
group C
group D
group E
group C
group A
high schoolfree/reduced
none
some college
free/reduced
completed
some college
standard none
some high school
free/reduced
none
associate’s standard
degree
completed
master’s degree
free/reduced
none
bachelor’s degree
standard completed
some college
standard none
bachelor’s degree
standard none
some high school
standard none
some college
standard none
high schoolstandard none
some high school
standard none
master’s degree
standard none
some college
free/reduced
none
master’s degree
standard completed
associate’s free/reduced
degree
none
bachelor’s degree
free/reduced
completed
associate’s free/reduced
degree
none
some high school
free/reduced
none
high schoolfree/reduced
none
some high school
standard completed
some college
free/reduced
none
high schoolfree/reduced
none
associate’s standard
degree
completed
some high school
standard none
high schoolfree/reduced
completed
associate’s free/reduced
degree
none
some college
standard none
master’s degree
standard none
associate’s standard
degree
none
high schoolstandard none
high schoolstandard completed
associate’s standard
degree
none
high schoolstandard completed
some high school
standard none
some college
free/reduced
none
high schoolstandard none
some college
free/reduced
none
some high school
free/reduced
completed
bachelor’s degree
free/reduced
completed
high schoolstandard none
master’s degree
standard none
some college
standard none
bachelor’s degree
standard none
associate’s standard
degree
none
high schoolstandard none
some high school
free/reduced
completed
some high school
standard none
87
50
73
41
83
69
82
81
48
79
53
53
92
78
56
100
63
58
54
37
45
82
61
32
65
73
74
45
90
55
86
48
69
47
70
66
63
62
67
50
64
49
61
53
99
44
72
49
65
78
68
65
53
84
83
81
91
54
76
44
71
81
84
58
100
76
64
53
52
35
65
65
45
79
73
92
56
73
73
75
44
62
50
68
71
60
49
67
51
83
55
74
56
100
58
83
70
80
72
66
62
48
86
87
80
83
54
85
40
67
80
81
53
98
74
68
58
46
31
73
71
37
76
77
93
51
70
70
77
41
66
47
67
71
56
52
64
47
83
51
70
49
94
51
77
59
70
male
female
male
male
male
female
male
male
male
male
male
male
female
female
female
male
female
male
female
male
female
male
male
male
male
female
male
female
female
male
female
female
female
female
male
male
male
female
male
male
female
female
female
male
male
female
female
female
female
group C
group C
group E
group E
group B
group D
group C
group C
group C
group C
group C
group B
group A
group C
group B
group D
group D
group C
group C
group C
group D
group C
group B
group C
group B
group C
group E
group D
group C
group C
group C
group C
group D
group D
group C
group C
group B
group D
group C
group B
group B
group C
group B
group E
group B
group C
group C
group D
group C
some high school
free/reduced
none
associate’s standard
degree
none
associate’s free/reduced
degree
none
high schoolstandard completed
bachelor’s degree
standard completed
bachelor’s degree
free/reduced
none
master’s degree
standard none
some college
free/reduced
none
some college
standard completed
some college
standard completed
some college
free/reduced
completed
some college
standard completed
some high school
standard none
associate’s free/reduced
degree
completed
some high school
standard none
high schoolstandard completed
high schoolstandard none
bachelor’s degree
standard none
some high school
standard none
associate’s standard
degree
none
high schoolstandard none
high schoolstandard none
some high school
standard none
high schoolstandard none
some high school
free/reduced
none
some college
free/reduced
none
some high school
standard none
bachelor’s degree
free/reduced
none
associate’s standard
degree
none
master’s degree
standard none
associate’s free/reduced
degree
none
high schoolstandard completed
associate’s standard
degree
completed
high schoolstandard none
high schoolstandard none
bachelor’s degree
free/reduced
none
master’s degree
standard completed
high schoolstandard completed
associate’s standard
degree
none
master’s degree
standard completed
high schoolfree/reduced
none
associate’s standard
degree
completed
some college
free/reduced
completed
high schoolstandard completed
high schoolstandard none
master’s degree
standard none
some high school
standard completed
some high school
free/reduced
none
some high school
standard none
32
64
75
100
100
55
79
39
60
89
67
74
61
57
63
58
39
100
47
81
39
93
46
83
70
46
60
77
77
69
62
51
70
60
73
58
64
85
79
78
56
79
52
85
56
56
65
49
48
31
86
74
95
91
73
63
40
64
86
69
67
68
76
63
58
57
94
63
75
57
88
50
77
74
63
53
83
80
62
64
69
77
72
72
54
73
87
70
77
65
91
65
76
47
69
69
61
59
28
83
69
96
95
77
67
29
59
88
66
72
68
70
59
59
58
94
53
74
55
82
48
72
71
59
50
81
83
60
70
65
86
72
68
49
77
93
63
82
62
91
61
75
48
73
72
55
53
female
female
male
female
male
male
male
female
male
male
female
male
female
female
female
male
female
male
male
male
male
female
female
male
male
female
male
female
male
male
female
female
male
male
female
female
female
female
female
female
female
female
male
male
male
female
male
male
male
group B
group C
group B
group C
group D
group C
group D
group E
group D
group B
group B
group D
group C
group E
group C
group B
group C
group E
group D
group D
group B
group D
group E
group E
group D
group A
group E
group A
group C
group C
group C
group A
group C
group A
group C
group A
group B
group A
group C
group D
group C
group E
group B
group B
group D
group A
group E
group A
group E
master’s degree
free/reduced
none
some high school
free/reduced
none
master’s degree
standard completed
high schoolstandard completed
high schoolfree/reduced
completed
high schoolfree/reduced
completed
some college
free/reduced
none
associate’s standard
degree
none
high schoolstandard none
high schoolfree/reduced
none
some high school
standard completed
some college
standard none
some high school
standard completed
some high school
standard none
master’s degree
free/reduced
none
high schoolstandard none
bachelor’s degree
standard none
associate’s free/reduced
degree
none
some college
standard completed
high schoolstandard none
some high school
standard none
some high school
standard none
associate’s standard
degree
none
associate’s standard
degree
completed
high schoolstandard none
associate’s standard
degree
none
associate’s free/reduced
degree
completed
some college
free/reduced
none
some high school
standard completed
some high school
free/reduced
none
associate’s standard
degree
completed
some high school
free/reduced
none
some college
free/reduced
none
high schoolfree/reduced
none
associate’s free/reduced
degree
completed
associate’s standard
degree
completed
associate’s standard
degree
completed
some high school
standard none
some high school
standard none
high schoolstandard none
high schoolstandard none
some college
standard none
some college
standard none
master’s degree
standard none
associate’s standard
degree
none
high schoolstandard none
some college
free/reduced
completed
associate’s standard
degree
none
associate’s standard
degree
completed
44
39
94
78
67
50
73
79
84
58
57
35
61
75
62
67
68
89
57
65
65
80
74
62
86
57
55
45
71
58
35
50
41
65
74
74
72
46
55
55
68
56
42
53
86
71
83
82
80
42
44
100
85
68
56
66
92
78
59
67
31
72
74
76
75
76
93
66
58
69
83
74
57
76
60
47
54
67
54
60
64
45
72
86
80
86
56
47
67
71
60
35
42
75
81
84
77
63
41
49
98
77
63
62
62
86
76
51
70
34
76
74
74
71
78
86
65
59
57
80
75
65
76
55
52
53
65
51
53
61
40
59
93
91
77
54
52
66
67
58
37
42
68
83
76
70
62
female
male
male
male
female
male
male
female
female
male
male
male
male
female
female
male
male
male
male
male
male
female
female
male
female
male
female
male
male
female
female
female
female
female
female
male
male
female
male
male
female
male
female
female
female
male
male
female
male
group C
group D
group B
group D
group C
group C
group B
group B
group E
group D
group C
group E
group D
group C
group D
group D
group B
group E
group D
group C
group D
group D
group B
group D
group C
group A
group C
group D
group D
group D
group B
group C
group B
group C
group A
group C
group B
group B
group B
group C
group B
group B
group C
group D
group C
group D
group C
group C
group B
some college
free/reduced
completed
associate’s standard
degree
none
high schoolfree/reduced
completed
associate’s standard
degree
none
associate’s free/reduced
degree
none
high schoolfree/reduced
none
high schoolstandard none
master’s degree
free/reduced
none
some college
free/reduced
none
associate’s standard
degree
none
bachelor’s degree
standard none
high schoolstandard none
some college
free/reduced
none
some high school
standard completed
associate’s standard
degree
none
some high school
free/reduced
none
high schoolstandard none
high schoolfree/reduced
completed
high schoolstandard none
some college
standard none
associate’s free/reduced
degree
none
bachelor’s degree
standard none
high schoolstandard completed
some high school
free/reduced
none
bachelor’s degree
free/reduced
completed
some college
standard none
master’s degree
free/reduced
none
high schoolfree/reduced
completed
some high school
standard none
some college
standard none
associate’s free/reduced
degree
completed
master’s degree
standard none
some high school
standard none
some college
standard none
some college
standard none
high schoolstandard completed
bachelor’s degree
standard none
bachelor’s degree
free/reduced
none
some college
standard none
associate’s standard
degree
none
associate’s standard
degree
none
some high school
free/reduced
none
some high school
standard none
high schoolfree/reduced
completed
high schoolfree/reduced
none
high schoolstandard completed
associate’s free/reduced
degree
none
master’s degree
standard completed
some college
standard none
54
73
50
81
38
47
70
80
57
77
72
62
46
68
62
74
63
69
71
68
65
69
79
48
48
76
51
68
66
90
36
56
42
51
70
89
83
43
77
62
42
61
62
57
48
88
71
72
68
74
64
57
84
53
58
65
95
68
65
69
43
47
81
70
73
78
65
70
71
58
65
94
44
63
60
63
64
59
86
56
58
55
52
88
82
74
54
81
56
50
57
61
75
63
88
67
78
67
74
68
52
74
48
48
66
93
58
69
67
40
44
74
75
63
68
61
69
62
56
70
94
44
59
58
53
65
59
98
56
64
48
57
83
74
68
56
77
62
45
56
61
75
60
88
64
81
67
male
female
male
female
female
male
male
male
female
male
male
male
female
female
female
female
female
male
male
male
female
female
female
male
male
male
female
female
female
female
female
female
female
male
female
male
male
female
female
male
male
male
male
male
male
female
male
male
female
group C
group B
group E
group C
group E
group D
group C
group E
group B
group D
group B
group C
group C
group D
group D
group C
group B
group B
group B
group E
group D
group C
group A
group C
group D
group C
group D
group C
group C
group C
group D
group C
group C
group A
group C
group D
group C
group B
group E
group E
group C
group E
group D
group D
group C
group A
group C
group B
group C
some high school
free/reduced
completed
some college
free/reduced
none
associate’s standard
degree
none
associate’s free/reduced
degree
none
bachelor’s degree
standard none
associate’s free/reduced
degree
completed
bachelor’s degree
free/reduced
completed
some high school
standard completed
some college
standard none
some college
standard completed
associate’s standard
degree
completed
some college
standard none
high schoolstandard completed
some college
standard none
high schoolfree/reduced
completed
high schoolstandard none
master’s degree
free/reduced
completed
some college
standard none
associate’s standard
degree
none
bachelor’s degree
standard none
some college
standard none
associate’s standard
degree
none
associate’s standard
degree
none
associate’s standard
degree
none
bachelor’s degree
free/reduced
completed
some high school
standard none
some college
free/reduced
none
master’s degree
standard completed
bachelor’s degree
free/reduced
none
high schoolstandard none
some high school
free/reduced
none
associate’s free/reduced
degree
completed
associate’s standard
degree
none
high schoolstandard completed
high schoolstandard none
bachelor’s degree
free/reduced
none
associate’s standard
degree
completed
some college
standard none
some college
standard none
bachelor’s degree
free/reduced
completed
high schoolfree/reduced
completed
some college
standard none
some college
standard completed
some college
free/reduced
none
some college
standard completed
high schoolstandard none
some high school
standard none
master’s degree
standard none
master’s degree
standard none
52
47
100
68
89
54
90
73
66
52
93
64
69
50
64
33
34
72
68
76
74
76
79
63
48
77
53
64
35
47
71
80
71
60
68
76
76
47
82
88
59
74
85
56
79
58
90
69
68
63
68
93
88
95
62
90
70
67
44
87
54
79
49
76
47
54
70
64
65
70
80
75
58
52
71
67
79
48
58
77
98
75
55
73
59
62
47
87
93
63
65
83
54
66
67
90
69
82
52
69
93
89
96
61
86
66
71
46
87
50
78
54
75
47
53
67
58
66
77
77
74
63
54
67
65
76
49
57
77
92
80
59
67
62
68
53
85
93
61
66
84
52
66
61
75
68
80
female
male
female
female
female
female
male
female
female
male
female
female
male
female
male
female
male
male
male
male
male
male
female
female
male
male
female
female
male
male
male
male
female
female
female
male
female
male
female
male
male
male
female
female
male
male
male
female
male
group C
group E
group C
group E
group D
group B
group E
group D
group B
group B
group D
group C
group C
group D
group C
group B
group C
group D
group B
group B
group D
group E
group D
group E
group C
group E
group C
group C
group E
group C
group C
group C
group D
group A
group B
group D
group C
group C
group C
group B
group B
group B
group B
group C
group E
group D
group C
group A
group E
master’s degree
standard none
associate’s standard
degree
none
bachelor’s degree
standard none
some high school
free/reduced
none
some college
standard none
some high school
free/reduced
none
associate’s free/reduced
degree
none
some college
free/reduced
none
some high school
standard none
some college
standard completed
some college
free/reduced
completed
associate’s free/reduced
degree
none
some college
free/reduced
none
some high school
free/reduced
none
bachelor’s degree
standard none
bachelor’s degree
standard completed
some high school
standard completed
associate’s standard
degree
completed
associate’s free/reduced
degree
none
high schoolfree/reduced
completed
some college
free/reduced
none
some college
free/reduced
none
some high school
standard none
some college
standard completed
associate’s standard
degree
none
some high school
standard completed
master’s degree
free/reduced
none
associate’s free/reduced
degree
none
associate’s standard
degree
completed
some college
standard completed
master’s degree
standard none
associate’s standard
degree
none
bachelor’s degree
standard none
master’s degree
free/reduced
none
bachelor’s degree
standard none
high schoolstandard none
some high school
free/reduced
none
bachelor’s degree
free/reduced
none
associate’s standard
degree
completed
high schoolstandard none
some high school
standard none
some college
standard none
some high school
standard completed
master’s degree
standard completed
some college
standard completed
bachelor’s degree
standard completed
master’s degree
standard none
master’s degree
free/reduced
none
some college
free/reduced
none
69
97
82
41
58
38
64
41
64
74
68
49
52
79
88
58
86
69
51
48
48
74
72
89
89
79
61
80
97
65
73
71
47
53
63
68
34
66
82
57
53
86
76
70
96
100
100
57
62
76
91
85
43
76
42
50
54
66
82
70
53
46
90
75
75
88
63
47
54
48
73
80
87
73
79
79
93
83
62
77
64
48
79
76
71
48
60
86
38
51
91
84
87
93
98
87
66
60
80
94
87
40
72
41
51
58
71
78
79
54
41
85
75
69
85
66
43
46
50
68
77
89
77
75
74
87
84
63
71
55
52
76
73
71
50
57
89
38
48
78
82
87
86
100
86
62
50
female
female
male
male
male
female
male
male
female
male
male
m
