There are thousands of mutual funds available. There is no shortage of sources of information about them. Newspapers regularly report the value of each unit, mutual fund companies and brokers advertise extensively, and there are books on the subject. Many of the advertisements imply that individuals should invest in the advertisers mutual fund because it has performed well in the past. Unfortunately, there is little evidence to infer that past performance is a predictor of the future. However, it may be possible to acquire useful information by examining the managers of mutual funds. Several researchers have studied the issue. One project gathered data concerning the performance of 2029 funds.

The performance of each fund was measured by its risk-adjusted excess return, which is the difference between the return on investment of the fund and a return that is considered a standard. The standard is based on a variety of variables including the risk-free rate.

There are four variables that describe the fund manager. They are age, tenure (how many years the manager has been in charge), whether the manager had an MBA (1 = yes, 0 = no), and a measure of the quality of the managers education (the average Scholastic Achievement Test (SAT) score of students at the university where the manager received his or her undergraduate degree).

Conduct an analysis of the data. Discuss how the average SAT score of the managers alma mater, whether he or she has an MBA and his or her age and tenure are related to the performance of the fund.

Use 0.05 significance level.

Analysis should include:

1. Multiple regression equation with Excel output. (1 mark)
2. Assessing the model using 3 ways (standard error of estimate, coefficient of determination, F-Test). Is the model valid?

(3 marks)

3. Interpreting the coefficients of the equation. (4 marks)
4. Which of the variables are linearly related to the dependent variable? Provide the testing procedure. (2 marks)

https://docs.google.com/spreadsheets/d/1qU-Y_7nht3LEwoi1kZBdsMVLiDXfzXLvaiqtbpqpTRU/edit?usp=sharing