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
- help on how write business research proposal either on the role of management in achieving organizational goals in micro finance institutions in Kenya /
- Please refer to the attachment to answer this question. This question was created from Dialogue Essay Assignment w17. Additional comments: "Would you say
- 1985 history of The medical Treatment and active Labor Act (TEMTALA)