10.2 Excel Activity 2b - Hypothesis Test for the Difference of Two Means (Structured)

Please see attachments for data

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.