(Step-by-Step) A financial analyst for Blue Investors wants to know how different investment strategies and fund manager tenure affect mutual fund returns.
Question: A financial analyst for Blue Investors wants to know how different investment strategies and fund manager tenure affect mutual fund returns. Mutual funds tracked by Morningstar were randomly sampled and end of year (EOY) return for a hypothetical $1,000 investment (in dollars), tenure of the fund manager (in years), and investment strategy (value or growth) were determined. The data are presented in Table F2.
- Using mathematical symbols, specify the linear model that is most appropriate for testing the relationship between fund manager tenure, investment strategy, and mutual fund return.
- Analyze the data. Specify the analytical technique you used and managerially interpret the results. Include Excel output to support your analysis.
- Graphically illustrate the relationship between mutual fund returns and the factor(s) found to affect returns.
Deliverable: Word Document 