9.31 6.21 3.84 3.59 797 3.66 5.87 4.81 3.73 171 3.15 4.77 3.85 6.57 3.44 2 24 4.11 3.99 1 und Numbelarket Ca Type Assetsurnover Rat Bete SD Risk YrReturn: YrReturn: YrReturn:DYrReturnepense Ratitar Rating 2 RF001 Large Growth 15.00 0.00 2.17 ### High 13.88 62.91 3.12 -2.30 1.93 Three 3 RF002 Large Growth 106.50 34.00 ## ### High 10.49 54.79 3.25 -0.73 1.61 Five RF003 Large Growth 144.50 76.00 ## ### High 10.10 54.75 3.33 -0.61 1.82 Two RF004 Large Growth 73.60 11.49 1.10 21.81 Averag. 13.72 38.84 1.73 6.71 1.21 Five 6 RF005 Large Growt 1104.40 19.00 1.04 ### Averag. 8.03 33.65 6.34 5.51 1.53 Five 7 RF006 Large Growth 443.60 231.00 ## ### Low 1.26 33.18 8.62 1.41 Five 8 RF007 Large Growth 88.00 27.00 1.28 ### High 2.44 32.45 6.59 2.50 1.33 Three 9RF008 Large Growth 6101.30 158.00 1.13 ### 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 4.03 1.31 Five 11 RF010 Large Growth 30.30 318.00 1.11 21.12 Average 3.52 27.17 1.55 Four 12 RF011 Large Growth 227.30 27.99 1.18 ### Averag -1.01 26.97 6.78 1.25 Five RF012 Large Growth 28.20 62.00 1.00 ### Averag. 6.98 26.40 5.52 1.65 Four 14 RF013 Large Growth 1874.80 69.00 1.03 ### Averag. 25.50 3.87 1.00 Five 15 RF014 Large Growth 335.40 12.00 1.06 ### Averag 5.15 24.97 3.47 5.98 0.59 Four 16 RF015 Large Growth 0.60 157.00 1.14 ### Average 24.85 1.33 4.59 2.54 Five 17 RF016 Large Growth ##### 132.00 1.08 ### Average 24.72 3.98 0.94 Four 18 RF017 Large Growth 1100.40 92.00 1.03 19.41 Averag. 4.30 24.64 3.61 5.31 0.83 Five 19RF018 Large Growth 240.80 12.00 1.00 ### Averag. -2.71 24.20 4.02 0.43 1.34 Three 20 RF019 Large Growth 45.40 117.00 ## ### Low 735 23.81 3.05 5.25 104 Four 21 RF020 Large Growth 388.20 43.12 1.26 ### High -2.88 23.77 3.88 2.22 0.97 Five 22 RF021 Large Growth 477.30 19.00 1.11 ### Averag. 3.20 23.73 4.13 4.80 1.00 Four 23 RF022 Large Growth 1279.80 88.00 1.08 ### Averag 1.32 23.70 3.46 4.41 0.88 Five 24 RF023 Large Growth 34.60 18.34 1.19 ### Averag. -4.74 23.47 2.13 1.47 Three 25 RF024 Growth 119.00 8.00 ## ### Low 1.92 23.40 3.00 5.00 1.55 Five 26 RF025 Large Growth 286.50 28.13 ## ### Low 23.23 4.52 1.24 Four 27 RF026 Large Growth 4213.40 182.00 1.10 ### Average 22.80 0.90 5.72 0.91 Three 28 RF027 Large Growth 33.50 28.00 1.12 21.18 Averag, -0.23 22.77 1.67 2.81 1.04 Five 29 RF028 Large Growth 6.70 40.00 1.11 ### Averag -2.96 22.37 3.03 1.55 Three 30 RF029 Large Growth 859.70 72.00 1.05 ### Averag, 2.94 22.15 2.55 0.63 Five 31 RF030 Large Growth 61.90 6.00 0.91 ### Low 6.60 22.01 3.74 1.79 Four 32 RF031 Large Growth ##### 93.00 1.29 ### High -3.43 21.80 2.04 4.72 0.70 Five 33 RF032 Large Growth 2.00 26.00 1.03 ### Averag 4.70 21.74 1.79 3.12 0.63 Three 34 RF033 Large Growth 947.70 75.00 1.01 ### Averag. 158 2171 4.86 7.00 101 Five 35 RF034 Large Growth 6101.20 13.00 1.00 ### Low 5.00 21.65 3.38 2.70 100 Four 36 RF035 Large Growth 340.70 47.00 ## ### Low 7.97 21.62 4.12 3.31 1.32 Five 37 RF036 Large Growth 59.20 65.00 1.03 19.41 Averag. 3.43 21.34 1.95 3.56 108 Three 38 RF037 Large Growth 720.60 67.00 1.06 ### Average 4.09 21.24 0.23 4.01 133 Five 39 RF038 Large Growth 676.70 257.00 ## 18.15 Low 1.24 21.21 -1.46 4.23 0.71 Three 40 RF039 Large Growth 1812.60 17.00 ## ### Low 5.27 20.96 3.58 2.46 1.01 Four 41 RF040 Growth 42.50 203.00 1.21 ### High -7.53 20.94 -2.38 -0.03 2.08 Five 42 RF041 Large Growth 509.80 277.00 ## ### Low 2.50 20.83 4.41 093 Four 43 RF042 Large Growth 172.70 Growth 14.78 1.00 ### Low 2.79 20.71 0.79 2.45 1.32 Five 44 RF043 Large Growth 32.20 37.58 1.05 ### Averag 5.08 20.86 1.84 2.08 Three 45 RF044 Large Growth 169.40 101.33 1.07 ### Average 2.45 20.63 1.27 1.83 1.45 Five 46 RF045 Large Growth 99.90 35.00 ## ### Low 3.23 20.62 1.84 3.16 142 Three 47 RF046 Large Growth 1046.20 82.00 1.02 ### Average 20.55 0.46 133 Five 48 RF047 Large Growth 28,90 159.31 ## ### Low 6.57 20.27 4.90 5.84 2.08 Four 49 RF048 Large Growth 218.90 30.00 ## ### Low 20.23 2.72 1.18 Five 50 RF049 Large Growth 22.80 65.96 1.01 ### Average -195 20.07 1.88 1.64 Three 51 RF050 Large Growth 940.30 53.00 ## 18.10 Low 19.63 6.83 1.05 Five 52 RF051 Large Growth 512.70 88.42 1.04 19.12 Averag. 19.46 -0.13 2.21 1.05 Two 53 RF052 Large Growth 12.00 8.00 1.00 ### Average 5.93 1939 -1.08 4.22 Five 54 RF053 Large Growth 37.10 20.00 ## ### Low 1.51 19.23 0.22 2.68 1.10 Three RF054 Large Growth 84.00 113.00 1.01 ### Averag. 1.65 19.16 1.62 1.28 Five 56 RF055 Large Growth 132.10 79.00 ## ### Low 4.33 19.13 -0.36 2.21 0.87 Two 57 RF056 Large Growth 434.60 31.00 1.04 19.91 Average 0.09 19.08 0.44 1.32 1.47 Five 58 RF057 Large Growth ##### 9.00 1.07 ### Average - 1.11 18.92 -0.07 3.38 0.80 Three 59 RF058 Large Growth ##### 57.00 ## 15.81 Low 4.27 18.87 3.15 7.54 0.92 Five 60 RF059 Large Growth 96.60 6.20 ## 17.12 Low 4.64 18.77 3.02 4.52 1.14 Five 61 RF060 Large Growth 23.20 12.81 1.26 ### High -2.68 18.46 -0.88 4.28 1.22 Two 62 RF061 Large Growth 86.70 18.70 ## ### Low 4.19 18.38 1.52 183 1.33 Five Large 3.84 3.28 2.41 4.32 3.44 3.78 4.87 3.08 6.60 0.59 111 55 2.58 A L 4.19 1.52 -1.02 -0.94 -0.51 183 3.30 2.06 4.46 4.39 8.03 5.65 0.76 -0.30 3.64 3.64 3.00 090 0.82 105 122 4.42 2.48 3.71 3.10 2.07 2.98 6.66 0.76 2.98 3.48 62 RF061 63 RF062 64 RF063 65 RF064 66 RF065 67 RF066 68 RF067 63 RF068 70 RF069 71RE070 72 RF071 73 RF072 74 RF073 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 S5 RF094 96 RF095 97 RF096 98 RF097 99 RF098 100 RF099 101 RF100 102 RF101 103 RF102 104 RF103 105 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 Large Large Large 3.32 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 Growth 0.40 Growth 182.00 Growth 463.70 Growth ##### Growth 272.20 Growth ##### 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 4.03 -1.49 -1.55 1.72 0.55 -0.81 3.60 139 5.24 -1.66 7.96 2.32 -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 E F G H 18.70 ## ### Low 75.38 109 ### Averag. Averag: 182.00 1.03 ### Averag 109.00 ## ### Low 3.00 ## 15.16 Low 18.00 1.00 ### Low 116.00 1.05 ### Average 92.00 ## 18.31 Low 34.00 ## 18.61 Low 453.00 ## ### Low 69.00 1.01 19.17 Averag 39.00 ## ### Averag 65.00 1.06 ### Averag, 70.00 1.05 ### Averag 51.00 1.03 ### Averag, 86.00 1.15 ### Averag 102.00 1.16 ### Averag 48.00 1.04 ### Average 7.00 ## ### Low 24.00 ## 18.12 Low 90.00 ## ### Low 63.48 ## ### Low 25.36 ## ### Low 44.00 1.01 ### Low 293.00 ## 17.11 Low 74.00 108 ### Average 194.00 ## ### Low 138.00 0.91 17.21 Low 57.00 ## ### Low 48.56 ## ### Low 271.00 ## ### Low 45.00 ## 16.41 Low 312.62 109 ### Average 127.00 ## ### Low 47.00 ## ### Low 17.00 0.91 ### Low 15.00 ## ### Low 10.00 1.06 ### Averag. 28.00 0.71 ### Low 74.00 ## 16.10 Low 47.00 ## ### Low 116.00 ## ### Low 62.40 0.81 ### Low 19.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 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.93 -0.33 2.13 1.00 -2.78 -2.76 1.57 2.31 129 0.78 3.79 1.87 0.63 -0.62 -4.15 1.41 MN 1.33 Five 1.59 TWO 1.13 Five 0.83 Three 1.14 Five 1.02 Three 1.29 Five 1.16 Four 153 Three 1.91 Five 1.11 Three 1.53 Five 0.90 Three 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 -0.17 2.31 2.92 338 3.09 2.72 1.31 3.17 5.30 233 3.19 2.98 0.19 2.46 3.17 -0.08 149 4.95 -159 6.46 3.53 0.59 3.33 3.47 -0.65 -0.45 1.29 -1.64 -1.55 0.69 -129 -0.03 0.81 -306 2.50 1.57 -2.77 -1.13 0.69 3.81 1.21 -8.44 -0.26 2.64 -135 -7.29 2.62 Large Large 8.72 106 RF104 107 RF105 108 RF106 109 RF107 110 RF108 8.74 8.49 6.10 0 .42 3.46 15.14 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 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 12.07 2.12 4.15 2.96 2.70 .40 0 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 142 RF140 143 RF141 144 RF142 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 Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Value ##### Value 119.90 Value 1508.21 Value 989.40 Value 554.20 Value 2.00 Value 560.00 Value 1682.40 Value 95.70 Value 47.80 Value 70.30 Value 1.40 Value 35.20 Value 6847.10 Value 32.60 Value 16.30 Value 26.60 Value 1288,60 Value ##### Value 106.10 Value ##### Value 82.90 Value 92.30 Value 22.60 Value 504.30 Value 23.60 Value 0.30 Value 14.60 Value 182.40 Value 219.00 Value 112.90 Value 31.70 Value 164.60 Value 1704.40 Value 5.90 Value 4.90 Value 920.00 Value 124.20 Value 458.40 Value 26.80 Value 8.50 Value 126.20 Value 126.70 Value 346.00 Value 340.70 Value 15.10 Value 1677.80 Value 463.00 Value 497.90 Value 1643.70 Value 8.90 Value 80.90 Value 28.60 Value 69.80 Value 189.60 3.05 ## ### Averag 40.00 1.09 ### Averag. 56.00 ## 17.81 Low 21.00 ## ### Low 78.38 ## ### Low 68.00 1.12 ### Averag 37.51 1.17 ### Averag 14.00 ## ### Low 167.00 ## 16.91 Low 26.76 1.20 ### Averag 21.00 ## 13.17 Low 72.27 1.03 ### Averag 40.00 1.12 ### Averag 36.00 1.17 ### Averag. 59.00 1.21 ### Averag 142.75 ## ### Low 47.00 1.05 ### Averag 20.00 ## ### Low 90.00 1.11 ### Averag 184.00 1.19 ### Averag 82.00 1.15 21.16 Averag 34.33 ## ### Low 8.16 1.02 ### Low 17.57 ## ### Low 28.00 1.02 ### Low 59.07 ## 17.41 Low 24.00 1.09 ### Averag 17.36 1.08 ### Averag: 169.00 1.06 ### Averag 20.00 ## 12.91 Low 37.00 1.01 ### Low 733.00 108 ### Averag. 85.09 1.10 ### Averag. 32.00 ## ### Low 22.00 1.01 ### Averag 14.00 ## ### Low 38.00 ## 18.51 Low 35.00 1.07 ### Averag 19.00 1.04 ### Averag. 2.00 ## ### Low 161.85 ## ### Low 33.68 1.18 ### Averag: 149.00 1.02 ### Low 0.00 ## ### Low 141.00 1.17 ### Averag 92.40 ## ### Low 26.00 1.05 ### Averag 196.00 1.08 ### Averag 11.63 ## ### Low 26.00 ## ### Low 43.00 ## ### Low 80.00 ## ### Low 31.68 ## 13.51 Low 55.00 ## ### Low 33.85 ## 11.68 Low -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 3.90 4.86 -0.92 31.25 27.03 23.49 21.94 21.76 2126 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 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 -1.86 0.59 -2.84 0.85 -1.08 4.58 -2.76 0.16 -1.67 -155 -0.76 3.22 -2.98 -4.39 -5.80 -0.58 -183 -0.53 -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 2.99 4.44 8.45 3.76 5.11 5.37 2.88 6.23 2.58 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 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.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 106 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 146 RF144 148 RF146 150 RF148 151 RF149 152 RF150 153 RF151 154 RF152 155 RF153 156 RF154 157 RF155 158 RF156 159 RF157 160 RF158 161 6.32 5.43 -7.21 2.44 10.07 -0.07 1.89 2.07 1.85 2.55 -2.74 173 6.82 4.50 0.22 -1.40 3.08 -2.23 3.28 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! 9.31 6.21 3.84 3.59 797 3.66 5.87 4.81 3.73 171 3.15 4.77 3.85 6.57 3.44 2 24 4.11 3.99 1 und Numbelarket Ca Type Assetsurnover Rat Bete SD Risk YrReturn: YrReturn: YrReturn:DYrReturnepense Ratitar Rating 2 RF001 Large Growth 15.00 0.00 2.17 ### High 13.88 62.91 3.12 -2.30 1.93 Three 3 RF002 Large Growth 106.50 34.00 ## ### High 10.49 54.79 3.25 -0.73 1.61 Five RF003 Large Growth 144.50 76.00 ## ### High 10.10 54.75 3.33 -0.61 1.82 Two RF004 Large Growth 73.60 11.49 1.10 21.81 Averag. 13.72 38.84 1.73 6.71 1.21 Five 6 RF005 Large Growt 1104.40 19.00 1.04 ### Averag. 8.03 33.65 6.34 5.51 1.53 Five 7 RF006 Large Growth 443.60 231.00 ## ### Low 1.26 33.18 8.62 1.41 Five 8 RF007 Large Growth 88.00 27.00 1.28 ### High 2.44 32.45 6.59 2.50 1.33 Three 9RF008 Large Growth 6101.30 158.00 1.13 ### 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 4.03 1.31 Five 11 RF010 Large Growth 30.30 318.00 1.11 21.12 Average 3.52 27.17 1.55 Four 12 RF011 Large Growth 227.30 27.99 1.18 ### Averag -1.01 26.97 6.78 1.25 Five RF012 Large Growth 28.20 62.00 1.00 ### Averag. 6.98 26.40 5.52 1.65 Four 14 RF013 Large Growth 1874.80 69.00 1.03 ### Averag. 25.50 3.87 1.00 Five 15 RF014 Large Growth 335.40 12.00 1.06 ### Averag 5.15 24.97 3.47 5.98 0.59 Four 16 RF015 Large Growth 0.60 157.00 1.14 ### Average 24.85 1.33 4.59 2.54 Five 17 RF016 Large Growth ##### 132.00 1.08 ### Average 24.72 3.98 0.94 Four 18 RF017 Large Growth 1100.40 92.00 1.03 19.41 Averag. 4.30 24.64 3.61 5.31 0.83 Five 19RF018 Large Growth 240.80 12.00 1.00 ### Averag. -2.71 24.20 4.02 0.43 1.34 Three 20 RF019 Large Growth 45.40 117.00 ## ### Low 735 23.81 3.05 5.25 104 Four 21 RF020 Large Growth 388.20 43.12 1.26 ### High -2.88 23.77 3.88 2.22 0.97 Five 22 RF021 Large Growth 477.30 19.00 1.11 ### Averag. 3.20 23.73 4.13 4.80 1.00 Four 23 RF022 Large Growth 1279.80 88.00 1.08 ### Averag 1.32 23.70 3.46 4.41 0.88 Five 24 RF023 Large Growth 34.60 18.34 1.19 ### Averag. -4.74 23.47 2.13 1.47 Three 25 RF024 Growth 119.00 8.00 ## ### Low 1.92 23.40 3.00 5.00 1.55 Five 26 RF025 Large Growth 286.50 28.13 ## ### Low 23.23 4.52 1.24 Four 27 RF026 Large Growth 4213.40 182.00 1.10 ### Average 22.80 0.90 5.72 0.91 Three 28 RF027 Large Growth 33.50 28.00 1.12 21.18 Averag, -0.23 22.77 1.67 2.81 1.04 Five 29 RF028 Large Growth 6.70 40.00 1.11 ### Averag -2.96 22.37 3.03 1.55 Three 30 RF029 Large Growth 859.70 72.00 1.05 ### Averag, 2.94 22.15 2.55 0.63 Five 31 RF030 Large Growth 61.90 6.00 0.91 ### Low 6.60 22.01 3.74 1.79 Four 32 RF031 Large Growth ##### 93.00 1.29 ### High -3.43 21.80 2.04 4.72 0.70 Five 33 RF032 Large Growth 2.00 26.00 1.03 ### Averag 4.70 21.74 1.79 3.12 0.63 Three 34 RF033 Large Growth 947.70 75.00 1.01 ### Averag. 158 2171 4.86 7.00 101 Five 35 RF034 Large Growth 6101.20 13.00 1.00 ### Low 5.00 21.65 3.38 2.70 100 Four 36 RF035 Large Growth 340.70 47.00 ## ### Low 7.97 21.62 4.12 3.31 1.32 Five 37 RF036 Large Growth 59.20 65.00 1.03 19.41 Averag. 3.43 21.34 1.95 3.56 108 Three 38 RF037 Large Growth 720.60 67.00 1.06 ### Average 4.09 21.24 0.23 4.01 133 Five 39 RF038 Large Growth 676.70 257.00 ## 18.15 Low 1.24 21.21 -1.46 4.23 0.71 Three 40 RF039 Large Growth 1812.60 17.00 ## ### Low 5.27 20.96 3.58 2.46 1.01 Four 41 RF040 Growth 42.50 203.00 1.21 ### High -7.53 20.94 -2.38 -0.03 2.08 Five 42 RF041 Large Growth 509.80 277.00 ## ### Low 2.50 20.83 4.41 093 Four 43 RF042 Large Growth 172.70 Growth 14.78 1.00 ### Low 2.79 20.71 0.79 2.45 1.32 Five 44 RF043 Large Growth 32.20 37.58 1.05 ### Averag 5.08 20.86 1.84 2.08 Three 45 RF044 Large Growth 169.40 101.33 1.07 ### Average 2.45 20.63 1.27 1.83 1.45 Five 46 RF045 Large Growth 99.90 35.00 ## ### Low 3.23 20.62 1.84 3.16 142 Three 47 RF046 Large Growth 1046.20 82.00 1.02 ### Average 20.55 0.46 133 Five 48 RF047 Large Growth 28,90 159.31 ## ### Low 6.57 20.27 4.90 5.84 2.08 Four 49 RF048 Large Growth 218.90 30.00 ## ### Low 20.23 2.72 1.18 Five 50 RF049 Large Growth 22.80 65.96 1.01 ### Average -195 20.07 1.88 1.64 Three 51 RF050 Large Growth 940.30 53.00 ## 18.10 Low 19.63 6.83 1.05 Five 52 RF051 Large Growth 512.70 88.42 1.04 19.12 Averag. 19.46 -0.13 2.21 1.05 Two 53 RF052 Large Growth 12.00 8.00 1.00 ### Average 5.93 1939 -1.08 4.22 Five 54 RF053 Large Growth 37.10 20.00 ## ### Low 1.51 19.23 0.22 2.68 1.10 Three RF054 Large Growth 84.00 113.00 1.01 ### Averag. 1.65 19.16 1.62 1.28 Five 56 RF055 Large Growth 132.10 79.00 ## ### Low 4.33 19.13 -0.36 2.21 0.87 Two 57 RF056 Large Growth 434.60 31.00 1.04 19.91 Average 0.09 19.08 0.44 1.32 1.47 Five 58 RF057 Large Growth ##### 9.00 1.07 ### Average - 1.11 18.92 -0.07 3.38 0.80 Three 59 RF058 Large Growth ##### 57.00 ## 15.81 Low 4.27 18.87 3.15 7.54 0.92 Five 60 RF059 Large Growth 96.60 6.20 ## 17.12 Low 4.64 18.77 3.02 4.52 1.14 Five 61 RF060 Large Growth 23.20 12.81 1.26 ### High -2.68 18.46 -0.88 4.28 1.22 Two 62 RF061 Large Growth 86.70 18.70 ## ### Low 4.19 18.38 1.52 183 1.33 Five Large 3.84 3.28 2.41 4.32 3.44 3.78 4.87 3.08 6.60 0.59 111 55 2.58 A L 4.19 1.52 -1.02 -0.94 -0.51 183 3.30 2.06 4.46 4.39 8.03 5.65 0.76 -0.30 3.64 3.64 3.00 090 0.82 105 122 4.42 2.48 3.71 3.10 2.07 2.98 6.66 0.76 2.98 3.48 62 RF061 63 RF062 64 RF063 65 RF064 66 RF065 67 RF066 68 RF067 63 RF068 70 RF069 71RE070 72 RF071 73 RF072 74 RF073 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 S5 RF094 96 RF095 97 RF096 98 RF097 99 RF098 100 RF099 101 RF100 102 RF101 103 RF102 104 RF103 105 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 Large Large Large 3.32 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 Growth 0.40 Growth 182.00 Growth 463.70 Growth ##### Growth 272.20 Growth ##### 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 4.03 -1.49 -1.55 1.72 0.55 -0.81 3.60 139 5.24 -1.66 7.96 2.32 -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 E F G H 18.70 ## ### Low 75.38 109 ### Averag. Averag: 182.00 1.03 ### Averag 109.00 ## ### Low 3.00 ## 15.16 Low 18.00 1.00 ### Low 116.00 1.05 ### Average 92.00 ## 18.31 Low 34.00 ## 18.61 Low 453.00 ## ### Low 69.00 1.01 19.17 Averag 39.00 ## ### Averag 65.00 1.06 ### Averag, 70.00 1.05 ### Averag 51.00 1.03 ### Averag, 86.00 1.15 ### Averag 102.00 1.16 ### Averag 48.00 1.04 ### Average 7.00 ## ### Low 24.00 ## 18.12 Low 90.00 ## ### Low 63.48 ## ### Low 25.36 ## ### Low 44.00 1.01 ### Low 293.00 ## 17.11 Low 74.00 108 ### Average 194.00 ## ### Low 138.00 0.91 17.21 Low 57.00 ## ### Low 48.56 ## ### Low 271.00 ## ### Low 45.00 ## 16.41 Low 312.62 109 ### Average 127.00 ## ### Low 47.00 ## ### Low 17.00 0.91 ### Low 15.00 ## ### Low 10.00 1.06 ### Averag. 28.00 0.71 ### Low 74.00 ## 16.10 Low 47.00 ## ### Low 116.00 ## ### Low 62.40 0.81 ### Low 19.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 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.93 -0.33 2.13 1.00 -2.78 -2.76 1.57 2.31 129 0.78 3.79 1.87 0.63 -0.62 -4.15 1.41 MN 1.33 Five 1.59 TWO 1.13 Five 0.83 Three 1.14 Five 1.02 Three 1.29 Five 1.16 Four 153 Three 1.91 Five 1.11 Three 1.53 Five 0.90 Three 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 -0.17 2.31 2.92 338 3.09 2.72 1.31 3.17 5.30 233 3.19 2.98 0.19 2.46 3.17 -0.08 149 4.95 -159 6.46 3.53 0.59 3.33 3.47 -0.65 -0.45 1.29 -1.64 -1.55 0.69 -129 -0.03 0.81 -306 2.50 1.57 -2.77 -1.13 0.69 3.81 1.21 -8.44 -0.26 2.64 -135 -7.29 2.62 Large Large 8.72 106 RF104 107 RF105 108 RF106 109 RF107 110 RF108 8.74 8.49 6.10 0 .42 3.46 15.14 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 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 12.07 2.12 4.15 2.96 2.70 .40 0 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 142 RF140 143 RF141 144 RF142 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 Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Large Value ##### Value 119.90 Value 1508.21 Value 989.40 Value 554.20 Value 2.00 Value 560.00 Value 1682.40 Value 95.70 Value 47.80 Value 70.30 Value 1.40 Value 35.20 Value 6847.10 Value 32.60 Value 16.30 Value 26.60 Value 1288,60 Value ##### Value 106.10 Value ##### Value 82.90 Value 92.30 Value 22.60 Value 504.30 Value 23.60 Value 0.30 Value 14.60 Value 182.40 Value 219.00 Value 112.90 Value 31.70 Value 164.60 Value 1704.40 Value 5.90 Value 4.90 Value 920.00 Value 124.20 Value 458.40 Value 26.80 Value 8.50 Value 126.20 Value 126.70 Value 346.00 Value 340.70 Value 15.10 Value 1677.80 Value 463.00 Value 497.90 Value 1643.70 Value 8.90 Value 80.90 Value 28.60 Value 69.80 Value 189.60 3.05 ## ### Averag 40.00 1.09 ### Averag. 56.00 ## 17.81 Low 21.00 ## ### Low 78.38 ## ### Low 68.00 1.12 ### Averag 37.51 1.17 ### Averag 14.00 ## ### Low 167.00 ## 16.91 Low 26.76 1.20 ### Averag 21.00 ## 13.17 Low 72.27 1.03 ### Averag 40.00 1.12 ### Averag 36.00 1.17 ### Averag. 59.00 1.21 ### Averag 142.75 ## ### Low 47.00 1.05 ### Averag 20.00 ## ### Low 90.00 1.11 ### Averag 184.00 1.19 ### Averag 82.00 1.15 21.16 Averag 34.33 ## ### Low 8.16 1.02 ### Low 17.57 ## ### Low 28.00 1.02 ### Low 59.07 ## 17.41 Low 24.00 1.09 ### Averag 17.36 1.08 ### Averag: 169.00 1.06 ### Averag 20.00 ## 12.91 Low 37.00 1.01 ### Low 733.00 108 ### Averag. 85.09 1.10 ### Averag. 32.00 ## ### Low 22.00 1.01 ### Averag 14.00 ## ### Low 38.00 ## 18.51 Low 35.00 1.07 ### Averag 19.00 1.04 ### Averag. 2.00 ## ### Low 161.85 ## ### Low 33.68 1.18 ### Averag: 149.00 1.02 ### Low 0.00 ## ### Low 141.00 1.17 ### Averag 92.40 ## ### Low 26.00 1.05 ### Averag 196.00 1.08 ### Averag 11.63 ## ### Low 26.00 ## ### Low 43.00 ## ### Low 80.00 ## ### Low 31.68 ## 13.51 Low 55.00 ## ### Low 33.85 ## 11.68 Low -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 3.90 4.86 -0.92 31.25 27.03 23.49 21.94 21.76 2126 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 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 -1.86 0.59 -2.84 0.85 -1.08 4.58 -2.76 0.16 -1.67 -155 -0.76 3.22 -2.98 -4.39 -5.80 -0.58 -183 -0.53 -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 2.99 4.44 8.45 3.76 5.11 5.37 2.88 6.23 2.58 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 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.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 106 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 146 RF144 148 RF146 150 RF148 151 RF149 152 RF150 153 RF151 154 RF152 155 RF153 156 RF154 157 RF155 158 RF156 159 RF157 160 RF158 161 6.32 5.43 -7.21 2.44 10.07 -0.07 1.89 2.07 1.85 2.55 -2.74 173 6.82 4.50 0.22 -1.40 3.08 -2.23 3.28 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
