\fa Learning C Due To A Recent Change By Mic b - Hypothesis Test for the Difference of Two Means (Structured) Q. Search this course X ToolPak 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 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. X Open spreadsheet a. Formulate Ho and H. such that rejection of Ho leads to the conclusion that the load mutual funds have a higher mean annual return over the five-year period. Ho : Mload - Hoo-load 0 Ha : Mload - Ano-load 0 b. Use the 60 mutual funds in the table above to conduct the hypothesis test. What is the p-value? p-value is 0.4969 (to 4 decimals) At & - .05, what is your conclusion? @ @that the mutual funds with a load have a greater mean rate of return. can conclude Reset Problem Check bly Work Next