The data in the file FinPortfolio.xls contain the company's portfolio performance data. Each observation includes the average return of the portfolio, the portfolio manager's Age and Tenure (Years in the company) as well their SAT score and whether they are MBA graduates (Yes:0, No:1). The total assets of each portfolio in thousands of dollars are also given.
The management of the financial company would like to determine to what extend all those characteristics explain the variation among the returns of individual portfolios. A regression using Age, Tenure, MBA, SAT and Assets as explanatory variables was suggested by the management. However the Business Analytics group suggests that using the logarithm of the assets [log (Assets)] is more appropriate and is used as a standard practice in industry.
i. Define the two regression models as they are described above and perform the corresponding regression analysis. Compare the results and justify why the model suggested by the Business Analytics group is the most appropriate.
PLEASE GIVE ME INSTRUCTIONS ON HOW TO SEND THE EXCEL FILEWITH THE DATA
Recently Asked Questions
- Effective team-building requires the following: leadership, skill mix, shared vision, and support team member competency technology all of the above
- All of the following are potential acquisition team members EXCEPT the __________. end user/customer program manager HR analyst financial manager
- All of the following are Department of Defense (DoD) organizations EXCEPT __________. the U.S. Army, Navy, Marine Corps, and Air Force the Children's Defense