Rates of return on 24 mutual funds are shown. Fund 12Month 5Year 1 12.5 9.7 2 2.4 3.2 3 8.3 4.6 4 3.7 3.5 5 3.1 2.3 6 10.1 6.6 7 14.4 6.1 8 5.4 6.7 9 6.6 7.1 10 12.0 15.5 11 9.2 12.1 12 10.4 8.1 13 8.4 15.2 14 10.3 7.7 15 12.8 11.4 16 1.0 4.8 17 6.5 5.3 18 21.4 8.9 19 1.2 3.8 20 7.5 9.2 21 7.8 10.4 22 0.8 9.1 23 0.9 5.9 24 14.0 8.8 Click here for the Excel Data File (a) Fill in the right side of the worksheet below. (Rank values lowest to highest by giving the lowest value a rank = 1.) Fund Rank 12-Month Rank 5-Year 1 IN W A CO 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24(b) Calculate Spearman's rank correlation coefficient. (Round your answer to 3 decimal places. Use the book's formula to determine the coefficient. If you use MegaStat to check answers, you must use version 10.2 Release 2.1 or higher. Ensure the box marked "correct for ties" is NOT checked. Connect's answers follow the textbook method, which does not correct for ties.) Rank correlation coefficient (c) Can the assumption of zero correlation be rejected? O Yes O No (d) Calculate the Pearson correlation coefficient. (Round your answer to 4 decimal places.) Pearson correlation coefficientRates of Return on Selected Mutual Funds (n = 20) Fund 12-Mo 5-Yr 12.5 9.7 -2.4 3.2 8.3 4.6 3.7 3.5 3.1 SOC NO) UI A W N- -2.3 10.1 6.6 14.4 6.1 5.4 6.7 6.6 7.1 10 12.0 15.5 11 9.2 12.1 12 10.4 8.1 13 8.4 15.2 14 10.3 7.7 15 12.8 11.4 16 -1.0 4.8 17 6.5 5.3 18 21.4 8.9 19 -1.2 3.8 20 7.5 9.2 21 7.8 10.4 22 0.8 9.1 23 0.9 5.9 24 14.0 8.8