please answer carefully Consider the set of dependent and independent variables given below. Perform a best subsets regression and choose the most appropriate model for these data.: Click the icon to view the data.Find the most appropriate model for the data. Note that the coefficient is 0 for any variable that is not included in the model.(Round to three decimal places as needed.)Data tableyX4X222X3X464742417436329153051782092549521738294144141739424717173023358533371715403930151027442720103041201773349PrintDone

Given data: y x1 x2 x3 x4 64 74 22 24 17 43 63 29 15 30 51 78 20 9 25 49 52 17 38 29 41 44 14 17 39 42 47 17 17 30 23 35 8 5 33 37 17 15 40 39 30 15 10 27 44 27 20 10 30 41 20 17 7 33 49Excel was used to obtain the multiple regression equation with the following steps: Enter this data in excel. Select data analysis (from the data menu). Select regression. Input the y and x range. Click on ok. SUMMARY OUTPUT Regression Statistics Multiple R 0.949403 R Square 0.901366 Adjusted R Square 0.83561 Standard Error 5.353841 Observations 11 ANOVA df SS MS F Significance F Regression 4 1571.655 392.9137 13.70775 0.003554 Residual 6 171.9817 28.66361 Total 10 1743.636 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 31.28647 23.12932 1.352676 0.224908 -25.3089 87.88188 -25.3089 87.88188 X Variable 1 0.333387 0.218617 1.524979 0.178107 -0.20155 0.868324 -0.20155 0.868324 X Variable 2 0.205407 0.445282 0.461297 0.660835 -0.88416 1.294973 -0.88416 1.294973 X Variable 3 0.454481 0.184062 2.469176 0.048512 0.004098 0.904863 0.004098 0.904863 X Variable 4 -0.58985 0.427866 -1.37858 0.217219 -1.6368 0.457103 -1.6368 0.457103 Coefficients Intercept 31.28647≈31.286 X Variable 1 0.333387≈0.333 X Variable 2 0.205407≈0.205 X Variable 3 0.454481≈0.454 X Variable 4 -0.58985≈-0.590 Answer: y^=31.286+0.333x1+0.205x2+0.454x3-0.590x4.