10 Score: 0 of 1 pt 5 of 6 (3 complete) 3.1-2.23-T Consider the retirement funds data linked below. Using the three-year return percentage variable, complete parts (a) through (c) below. Click the icon to view the data. a. Construct a table that computes the mean for each type, market cap, and risk. Risk Type Market Cap Low Average High Growth Small Growth Mid-Cap Growth Large (Round to four decimal places as needed.) B F G 3 YrReturn% 62.5 55.55 54.91 38.43 33.79 33.2 32.43 29.45 27.69 26.27 27.4 25.75 1 Market_Cap Type Risk 2 Large Growth High 3 Large Growth High 4 Large Growth High 5 Large Growth Average 6 Large Growth Average 7 Large Growth Low 8 Large Growth High 9 Large Growth Average 10 Large Growth Average 11 Large Growth Average 12 Large Growth Average 13 Large Growth Average 14 Large Growth Average 15 Large Growth Average 16 Large Growth Average 17 Large Growth Average 18 Large Growth Average 19 Large Growth Average 20 Large Growth Low 21 Large Growth High 22 Large Growth Average 23 Large Growth Average 24 Large Growth Average 25 Large Growth Low 26 Large Growth Low 27 Large Growth Average 28 Large Growth Average 29 Large Growth Average 30 Large Growth Average 31 Large Growth Low 32 Large Growth High 33 Large Growth Averare 34 Large Growth Average 35 Large Growth Low 36 Large Growth Low 37 Large Growth Average 38 Large Growth Average 24.77 24.23 25.5 25.41 23.7 23.51 23.18 23.36 23.79 22.9 24.41 23.42 24.07 22.45 23.28 22.92 22.89 22.91 21.19 22.11 22.22 22.55 20.72 21.58 21.08 + A D F 1 3YrReturn% Market_Cap 38 Large 39 Large 40 Large 41 Large 42 Large 43 Large 44 Large 45 Large 46 Large 47 Large 48 Large 49 Large 50 Large 51 Large 52 Large 53 Large 54 Large 55 Large 56 Large 57 Large 58 Large 59 Large B Type Risk Growth Average Growth Low Growth Low Growth High Growth Low Growth Low Growth Average Growth Average Growth Low Growth Average Growth Low Growth Low Growth Average Growth Low Growth Average Growth Average Growth Low Growth Average Growth Low Growth Average Growth Average Growth Low Growth Low Growth High Growth Low Growth Average Growth Average Growth Low Growth Low Growth Low Growth Growth Low Growth Low Growth Low Growth Average Growth Averare Growth 21.08 21.84 21.9 21.65 19.87 21.59 20.25 20.92 21.36 21.39 20.62 20.25 19.21 19.16 18.7 18.51 19.41 18.79 19.46 19.43 19.37 19.67 19.48 17.64 18.44 18.3 18.03 17.45 18.58 17.43 18.16 17.61 18.31 18.02 16.81 16.61 16.67 60 Large 61 Large 62 Large 63 Large 64 Large 65 Large 66 Lares 67 Large 68 Large 69 Large 70 Large 71 Large 72 Large 73 La 74 Large Average Average B C D E F Market_Cap 5 Large 6 Large 7 Large 8 Large #9 Large 30 Large B1 Large 82 Large 83 Large 84 Large 85 Large 86 Large 87 Large 88 Large 89 Large 90 Large 91 Large 92 Large 93 Large 94 Large 95 Large 96 Large 97 Large 98 Large 99 Large 100 Large 101 Large 102 Large 103 Large 104 Large 105 Large 106 Large 107 Large 108 Large 109 Large 110 Large 111 Large 112 Type Risk Growth Average Growth Average Growth Average Growth Average Growth Average Growth Low Growth Low Growth Low Growth Low Growth Low Growth Low Growth Low Growth Average Growth Low Growth Low Growth Low Growth Low Growth Low Growth Low Growth Average Growth Low Growth Low Growth Low Growth Growth Average Growth Low Growth Low Growth Low Growth LOW Growth Low Value Average Value Average Value Low Value Low Value Low Value Average Value Average 3YrReturn% 17.96 16.37 17.03 16.35 16.41 17.31 15.79 15.77 16.82 16.81 15.84 15.57 15.75 14.96 15.94 15.01 16.32 14.27 15.4 14.68 13.71 14.35 14.81 14.78 12.8 13.05 12.78 11.21 11.27 10.46 31.37 26.42 22.76 22.18 21.35 21.55 21.18 1912 LOW + B C D E F G 1 Risk Market_Cap Type 111 Large Value Average 112 Large Value Low 113 Large Value Low 114 Large Value Average 115 Large Value Low 116 Large Value Average 117 Large Value Average 118 Large Value Average 119 Large Value Average 120 Large Value Low 121 Large Value Average 122 Large Value Low 123 Large Value Average 124 Large Value Average 125 Large Value Average 126 Large Value Low 127 Large Value Low 128 Large Value Low 129 Large Value Low 130 Large Value Low 131 Large Value Average 132 Large Value Average 133 Large Value Average 134 Large Value Low 135 Large Value Low 136 Large Value Average 137 Large Value Average 138 Lares Value Low 139 Lares Value Average 140 Large Value Low 141 Large Value Low 142 Large Value Average 143 Large Value Average 144 Large Value Low 145 Large Value Low 146 Large Value 147 Large Value Low 1ARIM Value + Ready 3 YrReturn% 21.18 19.12 19.77 19.36 19.25 18.69 18.54 17.6 17.58 17.16 17.07 18.28 18.6 17.21 17.55 17.42 17.66 17.82 16.38 17.18 17.04 16.9 15.9 16.39 16.78 15.25 15.56 16 15.67 15.18 14.77 15.47 15.89 16.03 14.96 15.24 14.74 15.45 B D E F G 3YrReturn% A 1 Market_Cap Type Risk 149 Large Value Average 150 Large Value Low 151 Large Value Average 152 Large Value Average 153 Large Value Low 154 Large Value Low 155 Large Value Low 156 Large Value Low 157 Large Value Low 158 Large Value Low 159 Large Value Low 160 Mid-Cap Growth High 161 Mid-Cap Growth High 162 Mid-Cap Growth Average 163 Mid-Cap Growth High 164 Mid-Cap Growth Average 165 Mid-Cap Growth Average 166 Mid-Cap Growth Average 167 Mid-Cap Growth Average 168 Mid-Cap Growth Average 169 Mid-Cap Growth Average 170 Mid-Cap Growth High 171 Mid-Cap Growth Average 172 Mid-Cap Growth 173 Mid-Cap Growth High 174 Mid-Cap Growth Average 175 Mid-Cap Growth Average 176 Mid-Cap Growth Average 177 Mid-Cap Growth Average 178 Mid-Cap Growth Average 179 Mid Cap Growth Average 180 Mid-Cap Growth 181 Mid-Cap Growth Average 182 Mid-Cap Growth 183 Mid-Cap Growth 184 Mid-Cap Growth 185 Mid-Cap Growth Low 14.5 14.36 14.78 13.7 14.7 13.82 12.4 12.45 11.22 11.48 10.19 34.59 32.76 30.49 29.98 29.23 29.33 29.29 27.77 27.14 26.55 26.01 26.44 25.63 26.89 26.31 25.46 26.2 25.59 24.25 23,84 24.69 24.82 25.2 24.44 24.44 24.16 High Average Average Averse Average D E F G 3YrReturn% 1 A B Market_Cap Type Risk 86 Mid-Cap Growth Average 87 Mid-Cap Growth Average 188 Mid-Cap Growth Average 189 Mid-Cap Growth Low 190 Mid-Cap Growth Average 191 Mid-Cap Growth Low 192 Mid-Cap Growth High 193 Mid-Cap Growth Average 194 Mid-Cap Growth Average 195 Mid-Cap Growth Average 196 Mid-Cap Growth High 197 Mid-Cap Growth Average 198 Mid-Cap Growth High 199 Mid-Cap Growth Average 200 Mid-Cap Growth Average 201 Mid-Cap Growth Low 202 Mid-Cap Growth Average 203 Mid-Cap Growth Low 204 Mid-Cap Growth Low 205 Mid-Cap Growth Average 206 Mid-Cap Growth Average 207 Mid-Cap Growth Average 208 Mid-Cap Growth Low 209 Mid-Cap Growth 210 Mid-Cap Growth Average 211 Mid-Cap Growth Average 212 Mid-Cap Growth Average 213 Mid-Cap Growth Average 214 Mid Cap Growth Average 215 Mid-Cap Growth Average 216 Mid-Cap Growth High 217 Mid-Cap Growth Low 218 Mid-Cap Growth Low 219 Mid-Cap Growth Average 220 Mid-Cap Growth Average 221 Mid-Cap Growth Averans 222 Mid-Cap Growth Low 25.09 24.22 24.49 23.26 24.29 23.73 24.59 23.56 22.58 23.22 23.34 22.07 22.64 21.95 22.97 22.09 22.16 22.73 22.11 22.06 21.43 21.16 21.89 19.45 20.64 20.2 19.31 18.86 19.86 19.13 20.08 17.69 16.17 15.46 16.2 15.02 11.76 Low + Ready A B D m F 1 Market_Cap 222 Mid-Cap 223 Mid-Cap 224 Mid-Cap 225 Mid-Cap 226 Mid-Cap 227 Mid-Cap 228 Mid-Cap 229 Mid-Cap 230 Mid-Cap 231 Mid-Cap 232 Mid-Cap 233 Mid-Cap 234 Mid-Cap 235 Mid-Cap 236 Mid-Cap 237 Mid-Cap 238 Mid-Cap 239 Mid-Cap 240 Mid-Cap 241 Mid-Cap 242 Mid-Cap 243 Mid-Cap 244 Mid-Cap 245 Small 246 Small 247 Small 248 Small 249 Small 250 Small 251 Small 252 Small 253 Small 254 Small 255 Small 256 Small 257 Small 258 Small Type Risk Growth LOW Growth Low Growth Average Growth Average Value High Value High Value High Value High Value High Value High Value Low Value Average Value High Value Average Value Low Value Average Value Average Value Low Value Low Value High Value Low Value High Value Average Growth Growth High Growth Average Growth Growth Average Growth Average Growth High Growth Low Growth Growth Growth Growth Growth High Growth 3YrReturn% 11.76 9.32 7.38 3.92 34.38 30.39 29.99 24.37 25.24 25.69 24.65 23.66 22.89 23.36 22.63 21.43 20.78 21.34 20.47 21.02 20.31 19.98 19.28 35.8 33.42 30.89 31.22 32.01 31.65 30.55 29.43 30.69 29.78 28.64 28.21 26.76 26.09 70 70 High High Averare Average Average + Ready 1 Market_Cap Type Risk 259 Small Growth High 260 Small Growth Average 261 Small Growth Average 262 Small Growth High 263 Small Growth High 264 Small Growth Low 265 Small Growth Average 266 Small Growth High 267 Small Growth Average 268 Small Growth High 269 Small Growth High 270 Small Growth High 271 Small Growth High 272 Small Growth High 273 Small Growth Average 274 Small Growth High 275 Small Growth Average 276 Small Growth Average 277 Small Growth Average 278 Small Growth Average 279 Small Growth High 280 Small Growth Average 281 Small Growth High 282 Small Growth Average 283 Small Growth Average 284 Small Growth Average 285 Small Growth High 286 Small Growth 287 Small Growth High 288 Small Growth Average 289 Small Growth High 290 Small Growth 291 Small Growth 292 Small Growth High 293 Small Growth High 294 Small Growth 295 Small Growth 3YrReturn% 25.79 26.12 25.25 24.99 24.67 24.66 24.35 24.78 25.05 24.08 24.59 25.47 23.44 24.35 24 23.78 23.55 23.55 23.29 22.64 24.11 24.08 22.59 23.6 23.7 23.32 21.77 22.42 22.46 21.92 20.96 21.71 21.91 21.48 21.6 21.19 21.22 High Average Rear A1 XV fx Market_Cap A B C D E Risk 3YrReturn% Market_Cap 295 Small 296 Small 297 Small 298 Small 299 Small 300 Small 301 Small 302 Small 303 Small 304 Small 305 Small 306 Small 307 Small 308 Small 309 Small 310 Small 311 Small 312 Small 313 Small 314 Small 315 Small 316 Small 317 Small 318 Small 319 Small 320 Type Growth Growth Growth Growth Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value High Average High High High High High High High High High High High High High High Low Average High Low High High High Average High 21.22 18.75 16.14 12.59 36.84 32.68 32.49 32.13 31.19 30.54 28.21 29.09 26.47 25.7 24.42 24.08 23.36 22.36 22.17 21.34 20.9 20.45 20.84 19.23 19.63 321 322 323 324 325