The accompanying data set contains five variables, x1, x2, x3, x4, and x5. Click here for...

    

Transcribed Image Text:

The accompanying data set contains five variables, x1, x2, x3, x4, and x5. 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 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 observations 1 x1 21 30 40 51 60 71 81 90 10 0 11 0 12 1 13 0 14 0 15 0 16 0 17 0 18 1 19 0 20 1 21 0 22 0 23 0 24 0 25 0 26 0 27 0 28 1 A 29 0 30 0 31 1 32 0 33 1 34 0 35 0 36 0 37 1 38 0 39 0 40 0 41 0 42 0 B x2 Own Rent Rent Own Rent Own Own Rent Rent Rent Own Rent Rent Rent Rent Rent Own Rent Own Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Own Rent Own Rent x3 189 120 204 151 191 140 187 128 119 148 140 Rent Rent Own Rent Rent Rent Rent Rent С 128 108 155 166 213 156 118 158 141 162 117 134 177 117 175 139 166 120 167 142 130 131 160 98 140 166 167 146 143 150 Exercise 1.23 x4 328268S 33 28 24 17 20 15 37 23 23 22 26 39 14 20 24 37 10 17 19 25954A 36 16 14 17 16 15 59222~~~~473=3 19 26 14 D 26 31 38 6 + E 15 0.054587 0.009077 0.93814 0.020797 0.008174 0.143977 0.192234 0.01414 0.010242 0.004495 0.000147 0.057231 0.015253 0.022706 0.969233 0.007268 0.00713 0.464121 0.002375 0.008515 0.021796 0.160323 0.004233 0.003056 0.683372 0.00267 0.01753 0.867974 0.36321 0.468196 0.029088 0.089045 0.003414 0.005908 0.005501 0.072848 0.001544 0.004931 0.111923 0.031036 0.028299 F H12 42 0 43 0 44 0 45 0 46 0 47 0 48 0 49 0 50 0 51 0 52 0 53 1 54 0 55 0 56 0 570 58 0 59 0 60 0 61 0 62 0 63 0 64 1 65 0 66 0 67 0 68 1 69 0 70 0 71 1 72 73 0 74 0 75 0 76 0 77 0 78 0 79 800 81 0 82 0 83 0 A x ✓ fx C 150 132 101 135 112 94 B Rent Rent Rent Rent Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Bent Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Rent Own Rent Rent Own Own Rent Rent Rent Rent Rent Rent Own Rent Rent Rent Rent 155 140 171 157 166 123 138 99 201 95 153 158 144 132 140 156 150 148 192 201 170 119 114 154 124 130 133 189 178 160 157 163 159 -X55876838883222-SEA-BENAR-28382EC. 24 20 41 12 11 18 21 14 18 16 12 19 14 11 19 30 20 14 24 128 163 160 12 Exercise 1.23 + 13 D E 0.028299 0.050226 0.016332 0.003604 0.019936 0.00407 0.525924 0.094554 0.015012 0.108886 0.193048 0.00063 0.394119 0.002161 0.000957 0.212033 0.001528 0.991581 0.003358 0.027852 0.002714 0.043913 0.245807 0.027565 0.023534 0.023674 0.428712 0.000883 0.002865 0.069552 0.047958 0.036604 0.000117 0.038614 0.680381 0.007326 0.003768 0.045316 0.562921 0.002629 0.272405 0417452 H12 82 U 83 0 84 0 85 0 86 0 87 0 88 0 89 0 90 0 91 0 92 1 93 0 94 0 95 0 96 0 97 0 98 0 99 0 100 1 101 1 102 A x ✓ fx C B Kent Rent Rent Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Rent Rent Rent Rent Rent Own Own 163 160 140 159 128 169 137 139 125 126 151 172 138 124 191 147 128 154 126 136 8 7 20 28 14 19 18 28 22 38 38 23 30 30 83 37 10 13 14 5 23 D E U.272405 0.417452 0.001083 0.546549 0.00047 0.005424 0.000896 0.001067 0.024991 0.000346 8.81E-05 0.159971 0.003076 0.001804 0.314209 0.666483 0.000385 0.036317 0.000457 0.827123 F The accompanying data set contains five variables, x1, x2, x3, x4, and x5. 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 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 observations 1 x1 21 30 40 51 60 71 81 90 10 0 11 0 12 1 13 0 14 0 15 0 16 0 17 0 18 1 19 0 20 1 21 0 22 0 23 0 24 0 25 0 26 0 27 0 28 1 A 29 0 30 0 31 1 32 0 33 1 34 0 35 0 36 0 37 1 38 0 39 0 40 0 41 0 42 0 B x2 Own Rent Rent Own Rent Own Own Rent Rent Rent Own Rent Rent Rent Rent Rent Own Rent Own Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Own Rent Own Rent x3 189 120 204 151 191 140 187 128 119 148 140 Rent Rent Own Rent Rent Rent Rent Rent С 128 108 155 166 213 156 118 158 141 162 117 134 177 117 175 139 166 120 167 142 130 131 160 98 140 166 167 146 143 150 Exercise 1.23 x4 328268S 33 28 24 17 20 15 37 23 23 22 26 39 14 20 24 37 10 17 19 25954A 36 16 14 17 16 15 59222~~~~473=3 19 26 14 D 26 31 38 6 + E 15 0.054587 0.009077 0.93814 0.020797 0.008174 0.143977 0.192234 0.01414 0.010242 0.004495 0.000147 0.057231 0.015253 0.022706 0.969233 0.007268 0.00713 0.464121 0.002375 0.008515 0.021796 0.160323 0.004233 0.003056 0.683372 0.00267 0.01753 0.867974 0.36321 0.468196 0.029088 0.089045 0.003414 0.005908 0.005501 0.072848 0.001544 0.004931 0.111923 0.031036 0.028299 F H12 42 0 43 0 44 0 45 0 46 0 47 0 48 0 49 0 50 0 51 0 52 0 53 1 54 0 55 0 56 0 570 58 0 59 0 60 0 61 0 62 0 63 0 64 1 65 0 66 0 67 0 68 1 69 0 70 0 71 1 72 73 0 74 0 75 0 76 0 77 0 78 0 79 800 81 0 82 0 83 0 A x ✓ fx C 150 132 101 135 112 94 B Rent Rent Rent Rent Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Bent Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Rent Own Rent Rent Own Own Rent Rent Rent Rent Rent Rent Own Rent Rent Rent Rent 155 140 171 157 166 123 138 99 201 95 153 158 144 132 140 156 150 148 192 201 170 119 114 154 124 130 133 189 178 160 157 163 159 -X55876838883222-SEA-BENAR-28382EC. 24 20 41 12 11 18 21 14 18 16 12 19 14 11 19 30 20 14 24 128 163 160 12 Exercise 1.23 + 13 D E 0.028299 0.050226 0.016332 0.003604 0.019936 0.00407 0.525924 0.094554 0.015012 0.108886 0.193048 0.00063 0.394119 0.002161 0.000957 0.212033 0.001528 0.991581 0.003358 0.027852 0.002714 0.043913 0.245807 0.027565 0.023534 0.023674 0.428712 0.000883 0.002865 0.069552 0.047958 0.036604 0.000117 0.038614 0.680381 0.007326 0.003768 0.045316 0.562921 0.002629 0.272405 0417452 H12 82 U 83 0 84 0 85 0 86 0 87 0 88 0 89 0 90 0 91 0 92 1 93 0 94 0 95 0 96 0 97 0 98 0 99 0 100 1 101 1 102 A x ✓ fx C B Kent Rent Rent Rent Rent Rent Rent Rent Rent Rent Own Rent Rent Rent Rent Rent Rent Rent Own Own 163 160 140 159 128 169 137 139 125 126 151 172 138 124 191 147 128 154 126 136 8 7 20 28 14 19 18 28 22 38 38 23 30 30 83 37 10 13 14 5 23 D E U.272405 0.417452 0.001083 0.546549 0.00047 0.005424 0.000896 0.001067 0.024991 0.000346 8.81E-05 0.159971 0.003076 0.001804 0.314209 0.666483 0.000385 0.036317 0.000457 0.827123 F

Answer rating: 100% (QA)

Answer a There are three variables in the subset of the data set X2 X3 and X4 There ... View the full answer