Please. I only need quuestion 6
A B C D E F G H 1 J Adj R-Square 0,353 Std Error 123138,802 MS 1,3378E+11 15163164623 F 8,823 p-value 0,000 1 Multiple regression results for BASE PRICE 2 3 Regression summary 4 Multiple R R-square 5 0,631 0,398 6 7 ANOVA table 8 df SS 9 Regression 9 1,20402E+12 10 Error 120 1,81958E+12 11 Total 129 3,0236E+12 12 13 Regression equation 14 Coefficient Std Error 15 Intercept 125000,000 123138,802 16 COUNTRY_AUS 68181,818 125906,312 17 COUNTRY_BAN -75000,000 174144,564 18 COUNTRY_ENG 675000,000 142188,441 19 COUNTRY_IND 35660,377 124295,061 20 COUNTRY_NZ 110714,286 131640,917 21 COUNTRY_PAK 66666,667 129799,694 22 COUNTRY_SA 50000,000 126928,572 23 COUNTRY_SL 70833,333 128166,929 24 COUNTRY_WI 62500,000 133005,108 25 t-stat 1,015 0,542 -0,431 4,747 0,287 0,841 0,514 0,394 0,553 0,470 95% conf intervals p-value Lower 0,312 -118806,259 0,589 -181103,917 0,667 -419794,118 0,000 393476,782 0,775 -210435,192 0,402 -149925,568 0,608 -190327,695 0,694 -201309,739 0,582 -182928,266 0,639 -200840,857 Multicollinearity checks Upper VIE R-square 368806,259 317467,553 19,108 0,948 269794,118 1,985 0,496 956523,218 3,908 0,744 281755,947 31,985 0,969 371354,140 7,569 0,868 323661,028 9,308 0,893 301309,739 14,908 0,933 324594,933 11,800 0,915 325840,857 6,677 0,850 Questions for the Pricing of Players in the Indian Premier League case 1. Develop a multiple regression model and identify statistically significant predictors that influence the price of players in the IPL 2. Cricket in the T20 format is considered a young man's sport, is there evidence that the player's price is influenced by age? 3. What is the impact of ability to score SIXERS on the player's price? 4. What is the impact of the predictors' batting strike rate and bowling strike rate on pricing? Identify the predictor that has the highest impact on the price of players 5. Identify the player who is highly overpaid and the player who is highly underpaid 6. Are the players of Indian origin paid more than players from other countries? 7. If a regression model was built after removing Virat Kohli from the sample, what would be the impact on the coefficient for the predictors, INDIA AND L25? How would you interpret this imact? 8. How much should Mumbai Indians offer Sachin Tendulkar if they would like to retian him? Is the model sufficient to predict the price of Icon players
