Large GrowthLarge ValueВJAВCFund Number Market Cap Type 3YrReturn%1 Fund Number Market Cap Type 3YrReturn%58 RF057GrowthLarge18.92105 RF104ValueLarge31.2559 RFO582 RF001GrowthLargeGrowth62.91Large18.87106 RF105ValueLarge27.0354.793 RF00260 RF059GrowthGrowth18.77LargeLarge107 RF106ValueLarge23.494 RF003Growth61 RF060GrowthLarge54.75Large18.46108 RF107ValueLarge21.945 RF00462 RF061Growth38.84GrowthLargeLarge18.38109 RF108110 RF109ValueLarge21.766 RF0057 RF006Growth63 RF062GrowthLarge33.65Large18.34ValueLarge21.2664 RF063GrowthGrowth18.28Large33.18Large111 RF110ValueLarge20.938 RF0079 RF008GrowthGrowth65 RF06418.12Large32.45Large112 RF111ValueLarge20.0266 RF065GrowthGrowthLarge29.08Large18.01113 RF112Value20.01Large10 RF009Growth67 RF066GrowthLarge27.22Large17.98114 RF113ValueLarge19.4611 RF01068 RF067Growth27.17Growth17.98LargeLarge115 RF114ValueLarge18.94GrowthGrowth12 RF01169 RF068Large26.97Large17.94116 RF115ValueLarge18.8713 RF01270 RF069GrowthGrowth17.76Large26.40Large117 RF116Value18.83Large71 RF07014 RF01315 RF014GrowthGrowthLarge25.50Large17.69118 RF117ValueLarge18.25Growth72 RF071Growth17.63Large24.97Large119 RF118ValueLarge18.2116 RF01517 RF01673 RF072GrowthGrowth17.53Large24.85Large120 RF119ValueLarge18.04Growth24.7274 RF073Growth17.43LargeLarge121 RF120Value17.95Large18 RF017Growth75 RF074GrowthLarge24.64Large17.25122 RF121ValueLarge17.8719 RF01876 RF075GrowthGrowth17.25Large24.20Large123 RF122124 RF123125 RF124ValueLarge17.7820 RF019Growth77 RF076Growth17.25Large23.81LargeValue17.88Large21 RF02078 RF077GrowthGrowthLarge23.77Large17.17ValueLarge17.6322 RF02179 RF078GrowthGrowthLarge23.73Large16.86126 RF125ValueLarge17.3423 RF02224 RF023Growth80 RF079LargeGrowth23.70Large16.68127 RF126128 RF127ValueLarge17.42Growth81 RF080Growth16.61Large23.47LargeValue16.86Large25 RF024Growth82 RF081GrowthLarge23.40Large16.59129 RF128ValueLarge16.6726 RF02583 RF082Growth16.41Large23.23LargeGrowth130 RF129ValueLarge16.6527 RF026Growth84 RF083LargeGrowth22.80Large16.32131 RF130ValueLarge16.5528 RF02785 RF084GrowthGrowthLarge22.77Large15.96132 RF131Value16.35Large86 RF08529 RF028GrowthGrowthLarge22.37Large15.92133 RF132ValueLarge16.2330 RF02931 RF03087 RF086Growth22.15GrowthLargeLarge15.89134 RF133ValueLarge16.15Growth88 RF087LargeGrowth22.01Large15.65135 RF134136 RF135ValueLarge16.0432 RF03133 RF032Growth89 RF088Growth15.51Large21.80LargeValue15.98Large90 RF089GrowthGrowthLarge21.74Large15.50137 RF136ValueLarge15.9791 RF09034 RF033Growth21.71Growth15.44LargeLarge138 RF137ValueLarge15.9435 RF03436 RF035Growth92 RF091LargeGrowth21.65Large14.96139 RF138ValueLarge15.81Growth93 RF092GrowthLarge21.62Large14.67140 RF139Value15.53Large37 RF036Growth94 RF093GrowthLarge21.34Large14.39141 RF140ValueLarge15.5195 RF09438 RF037Growth21.24Growth14.36LargeLarge142 RF141ValueLarge15.4939 RF038Growth96 RF09514.33Large21.21LargeGrowth143 RF142ValueLarge15.3640 RF039Growth20.9697 RF096GrowthLargeLarge14.28144 RF143ValueLarge15.3441 RF040Growth20.9498 RF097Growth14.02LargeLarge145 RF144ValueLarge15.2342 RF04143 RF042GrowthGrowth99 RF09813.23Large20.83Large146 RF145147 RF146ValueLarge15.16100 RF099GrowthGrowthLarge20.71Large13.11Value14.98Large44 RF043101 RF100GrowthGrowthLarge20.86Large11.94148 RF147ValueLarge14.96102 RF101103 RF10245 RF044Growth20.63Growth11.54LargeLarge149 RF148ValueLarge14.9346 RF045GrowthGrowthLarge20.62Large11.51150 RF149151 RF150ValueLarge14.85104 RF10347 RF046GrowthLarge20.55LargeGrowth11.19Value14.45Large48 RF047GrowthLarge20.27152 RF151ValueLarge14.2749 RF048Growth20.23Large153 RF152154 RF153ValueLarge14.25Growth50 RF049Large20.07ValueLarge13.9451 RFO50LargeGrowth19.63155 RF154Value13.22Large52 RF051GrowthLarge19.46156 RF155ValueLarge12.1253 RF052GrowthLarge19.39157 RF156158 RF157ValueLarge11.3254 RF05355 RF05456 RF055GrowthLarge19.23Value11.21LargeGrowth19.16Large159 RF158ValueLarge9.82GrowthLarge19.1357 RF056GrowthLarge19.08

Question
Asked Dec 1, 2019
4 views

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 the two variables of interest?

b) Write a null and alternative hypothesis statement

c) At the 95% significance level, is there significant evidence of a difference between fund rate of returns?

Large Growth
Large Value
В
J
A
В
C
Fund Number Market Cap Type 3YrReturn%
1 Fund Number Market Cap Type 3YrReturn%
58 RF057
Growth
Large
18.92
105 RF104
Value
Large
31.25
59 RFO58
2 RF001
Growth
Large
Growth
62.91
Large
18.87
106 RF105
Value
Large
27.03
54.79
3 RF002
60 RF059
Growth
Growth
18.77
Large
Large
107 RF106
Value
Large
23.49
4 RF003
Growth
61 RF060
Growth
Large
54.75
Large
18.46
108 RF107
Value
Large
21.94
5 RF004
62 RF061
Growth
38.84
Growth
Large
Large
18.38
109 RF108
110 RF109
Value
Large
21.76
6 RF005
7 RF006
Growth
63 RF062
Growth
Large
33.65
Large
18.34
Value
Large
21.26
64 RF063
Growth
Growth
18.28
Large
33.18
Large
111 RF110
Value
Large
20.93
8 RF007
9 RF008
Growth
Growth
65 RF064
18.12
Large
32.45
Large
112 RF111
Value
Large
20.02
66 RF065
Growth
Growth
Large
29.08
Large
18.01
113 RF112
Value
20.01
Large
10 RF009
Growth
67 RF066
Growth
Large
27.22
Large
17.98
114 RF113
Value
Large
19.46
11 RF010
68 RF067
Growth
27.17
Growth
17.98
Large
Large
115 RF114
Value
Large
18.94
Growth
Growth
12 RF011
69 RF068
Large
26.97
Large
17.94
116 RF115
Value
Large
18.87
13 RF012
70 RF069
Growth
Growth
17.76
Large
26.40
Large
117 RF116
Value
18.83
Large
71 RF070
14 RF013
15 RF014
Growth
Growth
Large
25.50
Large
17.69
118 RF117
Value
Large
18.25
Growth
72 RF071
Growth
17.63
Large
24.97
Large
119 RF118
Value
Large
18.21
16 RF015
17 RF016
73 RF072
Growth
Growth
17.53
Large
24.85
Large
120 RF119
Value
Large
18.04
Growth
24.72
74 RF073
Growth
17.43
Large
Large
121 RF120
Value
17.95
Large
18 RF017
Growth
75 RF074
Growth
Large
24.64
Large
17.25
122 RF121
Value
Large
17.87
19 RF018
76 RF075
Growth
Growth
17.25
Large
24.20
Large
123 RF122
124 RF123
125 RF124
Value
Large
17.78
20 RF019
Growth
77 RF076
Growth
17.25
Large
23.81
Large
Value
17.88
Large
21 RF020
78 RF077
Growth
Growth
Large
23.77
Large
17.17
Value
Large
17.63
22 RF021
79 RF078
Growth
Growth
Large
23.73
Large
16.86
126 RF125
Value
Large
17.34
23 RF022
24 RF023
Growth
80 RF079
Large
Growth
23.70
Large
16.68
127 RF126
128 RF127
Value
Large
17.42
Growth
81 RF080
Growth
16.61
Large
23.47
Large
Value
16.86
Large
25 RF024
Growth
82 RF081
Growth
Large
23.40
Large
16.59
129 RF128
Value
Large
16.67
26 RF025
83 RF082
Growth
16.41
Large
23.23
Large
Growth
130 RF129
Value
Large
16.65
27 RF026
Growth
84 RF083
Large
Growth
22.80
Large
16.32
131 RF130
Value
Large
16.55
28 RF027
85 RF084
Growth
Growth
Large
22.77
Large
15.96
132 RF131
Value
16.35
Large
86 RF085
29 RF028
Growth
Growth
Large
22.37
Large
15.92
133 RF132
Value
Large
16.23
30 RF029
31 RF030
87 RF086
Growth
22.15
Growth
Large
Large
15.89
134 RF133
Value
Large
16.15
Growth
88 RF087
Large
Growth
22.01
Large
15.65
135 RF134
136 RF135
Value
Large
16.04
32 RF031
33 RF032
Growth
89 RF088
Growth
15.51
Large
21.80
Large
Value
15.98
Large
90 RF089
Growth
Growth
Large
21.74
Large
15.50
137 RF136
Value
Large
15.97
91 RF090
34 RF033
Growth
21.71
Growth
15.44
Large
Large
138 RF137
Value
Large
15.94
35 RF034
36 RF035
Growth
92 RF091
Large
Growth
21.65
Large
14.96
139 RF138
Value
Large
15.81
Growth
93 RF092
Growth
Large
21.62
Large
14.67
140 RF139
Value
15.53
Large
37 RF036
Growth
94 RF093
Growth
Large
21.34
Large
14.39
141 RF140
Value
Large
15.51
95 RF094
38 RF037
Growth
21.24
Growth
14.36
Large
Large
142 RF141
Value
Large
15.49
39 RF038
Growth
96 RF095
14.33
Large
21.21
Large
Growth
143 RF142
Value
Large
15.36
40 RF039
Growth
20.96
97 RF096
Growth
Large
Large
14.28
144 RF143
Value
Large
15.34
41 RF040
Growth
20.94
98 RF097
Growth
14.02
Large
Large
145 RF144
Value
Large
15.23
42 RF041
43 RF042
Growth
Growth
99 RF098
13.23
Large
20.83
Large
146 RF145
147 RF146
Value
Large
15.16
100 RF099
Growth
Growth
Large
20.71
Large
13.11
Value
14.98
Large
44 RF043
101 RF100
Growth
Growth
Large
20.86
Large
11.94
148 RF147
Value
Large
14.96
102 RF101
103 RF102
45 RF044
Growth
20.63
Growth
11.54
Large
Large
149 RF148
Value
Large
14.93
46 RF045
Growth
Growth
Large
20.62
Large
11.51
150 RF149
151 RF150
Value
Large
14.85
104 RF103
47 RF046
Growth
Large
20.55
Large
Growth
11.19
Value
14.45
Large
48 RF047
Growth
Large
20.27
152 RF151
Value
Large
14.27
49 RF048
Growth
20.23
Large
153 RF152
154 RF153
Value
Large
14.25
Growth
50 RF049
Large
20.07
Value
Large
13.94
51 RFO50
Large
Growth
19.63
155 RF154
Value
13.22
Large
52 RF051
Growth
Large
19.46
156 RF155
Value
Large
12.12
53 RF052
Growth
Large
19.39
157 RF156
158 RF157
Value
Large
11.32
54 RF053
55 RF054
56 RF055
Growth
Large
19.23
Value
11.21
Large
Growth
19.16
Large
159 RF158
Value
Large
9.82
Growth
Large
19.13
57 RF056
Growth
Large
19.08
help_outline

Image Transcriptionclose

Large Growth Large Value В J A В C Fund Number Market Cap Type 3YrReturn% 1 Fund Number Market Cap Type 3YrReturn% 58 RF057 Growth Large 18.92 105 RF104 Value Large 31.25 59 RFO58 2 RF001 Growth Large Growth 62.91 Large 18.87 106 RF105 Value Large 27.03 54.79 3 RF002 60 RF059 Growth Growth 18.77 Large Large 107 RF106 Value Large 23.49 4 RF003 Growth 61 RF060 Growth Large 54.75 Large 18.46 108 RF107 Value Large 21.94 5 RF004 62 RF061 Growth 38.84 Growth Large Large 18.38 109 RF108 110 RF109 Value Large 21.76 6 RF005 7 RF006 Growth 63 RF062 Growth Large 33.65 Large 18.34 Value Large 21.26 64 RF063 Growth Growth 18.28 Large 33.18 Large 111 RF110 Value Large 20.93 8 RF007 9 RF008 Growth Growth 65 RF064 18.12 Large 32.45 Large 112 RF111 Value Large 20.02 66 RF065 Growth Growth Large 29.08 Large 18.01 113 RF112 Value 20.01 Large 10 RF009 Growth 67 RF066 Growth Large 27.22 Large 17.98 114 RF113 Value Large 19.46 11 RF010 68 RF067 Growth 27.17 Growth 17.98 Large Large 115 RF114 Value Large 18.94 Growth Growth 12 RF011 69 RF068 Large 26.97 Large 17.94 116 RF115 Value Large 18.87 13 RF012 70 RF069 Growth Growth 17.76 Large 26.40 Large 117 RF116 Value 18.83 Large 71 RF070 14 RF013 15 RF014 Growth Growth Large 25.50 Large 17.69 118 RF117 Value Large 18.25 Growth 72 RF071 Growth 17.63 Large 24.97 Large 119 RF118 Value Large 18.21 16 RF015 17 RF016 73 RF072 Growth Growth 17.53 Large 24.85 Large 120 RF119 Value Large 18.04 Growth 24.72 74 RF073 Growth 17.43 Large Large 121 RF120 Value 17.95 Large 18 RF017 Growth 75 RF074 Growth Large 24.64 Large 17.25 122 RF121 Value Large 17.87 19 RF018 76 RF075 Growth Growth 17.25 Large 24.20 Large 123 RF122 124 RF123 125 RF124 Value Large 17.78 20 RF019 Growth 77 RF076 Growth 17.25 Large 23.81 Large Value 17.88 Large 21 RF020 78 RF077 Growth Growth Large 23.77 Large 17.17 Value Large 17.63 22 RF021 79 RF078 Growth Growth Large 23.73 Large 16.86 126 RF125 Value Large 17.34 23 RF022 24 RF023 Growth 80 RF079 Large Growth 23.70 Large 16.68 127 RF126 128 RF127 Value Large 17.42 Growth 81 RF080 Growth 16.61 Large 23.47 Large Value 16.86 Large 25 RF024 Growth 82 RF081 Growth Large 23.40 Large 16.59 129 RF128 Value Large 16.67 26 RF025 83 RF082 Growth 16.41 Large 23.23 Large Growth 130 RF129 Value Large 16.65 27 RF026 Growth 84 RF083 Large Growth 22.80 Large 16.32 131 RF130 Value Large 16.55 28 RF027 85 RF084 Growth Growth Large 22.77 Large 15.96 132 RF131 Value 16.35 Large 86 RF085 29 RF028 Growth Growth Large 22.37 Large 15.92 133 RF132 Value Large 16.23 30 RF029 31 RF030 87 RF086 Growth 22.15 Growth Large Large 15.89 134 RF133 Value Large 16.15 Growth 88 RF087 Large Growth 22.01 Large 15.65 135 RF134 136 RF135 Value Large 16.04 32 RF031 33 RF032 Growth 89 RF088 Growth 15.51 Large 21.80 Large Value 15.98 Large 90 RF089 Growth Growth Large 21.74 Large 15.50 137 RF136 Value Large 15.97 91 RF090 34 RF033 Growth 21.71 Growth 15.44 Large Large 138 RF137 Value Large 15.94 35 RF034 36 RF035 Growth 92 RF091 Large Growth 21.65 Large 14.96 139 RF138 Value Large 15.81 Growth 93 RF092 Growth Large 21.62 Large 14.67 140 RF139 Value 15.53 Large 37 RF036 Growth 94 RF093 Growth Large 21.34 Large 14.39 141 RF140 Value Large 15.51 95 RF094 38 RF037 Growth 21.24 Growth 14.36 Large Large 142 RF141 Value Large 15.49 39 RF038 Growth 96 RF095 14.33 Large 21.21 Large Growth 143 RF142 Value Large 15.36 40 RF039 Growth 20.96 97 RF096 Growth Large Large 14.28 144 RF143 Value Large 15.34 41 RF040 Growth 20.94 98 RF097 Growth 14.02 Large Large 145 RF144 Value Large 15.23 42 RF041 43 RF042 Growth Growth 99 RF098 13.23 Large 20.83 Large 146 RF145 147 RF146 Value Large 15.16 100 RF099 Growth Growth Large 20.71 Large 13.11 Value 14.98 Large 44 RF043 101 RF100 Growth Growth Large 20.86 Large 11.94 148 RF147 Value Large 14.96 102 RF101 103 RF102 45 RF044 Growth 20.63 Growth 11.54 Large Large 149 RF148 Value Large 14.93 46 RF045 Growth Growth Large 20.62 Large 11.51 150 RF149 151 RF150 Value Large 14.85 104 RF103 47 RF046 Growth Large 20.55 Large Growth 11.19 Value 14.45 Large 48 RF047 Growth Large 20.27 152 RF151 Value Large 14.27 49 RF048 Growth 20.23 Large 153 RF152 154 RF153 Value Large 14.25 Growth 50 RF049 Large 20.07 Value Large 13.94 51 RFO50 Large Growth 19.63 155 RF154 Value 13.22 Large 52 RF051 Growth Large 19.46 156 RF155 Value Large 12.12 53 RF052 Growth Large 19.39 157 RF156 158 RF157 Value Large 11.32 54 RF053 55 RF054 56 RF055 Growth Large 19.23 Value 11.21 Large Growth 19.16 Large 159 RF158 Value Large 9.82 Growth Large 19.13 57 RF056 Growth Large 19.08

fullscreen
check_circle

Expert Answer

star
star
star
star
star
1 Rating
Step 1

a).

Here, we want to test if there is a significant difference between the average rate or return on large value and large growth stock funds.

Thus, the two variables of interest are “large value” and “large growth”.

Step 2

b).

The null and alternative hypotheses are stated below:

0
help_outline

Image Transcriptionclose

0

fullscreen
Step 3

c).

Step-by-step procedure to obtain the test statistic using Excel Mega stat is given below:

  • In EXCEL, Select Add-Ins > Mega Stat > Hypothesis Tests.
  • Choose Compare Two Independent Groups.
  • Choose Data Input.
  • In Group 1, enter the column of large Growth.
  • In Group 2, enter the column of large value.
  • Enter 0 Under Hypothesized difference.
  • Check t-test (pooled variance), enter Con...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Math

Statistics

Other

Related Statistics Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Number 11

A: a.The null and the alternative hypotheses used for testing are given below:

question_answer

Q: Find the z value that corresponds to the given area in the figure below. Use a graphing calculator a...

A: It is given that Z is the standard normal variable. The required z-value can be obtain using MINITAB...

question_answer

Q: Suppose the neck size of men is normally distributed, with a mean of 15.5 inches and a standard devi...

A: Hey, since there are multiple subpart questions posted, we will answer first three subpart questions...

question_answer

Q: You wish to test the following claim (HaHa) at a significance level of α=0.05.      Ho:p1=p2      Ha...

A: Null Hypothesis: H0:p1=p2 Alternative Hypothesis: H1:p1<p2

question_answer

Q: Views on the Death Penalty. The Pew Research group conducted a poll in which they asked," are you in...

A: The appropriate null and alternative hypotheses are shown below:H0: p1 = p2.Ha: p1 ≠ p2.The test sta...

question_answer

Q: 3) Disney World requires that people employed as mickey mouse characters must have a height between ...

A: Hey, since there are multiple questions posted, we will answer first question. If you want any speci...

question_answer

Q: In the previous problem, there was a correlation of .62 between hours spent playing video games and ...

A: The percent of the variance in hours spent playing video games is accounted for by hand-eye coordina...

question_answer

Q: Lester Hollar is vice president for human resources for a large manufacturing company. In recent yea...

A: Degrees of freedom:For student’s t distribution, the degrees of freedom is n –1.The number of observ...

question_answer

Q: Graph these data. Based on your graph, is there evidence to suggest the distribution is not uniform?

A: Given data