You are hired in an investment company shortly after graduation and you need to assist investors interested in stock mutual funds. In a study, a sample of 316 stock mutual funds included 227 growth funds and 89 value funds were collected by the investment company. You are asked to analyze the three different returns of the funds: 3 year return, 5 year return, and 10 year return to determine if they are all performing equally, or if you need to drop any. The data collected is located under the Retirement Funds data set from page 406.

Please address the following four questions using the data set Retirement Funds:

1. Use the Analysis of Variance (ANOVA)-Single Factor technique using Excel on the data set. Show the ANOVA table. Answer the hypothesis being tested in this case study. Also, determine your conclusions. Would you accept or reject the null hypothesis for this sample? Why or why not?
2. What recommendations would you offer to the investment company? Where the mutual funds performing equal, or not? Explain and provide your own conclusions.
   1. Provide Descriptive Statistics for the excel file (e.g., sample size, mean, median, standard deviation, standard error). What are your preliminary observations of the descriptive of data set?
3. Provide a Line Graph using Excel or StatCrunch of the 3 year return, 5 year return, and 10year return, and explain if these are performing in an equal fashion, or if any of these is performing poorly. Discuss your conclusion and determine if this conclusion relates to the ANOVA results.

Fund Number	3YrReturn%	5YrReturn%	10YrReturn%
RF001	24.26	11.06	8.97
RF002	22.72	-4.89	0.02
RF003	21.91	1.53	12.55
RF004	21.89	1.57	12.69
RF005	16.47	9.40	10.30
RF006	16.10	6.33	10.41
RF007	13.44	3.58	6.03
RF008	13.30	4.05	9.69
RF009	13.16	2.85	5.69
RF010	12.59	-0.33	6.77
RF011	12.45	4.70	9.88
RF012	12.39	5.85	7.44
RF013	12.16	2.51	8.73
RF014	12.15	2.74	9.53
RF015	12.14	3.40	9.44
RF016	11.97	4.75	3.99
RF017	11.84	1.75	8.46
RF018	11.80	6.37	7.41
RF019	11.44	3.93	9.37
RF020	11.29	4.34	8.62
RF021	11.21	1.59	4.80
RF022	11.13	-0.12	10.32
RF023	11.07	4.05	7.10
RF024	11.07	1.96	8.11
RF025	11.04	3.54	6.31
RF026	10.90	3.79	6.81
RF027	10.86	2.85	1.38
RF028	10.83	0.48	1.76
RF029	10.68	9.03	8.99
RF030	10.67	1.52	8.60
RF031	10.62	1.93	7.97
RF032	10.56	2.44	7.48
RF033	10.54	0.89	6.11
RF034	10.52	2.80	3.06
RF035	10.43	1.21	5.94
RF036	10.35	-0.42	3.80
RF037	10.11	0.72	6.36
RF038	10.07	1.63	5.76
RF039	10.06	0.04	6.81
RF040	10.02	2.42	6.42
RF041	10.01	3.13	9.93
RF042	10.00	-1.50	-1.50
RF043	9.95	-0.34	6.79
RF044	9.92	1.59	6.68
RF045	9.92	12.33	10.25
RF046	9.75	3.68	6.86
RF047	9.74	1.60	5.43
RF048	9.69	1.99	8.09
RF049	9.67	2.49	7.71
RF050	9.65	0.12	7.07
RF051	9.64	0.19	5.37
RF052	9.56	2.37	6.59
RF053	9.52	0.90	8.42
RF054	9.46	0.34	6.29
RF055	9.46	0.78	9.69
RF056	9.45	1.40	0.90
RF057	9.44	5.71	5.56
RF058	9.34	-1.04	7.74
RF059	9.30	-1.01	5.39
RF060	9.25	-0.28	6.81
RF061	9.19	0.84	4.33
RF062	9.11	1.22	4.76
RF063	9.07	-2.31	6.82
RF064	8.97	2.32	7.59
RF065	8.90	2.95	2.95
RF066	8.78	-0.10	6.98
RF067	8.70	2.61	7.61
RF068	8.47	0.29	5.41
RF069	8.42	-1.40	6.36
RF070	8.42	0.13	7.74
RF071	8.40	0.70	6.50
RF072	8.34	0.11	7.92
RF073	8.21	3.36	6.62
RF074	8.16	3.33	11.70
RF075	8.16	2.44	6.75
RF076	8.12	-2.10	3.44
RF077	8.09	-0.99	5.92
RF078	7.99	2.32	5.62
RF079	7.96	1.93	6.35
RF080	7.89	1.18	7.55
RF081	7.89	2.84	5.50
RF082	7.88	-1.73	6.50
RF083	7.81	0.86	8.03
RF084	7.75	-0.59	7.74
RF085	7.64	-0.11	6.22
RF086	7.64	0.96	5.35
RF087	7.63	1.22	6.18
RF088	7.24	-0.54	3.18
RF089	7.21	0.36	6.40
RF090	7.12	3.91	9.12
RF091	7.03	-0.69	6.29
RF092	6.90	-0.34	6.02
RF093	6.62	-3.27	8.41
RF094	6.52	-3.00	7.46
RF095	5.92	-3.41	2.38
RF096	5.63	0.95	-0.05
RF097	5.61	-1.40	5.27
RF098	5.50	-4.17	4.83
RF099	5.35	-0.10	5.24
RF100	4.70	-4.24	8.38
RF101	4.58	-3.65	0.51
RF102	3.70	-3.36	3.61
RF103	1.18	-5.17	-1.31
RF104	12.40	1.04	1.84
RF105	12.28	0.00	5.13
RF106	11.96	0.88	7.15
RF107	11.85	2.54	6.03
RF108	10.81	0.15	-0.62
RF109	10.52	1.49	5.31
RF110	10.47	1.11	6.67
RF111	10.45	4.06	5.16
RF112	10.34	1.70	6.69
RF113	10.30	1.26	6.67
RF114	10.27	2.00	6.90
RF115	10.11	0.95	7.79
RF116	10.10	2.49	4.01
RF117	9.93	-0.38	6.31
RF118	9.91	-0.91	7.20
RF119	9.62	0.24	8.14
RF120	9.43	-0.19	6.08
RF121	9.42	0.45	7.44
RF122	9.33	2.73	7.14
RF123	9.26	1.83	7.86
RF124	9.22	-0.37	5.82
RF125	9.03	2.34	5.91
RF126	9.03	-0.30	5.62
RF127	8.83	2.59	6.75
RF128	8.78	4.05	10.09
RF129	8.76	-0.55	6.09
RF130	8.51	0.22	3.54
RF131	8.35	-0.86	7.14
RF132	8.32	-0.86	5.50
RF133	8.31	-2.18	4.70
RF134	8.30	-0.94	5.79
RF135	8.23	1.26	7.82
RF136	8.22	-2.44	5.88
RF137	8.19	-1.13	5.52
RF138	8.12	3.54	7.52
RF139	7.87	0.47	7.10
RF140	7.74	-2.91	4.53
RF141	7.54	-0.05	6.44
RF142	7.47	4.96	4.37
RF143	7.23	0.03	6.36
RF144	6.80	4.02	5.46
RF145	6.70	3.95	4.03
RF146	6.01	-2.30	7.71
RF147	5.68	0.22	8.58
RF148	5.57	0.56	5.19
RF149	5.56	-0.56	5.29
RF150	5.48	0.33	2.10
RF151	4.87	3.44	5.72
RF152	4.84	4.07	3.41
RF153	2.37	-2.50	4.66
RF154	18.70	4.86	8.31
RF155	16.25	4.15	11.23
RF156	15.65	4.85	9.01
RF157	15.26	8.88	8.52
RF158	15.04	3.22	9.52
RF159	15.02	-3.31	4.20
RF160	14.97	3.07	8.88
RF161	14.61	6.06	13.15
RF162	14.56	2.71	4.89
RF163	14.44	3.49	10.27
RF164	14.17	3.42	9.09
RF165	13.78	3.06	8.48
RF166	13.78	5.03	9.74
RF167	14.44	3.49	10.27
RF168	14.17	3.42	9.09
RF169	13.78	3.06	8.48
RF170	13.78	5.03	9.74
RF171	13.55	4.68	10.90
RF172	13.50	5.04	5.33
RF173	13.50	6.95	13.05
RF174	13.49	3.60	9.99
RF175	13.40	4.59	9.63
RF176	13.31	6.95	7.18
RF177	13.26	1.97	9.34
RF178	13.24	3.37	11.51
RF179	13.01	-0.27	11.36
RF180	12.94	5.78	11.11
RF181	12.92	1.45	1.22
RF182	12.71	4.09	8.34
RF183	12.69	3.13	14.11
RF184	12.60	3.91	10.00
RF185	12.53	0.97	11.04
RF186	12.03	0.83	9.75
RF187	11.81	4.42	6.01
RF188	11.72	3.40	10.87
RF189	11.64	5.10	10.79
RF190	11.60	4.20	6.01
RF191	11.53	0.82	8.85
RF192	11.52	-4.40	11.20
RF193	11.50	2.41	8.96
RF194	11.49	4.24	5.31
RF195	11.42	7.91	10.27
RF196	11.27	2.77	6.81
RF197	11.16	4.23	7.34
RF198	10.91	4.02	5.37
RF199	10.86	3.47	7.38
RF200	10.34	0.09	7.53
RF201	10.73	1.16	9.31
RF202	10.39	0.08	10.01
RF203	10.20	3.15	14.00
RF204	10.08	3.75	10.29
RF205	10.04	0.16	8.47
RF206	9.78	-1.12	12.38
RF207	9.71	2.94	9.68
RF208	9.60	0.64	8.77
RF209	9.58	-3.82	8.40
RF210	9.09	2.50	6.52
RF211	8.65	2.19	7.76
RF212	8.54	2.93	4.88
RF213	8.54	-1.96	6.43
RF214	8.19	1.71	7.87
RF215	7.99	0.32	7.75
RF216	7.26	-1.21	8.81
RF217	7.11	1.47	3.14
RF218	7.00	-0.26	5.67
RF219	6.97	4.64	5.46
RF220	6.18	0.11	9.27
RF221	6.02	-0.45	5.59
RF222	5.26	-2.36	6.81
RF223	1.17	-0.83	7.17
RF224	1.05	-9.03	3.49
RF225	-1.63	-5.78	4.45
RF226	14.77	5.04	10.18
RF227	12.67	2.87	9.61
RF228	12.50	3.99	8.59
RF229	12.28	4.84	4.66
RF230	12.18	1.31	3.35
RF231	12.04	6.33	11.90
RF232	12.04	5.34	10.38
RF233	11.61	1.39	8.90
RF234	11.39	6.34	8.62
RF235	11.11	1.90	8.65
RF236	11.01	3.65	7.13
RF237	10.77	1.24	8.78
RF238	10.53	3.00	8.49
RF239	10.53	0.53	8.54
RF240	10.20	1.94	7.95
RF241	8.65	5.20	3.93
RF242	8.19	-0.11	4.41
RF243	7.51	3.44	9.99
RF244	5.02	8.71	6.85
RF245	19.47	5.49	5.51
RF246	16.23	6.97	11.29
RF247	16.12	4.81	9.58
RF248	15.83	5.52	8.93
RF249	14.96	4.19	9.78
RF250	14.94	2.33	7.80
RF251	14.90	2.63	11.77
RF252	14.66	4.58	8.42
RF253	14.23	3.17	0.35
RF254	14.14	3.91	5.47
RF255	13.85	3.98	5.05
RF256	13.48	4.29	12.23
RF257	13.47	5.29	6.65
RF258	13.22	2.49	9.52
RF259	13.07	-0.01	6.25
RF260	12.90	6.17	10.04
RF261	12.84	3.55	8.91
RF262	12.76	2.99	10.27
RF263	12.67	-0.77	4.28
RF264	12.63	2.53	8.53
RF265	12.52	4.65	5.80
RF266	12.48	2.50	8.78
RF267	12.40	0.50	10.89
RF268	12.36	0.63	7.48
RF269	12.23	0.47	9.54
RF270	11.60	1.81	8.09
RF271	11.50	2.46	9.49
RF272	11.28	5.52	10.16
RF273	11.22	1.93	10.41
RF274	11.17	-1.46	8.00
RF275	11.14	-0.14	8.66
RF276	10.75	-0.11	8.36
RF277	10.57	1.88	2.90
RF278	10.54	3.67	5.50
RF279	9.94	-1.65	7.36
RF280	9.74	5.05	11.12
RF281	9.52	3.40	10.66
RF282	9.18	2.52	9.10
RF283	9.16	4.93	10.18
RF284	8.71	0.57	2.95
RF285	7.62	6.15	10.10
RF286	7.49	0.69	12.78
RF287	6.61	4.57	4.97
RF288	6.57	-2.09	4.08
RF289	6.56	-1.35	6.19
RF290	5.96	1.40	9.57
RF291	5.47	2.90	9.69
RF292	5.45	-2.93	6.31
RF293	5.38	-3.81	8.30
RF294	5.12	0.39	5.02
RF295	3.60	-1.08	-0.05
RF296	3.41	-4.05	5.78
RF297	19.88	10.75	6.10
RF298	14.69	3.09	9.86
RF299	13.80	6.15	10.12
RF300	13.13	6.63	9.63
RF301	12.25	4.41	11.78
RF302	12.11	4.91	10.10
RF303	12.09	7.31	8.29
RF304	11.76	6.27	10.15
RF305	11.41	6.77	11.86
RF306	11.08	5.11	8.76
RF307	10.82	2.35	7.54
RF308	10.40	-2.27	4.27
RF309	10.23	2.02	8.47
RF310	9.63	11.35	11.51
RF311	8.96	2.60	2.86
RF312	8.88	6.08	9.56
RF313	8.72	2.34	9.90
RF314	8.58	1.51	4.24
RF315	7.43	3.46	9.16
RF316	7.12	4.41	9.80