please answer. i will thumbs up

Problem 4 The following shows the value of a portfolio (Y) and the investments in the portfolio. Please clearly identify various parts of your solutions to this problem as a, b, c, and d. Use 95% confidence for this problem. You do not need to unhide the rows to solve this problem. a. Run a Regression analysis and determine the estimated regression function between the dependent (5 points) variable and all the independent variables. Which variables are significant? How do you know? b. Drop the variables that are not significant and run a new regression analysis with significant variables. (5 points) c. Is the model significant? Explain how you arrived at your conclusion. (5 points) Portfolio Value Problem 4 The following shows the value of a portfolio (Y) and the investments in the portfolio. Please clearly identify various parts of your solutions to this problem as a, b, c, and d. Use 95% confidence for this problem. You do not need to unhide the rows to solve this problem. a. Run a Regression analysis and determine the estimated regression function between the dependent (5 points) variable and all the independent variables. Which variables are significant? How do you know? b. Drop the variables that are not significant and run a new regression analysis with significant variables. (5 points) c. Is the model significant? Explain how you arrived at your conclusion. (5 points) Portfolio Value