MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

Question

the link to the data is given below. please help asap i will upvote!!

https://drive.google.com/file/d/1ervh7Ki2Nd-Ly1SjtXyCm82i40M6sE5z/view?usp=sharing

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
X
Open spreadsheet
a. Formulate
Ho and
Ha 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: load Uno-load
Ha: load
no-load
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?
-
Check My Work
î
0
0
that the mutual funds with a load have a greater mean rate of return.
Reset Problem
expand button
Transcribed Image Text: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 X Open spreadsheet a. Formulate Ho and Ha 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: load Uno-load Ha: load no-load 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? - Check My Work î 0 0 that the mutual funds with a load have a greater mean rate of return. Reset Problem
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman