Mutual funds are classified as load or no-load funds. Load funds require an investor to pay an initial fee based on a percentage of the amount invested in the fund. The no-load funds do not require this initial fee. Some financial advisors argue that the load mutual funds may be worth the extra fee because these funds provide a higher mean rate of return than the no-load mutual funds. A sample of 30 load mutual funds and a sample of 30 no-load mutual funds selected for analysis are contained in the Excel Online file below. Data were collected on the annual return for the funds over a five-year period. Construct a spreadsheet to answer the following questions. Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak Open spreadsheet a. Formulate Ho and H, such that rejection of He leads to the conclusion that the load mutual funds have a higher mean annual return over the five-year period. He do 0 10 b. Use the 60 mutual funds in the table above to conduct the hypothesis test. What is the p-value? p-value is (to 4 decimals) At a .05, what is your conclusion? that the mutual funds with a load have a greater mean rate of return. Mutual Funds-Load Load Helum Mutual Funds No Load No Load Retum Part b American National Grown 131 Anh Smal Cap Equity Barbell Cap Bosc the 15.03 Berger One Hundred Amana Income Fund Columbia International 1124 10.13 10.17 After reading these instructions delete at the Calvet World Use the XL Miner Analysis TooPak to conduct your I-Test analysi Dodge & Co Banced 1406 Colonial 17.33 1561 Sense Grown 1464 17.87 Davis Convert Suites 1242 Forts Advig Cap A Fiduity Fund 1861 After deleting a text in this shaded ares, set the output range in The TooPak to the top left cell of this area (02) 11.38 2011 Founders Be Chip Fund 1515 10 Dware Smal Cap Your 1-Test output should fit into this shaded area 1677 Goldman Core Fixed Income 11 Oy P 11.05 Hearland Value 10.15 12 Federated Stocks & Bonds 11.91 Jau Fund 1302 hoome 1424 1439 Memil Manatay Cap Agonciation 15.29 Spec Val 14.42 13 Equity Capital 1476 1740 FPA CA 2196 Oberes Emerging Gown 9.00 Gab Val Fund Paine Weber Growth & Income 1180 Significance Level (Ap) 005 2105 Pimco Total Retu 643 Cart we conclude that the mutual funds 10S New O 16.00 Prudental Equity 1629 20 John Hanck Goth&cone 1626 Puman Growth & Income 1580 Lint Abben Dev G 2125 Royce FD Mc Cap 15.05 1985 Souder Development 1080 23 MB Wid 1199 Smith Bamey Appreciation 13.09 24 New England Growth Opp 18.70 Se Foe Captop 1770 25 Oppenher Quest Ca 1367 Tow Price Matance 1157 Phoes Wh 1648 Thompson Plumb Crow 10 M 750 USAA G&Tax Stat Sagoch Diet Income 1500 17.00 yed Card come 11.30 1871 Vary OH legiona 1264 11.50 21 SR TRA 15.10 1782 with a load have a greater mean rate of ? Enter Car condudeor Cannot conce Formula A