A group of researches would like to determine the predictors of the stock price for a certain company. They obtained the stock price, net profit margin, return on asset ratio, return on equity ratio, and price earnings ratio for the past 10 years and the data is given below. Use a = 0.05. Net Profit Return on Return on Price Earnings Stock Price Margin Asset Ratio Equity Ratio Ratio 55 5.56 10.50 18.21 21.07 88.9 6.02 10.28 19.15 28.51 90.45 5.20 9.08 17.36 28.82 102 5.22 8.89 17.08 28.52 173.1 5.88 10.26 20.22 38.90 215 6.10 10.10 19.70 47.40 219 5.00 7.80 16.10 42.40 194 5.00 8.00 18.00 33.76 253 5.00 7.00 17.00 38.45 291.8 5.00 7.00 17.00 38.08 1. What is/are the significant predictor/s of stock price? 2. Determine the equation of the Linear Regression using: a. Significant predictors b. Including the non-significant predictors. 3. Explain the predicting capability of the predictors. 4. Using the linear regression line containing only the significant predictors, what will be the stock price given the following: Stock Price Net Profit Return on Return on Price Earnings Margin Asset Ratio Equity Ratio Ratio 4.85 6.50 15.60 20.97 6.42 10.73 21.00 48.00 5. Using the linear regression line containing all the possible predictors, what will be the stock price given the following: Stock Price Net Profit Return on Return on Price Earnings Margin Asset Ratio Equity Ratio Ratio 4.85 6.50 15.60 20.97 6.42 10.73 21.00 48.00