d. How many missing values are there in x1, x2, x3, and x4? Answer is complete and correct. The number of missing values in x1 The number of missing values in x2 10 The number of missing values in X3 10 The number of missing values in x4 e. How many observations are there in each category in x4? x Answer is complete but not entirely correct. Category Observation 117 X 2 117 X 3 117 X14 0 832114 31 44 0.112325 117 47 0.574482 160 48 0.120134 16 21 61 0.589061 62 0.502735 61 0.785451 2 24 54 0.016723 156 64 0.790703 177 12 64 0.795401 164 67 0.441254 191 30 68 0.723153 59 0.856265 14 70 0.434219 31 71 6304873 159 72 0.705185 141 74 0.913847 143 74 0.108156 11 75 0.546046 17 27 76 0.641941 116 13 77 6.79815 16 10 78 0.243203 146 79 0.585795 129 40 0 323373 22 #1 0.541049 #2 0.426494 $3 0.74748 173 84 0.234671 140 #5 0.02469 197 16 0.487175 142 7 0.973727 136 #8 0.430533 84 14 0.435048 24 22 10 0.684179 72 28 $1 0.495244 42 0.736532 32 93 0.241645 169 94 0.179239 181 95 0.269454 79 30 45 0.701412 5 20 97 0.702371 153 4 48 0.258309 29 94 0 218014 71 100 0.425147 108 37 101 0.870412 155 21 102 0.795872 79 10 103 0.019072 17 15 104 0.621474 162 105 0.85185 105 0.244578 113 107 0.065947 134 33 108 0.107952 189 17 109 0.558149 79 34 110 0.652779 154 20 111 0.350971 178 14 112 0.719585 50 113 0.74039 10 114 0.226235 39 115 0.23391 63 116 0.173195 3a 117 0.37753 150 118 0.121562 167Exercise 1-21 Algo The accompanying data set contains three numerical variables, x1, x2, and x3, and one categorical variable x4. Click here for the Excel Data File a. How many observations have x4 values that are less than 3? Answer is complete and correct. Number of 85 observations b. Sort the data by x1 in ascending order. What are the x1, x2, x3, and x4 values of the first observation after the data are sorted? (For x1, round your answer to four decimal places.) x Answer is complete but not entirely correct. Value of X1 0. 1982 X Value of X2 78 X Value of X3 23 X Value of X4 3c. Sort the data by x1 in descending order. What are the x1, x2, x3, and x4 values of the first observation after the data are sorted? (For x1, round your answer to four decimal places.) x Answer is not complete. Value of x1 0.1900 X Value of X2 196 Value of X3 13 Value of X4 d. How many missing values are there in x1, x2, x3, and x4? Answer is complete and correct. The number of missing values in x1 10 The number of missing values in x2 The number of missing values in x3 The number of missing values in x4Observation 2 0.1982039 78 3 0.8693283 93 4 0.7494513 59 5 0.1773415 5 0.0121473 7 0.4720218 8 0.3243588 30 9 0.66549 91 10 0.841065 12 11 0.586955 165 12 0.6351973 24 13 0.6511778 13 14 0.9110205 153 15 0.7383863 54 16 0.299453 46 17 0.0156395 21 18 0.716167 78 19 0.8618273 19 20 0.6037751 21 0.5345915 6 22 0.6555908 188 23 0.7453034 121 24 0.4142949 175 25 0.4030056 45 26 0.2903283 17 27 0.2574654 117 28 0.4099033 119 29 0.52604 153 30 0.0860825 104 31 0.6031675 197 32 0.4011186 120 33 0.3664335 53 34 0.5772811 140 35 0.6260033 91 36 0.8612812 172 37 0.4176901 49 38 0.8321405 50 39 0.1345976 93 12 40 0.4090936 125 16 41 0.3765113 181 42 0.3896237 48 43 0.3687329 198 44 0.481509 196 0.997994 196 46 0.250957 51 47 0.581108 97 313 48 0.1466676 94 23 49 0.5140172 30 0.4359607 51 0.821136 $2 0.3891135 0.626565 SA 0.8223349