N R U 0 P Q S T M D E F G H I K L A B C Own 104 29 0.562921 Own 213 27 0.002629 Rent 114 34 0.272405 Own 92 13 0.417452 Own 170 8 0.001083 Rent 104 8 0.546549 Rent 137 6 0.00047 Rent 215 58 0.005424 Rent 191 27 0.000896 Rent 111 49 0.001067 Own 164 24 0.024991 Rent 119 60 0.000346 Own 129 51 8.81E-05 Own 114 51 0.159971 Rent 217 13 0.003076 Own 120 31 0.001804 Rent 200 6 0.314209 97 Rent 209 16 0.666483 98 0 Rent 204 7 0.000385 99 Rent 114 52 0.036317 100 Rent 128 10 0.000457 101 Own 155 10 0.827123 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 ScreenshotCheck my work Exercise 1-23 Algo 20 The accompanying data set contains five variables, x1, x2, x3, x4, and x5. points 2 Skipped Click here for the Excel Data File a. Subset the data set to include only x2, x3, and x4. How many missing values are there in these three variables? Number of missing values eBook Print References b. Remove all observations that have "Own" as the value for x2. Then remove all observations that have values lower than 150 for x3. How many observations remain in the data set? Number of observationsx2 x3 x4 x5 Own 172 2 0.054587 Rent 183 3 0.009077 Own 172 60 0.93814 Rent 148 7 0.020797 Own 194 0.008174 Own 209 28 0.143977 Rent 110 53 0.192234 Own 113 33 0.01414 Own 162 21 0.010242 Rent 164 15 0.004495 Own 170 57 0.000147 Rent 156 27 0.057231 Rent 113 33 0.015253 Rent 219 22 0.022706 Rent 173 26 0.969233 Own 152 38 0.007268 Own 168 35 0.00713 ent 108 46 0.464121 Own 164 36 0.002375 Own 138 58 0.008515 Rent 218 59 0.021796 Own 210 53 0.160323 Own 211 49 0.004233 Own 189 19 0.003056 Own 169 36 0.683372 Own 211 46 0.00267 Own 120 50 0.01753 Own 171 43 0.867974 Own 212 51 0.36321 Rent 166 9 0.468196 Own 112 5 0.029088 Rent 97 29 0.089045 Rent 162 44 0.003414 Rent 183 40 0.005908 Rent 200 19 0.005501 Rent 146 55 0.072848 Rent 179 4 0.001544 Rent 187 51 0.004931 Own 92 50 0.111923 Own 97 51 0.031036 Rent 209 3 0.028299 Rent 140 51 0.050226 Own 211 53 0.016332 Rent 145 38 0.003604 Rent 184 54 0.019936 Own 126 10 0.00407 Own 198 20 0.525924 Own 149 13 0.094654 Own 127 14 0.015012 Own 188 11 0. 108886 Screenshot Exercise 1K N S I L M 0 P Q R T U B C D E F G H Own 149 13 0.094654 Own 127 14 0.015012 Own 188 11 0. 108886 Own 218 54 0.193048 Own 194 43 0.00063 Rent 188 52 0.394119 Own 176 12 0.002161 Own 127 45 0.000957 Own 204 33 0.212033 Own 206 59 0.001528 Own 112 34 0.991581 Own 179 47 0.003358 Rent 166 28 0.027852 Own 161 48 0.002714 Rent 120 26 0.043913 Own 163 21 0.245807 Rent 133 33 0.027565 Own 120 48 0.023534 Rent 134 19 0.023674 Own 91 51 0.428712 Own 97 39 0.000883 Own 153 40 0.002865 Own 163 22 0.069552 Rent 35 0.047958 Own 33 0.036604 Own 44 0.000117 Rent 163 59 0.038614 Rent 184 35 0.680381 Rent 168 59 0.007326 Own 14 0.003768 Rent 161 16 0.048316 Own 104 29 0.562921 Own 213 27 0.002629 Rent 114 34 0.272405 Own 92 13 0.417452 Own 170 0.001083 Rent 104 0.546549 Rent 137 6 0.00047 Rent 215 58 0.005424 Rent 191 27 0.000896 Rent 111 49 0.001067 Own 164 24 0.024991 Rent 119 60 0.000346 Own 129 51 8.81E-05 Own 114 51 0.159971 Rent 217 13 0.003076 Own 120 31 0.001804 Rent 200 6 0.314209 Rent 209 16 0.666483 Rent 204 0.000385 Screenshot