Question

i want to know how could i conclude the gap that even though rhe sognofocance f is hogher than 0.05, but each variables are statistic based on p value is less than 0.05

2. You have been asked to develop a multiple regression model to predict the annual number of traffic deaths. The data file "traffic death rate" contains 10 years of annual data on the death rates per 100 mlion vehicle miles (y), total travel in billion vehicle miles (x1), and average speed in miles per hour of all vehicles (x2). Compute the multiple regression of y on xl and x2 and write a report discussing your findings Y X1 X2 738.0 52.6 5.2 5.3 767.0 53.8 5.4 805.0 55.8 5.6 847.0 55.9 5.5 889.0 56.4 5.7 930.0 57.3 5.5 962.0 58.0 1016.0 59.0 5.4 5.2 1071.0 60.0 4.9 1121.0 59.2 LO LO LO A E C E G X1 X2 2 5.2 738.0 52.6 5.30 767.0 53.8 5.4 805.0 55.8 5.6 847.0 55.9 869.0 030.01 6 5.5 56.4 7 SUMMARY OUTPUT 5.7 57.3 5.5 962.0 58.0 Regression Statistics 5,4 1016.0 59.0 e0.0 69.2 10 5.2 1071.0 Multiple R 0.742349 R Square 0.651083 Adjusted R 0.42282 Standard E 0.175633 4.9 11 1121.0 15 13 14 Observatio 10 15 16 ANOVA 17 MS gnfcance Regresson Residua 2 0.205071 0.132536 4.296634 0.000615 16 7 0215929 0.030647 0.401 20 Total 21 2 Coeficientslandard Em Pvalue 2.96943 3.436814 0.86401 0.416206 -11.0962 5.157348 -11.0962 5.157348 Lower 95% Upper 95 %.ower 95.0Jpper 95.0 % t Stat Intercept 23 24 25 X1 0.00447 0.001549 288535 0.023472 0.00813 0.00081 0.00813 0.00081 X2 0.218794 0.083909 2.607511 0.03504 0.02038 0417207 0.02038 0.417207 26 27