Question
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
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.
A.What are two variables of interest?
B.determine a null and alternative hypothesis statement
C.At the 95% significance level, is there significant evidence of a difference between fund rate of returns?
D.Do you accept or reject the null hypothesis?
E.how would you explain the results to a senior executive that isn't as familiar with statistics as you are!
Fund # Market Cap Type- assets Turnover Ratio Beta SD 1YrReturn% 3YrReturn% 5YrReturn% 10YrReturn% Expense Ratio
RF001 Large Growth 15.00 0.00 2.17 42.42 13.88 62.91 -3.12 -2.30 1.93
RF002 Large Growth 106.50 34.00 2.05 39.98 10.49 54.79 3.25 -0.73 1.61
RF003 Large Growth 144.50 76.00 2.05 40.09 10.10 54.75 3.33 -0.61 1.82
RF004 Large Growth 73.60 11.49 1.10 21.81 13.72 38.84 1.73 6.71 1.21
RF005 Large Growth 1104.40 19.00 1.04 20.39 8.03 33.65 6.34 5.51 1.53
RF006 Large Growth 443.60 231.00 0.90 18.02 1.26 33.18 8.62 9.31 1.41
RF007 Large Growth 88.00 27.00 1.28 25.63 2.44 32.45 6.59 2.50 1.33
RF008 Large Growth 6101.30 158.00 1.13 22.24 3.05 29.08 6.65 6.59 0.94
RF009 Large Growth 656.20 55.00 1.00 19.51 7.93 27.22 6.21 4.03 1.31
RF010 Large Growth 30.30 318.00 1.11 21.12 3.52 27.17 3.84 3.59 1.55
RF011 Large Growth 227.30 27.99 1.18 23.00 -1.01 26.97 6.78 7.97 1.25
RF012 Large Growth 28.20 62.00 1.00 19.52 6.98 26.40 5.52 3.66 1.65
RF013 Large Growth 1874.80 69.00 1.03 19.44 4.81 25.50 3.87 5.87 1.00
RF014 Large Growth 335.40 12.00 1.06 20.20 5.15 24.97 3.47 5.98 0.59
RF015 Large Growth 0.60 157.00 1.14 21.62 3.73 24.85 1.33 4.59 2.54
RF016 Large Growth 10572.00 132.00 1.08 20.51 1.71 24.72 3.98 3.15 0.94
RF017 Large Growth 1100.40 92.00 1.03 19.41 4.30 24.64 3.61 5.31 0.83
RF018 Large Growth 240.80 12.00 1.00 20.32 -2.71 24.20 4.02 0.43 1.34
RF019 Large Growth 45.40 117.00 0.96 18.02 7.35 23.81 3.05 5.25 1.04
RF020 Large Growth 388.20 43.12 1.26 24.81 -2.88 23.77 3.88 2.22 0.97
RF021 Large Growth 477.30 19.00 1.11 20.94 3.20 23.73 4.13 4.80 1.00
RF022 Large Growth 1279.80 88.00 1.08 20.16 1.32 23.70 3.46 4.41 0.88
RF023 Large Growth 34.60 18.34 1.19 22.86 -4.74 23.47 2.13 4.77 1.47
RF024 Large Growth 119.00 8.00 0.99 18.92 1.92 23.40 3.00 5.00 1.55
RF025 Large Growth 286.50 28.13 0.89 17.02 6.57 23.23 4.52 3.85 1.24
RF026 Large Growth 4213.40 182.00 1.10 21.20 3.44 22.80 0.90 5.72 0.91
RF027 Large Growth 33.50 28.00 1.12 21.18 -0.23 22.77 1.67 2.81 1.04
RF028 Large Growth 6.70 40.00 1.11 21.80 -2.96 22.37 2.24 3.03 1.55
RF029 Large Growth 859.70 72.00 1.05 19.72 2.94 22.15 2.55 4.11 0.63
RF030 Large Growth 61.90 6.00 0.91 16.96 6.60 22.01 3.99 3.74 1.79
RF031 Large Growth 3300.30 93.00 1.29 24.90 -3.43 21.80 2.04 4.72 0.70
RF032 Large Growth 2.00 26.00 1.03 19.56 4.70 21.74 1.79 3.12 0.63
RF033 Large Growth 947.70 75.00 1.01 19.38 1.58 21.71 4.86 7.00 1.01
RF034 Large Growth 6101.20 13.00 1.00 18.73 5.00 21.65 3.38 2.70 1.00
RF035 Large Growth 340.70 47.00 0.94 17.74 7.97 21.62 4.12 3.31 1.32
RF036 Large Growth 59.20 65.00 1.03 19.41 3.43 21.34 1.95 3.56 1.08
RF037 Large Growth 720.60 67.00 1.06 19.98 4.09 21.24 0.23 4.01 1.33
RF038 Large Growth 676.70 257.00 0.95 18.15 1.24 21.21 -1.46 4.23 0.71
RF039 Large Growth 1812.60 17.00 0.97 18.32 5.27 20.96 3.58 2.46 1.01
RF040 Large Growth 42.50 203.00 1.21 24.20 -7.53 20.94 -2.38 -0.03 2.08
RF041 Large Growth 509.80 277.00 0.98 18.53 2.50 20.83 4.41 3.84 0.93
RF042 Large Growth 172.70 14.78 1.00 18.86 2.79 20.71 0.79 2.45 1.32
RF043 Large Growth 32.20 37.58 1.05 19.47 5.08 20.86 1.84 3.28 2.08
RF044 Large Growth 169.40 101.33 1.07 19.95 2.45 20.63 1.27 1.83 1.45
RF045 Large Growth 99.90 35.00 0.97 18.27 3.23 20.62 1.84 3.16 1.42
RF046 Large Growth 1046.20 82.00 1.02 19.60 2.41 20.55 0.46 4.32 1.33
RF047 Large Growth 28.90 159.31 0.98 18.47 6.57 20.27 4.90 5.84 2.08
RF048 Large Growth 218.90 30.00 0.97 18.67 3.44 20.23 2.72 3.78 1.18
RF049 Large Growth 22.80 65.96 1.01 19.34 -1.95 20.07 1.88 4.87 1.64
RF050 Large Growth 940.30 53.00 0.95 18.10 6.60 19.63 3.08 6.83 1.05
RF051 Large Growth 512.70 88.42 1.04 19.12 0.59 19.46 -0.13 2.21 1.05
RF052 Large Growth 12.00 8.00 1.00 20.33 5.93 19.39 -1.08 1.11 4.22
RF053 Large Growth 37.10 20.00 0.94 17.42 1.51 19.23 0.22 2.68 1.10
RF054 Large Growth 84.00 113.00 1.01 19.03 1.65 19.16 1.62 2.58 1.28
RF055 Large Growth 132.10 79.00 0.99 18.76 4.33 19.13 -0.36 2.21 0.87
RF056 Large Growth 434.60 31.00 1.04 19.91 0.09 19.08 0.44 1.32 1.47
RF057 Large Growth 2376.90 9.00 1.07 19.80 -1.11 18.92 -0.07 3.38 0.80
RF058 Large Growth 58729.30 57.00 0.84 15.81 4.27 18.87 3.15 7.54 0.92
RF059 Large Growth 96.60 6.20 0.93 17.12 4.64 18.77 3.02 4.52 1.14
RF060 Large Growth 23.20 12.81 1.26 23.47 -2.68 18.46 -0.88 4.28 1.22
RF061 Large Growth 86.70 18.70 0.97 18.50 4.19 18.38 1.52 1.83 1.33
RF062 Large Growth 24.60 75.38 1.09 20.65 4.03 18.34 -1.02 3.30 1.59
RF063 Large Growth 61.20 182.00 1.03 19.49 -1.49 18.28 -0.94 2.06 1.13
RF064 Large Growth 1879.10 109.00 0.99 18.44 -1.55 18.12 -0.51 4.46 0.83
RF065 Large Growth 2171.30 3.00 0.80 15.16 1.72 18.01 4.39 8.03 1.14
RF066 Large Growth 192.90 18.00 1.00 18.42 0.55 17.98 0.76 5.65 1.02
RF067 Large Growth 84.60 116.00 1.05 20.03 -0.81 17.98 -0.30 3.64 1.29
RF068 Large Growth 8.20 92.00 0.98 18.31 3.60 17.94 3.00 3.64 1.16
RF069 Large Growth 3.60 34.00 0.99 18.61 1.39 17.76 0.90 1.05 1.53
RF070 Large Growth 28.90 453.00 0.92 16.88 5.24 17.69 0.82 4.42 1.91
RF071 Large Growth 33.50 69.00 1.01 19.17 -1.66 17.63 1.22 2.48 1.11
RF072 Large Growth 94.30 39.00 0.99 19.20 7.96 17.53 2.93 3.71 1.53
RF073 Large Growth 1335.60 65.00 1.06 20.04 2.32 17.43 -0.33 3.10 0.90
RF074 Large Growth 0.40 70.00 1.05 20.14 -6.25 17.25 2.13 2.07 1.11
RF075 Large Growth 182.00 51.00 1.03 19.26 3.33 17.25 1.00 2.98 0.88
RF076 Large Growth 463.70 86.00 1.15 21.90 -8.49 17.25 -2.78 6.66 1.37
RF077 Large Growth 13320.90 102.00 1.16 21.93 -7.74 17.17 -2.76 0.76 0.60
RF078 Large Growth 272.20 48.00 1.04 19.27 -3.62 16.86 1.57 2.98 1.26
RF079 Large Growth 2442.60 7.00 0.90 16.96 2.97 16.68 2.31 3.48 0.92
RF080 Large Growth 13.60 24.00 0.97 18.12 0.19 16.61 1.29 3.32 2.37
RF081 Large Growth 2100.30 90.00 0.98 18.29 -0.63 16.59 0.78 2.31 0.90
RF082 Large Growth 1698.10 63.48 0.84 15.58 4.67 16.41 3.79 2.92 1.09
RF083 Large Growth 279.60 25.36 0.92 17.06 4.04 16.32 1.87 3.38 1.00
RF084 Large Growth 2.80 44.00 1.01 18.62 0.02 15.96 0.63 3.09 0.63
RF085 Large Growth 19.40 293.00 0.90 17.11 0.05 15.92 -0.62 2.72 1.00
RF086 Large Growth 57.90 74.00 1.08 20.54 -4.48 15.89 -4.15 1.31 1.52
RF087 Large Growth 6.60 194.00 0.87 16.20 8.60 15.65 1.41 3.17 1.12
RF088 Large Growth 0.60 138.00 0.91 17.21 1.28 15.51 -0.17 5.30 0.97
RF089 Large Growth 399.10 57.00 0.94 17.67 2.51 15.50 -0.65 2.33 1.20
RF090 Large Growth 343.70 48.56 0.99 18.45 -0.72 15.44 -0.45 3.19 1.15
RF091 Large Growth 7.50 271.00 0.85 16.79 7.56 14.96 1.29 2.98 1.11
RF092 Large Growth 5.10 45.00 0.86 16.41 1.46 14.67 -1.64 0.19 0.95
RF093 Large Growth 16.00 312.62 1.09 21.99 -17.63 14.39 -1.55 2.46 1.35
RF094 Large Growth 16.80 127.00 0.86 16.32 1.47 14.36 0.69 3.17 2.57
RF095 Large Growth 1.90 47.00 0.94 17.68 1.82 14.33 -1.29 -0.08 1.62
RF096 Large Growth 168.70 17.00 0.91 17.23 3.81 14.28 -0.03 1.49 1.21
RF097 Large Growth 23.50 15.00 0.84 15.78 1.21 14.02 0.81 4.95 1.01
RF098 Large Growth 50.70 10.00 1.06 20.36 -8.44 13.23 -3.06 -1.59 1.86
RF099 Large Growth 145.70 28.00 0.71 14.58 -0.26 13.11 2.50 6.46 0.98
RF100 Large Growth 91.60 74.00 0.85 16.10 2.64 11.94 1.57 3.53 0.93 4
RF101 Large Growth 13.60 47.00 0.93 17.45 -1.35 11.54 -2.77 0.59 2.47
RF102 Large Growth 55.30 116.00 0.92 18.26 -7.29 11.51 -1.13 3.33 1.71
RF103 Large Growth 105.90 62.40 0.81 15.52 2.62 11.19 0.69 3.47 1.24
RF104 Large Value 4946.30 3.05 0.94 20.03 8.72 31.25 9.30 11.51 1.27
RF105 Large Value 119.90 40.00 1.09 22.31 6.11 27.03 -0.38 4.18 1.30
RF106 Large Value 1508.21 56.00 0.93 17.81 8.74 23.49 0.49 5.38 0.84
RF107 Large Value 989.40 21.00 0.92 17.72 8.49 21.94 -2.56 2.88 1.21
RF108 Large Value 554.20 78.38 0.97 18.45 6.10 21.76 0.69 3.26 1.10
RF109 Large Value 2.00 68.00 1.12 21.20 3.34 21.26 -2.96 7.27 1.32
RF110 Large Value 560.00 37.51 1.17 21.45 0.42 20.93 -1.78 4.78 1.20
RF111 Large Value 1682.40 14.00 0.98 17.87 3.46 20.02 2.13 6.77 1.41
RF112 Large Value 95.70 167.00 0.88 16.91 15.14 20.01 -1.40 2.73 0.83
RF113 Large Value 47.80 26.76 1.20 22.12 -0.87 19.46 -2.26 4.24 1.19
RF114 Large Value 70.30 21.00 0.66 13.17 12.07 18.94 0.32 3.76 1.34
RF115 Large Value 1.40 72.27 1.03 19.03 4.47 18.87 -0.61 3.27 1.12
RF116 Large Value 35.20 40.00 1.12 21.33 -2.12 18.83 -1.39 1.77 1.51
RF117 Large Value 6847.10 36.00 1.17 21.46 -4.15 18.25 -2.98 2.96 0.69
RF118 Large Value 32.60 59.00 1.21 22.17 -0.87 18.21 -3.44 2.99 1.39
RF119 Large Value 16.30 142.75 0.93 17.74 2.70 18.04 0.42 4.44 3.99
RF120 Large Value 26.60 47.00 1.05 19.25 0.40 17.95 1.98 8.45 1.28
RF121 Large Value 1288.60 20.00 0.93 17.26 0.11 17.87 1.13 3.76 0.91
RF122 Large Value 3666.40 90.00 1.11 20.22 -0.55 17.78 -1.86 5.11 0.97
RF123 Large Value 106.10 184.00 1.19 22.58 -7.47 17.88 0.59 5.37 0.96
RF124 Large Value 4293.60 82.00 1.15 21.16 -2.72 17.63 -2.84 2.88 0.88
RF125 Large Value 82.90 34.33 0.95 17.58 1.46 17.34 0.85 6.23 1.10
RF126 Large Value 92.30 8.16 1.02 18.86 4.22 17.42 -1.08 2.58 1.04
RF127 Large Value 22.60 17.57 0.85 16.40 5.20 16.86 4.58 4.87 1.28
RF128 Large Value 504.30 28.00 1.02 18.66 3.11 16.67 -2.76 3.39 0.87
RF129 Large Value 23.60 59.07 0.95 17.41 6.35 16.65 0.16 5.19 1.19
RF130 Large Value 0.30 24.00 1.09 20.03 1.20 16.55 -1.67 2.41 7.28
RF131 Large Value 14.60 17.36 1.08 19.89 0.55 16.35 -1.55 3.69 2.36
RF132 Large Value 182.40 169.00 1.06 19.93 3.86 16.23 -0.76 3.39 1.29
RF133 Large Value 219.00 20.00 0.70 12.91 6.86 16.15 3.22 6.22 1.25
RF134 Large Value 112.90 37.00 1.01 18.55 3.06 16.04 -2.98 3.11 1.11
RF135 Large Value 31.70 733.00 1.08 19.82 -0.70 15.98 -4.39 4.37 1.89
RF136 Large Value 164.60 85.09 1.10 20.51 -0.35 15.97 -5.80 1.05 1.44
RF137 Large Value 1704.40 32.00 0.92 16.98 2.36 15.94 -0.58 4.81 1.01
RF138 Large Value 5.90 22.00 1.01 19.26 -0.28 15.81 -1.83 1.40 1.47
RF139 Large Value 4.90 14.00 0.78 14.58 3.90 15.53 -0.53 7.59 2.75
RF140 Large Value 920.00 38.00 0.99 18.51 4.86 15.51 -2.19 5.36 1.06
RF141 Large Value 124.20 35.00 1.07 19.82 -0.92 15.49 -1.35 3.27 1.41
RF142 Large Value 458.40 19.00 1.04 19.32 3.85 15.36 -3.77 5.85 1.11
RF143 Large Value 26.80 2.00 0.74 13.98 6.32 15.34 -0.78 5.71 0.98
RF144 Large Value 8.50 161.85 0.86 16.23 5.43 15.23 -1.51 3.63 2.86
RF145 Large Value 126.20 33.68 1.18 21.78 -7.21 15.16 -3.03 2.81 1.23
RF146 Large Value 126.70 149.00 1.02 18.85 2.44 14.98 -1.77 2.85 1.41
RF147 Large Value 346.00 0.00 0.70 13.86 10.07 14.96 0.41 6.34 1.48
RF148 Large Value 340.70 141.00 1.17 21.70 -0.07 14.93 -5.22 2.74 0.75
RF149 Large Value 15.10 92.40 0.68 16.26 1.89 14.85 -0.27 3.40 2.03
RF150 Large Value 1677.80 26.00 1.05 19.64 -2.07 14.45 -1.30 4.53 0.95
RF151 Large Value 463.00 196.00 1.08 19.63 1.85 14.27 -4.06 2.92 0.73
RF152 Large Value 497.90 11.63 0.94 18.02 -2.55 14.25 -5.85 2.22 1.24
RF153 Large Value 1643.70 26.00 0.98 18.04 -2.74 13.94 1.04 6.72 1.11
RF154 Large Value 8.90 43.00 0.94 17.23 1.73 13.22 -1.74 5.22 1.09
RF155 Large Value 80.90 80.00 0.67 13.58 6.82 12.12 3.93 3.97 1.68
RF156 Large Value 28.60 31.68 0.69 13.51 4.50 11.32 3.08 5.28 1.86
RF157 Large Value 69.80 55.00 0.96 17.95 0.22 11.21 -2.23 2.77 1.28
RF158 Large Value 189.60 33.85 0.55 11.68 -1.40 9.82 3.28 5.06 1.28
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started