Question

1 Approved Answer

Posted on Sep 05, 2024

Retirement Funds Spreadsheet O Q Large P Bins Midpoints -0.01 2.50 4.99 7.50 9.99 12.50 14.99 17.50 19.99 22.50 24.99 27.50 29.99 32.50 37.50 39.99

Retirement Funds Spreadsheet image text in transcribed

O Q Large P Bins Midpoints -0.01 2.50 4.99 7.50 9.99 12.50 14.99 17.50 19.99 22.50 24.99 27.50 29.99 32.50 37.50 39.99 42.50 44.99 47.50 49.99 52.50 54.99 57.50 59.99 62.50 64.99 34.99 B C D F G H M I N 1 Fund Number Market Cap Type Assets Turnover Ratio Beta SD Risk 1YrReturn% 3YrReturn% 5YrReturn% 10YrReturn% Expense Ratio Star Rating 2 RF001 Growth 15.00 0.00 2.17 42.42 High 13.88 62.91 -3.12 -2.30 1.93 Three 3 RF002 Large Growth 106.50 34.00 2.05 39.98 High 10.49 54.79 3.25 -0.73 1.61 Five 4 RF003 Large Growth 144.50 76.00 2.05 40.09 High 10.10 54.75 3.33 -0.61 1.82 Two 5 RF004 Large Growth 73.60 11.49 1.10 21.81 Average 13.72 38.84 1.73 6.71 1.21 Five 6 RF005 Large Growth 1104.40 19.00 1.04 20.39 Average 8.03 33.65 6.34 5.51 1.53 Five 7 RF006 Large Growth 443.60 231.00 0.90 18.02 Low 1.26 33.18 8.62 9.31 1.41 Five 8 RF007 Large Growth 88.00 27.00 1.28 25.63 High 2.44 32.45 6.59 2.50 1.33 Three 9 RF008 Large Growth 6101.30 158.00 1.13 22.24 Average 3.05 29.08 6.65 6.59 0.94 Five 10 RF009 Large Growth 656.20 55.00 1.00 19.51 Average 7.93 27.22 6.21 4.03 1.31 Five 11 RF010 Large Growth 30.30 318.00 1.11 21.12 Average 3.52 27.17 3.84 3.59 1.55 Four 12 RF011 Large Growth 227.30 27.99 1.18 23.00 Average -1.01 26.97 6.78 7.97 1.25 Five 13 RF012 Large Growth 28.20 62.00 1.00 19.52 Average 6.98 26.40 5.52 3.66 1.65 Four 14 RF013 Large Growth 1874.80 69.00 1.03 19.44 Average 4.81 25.50 3.87 5.87 1.00 Five 15 RF014 Large Growth 335.40 12.00 1.06 20.20 Average 5.15 24.97 3.47 5.98 0.59 Four 16 RF015 Large Growth 0.60 157.00 1.14 21.62 Average 3.73 24.85 1.33 4.59 2.54 Five 17 RF016 Large Growth 10572.00 132.00 1.08 20.51 Average 1.71 24.72 3.98 3.15 0.94 Four 18 RF017 Large Growth 1100.40 92.00 1.03 19.41 Average 4.30 24.64 3.61 5.31 0.83 Five 19 RF018 Large Growth 240.80 12.00 1.00 20.32 Average -2.71 24.20 4.02 0.43 1.34 Three 20 RF019 Large Growth 45.40 117.00 0.96 18.02 Low 7.35 23.81 3.05 5.25 1.04 Four 21 RF020 Large Growth 388.20 43.12 1.26 24.81 High -2.88 23.77 3.88 2.22 0.97 Five 22 RF021 Large Growth 477.30 19.00 1.11 20.94 Average 3.20 23.73 4.13 4.80 1.00 Four 23 RF022 Large Growth 1279.80 88.00 1.08 20.16 Average 1.32 23.70 3.46 4.41 0.88 Five 24 RF023 Large Growth 34.60 18.34 1.19 22.86 Average -4.74 23.47 2.13 4.77 1.47 Three 25 RF024 Large Growth 119.00 8.00 0.99 18.92 Low 1.92 23.40 3.00 5.00 1.55 Five 26 RF025 Large Growth 286.50 28.13 0.89 17.02 Low 6.57 23.23 4.52 3.85 1.24 Four 27 RF026 Large Growth 4213.40 182.00 1.10 21.20 Average 3.44 22.80 0.90 5.72 0.91 Three 28 RF027 Large Growth 33.50 28.00 1.12 21.18 Average -0.23 22.77 1.67 2.81 1.04 Five 29 RF028 Large Growth 6.70 40.00 1.11 21.80 Average -2.96 22.37 2.24 3.03 1.55 Three 30 RF029 Large Growth 859.70 72.00 1.05 19.72 Average 2.94 22.15 2.55 4.11 0.63 Five 31 RF030 Large Growth 61.90 6.00 0.91 16.96 Low 6.60 22.01 3.99 3.74 1.79 Four 32 RF031 Large Growth 3300.30 93.00 1.29 24.90 High -3.43 21.80 2.04 4.72 0.70 Five 33 RF032 Large Growth 2.00 26.00 1.03 19.56 Average 4.70 21.74 1.79 3.12 0.63 Three 34 RF033 Large Growth 947.70 75.00 1.01 19.38 Average 1.58 21.71 4.86 7.00 1.01 Five 35 RF034 Large Growth 6101.20 13.00 1.00 18.73 Low 5.00 21.65 3.38 2.70 1.00 Four 36 RF035 Large Growth 340.70 47.00 0.94 17.74 Low 7.97 21.62 4.12 3.31 1.32 Five 37 RF036 Large Growth 59.20 65.00 1.03 19.41 Average 3.43 21.34 1.95 3.56 1.08 Three K M A 38 RF037 39 RF038 40 RF039 41 RF040 42 RF041 43 RF042 44 RF043 45 RF044 46 RF045 47 RF046 48 RF047 49 RF048 50 RF049 51 RF050 52 RF051 53 RF052 54 RF053 55 RF054 56 RF055 57 RF056 58 RF057 59 RF058 60 RF059 61 RF060 62 RF061 63 RF062 64 RF063 65 RF064 66 RF065 67 RF066 68 RF067 69 RF068 70 RF069 71 RF070 72 RF071 73 RF072 74 RF073 B Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large C D Growth 720.60 Growth 676.70 Growth 1812.60 Growth 42.50 Growth 509.80 Growth 172.70 Growth 32.20 Growth 169.40 Growth 99.90 Growth 1046.20 Growth 28.90 Growth 218.90 Growth 22.80 Growth 940.30 Growth 512.70 Growth 12.00 Growth 37.10 Growth 84.00 Growth 132.10 Growth 434.60 Growth 2376.90 Growth 58729.30 Growth 96.60 Growth 23.20 Growth 86.70 Growth 24.60 Growth 61.20 Growth 1879.10 Growth 2171.30 Growth 192.90 Growth 84.60 Growth 8.20 Growth 3.60 Growth 28.90 Growth 33.50 Growth 94.30 Growth 1335.60 67.00 1.06 19.98 Average 16 1998 Average 257.00 0.95 18.15 Low 17.00 0.97 18.32 Low 203.00 1.21 24.20 High 277.00 0.98 18.53 Low 14.78 1.00 18.86 Low 37.58 1.05 19.47 Average 101.33 1.07 19.95 Average 35.00 0.97 18.27 Low 82.00 1.02 19.60 Average 159.31 0.98 18.47 Low 30.00 0.97 18.67 Low 65.96 1.01 19.34 Average 53.00 0.95 18.10 Low 88.42 1.04 19.12 Average 8.00 1.00 20.33 Average 20.00 0.94 17.42 Low 113.00 1.01 19.03 Average 79.00 0.99 18.76 Low 31.00 1.04 19.91 Average 9.00 1.07 19.80 Average 57.00 0.84 15.81 Low 6.20 0.93 17.12 Low 12.81 1.26 23.47 High 18.70 0.97 18.50 Low 75.38 1.09 20.65 Average 182.00 1.03 19.49 Average 109.00 0.99 18.44 Low 3.00 0.80 15.16 Low 18.00 1.00 18.42 Low 116.00 1.05 20.03 Average 92.00 0.98 18.31 Low 34.00 0.99 18.61 Low 453.00 0.92 16.88 Low 69.00 1.01 19.17 Average 39.00 0.99 19.20 Average 65.00 1.06 20.04 Average 4.09 1.24 5.27 -7.53 2.50 2.79 5.08 2.45 3.23 2.41 6.57 3.44 -1.95 6.60 0.59 5.93 1.51 1.65 4.33 0.09 -1.11 4.27 4.64 -2.68 4.19 4.03 -1.49 -1.55 1.72 0.55 -0.81 3.60 1.39 5.24 -1.66 7.96 2.32 21.24 21.21 20.96 20.94 20.83 20.71 20.86 20.63 20.62 20.55 20.27 20.23 20.07 19.63 19.46 19.39 19.23 19.16 19.13 19.08 18.92 18.87 18.77 18.46 18.38 18.34 18.28 18.12 18.01 17.98 17.98 17.94 17.76 17.69 17.63 17.53 17.43 0.23 -1.46 3.58 -2.38 4.41 0.79 1.84 1.27 1.84 0.46 4.90 2.72 1.88 3.08 -0.13 -1.08 0.22 1.62 -0.36 0.44 -0.07 3.15 3.02 -0.88 1.52 -1.02 -0.94 -0.51 4.39 0.76 -0.30 3.00 0.90 0.82 1.22 2.93 -0.33 4.01 4.23 2.46 -0.03 3.84 2.45 3.28 1.83 3.16 4.32 5.84 3.78 4.87 6.83 2.21 1.11 2.68 2.58 2.21 1.32 3.38 7.54 4.52 4.28 1.83 3.30 2.06 4.46 8.03 5.65 3.64 3.64 1.05 4.42 2.48 3.71 3.10 N 1.33 Five 0.71 Three 1.01 Four 2.08 Five 0.93 Four 1.32 Five 2.08 Three 1.45 Five 1.42 Three 1.33 Five 2.08 Four 1.18 Five 1.64 Three 1.05 Five 1.05 Two 4.22 Five 1.10 Three 1.28 Five 0.87 Two 1.47 Five 0.80 Three 0.92 Five 1.14 Five 1.22 Two 1.33 Five 1.59 Two 1.13 Five 0.83 Three 1.14 Five 1.02 Three 1.29 Five 1.16 Four 1.53 Three 1.91 Five 1.11 Three 1.53 Five 0.90 Three 75 RF074 76 RF075 77 RF076 78 RF077 79 RF078 80 RF079 81 RF080 82 RF081 83 RF082 84 RF083 85 RF084 86 RF085 87 RF086 88 RF087 89 RF088 90 RF089 91 RF090 92 RF091 93 RF092 94 RF093 95 RF094 96 RF095 97 RF096 98 RF097 99 RF098 100 RF099 101 RF100 102 RF101 103 RF102 104 RF103 A B Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large C D Growth 0.40 Growth 182.00 Growth 463.70 Growth 13320.90 Growth 272.20 Growth 2442.60 Growth 13.60 Growth 2100.30 Growth 1698.10 Growth 279.60 Growth 2.80 Growth 19.40 Growth 57.90 Growth 6.60 Growth 0.60 Growth 399.10 Growth 343.70 Growth 7.50 Growth 5.10 Growth 16.00 Growth 16.80 Growth 1.90 Growth 168.70 Growth 23.50 Growth 50.70 Growth 145.70 Growth 91.60 Growth 13.60 Growth 55.30 Growth 105.90 E F G H 70.00 1.05 20.14 Average 51.00 1.03 19.26 Average 86.00 1.15 21.90 Average 102.00 1.16 21.93 Average 48.00 1.04 19.27 Average 7.00 0.90 16.96 Low 24.00 0.97 18.12 Low 90.00 0.98 18.29 Low 63.48 0.84 15.58 Low 25.36 0.92 17.06 Low 44.00 1.01 18.62 Low 293.00 0.90 17.11 Low 74.00 1.08 20.54 Average 194.00 0.87 16.20 Low 138.00 0.91 17.21 Low 57.00 0.94 17.67 Low 48.56 0.99 18.45 Low 271.00 0.85 16.79 Low 45.00 0.86 16.41 Low 312.62 1.09 21.99 Average 127.00 0.86 16.32 Low 47.00 0.94 17.68 Low 17.00 0.91 17.23 Low 15.00 0.84 15.78 Low 10.00 1.06 20.36 Average 28.00 0.71 14.58 Low 74.00 0.85 16.10 Low 47.00 0.93 17.45 Low 116.00 0.92 18.26 Low 62.40 0.81 15.52 Low I -6.25 3.33 -8.49 -7.74 -3.62 2.97 0.19 -0.63 4.67 4.04 0.02 0.05 -4.48 8.60 1.28 2.51 -0.72 7.56 1.46 -17.63 1.47 1.82 3.81 1.21 -8.44 -0.26 2.64 -1.35 -7.29 2.62 17.25 17.25 17.25 17.17 16.86 16.68 16.61 16.59 16.41 16.32 15.96 15.92 15.89 15.65 15.51 15.50 15.44 14.96 14.67 14.39 14.36 14.33 14.28 14.02 13.23 13.11 11.94 11.54 11.51 11.19 2167.44 2.13 1.00 -2.78 -2.76 1.57 2.31 1.29 0.78 3.79 1.87 0.63 -0.62 -4.15 1.41 -0.17 -0.65 -0.45 1.29 -1.64 -1.55 0.69 -1.29 -0.03 0.81 -3.06 2.50 1.57 -2.77 -1.13 0.69 2.07 2.98 6.66 0.76 2.98 3.48 3.32 2.31 2.92 3.38 3.09 2.72 1.31 3.17 5.30 2.33 3.19 2.98 0.19 2.46 3.17 -0.08 1.49 4.95 -1.59 6.46 3.53 0.59 3.33 3.47 N 1.11 Five 0.88 Three 1.37 Five 0.60 One 1.26 Three 0.92 Five 2.37 Three 0.90 Five 1.09 Four 1.00 Five 0.63 Three 1.00 Five 1.52 One 1.12 Five 0.97 Two 1.20 Five 1.15 Two 1.11 Five 0.95 Two 1.35 Five 2.57 Three 1.62 Five 1.21 Two 1.01 Five 1.86 One 0.98 Five 0.93 Three 2.47 Five 1.71 Two 1.24 Five 105 11.51 4.18 5.38 2.88 3.26 7.27 4.78 6.77 2.73 4.24 3.76 3.27 1.77 106 RF104 107 RF105 108 RF106 109 RF107 110 RF108 111 RF109 112 RF110 113 RF111 114 RF112 115 RF113 116 RF114 117 RF115 118 RF116 119 RF117 120 RF118 121 RF119 122 RF120 123 RF121 124 RF122 125 RF123 126 RF124 127 RF125 128 RF126 129 RF127 130 RF128 131 RF129 132 RF130 133 RF131 134 RF132 135 RF133 136 RF134 137 RF135 138 RF136 139 RF137 140 RF138 141 RF139 Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value 4946.30 119.90 1508.21 989.40 554.20 2.00 560.00 1682.40 95.70 47.80 70.30 1.40 35.20 6847.10 32.60 16.30 26.60 1288.60 3666.40 106.10 4293.60 82.90 92.30 22.60 504.30 23.60 0.30 14.60 182.40 219.00 112.90 31.70 164.60 1704.40 5.90 4.90 3.05 0.94 20.03 Average 40.00 1.09 22.31 Average 56.00 0.93 17.81 Low 21.00 0.92 17.72 Low 78.38 0.97 18.45 Low 68.00 1.12 21.20 Average 37.51 1.17 21.45 Average 14.00 0.98 17.87 Low 167.00 0.88 16.91 Low 26.76 1.20 22.12 Average 21.00 0.66 13.17 Low 72.27 1.03 19.03 Average 40.00 1.12 21.33 Average 36.00 1.17 21.46 Average 59.00 1.21 22.17 Average 142.75 0.93 17.74 Low 47.00 1.05 19.25 Average 20.00 0.93 17.26 Low 90.00 1.11 20.22 Average 184.00 1.19 22.58 Average 82.00 1.15 21.16 Average 34.33 0.95 17.58 Low 8.16 1.02 18.86 Low 17.57 0.85 16.40 Low 28.00 1.02 18.66 Low 59.07 0.95 17.41 Low 24.00 1.09 20.03 Average 17.36 1.08 19.89 Average 169.00 1.06 19.93 Average 20.00 0.70 12.91 Low 37.00 1.01 18.55 Low 733.00 1.08 19.82 Average 85.09 1.10 20.51 Average 32.00 0.92 16.98 Low 22.00 1.01 19.26 Average 14.00 0.78 14.58 Low 8.72 6.11 8.74 8.49 6.10 3.34 0.42 3.46 15.14 -0.87 12.07 4.47 -2.12 -4.15 -0.87 2.70 0.40 0.11 -0.55 -7.47 -2.72 1.46 4.22 5.20 3.11 6.35 1.20 0.55 3.86 6.86 3.06 -0.70 -0.35 2.36 -0.28 31.25 27.03 23.49 21.94 21.76 21.26 20.93 20.02 20.01 19.46 18.94 18.87 18.83 18.25 18.21 18.04 17.95 17.87 17.78 17.88 17.63 17.34 17.42 16.86 16.67 16.65 16.55 16.35 16.23 16.15 16.04 15.98 15.97 15.94 15.81 15.53 9.30 -0.38 0.49 -2.56 0.69 -2.96 -1.78 2.13 -1.40 -2.26 0.32 -0.61 -1.39 -2.98 -3.44 0.42 1.98 1.13 -1.86 0.59 -2.84 0.85 -1.08 4.58 -2.76 0.16 -1.67 -1.55 -0.76 3.22 -2.98 -4.39 -5.80 -0.58 -1.83 -0.53 2.96 2.99 4.44 8.45 3.76 5.11 5.37 2.88 6.23 2.58 1.27 Five 1.30 Three 0.84 Five 1.21 Three 1.10 Five 1.32 Three 1.20 Five 1.41 Five 0.83 Five 1.19 Three 1.34 Five 1.12 Three 1.51 Five 0.69 Two 1.39 Five 3.99 Four 1.28 Five 0.91 Four 0.97 Five 0.96 Four 0.88 Five 1.10 Four 1.04 Five 1.28 Four 0.87 Five 1.19 Four 7.28 Five 2.36 Three 1.29 Five 1.25 Five 1.11 Five 1.89 Two 1.44 Five 1.01 Four 1.47 Five 2.75 Five 4.87 3.39 5.19 2.41 3.69 3.39 6.22 3.11 4.37 1.05 4.81 1.40 7.59 3.90 L M 142 RF140 143 RF141 144 RF142 145 RF143 146 RF144 147 RF145 148 RF146 149 RF147 150 RF148 151 RF149 152 RF150 153 RF151 154 RF152 155 RF153 156 RF154 157 RF155 158 RF156 159 RF157 160 RF158 161 LBC D Large Value 920.00 Large Value 124.20 Large Value 458.40 Large Value 26.80 Large Value 8.50 Large Value 126.20 Large Value 126.70 Large Value 346.00 Large Value 340.70 Large Value 15.10 Large Value 1677.80 Large Value 463.00 Large Value 497.90 Large Value 1643.70 Large Value 8.90 Large Value 80.90 Large Value 28.60 Large Value 69.80 Large Value 189.60 F G H 38.00 0.99 18.51 Low 35.00 1.07 19.82 Average 19.00 1.04 19.32 Average 2.00 0.74 13.98 Low 161.85 0.86 16.23 Low 33.68 1.18 21.78 Average 149.00 1.02 18.85 Low 0.00 0.70 13.86 Low 141.00 1.17 21.70 Average 92.40 0.68 16.26 Low 26.00 1.05 19.64 Average 196.00 1.08 19.63 Average 11.63 0.94 18.02 Low 26.00 0.98 18.04 Low 43.00 0.94 17.23 Low 80.00 0.67 13.58 Low 31.68 0.69 13.51 Low 55.00 0.96 17.95 Low 33.85 0.55 11.68 Low 4.86 -0.92 3.85 6.32 5.43 -7.21 2.44 10.07 -0.07 1.89 -2.07 1.85 -2.55 -2.74 1.73 6.82 4.50 0.22 -1.40 15.51 15.49 15.36 15.34 15.23 15.16 14.98 14.96 14.93 14.85 14.45 14.27 14.25 13.94 13.22 12.12 11.32 11.21 9.82 939.30 K -2.19 -1.35 -3.77 -0.78 -1.51 -3.03 -1.77 0.41 -5.22 -0.27 -1.30 -4.06 -5.85 1.04 -1.74 3.93 3.08 -2.23 3.28 5.36 3.27 5.85 5.71 3.63 2.81 2.85 6.34 2.74 3.40 4.53 2.92 2.22 6.72 5.22 3.97 5.28 2.77 5.06 1.06 Three 1.41 Five 1.11 Two 0.98 Five 2.86 Four 1.23 Five 1.41 Two 1.48 Five 0.75 One 2.03 Five 0.95 Five 0.73 Two 1.24 Five 1.11 Four 1.09 Five 1.68 Four 1.86 Five 1.28 Three 1.28 Five 6.21 8.46 5.92 7.30 4.73 6.42 9.03 11.16 4.66 9.62 5.78 7.66 5.92 162 RF159 163 RF160 164 RF161 165 RF162 166 RF163 167 RF164 168 RF165 169 RF166 170 RF167 171 RF168 172 RF169 173 RF170 174 RF171 175 RF172 176 RF173 177 RF174 178 RF175 179 RF176 180 RF177 181 RF178 182 RF179 183 RF180 184 RF181 185 RF182 186 RF183 187 RF184 188 RF185 189 RF186 190 RF187 191 RF188 192 RF189 193 RF190 194 RF191 195 RF192 196 RF193 197 RF194 198 RF195 | B Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap C Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 29.90 274.10 3.20 184.10 18.80 4.40 354.70 31.80 5222.40 261.80 136.20 766.30 101.90 495.40 651.10 841.80 42.30 708.40 5.70 75.40 108.20 1.50 252.10 35.50 8.20 95.40 9.20 70.90 2403.00 319.50 168.30 27.90 0.60 4352.50 94.00 28.30 696.30 F G H 205.00 1.27 26.54 High 147.00 1.18 23.49 High 178.00 1.11 21.66 Average 20.00 1.20 23.08 High 27.84 1.00 20.12 Average 25.10 1.00 19.96 Average 111.00 1.07 21.49 Average 9.00 1.02 20.47 Average 66.00 1.17 22.45 Average 65.43 1.05 20.43 Average 19.00 1.16 23.56 High 19.00 1.04 19.97 Average 56.00 1.22 23.41 High 104.00 1.20 23.62 High 13.00 0.99 20.94 Average 41.00 1.10 21.03 Average 39.00 1.04 21.24 Average 15.00 1.07 21.18 Average 426.00 1.10 21.01 Average 30.33 1.09 21.44 Average 21.00 1.08 21.94 Average 133.00 1.14 21.94 Average 191.00 1.17 22.48 Average 24.00 0.95 19.40 Average 65.00 1.01 19.89 Average 35.00 0.92 17.92 Low 50.74 1.11 21.99 Average 34.00 1.11 21.46 Average 95.00 1.10 21.72 Average 7.00 0.96 18.10 Low 104.00 1.10 21.79 Average 159.00 0.79 16.19 Low 97.00 1.27 24.13 High 13.51 1.01 19.90 Average 79.00 1.05 21.08 Average 18.66 1.09 21.52 Average 66.00 1.23 23.61 High I -3.66 6.76 8.97 4.03 7.52 11.77 7.15 3.13 2.03 -3.21 -5.22 3.03 -2.95 -3.08 8.29 3.38 3.97 0.87 2.35 5.67 0.60 0.34 -1.82 7.07 5.50 7.29 -0.25 4.05 -0.47 9.63 -0.37 11.80 -0.75 4.08 2.39 2.86 -8.64 34.18 32.52 30.80 29.41 29.31 28.78 28.55 27.50 26.90 26.65 26.23 26.11 26.10 26.05 25.94 25.93 25.89 25.37 25.13 24.78 24.77 24.74 24.89 24.60 24.46 24.38 24.38 24.32 23.96 23.95 23.94 23.87 23.83 23.58 23.27 23.20 23.18 4.59 8.17 2.62 5.66 5.17 6.43 5.95 8.62 1.63 4.47 2.77 4.71 2.52 2.88 3.01 4.95 4.60 3.59 4.04 3.99 6.01 3.93 -1.52 5.50 2.17 3.12 4.23 4.60 6.01 4.00 2.29 4.97 0.73 1.80 5.48 2.57 4.40 4.96 11.76 7.87 7.46 7.13 4.91 5.93 6.62 5.11 3.18 6.21 0.91 5.38 6.38 7.38 8.35 7.30 4.93 8.06 4.05 7.48 4.80 12.04 5.97 MN 2.12 Three 1.55 Five 3.03 Four 1.37 Five 1.65 Four 1.56 Five 1.41 Five 1.98 Five 0.61 Two 1.41 Five 2.12 Five 0.94 Four 1.05 Five 1.28 Three 1.52 Five 1.38 Four 1.46 Five 1.04 Three 1.78 Five 1.51 Three 1.95 Five 1.13 Three 0.79 Five 1.42 Five 1.79 Five 1.04 Four 2.03 Five 1.31 Four 1.01 Five 1.23 Five 1.40 Five 2.00 Five 1.21 Five 1.32 Three 1.23 Five 1.47 Three 1.08 Five N B Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap 2A 199 RF196 200 RF197 201 RF198 202 RF199 203 RF200 204 RF201 205 RF202 206 RF203 207 RF204 208 RF205 209 RF206 210 RF207 211 RF208 212 RF209 213 RF210 214 RF211 215 RF212 216 RF213 217 RF214 218 RF215 219 RF216 220 RF217 221 RF218 222 RF219 223 RF220 224 RF221 225 RF222 226 RF223 227 RF224 228 C Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 146.70 970.40 613.80 267.10 287.60 1619.50 61.80 174.00 176.80 1948.30 2.50 3507.40 110.60 22.80 26.50 38.80 Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap F G H. 26.98 1.11 21.60 Average 10.77 1.21 23.77 High 87.00 1.18 22.59 Average 60.44 1.15 22.16 Average 16.00 0.95 18.59 Low 165.00 1.15 22.20 Average 17.99 0.98 18.46 Low 12.00 0.92 17.52 Low 5.00 1.00 19.50 Average 23.89 1.05 20.27 Average 64.00 1.16 22.77 Average 18.00 0.93 18.02 Low 27.93 0.88 17.24 Low 62.00 1.04 20.46 Average 132.20 1.20 22.88 Average 59.00 1.01 19.62 Average 127.00 1.17 22.35 Average 57.00 1.13 21.62 Average 111.00 1.09 21.73 Average 54.00 1.27 24.54 High 246.00 0.95 18.40 Low 7.00 0.76 15.42 Low 77.00 0.99 19.39 Average 90.00 1.02 20.70 Average 280.00 1.07 21.65 Average 150.00 0.82 16.16 Low 205.00 0.59 13.31 Low 241.00 0.97 20.53 Average 250.10 0.89 19.67 Average 0.92 -3.60 -0.57 1.00 11.54 -2.32 3.99 6.30 7.15 0.21 -4.67 7.16 3.67 1.80 -4.40 2.79 -3.57 -2.61 -3.82 -0.32 8.67 10.95 -1.71 -2.49 9.45 -0.80 -3.72 -11.42 -16.04 22.91 22.78 22.71 22.66 22.54 22.34 22.28 22.17 22.04 21.65 21.34 21.32 20.37 20.37 20.04 19.80 19.68 19.51 19.38 19.14 17.91 17.11 16.07 15.51 14.61 12.01 8.77 6.85 3.39 1498.71 2.21 -1.60 0.65 2.82 2.70 0.46 4.01 2.31 4.62 0.31 -0.59 5.94 3.38 4.78 1.45 1.46 -1.17 1.27 1.61 -2.39 0.79 -2.11 -0.59 0.27 0.45 2.13 2.76 -4.68 -0.03 4.81 8.28 3.80 5.93 6.73 1.36 6.18 5.99 9.93 6.18 2.51 9.76 4.88 6.89 6.00 5.12 3.71 6.56 9.47 1.25 Three 1.71 Five 1.13 Two 1.30 Five 1.21 Three 0.79 Five 1.46 Four 1.25 Five 1.50 Four 1.33 Five 2.76 Two 1.14 Five 0.99 Four 2.47 Five 1.15 Three 1.22 Five 1.31 Two 2.01 Five 1.24 Three 3.22 Five 1.17 Three 1.31 Five 1.94 Two 1.01 Five 1.26 Two 1.30 Five 1.81 Three 1.25 Five 3.92 Two 0.72 9.70 34.60 11.50 9.10 135.40 38.40 1208.70 75.80 150.60 70.50 129.60 2.68 0.53 2.92 5.02 3.63 7.82 2.07 2.00 2.25 229 RF225 230 RF226 231 RF227 232 RF228 233 RF229 234 RF230 235 RF231 236 RF232 237 RF233 238 RF234 239 RF235 240 RF236 241 RF237 242 RF238 243 RF239 244 RF240 245 RF241 246 RF242 247 RF243 248 I B Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap C Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value D 18.30 28.00 1352.30 5926.30 2.50 21.00 37.10 554.00 4.60 13.20 1546.10 92.70 131.20 196.90 1452.00 47.50 44.70 6.50 601.90 F G H 26.00 1.46 28.97 High 381.00 1.57 32.05 High 38.00 1.44 28.42 High 95.00 1.38 25.91 High 107.00 1.24 23.09 High 27.00 1.33 24.86 High 82.00 0.86 16.31 Low 185.00 1.18 22.50 Average 32.00 1.25 23.51 High 55.00 1.07 20.06 Average 41.00 0.99 18.64 Low 44.00 1.12 21.38 Average 37.00 1.18 21.97 Average 68.05 0.76 15.86 Low 43.00 0.93 17.47 Low 134.34 1.33 25.48 High 21.00 1.02 18.99 Low 678.00 1.18 22.53 High 29.00 1.12 20.74 Average 0.81 0.44 0.57 -3.26 2.16 -4.86 6.37 -1.04 -0.89 2.88 5.16 3.37 -3.82 4.86 2.81 - 1.19 1.85 -0.80 -2.66 35.01 30.04 29.83 25.33 25.00 24.89 24.18 23.88 23.85 22.85 21.81 21.74 21.62 21.61 20.74 20.73 20.68 20.49 20.12 454.40 2.73 -2.87 4.82 -1.41 1.06 -0.14 0.64 0.29 -0.61 1.01 2.17 -0.46 0.44 6.17 3.35 -1.37 -1.34 -0.33 2.35 4.46 2.03 10.09 6.41 3.65 6.44 3.88 6.71 6.60 4.55 8.90 6.35 5.98 6.68 8.20 4.62 5.43 5.42 7.77 MN 2.07 Three 1.54 Five 1.29 Four 0.60 Five 1.28 Three 1.55 Five 1.76 Four 0.91 Five 1.40 Two 1.26 Five 1.15 Five 1.43 Five 1.25 Three 1.70 Five 1.01 Four 1.71 Five 1.27 Two 1.87 Five 1.23 Four M -0.28 13.36 16.22 5.10 3.86 6.05 3.58 7.70 11.32 4.11 7.65 6.97 2.98 7.82 1.44 3.85 5.66 5.91 8.66 249 RF244 250 RF245 251 RF246 252 RF247 253 RF248 254 RF249 255 RF250 256 RF251 257 RF252 258 RF253 259 RF254 260 RF255 261 RF256 262 RF257 263 RF258 264 RF259 265 RF260 266 RF261 267 RF262 268 RF263 269 RF264 270 RF265 271 RF266 272 RF267 273 RF268 274 RF269 275 RF270 276 RF271 277 RF272 278 RF273 279 RF274 280 RF275 281 RF276 282 RF277 283 RF278 284 RF279 285 RF280 B Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small C Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 2.90 36.00 450.20 8.10 244.10 1014.10 20.10 147.90 140.90 508.40 366.70 251.00 19.90 294.40 11.60 118.10 170.80 38.70 1168.70 34.50 223.50 89.20 3.70 63.00 271.00 331.10 7.10 116.10 12.90 97.10 2564.00 212.80 173.00 316.10 205.30 3066.00 13.10 E F G H 232.00 1.41 29.58 High 16.00 1.17 24.49 High 80.26 1.06 21.60 Average 70.00 1.22 24.86 High 54.00 1.06 21.25 Average 42.00 1.02 20.21 Average 180.00 1.44 28.43 High 60.00 0.92 18.96 Low 79.00 1.11 22.60 Average 27.00 1.01 20.02 Average 101.00 1.23 24.65 High 55.00 1.11 22.16 High 209.00 1.25 25.64 High 30.00 1.09 21.48 Average 92.00 1.14 24.22 High 75.00 1.05 21.59 Average 76.00 1.02 20.41 Average 147.00 1.23 24.51 High 106.00 1.21 23.52 High 24.64 0.94 18.78 Low 14.00 1.08 21.24 Average 42.00 1.01 22.33 High 18.00 1.06 20.52 Average 51.00 1.21 25.31 High 119.00 1.27 25.18 High 7.00 1.22 23.69 High 48.00 1.18 23.38 High 85.00 1.22 24.16 High 530.00 1.15 22.71 Average 14.00 1.13 23.86 High 82.00 1.18 22.48 Average 18.03 1.01 20.55 Average 74.00 1.03 21.12 Average 17.01 1.12 22.04 Average 46.00 1.31 26.64 High 32.81 1.05 20.51 Average 199.00 1.49 29.22 High 14.64 11.58 2.77 8.86 9.01 1.33 0.65 5.07 6.94 11.94 2.77 5.57 4.75 -0.39 7.73 -5.48 -0.20 -0.59 5.82 5.78 6.76 -0.10 1.09 8.58 3.55 4.09 -5.68 1.52 -1.74 35.13 33.99 31.46 31.40 31.19 31.04 30.43 30.33 29.83 29.31 29.21 27.76 27.33 27.03 26.75 25.77 25.37 25.30 25.08 24.93 24.90 24.84 24.72 24.82 24.61 24.61 24.30 24.21 24.06 23.72 23.86 23.61 23.31 23.19 23.17 23.12 23.10 2.14 -1.21 3.35 0.38 3.20 8.12 5.12 1.55 5.69 2.62 6.45 0.90 3.41 -0.59 4.18 2.05 6.00 1.05 3.00 6.22 3.82 6.19 2.89 -3.91 3.07 5.40 2.45 2.93 2.62 7.38 1.79 5.62 2.33 5.90 -1.18 2.18 -2.11 5.00 5.64 6.33 5.86 7.73 5.24 6.48 8.17 6.90 4.17 11.26 4.40 2.29 6.01 10.96 6.14 4.36 5.88 7.91 4.53 10.57 8.03 7.12 6.90 7.82 1.04 IN 2.76 Three 1.55 Five 1.66 Four 2.47 Five 0.96 Four 0.94 Five 1.58 Three 1.43 Five 1.51 Five 1.31 Five 1.46 Four 1.58 Five 1.55 Three 2.16 Five 1.57 Three 1.50 Five 1.27 Four 1.68 Five 0.95 Three 1.25 Five 1.25 Five 2.19 Four 1.90 Five 1.39 One 1.53 Five 1.50 Four 2.18 Five 1.98 Three 1.78 Five 2.11 Five 1.45 Three 1.27 Five 1.57 Five 1.13 Four 1.52 Five 1.31 Five 3.73 One M N 286 RF281 287 RF282 288 RF283 289 RF284 290 RF285 291 RF286 292 RF287 293 RF288 294 RF289 295 RF290 296 RF291 297 RF292 298 RF293 299 RF294 300 RF295 301 RF296 302 RF297 303 B Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 68.80 185.40 88.60 182.60 5.80 480.10 7.70 159.80 11.20 0.70 1510.80 25.10 21.80 91.20 258.50 159.10 31.00 F G H 43.00 1.12 22.31 Average 7.54 1.12 22.30 Average 27.00 1.06 20.85 Average 107.00 1.25 25.01 High 195.00 1.49 29.20 High 26.34 1.18 23.14 High 194.26 1.11 22.39 Average 108.00 1.29 26.19 High 160.00 1.08 22.58 Average 112.00 1.39 27.79 High 28.00 1.18 23.46 High 197.43 1.45 30.69 High 37.00 1.30 26.68 High 122.00 1.18 23.46 High 63.00 1.12 22.96 Average 26.00 1.38 27.54 High 133.00 1.14 22.54 High I 1.24 4.06 0.42 1.03 -2.52 0.28 1.89 0.36 -3.22 -7.98 -1.06 - 10.23 -5.04 -1.22 3.04 -8.38 -9.80 J 22.95 22.78 22.69 22.32 22.20 21.75 21.67 21.65 21.46 21.36 21.23 21.13 21.11 20.53 18.01 15.67 12.14 1337.44 4.45 2.21 -3.26 3.00 -2.52 -0.40 0.33 2.95 1.01 0.41 0.08 -1.01 -3.58 0.82 0.42 -7.19 -3.87 5.37 4.82 4.20 4.17 3.91 2.01 2.45 7.09 3.71 0.37 10.29 0.07 5.93 2.58 6.33 1.34 Five 1.39 Five 1.64 Two 1.51 Five 4.82 One 1.41 Five 1.46 Two 1.42 Five 3.63 Three 1.31 Five 1.44 Three 1.64 Five 1.89 Two 1.39 Five 1.03 Three 1.64 Five 1.49 Two 2.31 3.21 A L M 14.32 -4.14 -5.16 0.55 4.79 -1.13 -2.39 -5.06 3.36 304 RF298 305 RF299 306 RF300 307 RF301 308 RF302 309 RF303 310 RF304 311 RF305 312 RF306 313 RF307 314 RF308 315 RF309 316 RF310 317 RF311 318 RF312 319 RF313 320 RF314 321 RF315 322 RF316 323 RF317 324 RF318 325 B Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small C Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value D 181.60 84.80 180.40 82.50 206.50 83.90 39.10 76.20 77.50 1692.80 845.90 121.30 155.00 44.70 1126.80 680.80 1698.90 22.30 9.00 68.50 83.60 E F G H 155.00 1.20 30.27 High 135.00 1.18 27.10 High 164.00 1.03 32.31 High 195.00 0.85 42.87 High 141.00 1.14 27.05 High 125.00 1.21 25.04 High 158.00 0.95 32.02 High 131.00 1.10 25.66 High 125.00 1.10 24.53 High 124.00 1.04 24.47 High 134.00 0.99 25.78 High 123.00 1.01 23.91 High 94.00 1.24 18.42 Low 117.00 1.00 22.76 Average 119.00 0.97 23.77 High 86.00 1.27 16.65 Low 123.00 0.95 23.68 High 127.00 0.68 24.86 High 131.00 0.85 25.14 High 101.00 0.98 20.16 Average 124.00 0.85 23.62 High 1.16 1.66 4.87 13.44 -0.22 -1.36 5.02 5.64 4.63 -1.34 0.32 -3.77 37.19 32.58 32.51 32.21 31.25 31.19 29.11 28.36 26.96 25.27 24.99 23.71 23.46 22.44 22.39 21.81 21.74 20.90 20.13 19.37 19.06 546.63 K 9.37 5.82 1.32 -4.14 1.61 5.08 -1.65 1.85 1.85 3.82 1.58 -1.50 0.88 2.13 -0.29 12.18 1.35 -0.92 -0.94 4.42 2.16 11.90 10.83 8.50 2.19 7.91 8.16 3.81 7.46 7.56 8.97 8.77 6.85 9.23 6.55 7.58 12.30 8.43 4.44 6.45 9.69 9.13 N 1.35 Four 1.40 Five 1.47 Two 1.54 One 1.53 Three 1.66 Five 1.55 Two 1.09 Five 1.62 Three 1.13 Five 1.19 Three 1.34 Five 1.50 Four 1.57 Five 1.14 Three 1.46 Five 1.36 Three 1.96 Five 1.87 Two 1.28 Five 1.60 Three Part 2 - Two Sample Hypothesis Testing Using the Retirement funds spreadsheet, please determine if there is a significant difference between the average rate of return on Large Value and Large Growth stock funds. I. What are the two variables of interest? J. Write a null and alternative hypothesis statement K. At the 95% significance level, is there significant evidence of a difference between fund rate of returns? L. Do you accept or reject the null hypothesis? M. Based upon your answer above, provide us with a paragraph (3-4 sentence) conclusion that would be appropriate to explain the results to a senior executive that isn't as familiar with statistics as you are! O Q Large P Bins Midpoints -0.01 2.50 4.99 7.50 9.99 12.50 14.99 17.50 19.99 22.50 24.99 27.50 29.99 32.50 37.50 39.99 42.50 44.99 47.50 49.99 52.50 54.99 57.50 59.99 62.50 64.99 34.99 B C D F G H M I N 1 Fund Number Market Cap Type Assets Turnover Ratio Beta SD Risk 1YrReturn% 3YrReturn% 5YrReturn% 10YrReturn% Expense Ratio Star Rating 2 RF001 Growth 15.00 0.00 2.17 42.42 High 13.88 62.91 -3.12 -2.30 1.93 Three 3 RF002 Large Growth 106.50 34.00 2.05 39.98 High 10.49 54.79 3.25 -0.73 1.61 Five 4 RF003 Large Growth 144.50 76.00 2.05 40.09 High 10.10 54.75 3.33 -0.61 1.82 Two 5 RF004 Large Growth 73.60 11.49 1.10 21.81 Average 13.72 38.84 1.73 6.71 1.21 Five 6 RF005 Large Growth 1104.40 19.00 1.04 20.39 Average 8.03 33.65 6.34 5.51 1.53 Five 7 RF006 Large Growth 443.60 231.00 0.90 18.02 Low 1.26 33.18 8.62 9.31 1.41 Five 8 RF007 Large Growth 88.00 27.00 1.28 25.63 High 2.44 32.45 6.59 2.50 1.33 Three 9 RF008 Large Growth 6101.30 158.00 1.13 22.24 Average 3.05 29.08 6.65 6.59 0.94 Five 10 RF009 Large Growth 656.20 55.00 1.00 19.51 Average 7.93 27.22 6.21 4.03 1.31 Five 11 RF010 Large Growth 30.30 318.00 1.11 21.12 Average 3.52 27.17 3.84 3.59 1.55 Four 12 RF011 Large Growth 227.30 27.99 1.18 23.00 Average -1.01 26.97 6.78 7.97 1.25 Five 13 RF012 Large Growth 28.20 62.00 1.00 19.52 Average 6.98 26.40 5.52 3.66 1.65 Four 14 RF013 Large Growth 1874.80 69.00 1.03 19.44 Average 4.81 25.50 3.87 5.87 1.00 Five 15 RF014 Large Growth 335.40 12.00 1.06 20.20 Average 5.15 24.97 3.47 5.98 0.59 Four 16 RF015 Large Growth 0.60 157.00 1.14 21.62 Average 3.73 24.85 1.33 4.59 2.54 Five 17 RF016 Large Growth 10572.00 132.00 1.08 20.51 Average 1.71 24.72 3.98 3.15 0.94 Four 18 RF017 Large Growth 1100.40 92.00 1.03 19.41 Average 4.30 24.64 3.61 5.31 0.83 Five 19 RF018 Large Growth 240.80 12.00 1.00 20.32 Average -2.71 24.20 4.02 0.43 1.34 Three 20 RF019 Large Growth 45.40 117.00 0.96 18.02 Low 7.35 23.81 3.05 5.25 1.04 Four 21 RF020 Large Growth 388.20 43.12 1.26 24.81 High -2.88 23.77 3.88 2.22 0.97 Five 22 RF021 Large Growth 477.30 19.00 1.11 20.94 Average 3.20 23.73 4.13 4.80 1.00 Four 23 RF022 Large Growth 1279.80 88.00 1.08 20.16 Average 1.32 23.70 3.46 4.41 0.88 Five 24 RF023 Large Growth 34.60 18.34 1.19 22.86 Average -4.74 23.47 2.13 4.77 1.47 Three 25 RF024 Large Growth 119.00 8.00 0.99 18.92 Low 1.92 23.40 3.00 5.00 1.55 Five 26 RF025 Large Growth 286.50 28.13 0.89 17.02 Low 6.57 23.23 4.52 3.85 1.24 Four 27 RF026 Large Growth 4213.40 182.00 1.10 21.20 Average 3.44 22.80 0.90 5.72 0.91 Three 28 RF027 Large Growth 33.50 28.00 1.12 21.18 Average -0.23 22.77 1.67 2.81 1.04 Five 29 RF028 Large Growth 6.70 40.00 1.11 21.80 Average -2.96 22.37 2.24 3.03 1.55 Three 30 RF029 Large Growth 859.70 72.00 1.05 19.72 Average 2.94 22.15 2.55 4.11 0.63 Five 31 RF030 Large Growth 61.90 6.00 0.91 16.96 Low 6.60 22.01 3.99 3.74 1.79 Four 32 RF031 Large Growth 3300.30 93.00 1.29 24.90 High -3.43 21.80 2.04 4.72 0.70 Five 33 RF032 Large Growth 2.00 26.00 1.03 19.56 Average 4.70 21.74 1.79 3.12 0.63 Three 34 RF033 Large Growth 947.70 75.00 1.01 19.38 Average 1.58 21.71 4.86 7.00 1.01 Five 35 RF034 Large Growth 6101.20 13.00 1.00 18.73 Low 5.00 21.65 3.38 2.70 1.00 Four 36 RF035 Large Growth 340.70 47.00 0.94 17.74 Low 7.97 21.62 4.12 3.31 1.32 Five 37 RF036 Large Growth 59.20 65.00 1.03 19.41 Average 3.43 21.34 1.95 3.56 1.08 Three K M A 38 RF037 39 RF038 40 RF039 41 RF040 42 RF041 43 RF042 44 RF043 45 RF044 46 RF045 47 RF046 48 RF047 49 RF048 50 RF049 51 RF050 52 RF051 53 RF052 54 RF053 55 RF054 56 RF055 57 RF056 58 RF057 59 RF058 60 RF059 61 RF060 62 RF061 63 RF062 64 RF063 65 RF064 66 RF065 67 RF066 68 RF067 69 RF068 70 RF069 71 RF070 72 RF071 73 RF072 74 RF073 B Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large C D Growth 720.60 Growth 676.70 Growth 1812.60 Growth 42.50 Growth 509.80 Growth 172.70 Growth 32.20 Growth 169.40 Growth 99.90 Growth 1046.20 Growth 28.90 Growth 218.90 Growth 22.80 Growth 940.30 Growth 512.70 Growth 12.00 Growth 37.10 Growth 84.00 Growth 132.10 Growth 434.60 Growth 2376.90 Growth 58729.30 Growth 96.60 Growth 23.20 Growth 86.70 Growth 24.60 Growth 61.20 Growth 1879.10 Growth 2171.30 Growth 192.90 Growth 84.60 Growth 8.20 Growth 3.60 Growth 28.90 Growth 33.50 Growth 94.30 Growth 1335.60 67.00 1.06 19.98 Average 16 1998 Average 257.00 0.95 18.15 Low 17.00 0.97 18.32 Low 203.00 1.21 24.20 High 277.00 0.98 18.53 Low 14.78 1.00 18.86 Low 37.58 1.05 19.47 Average 101.33 1.07 19.95 Average 35.00 0.97 18.27 Low 82.00 1.02 19.60 Average 159.31 0.98 18.47 Low 30.00 0.97 18.67 Low 65.96 1.01 19.34 Average 53.00 0.95 18.10 Low 88.42 1.04 19.12 Average 8.00 1.00 20.33 Average 20.00 0.94 17.42 Low 113.00 1.01 19.03 Average 79.00 0.99 18.76 Low 31.00 1.04 19.91 Average 9.00 1.07 19.80 Average 57.00 0.84 15.81 Low 6.20 0.93 17.12 Low 12.81 1.26 23.47 High 18.70 0.97 18.50 Low 75.38 1.09 20.65 Average 182.00 1.03 19.49 Average 109.00 0.99 18.44 Low 3.00 0.80 15.16 Low 18.00 1.00 18.42 Low 116.00 1.05 20.03 Average 92.00 0.98 18.31 Low 34.00 0.99 18.61 Low 453.00 0.92 16.88 Low 69.00 1.01 19.17 Average 39.00 0.99 19.20 Average 65.00 1.06 20.04 Average 4.09 1.24 5.27 -7.53 2.50 2.79 5.08 2.45 3.23 2.41 6.57 3.44 -1.95 6.60 0.59 5.93 1.51 1.65 4.33 0.09 -1.11 4.27 4.64 -2.68 4.19 4.03 -1.49 -1.55 1.72 0.55 -0.81 3.60 1.39 5.24 -1.66 7.96 2.32 21.24 21.21 20.96 20.94 20.83 20.71 20.86 20.63 20.62 20.55 20.27 20.23 20.07 19.63 19.46 19.39 19.23 19.16 19.13 19.08 18.92 18.87 18.77 18.46 18.38 18.34 18.28 18.12 18.01 17.98 17.98 17.94 17.76 17.69 17.63 17.53 17.43 0.23 -1.46 3.58 -2.38 4.41 0.79 1.84 1.27 1.84 0.46 4.90 2.72 1.88 3.08 -0.13 -1.08 0.22 1.62 -0.36 0.44 -0.07 3.15 3.02 -0.88 1.52 -1.02 -0.94 -0.51 4.39 0.76 -0.30 3.00 0.90 0.82 1.22 2.93 -0.33 4.01 4.23 2.46 -0.03 3.84 2.45 3.28 1.83 3.16 4.32 5.84 3.78 4.87 6.83 2.21 1.11 2.68 2.58 2.21 1.32 3.38 7.54 4.52 4.28 1.83 3.30 2.06 4.46 8.03 5.65 3.64 3.64 1.05 4.42 2.48 3.71 3.10 N 1.33 Five 0.71 Three 1.01 Four 2.08 Five 0.93 Four 1.32 Five 2.08 Three 1.45 Five 1.42 Three 1.33 Five 2.08 Four 1.18 Five 1.64 Three 1.05 Five 1.05 Two 4.22 Five 1.10 Three 1.28 Five 0.87 Two 1.47 Five 0.80 Three 0.92 Five 1.14 Five 1.22 Two 1.33 Five 1.59 Two 1.13 Five 0.83 Three 1.14 Five 1.02 Three 1.29 Five 1.16 Four 1.53 Three 1.91 Five 1.11 Three 1.53 Five 0.90 Three 75 RF074 76 RF075 77 RF076 78 RF077 79 RF078 80 RF079 81 RF080 82 RF081 83 RF082 84 RF083 85 RF084 86 RF085 87 RF086 88 RF087 89 RF088 90 RF089 91 RF090 92 RF091 93 RF092 94 RF093 95 RF094 96 RF095 97 RF096 98 RF097 99 RF098 100 RF099 101 RF100 102 RF101 103 RF102 104 RF103 A B Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large C D Growth 0.40 Growth 182.00 Growth 463.70 Growth 13320.90 Growth 272.20 Growth 2442.60 Growth 13.60 Growth 2100.30 Growth 1698.10 Growth 279.60 Growth 2.80 Growth 19.40 Growth 57.90 Growth 6.60 Growth 0.60 Growth 399.10 Growth 343.70 Growth 7.50 Growth 5.10 Growth 16.00 Growth 16.80 Growth 1.90 Growth 168.70 Growth 23.50 Growth 50.70 Growth 145.70 Growth 91.60 Growth 13.60 Growth 55.30 Growth 105.90 E F G H 70.00 1.05 20.14 Average 51.00 1.03 19.26 Average 86.00 1.15 21.90 Average 102.00 1.16 21.93 Average 48.00 1.04 19.27 Average 7.00 0.90 16.96 Low 24.00 0.97 18.12 Low 90.00 0.98 18.29 Low 63.48 0.84 15.58 Low 25.36 0.92 17.06 Low 44.00 1.01 18.62 Low 293.00 0.90 17.11 Low 74.00 1.08 20.54 Average 194.00 0.87 16.20 Low 138.00 0.91 17.21 Low 57.00 0.94 17.67 Low 48.56 0.99 18.45 Low 271.00 0.85 16.79 Low 45.00 0.86 16.41 Low 312.62 1.09 21.99 Average 127.00 0.86 16.32 Low 47.00 0.94 17.68 Low 17.00 0.91 17.23 Low 15.00 0.84 15.78 Low 10.00 1.06 20.36 Average 28.00 0.71 14.58 Low 74.00 0.85 16.10 Low 47.00 0.93 17.45 Low 116.00 0.92 18.26 Low 62.40 0.81 15.52 Low I -6.25 3.33 -8.49 -7.74 -3.62 2.97 0.19 -0.63 4.67 4.04 0.02 0.05 -4.48 8.60 1.28 2.51 -0.72 7.56 1.46 -17.63 1.47 1.82 3.81 1.21 -8.44 -0.26 2.64 -1.35 -7.29 2.62 17.25 17.25 17.25 17.17 16.86 16.68 16.61 16.59 16.41 16.32 15.96 15.92 15.89 15.65 15.51 15.50 15.44 14.96 14.67 14.39 14.36 14.33 14.28 14.02 13.23 13.11 11.94 11.54 11.51 11.19 2167.44 2.13 1.00 -2.78 -2.76 1.57 2.31 1.29 0.78 3.79 1.87 0.63 -0.62 -4.15 1.41 -0.17 -0.65 -0.45 1.29 -1.64 -1.55 0.69 -1.29 -0.03 0.81 -3.06 2.50 1.57 -2.77 -1.13 0.69 2.07 2.98 6.66 0.76 2.98 3.48 3.32 2.31 2.92 3.38 3.09 2.72 1.31 3.17 5.30 2.33 3.19 2.98 0.19 2.46 3.17 -0.08 1.49 4.95 -1.59 6.46 3.53 0.59 3.33 3.47 N 1.11 Five 0.88 Three 1.37 Five 0.60 One 1.26 Three 0.92 Five 2.37 Three 0.90 Five 1.09 Four 1.00 Five 0.63 Three 1.00 Five 1.52 One 1.12 Five 0.97 Two 1.20 Five 1.15 Two 1.11 Five 0.95 Two 1.35 Five 2.57 Three 1.62 Five 1.21 Two 1.01 Five 1.86 One 0.98 Five 0.93 Three 2.47 Five 1.71 Two 1.24 Five 105 11.51 4.18 5.38 2.88 3.26 7.27 4.78 6.77 2.73 4.24 3.76 3.27 1.77 106 RF104 107 RF105 108 RF106 109 RF107 110 RF108 111 RF109 112 RF110 113 RF111 114 RF112 115 RF113 116 RF114 117 RF115 118 RF116 119 RF117 120 RF118 121 RF119 122 RF120 123 RF121 124 RF122 125 RF123 126 RF124 127 RF125 128 RF126 129 RF127 130 RF128 131 RF129 132 RF130 133 RF131 134 RF132 135 RF133 136 RF134 137 RF135 138 RF136 139 RF137 140 RF138 141 RF139 Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value 4946.30 119.90 1508.21 989.40 554.20 2.00 560.00 1682.40 95.70 47.80 70.30 1.40 35.20 6847.10 32.60 16.30 26.60 1288.60 3666.40 106.10 4293.60 82.90 92.30 22.60 504.30 23.60 0.30 14.60 182.40 219.00 112.90 31.70 164.60 1704.40 5.90 4.90 3.05 0.94 20.03 Average 40.00 1.09 22.31 Average 56.00 0.93 17.81 Low 21.00 0.92 17.72 Low 78.38 0.97 18.45 Low 68.00 1.12 21.20 Average 37.51 1.17 21.45 Average 14.00 0.98 17.87 Low 167.00 0.88 16.91 Low 26.76 1.20 22.12 Average 21.00 0.66 13.17 Low 72.27 1.03 19.03 Average 40.00 1.12 21.33 Average 36.00 1.17 21.46 Average 59.00 1.21 22.17 Average 142.75 0.93 17.74 Low 47.00 1.05 19.25 Average 20.00 0.93 17.26 Low 90.00 1.11 20.22 Average 184.00 1.19 22.58 Average 82.00 1.15 21.16 Average 34.33 0.95 17.58 Low 8.16 1.02 18.86 Low 17.57 0.85 16.40 Low 28.00 1.02 18.66 Low 59.07 0.95 17.41 Low 24.00 1.09 20.03 Average 17.36 1.08 19.89 Average 169.00 1.06 19.93 Average 20.00 0.70 12.91 Low 37.00 1.01 18.55 Low 733.00 1.08 19.82 Average 85.09 1.10 20.51 Average 32.00 0.92 16.98 Low 22.00 1.01 19.26 Average 14.00 0.78 14.58 Low 8.72 6.11 8.74 8.49 6.10 3.34 0.42 3.46 15.14 -0.87 12.07 4.47 -2.12 -4.15 -0.87 2.70 0.40 0.11 -0.55 -7.47 -2.72 1.46 4.22 5.20 3.11 6.35 1.20 0.55 3.86 6.86 3.06 -0.70 -0.35 2.36 -0.28 31.25 27.03 23.49 21.94 21.76 21.26 20.93 20.02 20.01 19.46 18.94 18.87 18.83 18.25 18.21 18.04 17.95 17.87 17.78 17.88 17.63 17.34 17.42 16.86 16.67 16.65 16.55 16.35 16.23 16.15 16.04 15.98 15.97 15.94 15.81 15.53 9.30 -0.38 0.49 -2.56 0.69 -2.96 -1.78 2.13 -1.40 -2.26 0.32 -0.61 -1.39 -2.98 -3.44 0.42 1.98 1.13 -1.86 0.59 -2.84 0.85 -1.08 4.58 -2.76 0.16 -1.67 -1.55 -0.76 3.22 -2.98 -4.39 -5.80 -0.58 -1.83 -0.53 2.96 2.99 4.44 8.45 3.76 5.11 5.37 2.88 6.23 2.58 1.27 Five 1.30 Three 0.84 Five 1.21 Three 1.10 Five 1.32 Three 1.20 Five 1.41 Five 0.83 Five 1.19 Three 1.34 Five 1.12 Three 1.51 Five 0.69 Two 1.39 Five 3.99 Four 1.28 Five 0.91 Four 0.97 Five 0.96 Four 0.88 Five 1.10 Four 1.04 Five 1.28 Four 0.87 Five 1.19 Four 7.28 Five 2.36 Three 1.29 Five 1.25 Five 1.11 Five 1.89 Two 1.44 Five 1.01 Four 1.47 Five 2.75 Five 4.87 3.39 5.19 2.41 3.69 3.39 6.22 3.11 4.37 1.05 4.81 1.40 7.59 3.90 L M 142 RF140 143 RF141 144 RF142 145 RF143 146 RF144 147 RF145 148 RF146 149 RF147 150 RF148 151 RF149 152 RF150 153 RF151 154 RF152 155 RF153 156 RF154 157 RF155 158 RF156 159 RF157 160 RF158 161 LBC D Large Value 920.00 Large Value 124.20 Large Value 458.40 Large Value 26.80 Large Value 8.50 Large Value 126.20 Large Value 126.70 Large Value 346.00 Large Value 340.70 Large Value 15.10 Large Value 1677.80 Large Value 463.00 Large Value 497.90 Large Value 1643.70 Large Value 8.90 Large Value 80.90 Large Value 28.60 Large Value 69.80 Large Value 189.60 F G H 38.00 0.99 18.51 Low 35.00 1.07 19.82 Average 19.00 1.04 19.32 Average 2.00 0.74 13.98 Low 161.85 0.86 16.23 Low 33.68 1.18 21.78 Average 149.00 1.02 18.85 Low 0.00 0.70 13.86 Low 141.00 1.17 21.70 Average 92.40 0.68 16.26 Low 26.00 1.05 19.64 Average 196.00 1.08 19.63 Average 11.63 0.94 18.02 Low 26.00 0.98 18.04 Low 43.00 0.94 17.23 Low 80.00 0.67 13.58 Low 31.68 0.69 13.51 Low 55.00 0.96 17.95 Low 33.85 0.55 11.68 Low 4.86 -0.92 3.85 6.32 5.43 -7.21 2.44 10.07 -0.07 1.89 -2.07 1.85 -2.55 -2.74 1.73 6.82 4.50 0.22 -1.40 15.51 15.49 15.36 15.34 15.23 15.16 14.98 14.96 14.93 14.85 14.45 14.27 14.25 13.94 13.22 12.12 11.32 11.21 9.82 939.30 K -2.19 -1.35 -3.77 -0.78 -1.51 -3.03 -1.77 0.41 -5.22 -0.27 -1.30 -4.06 -5.85 1.04 -1.74 3.93 3.08 -2.23 3.28 5.36 3.27 5.85 5.71 3.63 2.81 2.85 6.34 2.74 3.40 4.53 2.92 2.22 6.72 5.22 3.97 5.28 2.77 5.06 1.06 Three 1.41 Five 1.11 Two 0.98 Five 2.86 Four 1.23 Five 1.41 Two 1.48 Five 0.75 One 2.03 Five 0.95 Five 0.73 Two 1.24 Five 1.11 Four 1.09 Five 1.68 Four 1.86 Five 1.28 Three 1.28 Five 6.21 8.46 5.92 7.30 4.73 6.42 9.03 11.16 4.66 9.62 5.78 7.66 5.92 162 RF159 163 RF160 164 RF161 165 RF162 166 RF163 167 RF164 168 RF165 169 RF166 170 RF167 171 RF168 172 RF169 173 RF170 174 RF171 175 RF172 176 RF173 177 RF174 178 RF175 179 RF176 180 RF177 181 RF178 182 RF179 183 RF180 184 RF181 185 RF182 186 RF183 187 RF184 188 RF185 189 RF186 190 RF187 191 RF188 192 RF189 193 RF190 194 RF191 195 RF192 196 RF193 197 RF194 198 RF195 | B Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap C Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 29.90 274.10 3.20 184.10 18.80 4.40 354.70 31.80 5222.40 261.80 136.20 766.30 101.90 495.40 651.10 841.80 42.30 708.40 5.70 75.40 108.20 1.50 252.10 35.50 8.20 95.40 9.20 70.90 2403.00 319.50 168.30 27.90 0.60 4352.50 94.00 28.30 696.30 F G H 205.00 1.27 26.54 High 147.00 1.18 23.49 High 178.00 1.11 21.66 Average 20.00 1.20 23.08 High 27.84 1.00 20.12 Average 25.10 1.00 19.96 Average 111.00 1.07 21.49 Average 9.00 1.02 20.47 Average 66.00 1.17 22.45 Average 65.43 1.05 20.43 Average 19.00 1.16 23.56 High 19.00 1.04 19.97 Average 56.00 1.22 23.41 High 104.00 1.20 23.62 High 13.00 0.99 20.94 Average 41.00 1.10 21.03 Average 39.00 1.04 21.24 Average 15.00 1.07 21.18 Average 426.00 1.10 21.01 Average 30.33 1.09 21.44 Average 21.00 1.08 21.94 Average 133.00 1.14 21.94 Average 191.00 1.17 22.48 Average 24.00 0.95 19.40 Average 65.00 1.01 19.89 Average 35.00 0.92 17.92 Low 50.74 1.11 21.99 Average 34.00 1.11 21.46 Average 95.00 1.10 21.72 Average 7.00 0.96 18.10 Low 104.00 1.10 21.79 Average 159.00 0.79 16.19 Low 97.00 1.27 24.13 High 13.51 1.01 19.90 Average 79.00 1.05 21.08 Average 18.66 1.09 21.52 Average 66.00 1.23 23.61 High I -3.66 6.76 8.97 4.03 7.52 11.77 7.15 3.13 2.03 -3.21 -5.22 3.03 -2.95 -3.08 8.29 3.38 3.97 0.87 2.35 5.67 0.60 0.34 -1.82 7.07 5.50 7.29 -0.25 4.05 -0.47 9.63 -0.37 11.80 -0.75 4.08 2.39 2.86 -8.64 34.18 32.52 30.80 29.41 29.31 28.78 28.55 27.50 26.90 26.65 26.23 26.11 26.10 26.05 25.94 25.93 25.89 25.37 25.13 24.78 24.77 24.74 24.89 24.60 24.46 24.38 24.38 24.32 23.96 23.95 23.94 23.87 23.83 23.58 23.27 23.20 23.18 4.59 8.17 2.62 5.66 5.17 6.43 5.95 8.62 1.63 4.47 2.77 4.71 2.52 2.88 3.01 4.95 4.60 3.59 4.04 3.99 6.01 3.93 -1.52 5.50 2.17 3.12 4.23 4.60 6.01 4.00 2.29 4.97 0.73 1.80 5.48 2.57 4.40 4.96 11.76 7.87 7.46 7.13 4.91 5.93 6.62 5.11 3.18 6.21 0.91 5.38 6.38 7.38 8.35 7.30 4.93 8.06 4.05 7.48 4.80 12.04 5.97 MN 2.12 Three 1.55 Five 3.03 Four 1.37 Five 1.65 Four 1.56 Five 1.41 Five 1.98 Five 0.61 Two 1.41 Five 2.12 Five 0.94 Four 1.05 Five 1.28 Three 1.52 Five 1.38 Four 1.46 Five 1.04 Three 1.78 Five 1.51 Three 1.95 Five 1.13 Three 0.79 Five 1.42 Five 1.79 Five 1.04 Four 2.03 Five 1.31 Four 1.01 Five 1.23 Five 1.40 Five 2.00 Five 1.21 Five 1.32 Three 1.23 Five 1.47 Three 1.08 Five N B Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap 2A 199 RF196 200 RF197 201 RF198 202 RF199 203 RF200 204 RF201 205 RF202 206 RF203 207 RF204 208 RF205 209 RF206 210 RF207 211 RF208 212 RF209 213 RF210 214 RF211 215 RF212 216 RF213 217 RF214 218 RF215 219 RF216 220 RF217 221 RF218 222 RF219 223 RF220 224 RF221 225 RF222 226 RF223 227 RF224 228 C Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 146.70 970.40 613.80 267.10 287.60 1619.50 61.80 174.00 176.80 1948.30 2.50 3507.40 110.60 22.80 26.50 38.80 Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap F G H. 26.98 1.11 21.60 Average 10.77 1.21 23.77 High 87.00 1.18 22.59 Average 60.44 1.15 22.16 Average 16.00 0.95 18.59 Low 165.00 1.15 22.20 Average 17.99 0.98 18.46 Low 12.00 0.92 17.52 Low 5.00 1.00 19.50 Average 23.89 1.05 20.27 Average 64.00 1.16 22.77 Average 18.00 0.93 18.02 Low 27.93 0.88 17.24 Low 62.00 1.04 20.46 Average 132.20 1.20 22.88 Average 59.00 1.01 19.62 Average 127.00 1.17 22.35 Average 57.00 1.13 21.62 Average 111.00 1.09 21.73 Average 54.00 1.27 24.54 High 246.00 0.95 18.40 Low 7.00 0.76 15.42 Low 77.00 0.99 19.39 Average 90.00 1.02 20.70 Average 280.00 1.07 21.65 Average 150.00 0.82 16.16 Low 205.00 0.59 13.31 Low 241.00 0.97 20.53 Average 250.10 0.89 19.67 Average 0.92 -3.60 -0.57 1.00 11.54 -2.32 3.99 6.30 7.15 0.21 -4.67 7.16 3.67 1.80 -4.40 2.79 -3.57 -2.61 -3.82 -0.32 8.67 10.95 -1.71 -2.49 9.45 -0.80 -3.72 -11.42 -16.04 22.91 22.78 22.71 22.66 22.54 22.34 22.28 22.17 22.04 21.65 21.34 21.32 20.37 20.37 20.04 19.80 19.68 19.51 19.38 19.14 17.91 17.11 16.07 15.51 14.61 12.01 8.77 6.85 3.39 1498.71 2.21 -1.60 0.65 2.82 2.70 0.46 4.01 2.31 4.62 0.31 -0.59 5.94 3.38 4.78 1.45 1.46 -1.17 1.27 1.61 -2.39 0.79 -2.11 -0.59 0.27 0.45 2.13 2.76 -4.68 -0.03 4.81 8.28 3.80 5.93 6.73 1.36 6.18 5.99 9.93 6.18 2.51 9.76 4.88 6.89 6.00 5.12 3.71 6.56 9.47 1.25 Three 1.71 Five 1.13 Two 1.30 Five 1.21 Three 0.79 Five 1.46 Four 1.25 Five 1.50 Four 1.33 Five 2.76 Two 1.14 Five 0.99 Four 2.47 Five 1.15 Three 1.22 Five 1.31 Two 2.01 Five 1.24 Three 3.22 Five 1.17 Three 1.31 Five 1.94 Two 1.01 Five 1.26 Two 1.30 Five 1.81 Three 1.25 Five 3.92 Two 0.72 9.70 34.60 11.50 9.10 135.40 38.40 1208.70 75.80 150.60 70.50 129.60 2.68 0.53 2.92 5.02 3.63 7.82 2.07 2.00 2.25 229 RF225 230 RF226 231 RF227 232 RF228 233 RF229 234 RF230 235 RF231 236 RF232 237 RF233 238 RF234 239 RF235 240 RF236 241 RF237 242 RF238 243 RF239 244 RF240 245 RF241 246 RF242 247 RF243 248 I B Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap Mid-Cap C Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value D 18.30 28.00 1352.30 5926.30 2.50 21.00 37.10 554.00 4.60 13.20 1546.10 92.70 131.20 196.90 1452.00 47.50 44.70 6.50 601.90 F G H 26.00 1.46 28.97 High 381.00 1.57 32.05 High 38.00 1.44 28.42 High 95.00 1.38 25.91 High 107.00 1.24 23.09 High 27.00 1.33 24.86 High 82.00 0.86 16.31 Low 185.00 1.18 22.50 Average 32.00 1.25 23.51 High 55.00 1.07 20.06 Average 41.00 0.99 18.64 Low 44.00 1.12 21.38 Average 37.00 1.18 21.97 Average 68.05 0.76 15.86 Low 43.00 0.93 17.47 Low 134.34 1.33 25.48 High 21.00 1.02 18.99 Low 678.00 1.18 22.53 High 29.00 1.12 20.74 Average 0.81 0.44 0.57 -3.26 2.16 -4.86 6.37 -1.04 -0.89 2.88 5.16 3.37 -3.82 4.86 2.81 - 1.19 1.85 -0.80 -2.66 35.01 30.04 29.83 25.33 25.00 24.89 24.18 23.88 23.85 22.85 21.81 21.74 21.62 21.61 20.74 20.73 20.68 20.49 20.12 454.40 2.73 -2.87 4.82 -1.41 1.06 -0.14 0.64 0.29 -0.61 1.01 2.17 -0.46 0.44 6.17 3.35 -1.37 -1.34 -0.33 2.35 4.46 2.03 10.09 6.41 3.65 6.44 3.88 6.71 6.60 4.55 8.90 6.35 5.98 6.68 8.20 4.62 5.43 5.42 7.77 MN 2.07 Three 1.54 Five 1.29 Four 0.60 Five 1.28 Three 1.55 Five 1.76 Four 0.91 Five 1.40 Two 1.26 Five 1.15 Five 1.43 Five 1.25 Three 1.70 Five 1.01 Four 1.71 Five 1.27 Two 1.87 Five 1.23 Four M -0.28 13.36 16.22 5.10 3.86 6.05 3.58 7.70 11.32 4.11 7.65 6.97 2.98 7.82 1.44 3.85 5.66 5.91 8.66 249 RF244 250 RF245 251 RF246 252 RF247 253 RF248 254 RF249 255 RF250 256 RF251 257 RF252 258 RF253 259 RF254 260 RF255 261 RF256 262 RF257 263 RF258 264 RF259 265 RF260 266 RF261 267 RF262 268 RF263 269 RF264 270 RF265 271 RF266 272 RF267 273 RF268 274 RF269 275 RF270 276 RF271 277 RF272 278 RF273 279 RF274 280 RF275 281 RF276 282 RF277 283 RF278 284 RF279 285 RF280 B Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small C Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 2.90 36.00 450.20 8.10 244.10 1014.10 20.10 147.90 140.90 508.40 366.70 251.00 19.90 294.40 11.60 118.10 170.80 38.70 1168.70 34.50 223.50 89.20 3.70 63.00 271.00 331.10 7.10 116.10 12.90 97.10 2564.00 212.80 173.00 316.10 205.30 3066.00 13.10 E F G H 232.00 1.41 29.58 High 16.00 1.17 24.49 High 80.26 1.06 21.60 Average 70.00 1.22 24.86 High 54.00 1.06 21.25 Average 42.00 1.02 20.21 Average 180.00 1.44 28.43 High 60.00 0.92 18.96 Low 79.00 1.11 22.60 Average 27.00 1.01 20.02 Average 101.00 1.23 24.65 High 55.00 1.11 22.16 High 209.00 1.25 25.64 High 30.00 1.09 21.48 Average 92.00 1.14 24.22 High 75.00 1.05 21.59 Average 76.00 1.02 20.41 Average 147.00 1.23 24.51 High 106.00 1.21 23.52 High 24.64 0.94 18.78 Low 14.00 1.08 21.24 Average 42.00 1.01 22.33 High 18.00 1.06 20.52 Average 51.00 1.21 25.31 High 119.00 1.27 25.18 High 7.00 1.22 23.69 High 48.00 1.18 23.38 High 85.00 1.22 24.16 High 530.00 1.15 22.71 Average 14.00 1.13 23.86 High 82.00 1.18 22.48 Average 18.03 1.01 20.55 Average 74.00 1.03 21.12 Average 17.01 1.12 22.04 Average 46.00 1.31 26.64 High 32.81 1.05 20.51 Average 199.00 1.49 29.22 High 14.64 11.58 2.77 8.86 9.01 1.33 0.65 5.07 6.94 11.94 2.77 5.57 4.75 -0.39 7.73 -5.48 -0.20 -0.59 5.82 5.78 6.76 -0.10 1.09 8.58 3.55 4.09 -5.68 1.52 -1.74 35.13 33.99 31.46 31.40 31.19 31.04 30.43 30.33 29.83 29.31 29.21 27.76 27.33 27.03 26.75 25.77 25.37 25.30 25.08 24.93 24.90 24.84 24.72 24.82 24.61 24.61 24.30 24.21 24.06 23.72 23.86 23.61 23.31 23.19 23.17 23.12 23.10 2.14 -1.21 3.35 0.38 3.20 8.12 5.12 1.55 5.69 2.62 6.45 0.90 3.41 -0.59 4.18 2.05 6.00 1.05 3.00 6.22 3.82 6.19 2.89 -3.91 3.07 5.40 2.45 2.93 2.62 7.38 1.79 5.62 2.33 5.90 -1.18 2.18 -2.11 5.00 5.64 6.33 5.86 7.73 5.24 6.48 8.17 6.90 4.17 11.26 4.40 2.29 6.01 10.96 6.14 4.36 5.88 7.91 4.53 10.57 8.03 7.12 6.90 7.82 1.04 IN 2.76 Three 1.55 Five 1.66 Four 2.47 Five 0.96 Four 0.94 Five 1.58 Three 1.43 Five 1.51 Five 1.31 Five 1.46 Four 1.58 Five 1.55 Three 2.16 Five 1.57 Three 1.50 Five 1.27 Four 1.68 Five 0.95 Three 1.25 Five 1.25 Five 2.19 Four 1.90 Five 1.39 One 1.53 Five 1.50 Four 2.18 Five 1.98 Three 1.78 Five 2.11 Five 1.45 Three 1.27 Five 1.57 Five 1.13 Four 1.52 Five 1.31 Five 3.73 One M N 286 RF281 287 RF282 288 RF283 289 RF284 290 RF285 291 RF286 292 RF287 293 RF288 294 RF289 295 RF290 296 RF291 297 RF292 298 RF293 299 RF294 300 RF295 301 RF296 302 RF297 303 B Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth Growth D 68.80 185.40 88.60 182.60 5.80 480.10 7.70 159.80 11.20 0.70 1510.80 25.10 21.80 91.20 258.50 159.10 31.00 F G H 43.00 1.12 22.31 Average 7.54 1.12 22.30 Average 27.00 1.06 20.85 Average 107.00 1.25 25.01 High 195.00 1.49 29.20 High 26.34 1.18 23.14 High 194.26 1.11 22.39 Average 108.00 1.29 26.19 High 160.00 1.08 22.58 Average 112.00 1.39 27.79 High 28.00 1.18 23.46 High 197.43 1.45 30.69 High 37.00 1.30 26.68 High 122.00 1.18 23.46 High 63.00 1.12 22.96 Average 26.00 1.38 27.54 High 133.00 1.14 22.54 High I 1.24 4.06 0.42 1.03 -2.52 0.28 1.89 0.36 -3.22 -7.98 -1.06 - 10.23 -5.04 -1.22 3.04 -8.38 -9.80 J 22.95 22.78 22.69 22.32 22.20 21.75 21.67 21.65 21.46 21.36 21.23 21.13 21.11 20.53 18.01 15.67 12.14 1337.44 4.45 2.21 -3.26 3.00 -2.52 -0.40 0.33 2.95 1.01 0.41 0.08 -1.01 -3.58 0.82 0.42 -7.19 -3.87 5.37 4.82 4.20 4.17 3.91 2.01 2.45 7.09 3.71 0.37 10.29 0.07 5.93 2.58 6.33 1.34 Five 1.39 Five 1.64 Two 1.51 Five 4.82 One 1.41 Five 1.46 Two 1.42 Five 3.63 Three 1.31 Five 1.44 Three 1.64 Five 1.89 Two 1.39 Five 1.03 Three 1.64 Five 1.49 Two 2.31 3.21 A L M 14.32 -4.14 -5.16 0.55 4.79 -1.13 -2.39 -5.06 3.36 304 RF298 305 RF299 306 RF300 307 RF301 308 RF302 309 RF303 310 RF304 311 RF305 312 RF306 313 RF307 314 RF308 315 RF309 316 RF310 317 RF311 318 RF312 319 RF313 320 RF314 321 RF315 322 RF316 323 RF317 324 RF318 325 B Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small Small C Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value Value D 181.60 84.80 180.40 82.50 206.50 83.90 39.10 76.20 77.50 1692.80 845.90 121.30 155.00 44.70 1126.80 680.80 1698.90 22.30 9.00 68.50 83.60 E F G H 155.00 1.20 30.27 High 135.00 1.18 27.10 High 164.00 1.03 32.31 High 195.00 0.85 42.87 High 141.00 1.14 27.05 High 125.00 1.21 25.04 High 158.00 0.95 32.02 High 131.00 1.10 25.66 High 125.00 1.10 24.53 High 124.00 1.04 24.47 High 134.00 0.99 25.78 High 123.00 1.01 23.91 High 94.00 1.24 18.42 Low 117.00 1.00 22.76 Average 119.00 0.97 23.77 High 86.00 1.27 16.65 Low 123.00 0.95 23.68 High 127.00 0.68 24.86 High 131.00 0.85 25.14 High 101.00 0.98 20.16 Average 124.00 0.85 23.62 High 1.16 1.66 4.87 13.44 -0.22 -1.36 5.02 5.64 4.63 -1.34 0.32 -3.77 37.19 32.58 32.51 32.21 31.25 31.19 29.11 28.36 26.96 25.27 24.99 23.71 23.46 22.44 22.39 21.81 21.74 20.90 20.13 19.37 19.06 546.63 K 9.37 5.82 1.32 -4.14 1.61 5.08 -1.65 1.85 1.85 3.82 1.58 -1.50 0.88 2.13 -0.29 12.18 1.35 -0.92 -0.94 4.42 2.16 11.90 10.83 8.50 2.19 7.91 8.16 3.81 7.46 7.56 8.97 8.77 6.85 9.23 6.55 7.58 12.30 8.43 4.44 6.45 9.69 9.13 N 1.35 Four 1.40 Five 1.47 Two 1.54 One 1.53 Three 1.66 Five 1.55 Two 1.09 Five 1.62 Three 1.13 Five 1.19 Three 1.34 Five 1.50 Four 1.57 Five 1.14 Three 1.46 Five 1.36 Three 1.96 Five 1.87 Two 1.28 Five 1.60 Three Part 2 - Two Sample Hypothesis Testing Using the Retirement funds spreadsheet, please determine if there is a significant difference between the average rate of return on Large Value and Large Growth stock funds. I. What are the two variables of interest? J. Write a null and alternative hypothesis statement K. At the 95% significance level, is there significant evidence of a difference between fund rate of returns? L. Do you accept or reject the null hypothesis? M. Based upon your answer above, provide us with a paragraph (3-4 sentence) conclusion that would be appropriate to explain the results to a senior executive that isn't as familiar with statistics as you are