Answer Happy

Date Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Den 13 B Energy -4.91 1.5 2.23 3.03 - 11.1 -5.75 8.73 -5.98 10.18 3.85 2.82 5.54 6.56 6.1 1.39 1.63 -4.05 -2.03 1.18 -10.35 -15.01 18.7 1.04 -8.37 4.38 5.16 -6.63 -1.5 - 12.17 5.66 2.73 2.84 2.84 -1.08 -0.8 0 5.66 -1.98 1.58 -0.22 1.6 -3.61 5.29 -0.27 2.98 4.51 -0.86 -157 Healthcare -0.09 0.49 1.34 -3.8 -5.14 -0.56 1.54 -1.07 8.19 2.28 -2.55 1.7 1.65 3.02 1.27 5.88 2.6 -0.59 -2.71 -2.83 -4.09 4.63 -0.15 -2.98 2.53 1.7 3.44 -0.47 -3.43 5.47 -0.47 1.9 3.75 -0.77 0.44 -3.05 6.44 1.3 3.62 3.07 1.31 0.33 5.59 -2.13 4.04 3.92 4.8 -4 59

D N A 47 Oct-13 48 Nov-13 49 Dec-13 50 Jan-14 51 Feb-14 52 Mar-14 53 Apr-14 54 May-14 55 Jun-14 56 Jul-14 57 Aug-14 58 Sep-14 59 Oct-14 60 Nov-14 61 Dec-14 62 Jan-15 63 Feb-15 64 Mar-15 65 Apr-15 66 May-15 67 Jun-15 68 Jul-15 69 Aug-15 70 Sep-15 71 Oct-15 72 Nov-15 73 Dec-15 74 Jan-16 75 Feb-16 76 Mar-16 77 Apr-16 78 May-16 79 Jun-16 80 Jul-16 81 Aug-16 82 Sep-16 83 Oct-16 84 Nov-16 85 Dec-16 B 4.51 -0.86 -1.57 -5.26 6.12 1.64 5.42 1.14 4.9 -4.69 1.86 -7.5 -5.05 -9.12 -9.69 -3.93 5.03 -2.46 10.54 -6.51 -4.37 -7.76 -4.83 -7.59 10.77 -1 -11.78 -1.44 -2.59 12.46 10.01 -1.36 3.54 -1.02 2.54 2.62 -3.02 6.97 0.2 1 3.92 4.8 -4.59 2.37 8.56 -6.08 -2 3.63 3.38 -0.13 3.97 -0.23 5.18 3.4 -8.51 2.05 4.79 -0.4 -0.64 4.81 -0.27 2.48 -5.78 -5.74 5.96 1.49 -3.72 -8.83 -1.83 -0.44 2.66 2.73 -0.02 5.13 -4.89 0.6 -7.65 1.51 -5.25

Exercise 14-59 Algo The following table shows a portion of the monthly returns data (in percent) from 2010–2016 for two of Vanguard's mutual funds: the Energy Fund and the Healthcare Fund. [You may find it useful to reference the t table.] Date Jan-10 Feb-10 Energy -4.91 1.50 Healthcare -0.09 0.49 : -5.25 Dec-16 0.20 Click here for the Excel Data File a. Calculate the sample correlation coefficient rxy. (Round intermediate calculations to at least 4 decimal places and final answer to 4 decimal places.) Sample Correlation coefficient b. Specify the competing hypotheses in order to determine whether the population correlation coefficient is different from zero. O Ho: Pxy S 0; HA Pxy> O Ho: Pxy 2 0; HA Pxy<0 O Ho: Pxy= 0; HA Pxy7 0

C-1. Calculate the value of the test statistic. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Test statistic c-2. Find the p-value. O p-value < 0.01 O 0.01 s p-value < 0.02 O 0.02 s p-value < 0.05 O 0.05 S p-value < 0.10 O p-value 2 0.10 c-3. At the 5% significance level, what is the conclusion to the test? O O Reject Ho; there is enough evidence to state the returns are correlated. Reject Ho; there is not enough evidence to state the returns are correlated. Do not reject Ho; there is enough evidence to state the returns are correlated. O Do not reject Ho; there is not enough evidence to state the returns are correlated.