1.How many elements are in the provided data set?
2.How many are the variables?
3.How many variables are qualitative – categorical?
4.How many variables are quantitative – discrete?
5.How many variables are quantitative – continuous?
What is the data set about?
1.Sorting: Sort the data set according to ID sequence, from smallest to biggest. Following the sorted unique ID number from smallest to biggest, what is the complete data for 100th observation?
2.Filtering: By filtering the ”race” variable, identify the number of a) White students, b) Hispanic, c)African-American and d) Asians; What is the ratio/percentage of Asians to the total population given the data set?
- Conditional Formatting: Using conditional formatting, use Data Bars on each variable grade across all elements assigning the following colors: Reading = Blue
Writing = Green
Math = Red
Science = Yellow
Social Studies = Purple
Highlight all Math_high results, and add a rule to highlight cells in “Green Fill with Dark Green Text” for all data Greater than “60”. By Filtering the cells highlighted with “Green Fill” for the variable “Math_high”, count how many students got a math score greater than 60?
- Use Conditional Formatting to highlight all “low” Social Economic Status (SES) into Light Red Fill with Dark Red Text.
Extracted text: 65 female white middle public academic 55 54 66 42 56 101 female white high public academic 60 62 67 50 56 89 female white low public vocation 35 35 40 51 33 54 female african-am low private general 47 54 46 50 56 180 female white high private academic 71 65 69 58 71 162 female white middle public vocation 57 52 40 61 56 public public 4 female hispanic low academic 44 50 41 39 51 131 female white high academic 65 59 57 46 66 white public private 125 female low academic 68 65 58 59 56 high middle 34 female hispanic academic 73 61 57 5 66 public public 106 female white vocation 36 44 37 42 41 high high 130 female white general 43 54 55 55 46 93 female white public academic 73 67 62 58 66 163 female white low public academic 52 57 64 58 56 37 female african-am low public vocation 41 47 40 39 51 35 female hispanic white low private general 60 54 50 50 51 87 female middle general academic public 50 52 46 50 56 73 female white middle public 50 52 53 39 56 151 female white middle public vocation 47 46 52 48 46 public public public 44 female african-am low vocation 47 62 45 34 46 152 female 105 female academic academic white high 55 57 56 58 61 white middle 50 41 45 44 56 28 female asian middle public general 39 53 54 50 41 91 female white high african-am low public vocation 50 49 56 47 46 45 female public vocation 34 35 41 29 26 116 female white middle public academic 57 59 54 50 56 33 female asian low public academic 57 65 72 54 56 50 66 female 72 female 77 female white middle public vocation 68 62 56 51 white middle public public vocation 42 54 47 47 46 white low academic 61 59 49 44 66 61 female white high public academic 76 63 60 67 66 190 female white middle private academic 47 59 54 58 46 42 female 2 female 55 female african-am middle public vocation 46 52 55 44 56 hispanic middle public private vocation 39 41 33 42 41 african-am middle academic 52 49 49 44 61 public public 19 female hispanic low general 28 46 43 44 51 90 female 142 female white high academic 42 54 50 50 52 public public white middle vocation 47 42 52 39 51 17 female hispanic middle academic 47 57 48 44 41 122 female 191 female 83 female white middle public academic 52 59 58 53 66 white white high private academic 47 52 43 48 61 middle public vocation 50 62 41 55 31 182 female white middle private academic 44 52 43 44 51 6 female public public public hispanic low academic 46 40 41 46 female african-am low academic 45 55 44 34 41 african-am low high middle 43 female academic 47 37 43 42 46 96 female white public public academic 65 54 61 58 56 138 female white vocation 43 57 40 50 51 10 female 71 female hispanic white public public middle general 47 54 49 53 61 middle general 57 62 56 58 66 139 female white middle public academic 68 59 61 55 71 110 female white middle public vocation 52 55 50 54 61 148 female white middle public vocation 42 57 51 47 61 109 female white middle public public public general 42 39 42 42 41 39 female african-am high academic 66 67 67 61 66 147 female white low academic 47 62 53 53 61 74 female white middle public academic 57 50 50 51 58 198 female white high private academic 47 61 51 63 31 161 female white low public academic 57 62 72 61 61 112 female white middle public academic 52 59 48 55 61 69 female white low public vocation 44 44 40 40 31 156 female white middle public public academic 50 59 53 61 61 111 female white low general 39 54 39 47 36 186 female white middle private academic 57 62 63 55 41 98 female white low public vocation 57 60 51 53 37 119 female 13 female public public white low general 42 57 45 50 43 hispanic african-am high middle vocation 47 46 39 47 61 general academic 51 female public 42 36 42 31 39 26 female asian high public 60 59 62 61 51 public public public public public 36 female african-am low general 44 49 44 35 51 135 female white low academic 63 60 65 54 66 59 female white middle academic 65 67 63 55 71 78 female white middle academic 39 54 54 53 41 64 female white vocation 36 high low 50 52 45 58 63 female white public general 52 65 60 56 51 79 female white middle academic public 60 62 49 50 51 193 female white middle private academic 44 49 48 39 51 92 female white high public public public public general 52 67 57 63 61 160 female white middle academic 55 65 55 50 61 asian high low 32 female vocation 50 67 66 66 56 23 female asian academic 65 65 64 58 71 158 female white middle public general 52 54 55 53 51 25 female asian middle public general 47 44 42 42 36 188 female white high private academic 63 62 56 55 61 52 female african-am low public academic 50 46 53 53 66 124 female white low public vocation 42 54 41 42 41 175 female white private eral 36 57 42 50 41 ge vocation 184 female 30 female middle private public white 50 52 53 55 56 asian high academic 41 59 42 34 51 179 female white middle private academic 47 65 60 50 56 31 female asian middle 56 private public general 55 59 52 42 145 female white middle vocation 42 46 38 36 46 187 female white middle private general 57 41 57 55 52 118 female white middle public general 55 62 58 58 61 137 female white high public academic 63 65 65 53 61
Extracted text: id gender schooltype program read_high write_colle math_highscience_co socst_college race ses 70 male white low general vocation public 57 52 47 57 public public public 121 female white middle 68 59 53 63 61 86 male white high general 44 33 54 58 31 141 male white high vocation 63 44 47 53 56 172 male white middle public academic 47 52 57 53 61 113 male white middle public academic 44 52 51 63 61 50 male african-am middle public 59 53 general 50 61 11 male hispanic middle public academic 34 46 45 39 36 84 male 48 male white middle public general 63 57 54 58 51 african-am middle public academic 57 55 52 50 51 75 male white middle public vocation 60 46 51 53 61 public public public 60 male white middle academic 57 65 51 63 61 95 male high high african-am low white academic 73 60 71 61 71 104 male 38 male white academic academic 54 63 57 55 46 public 45 57 50 31 56 115 male white low public general 42 49 43 50 56 76 male white high public academic 47 52 51 50 56 195 male white middle private general 57 57 60 58 56 114 male white high public academic general 68 65 62 55 61 85 male white middle public 55 39 57 53 46 167 male white middle public general 63 49 35 66 41 143 male 75 vocation academic white middle public 63 63 72 66 41 male african-am middle public 50 40 45 55 56 20 male hispanic hispanic high public academic 60 52 57 61 61 12 male middle public public vocation 37 44 45 39 46 53 male african-am middle vocation 34 37 46 39 31 high middle 154 male white public academic 65 65 66 61 66 private private public public 178 male white vocation 47 57 57 58 46 196 male white high academic 44 38 39 46 29 male asian low general 52 44 49 55 41 middle high high 126 male white general 42 31 57 47 51 103 male white public academic 76 52 64 64 61 192 male white private academic 65 67 63 66 71 150 male 199 male white middle public vocation 42 41 57 72 31 white private academic 52 59 50 61 public private 144 male white high general academic 60 65 58 61 66 200 male white middle 68 54 75 66 66 80 male 16 male high low white public academic 65 66 66 public public private private hispanic white vocation 47 31 44 36 36 153 male 176 male middle vocation 39 31 40 39 51 white middle academic 47 47 41 42 51 177 male white middle academic 55 59 62 58 51 168 male white middle public academic 52 55 51 40 male african-am low public general 42 41 43 50 41 white 62 male 169 male high public general 65 65 48 63 66 white low public general 55 59 63 69 46 49 male african-am high public public vocation 50 40 39 49 47 136 male white middle academic 65 59 70 63 51 academic academic 189 male white middle private public public public 47 59 63 53 46 7 male hispanic middle 57 54 59 47 51 27 male asian middle academic 53 61 61 57 56 128 male white high academic 39 33 38 47 41 21 male hispanic public private middle generaT 44 44 61 50 46 183 male white middle academic 63 59 49 55 71 132 male white middle public public public academic 73 62 73 69 66 15 male hispanic high vocation 39 39 44 26 42 67 male white low vocation 42 37 37 33 32 public private 22 male hispanic middle vocation 42 39 39 56 46 185 male white middle academic 63 57 55 58 41 9 male public private hispanic middle vocation 48 49 52 44 51 181 male white middle academic 50 46 45 58 61 170 male white high public academic 47 62 61 69 66 public public 134 male white low general 44 44 39 34 46 108 male white middle general 34 33 41 36 36 private public public 197 male white high academic 50 42 50 36 61 140 male white middle middle vocation 44 41 40 50 26 171 male white academic 60 54 60 55 66 107 male white low public vocation 47 39 47 42 26 81 male white public public low academic 63 43 59 65 44 18 male vocation 50 hispanic white middle 33 49 44 36 155 male 97 male middle public general 44 44 46 39 51 white high public academic 60 54 58 58 61 68 male white middle public academic 73 67 71 63 66 157 male white middle public public public general vocation 68 59 58 74 66 56 male 5 male white middle 55 45 46 58 51 hispanic white low academic 47 40 43 45 31 159 male high public academic 55 61 54 49 61 123 male white high public general 68 59 56 63 66 164 male white middle public vocation 31 36 46 39 46 public public public 14 male hispanic high high academic 47 41 54 42 56 127 male white academic 63 59 57 55 56 165 male white low vocation 36 49 54 61 36 white private public 174 male middle academic 68 59 71 66 56 3 male hispanic low academic 63 65 48 63 56 public public public 58 male white middle vocation 55 41 40 44 41 146 male white high academic 62 64 63 66 102 male high high middle white academic 52 41 51 53 56 117 male white public vocation 34 49 39 42 56 white 133 male 94 male public vocation 50 31 40 34 31 white high middle public public public public academic 55 49 61 61 56 academic general asian 24 male 149 male 52 62 66 47 46 white low 63 49 49 66 46 82 female 8 female 129 female white high academic 68 62 65 69 61 hispanic low public academic 39 44 52 44 48 white low public general 44 44 46 47 51 173 female white low general academic public 50 62 61 63 51 57 female middle high white public 71 65 72 66 56 100 female 1 female white public academic 63 65 71 69 71 public private hispanic low vocation 34 44 40 39 41 194 female white high academic 63 63 69 61 61 88 female high high public public public white academic 68 60 64 69 66 99 female white general 47 59 56 66 61 47 female african-am low academic 47 46 49 33 41 120 female white high middle public academic 63 52 54 50 51 166 femnale white public academic 52 59 53 61 51