Question

In deciding where to invest her retirement fund, an investor recorded the weekly returns of two portfolios for one year, with the results stored in columns 1 and 2. Some of these data are shown below. Can we conclude at the 5% significance level that portfolio 2 is riskier than portfolio 1? Compare both return and risk . Do on Excel .

This is the Data :

Portflio-1	Portflio-2
0.22	0.32
0.59	0.35
0.11	0.48
-0.05	0.36
0.44	0.27
0.38	0.33
0.05	0.47
0.00	-0.01
0.27	-0.22
0.10	0.37
0.41	0.76
0.01	0.14
0.46	0.57
0.26	0.06
0.08	0.70
0.42	-0.32
0.38	0.83
0.22	0.55
0.13	0.73
0.11	-0.17
0.33	0.04
0.14	-0.07
0.28	0.28
0.28	0.31
0.44	0.72
0.28	-0.03
0.21	0.34
0.04	0.13
0.58	0.24
0.24	0.64
0.17	-0.22
0.10	0.81
-0.03	0.33
0.44	0.66
0.12	0.80
0.00	0.09
0.11	0.24
0.11	0.22
0.29	0.51
0.14	0.60
0.15	0.42
0.43	-0.10
0.15	0.26
0.55	0.57
0.18	0.24
0.22	0.37
0.22	0.41
0.11	0.78
0.03	0.24
0.10	0.32
0.15	0.56
0.23	-0.02

Answer 1