Click here for the Excel Data File a. The variable x1 contains 3 categories: S, M, and L. Convert the category names into category scores (.e. S=1, M = 2, and L = 3). What is the average score for the variable x1? (Round your answer to two decimal places.) Average score of X b. Transform x2 Into an appropriate number of dummy variables. How many dummy variables should be created? Number of dummy variables to be created c. The variable x3 contains four categories: A, B, C, and D. Reduce the number of categories by combining the two least frequent categories into a new category E. How many observations are in the E category? Number of observations in the Ecategory MacBook Pro 3 4 5 6 - Yes Yes Yes Yes Yes Yes Yes No Yes No Yes Yes NO M S No Yes No Yes No No No Yes No Yes No Yes No M + L M L. Yes M 5 S L 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 45 47 M $ M 5 5 M M No No Yes No Yes No Yes No Yes Yes Yes NO Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Yes Yes NO No Yes NO Yes Yes Yes ves Yes No Yes Yes M L M Yes Yes Na Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Yes Yes No No Yes No Yes Yes Yes Yes Yes No Yes Yes NS Yes Yes Yes 5 1 5 $ 5 5 M M E 49 M Yes Yes Yes 50 51 52 53 54 SS SG 57 5 1 M 5 5 M M 5 5 Yes Yes NO No Yes Ne NO Yes No Yes 59 Exercise 2.53 + Ready G13 1 F E A C D TH Yes Yes Yes SSSSS Yes 5 Se Yes BE tie 25 26 62 M 1 Y 99 10 73 22 13 34 75 c 77 21 A c S Y D 5 A 12 GL . 181 10 > 131 BIB 167 STI Ecoce 203 Ready esc 64 B I c A A A B D B D + D C C D A D C A C B A A 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 c A A C A