A logistics company needs to minimize the excess space measured as 1000 sqft on any given delivery Excess1000. He gathers data on a sample of NE57 shipments and would like to run a regression with the following independent variables. The results are reported below. Client10 is a continuous variable that measures the number of customers in 10's on any one shipment. The categorical variables are Region and ABLing shown below. ABLins, =1 if shipment was on ABLine carrier #0 If shipment was on Other carrier Region1 =1 if shipment originated in Region1 -0 otherwise Omitted category Is Regions Region2 =1 if shipment originated in Region 2 =0 otherwise Regression Analysis: Excess1000 versus Client10, ABLine, Reg1, Reg2 Method Categorical predictor coding (1, 0) Analysis of Variance Source OF Ad SS Ad MS F-Value P.Value Regression 10103-1 2525.77 6.9 0.00 Client10 3796.3 3796.33 1039 0.002 ABLine 59.9 59.94 0.16 0.687 Reg1 13552 1355.22 1.71 Reg2 16190 1619.04 4.43 Enor 52 19007-3 365.52 Lock-of-Fa 18 6696.1 372.01 103 0.457 Pure Error 34 123111 362.09 Total 56 291104 Model Summary R. R-aglachy R-1ofpred) 19.1107 34.71%% 29.60% 23.09% Coefficients Term Cool SE Coel T-Value P.Value VIF Constant 1855 681 272 10.009 Client10 5.20 0 002 1.05 ABLINE 6 687 1.08 Reg 125 650 0.060 L16 Reg2 -13.09 622 -210 0040 1.12Choose the correct computed and table test statistics Region 1 and for Ho;BRegion1= 0; O FC= 6.9 Table = T.025,4,52 and T.025,4,52 O TC= 12.51 O TC=1.93 Choose the best recommendation for ABLine that minimizes Excess space Do not spend money using ABLine versus other carriers to minimize excess space. Choose ABLine and Region 2 in order to minimizes excess space. Choose other carriers rather than ABLine to minimize Excess space Choose ABLine in order to reduce excess space since ABLine has lower Excess space than other carriers. Choose the best recommendation for Region 2 to minimize Excess space. Use Region 3 rather than Region 2 origination. Use Region 2 versus other originations. O Use Region 2 rather than Region 3 origination. Do not pay more for Region 2 versus Region 3 origination