The data on structurally deficient highway bridges compiled by the Federal Highway Administration (FHWA) into the National Bridge Inventory (NBI). For each state, the NBI lists the number of structurally deficient bridges and the total area (thousands of square feet) of the deficient bridges. The data for the 50 states (plus the District of Columbia and Puerto Rico) are saved in the file. (The first five and last five observations are listed in the table in the next column.) For future planning and budgeting, the FHWA wants to estimate the total area of structurally deficient bridges in a state based on the number of deficient bridges.
For Information: Refer to Exercise 1.28

a. Write the equation of a straight-line model relating total area (y) to number of structurally deficient bridges (x).
b. The model, part a, was fit to the data using Minitab. as shown below. Find the least squares prediction equation on the printout.
c. List the assumptions required for the regression analysis.
d. Locate the estimated standard error of the regression model, s, on the printout.
e. Use the value of s to find a range where most (about 95%) of the errors of prediction will fall.

State NumberArea (thousands of sq. ft) Alabama Alaska Arizona Arkansas California 1,899 181 3,140 432.7 60.9 110.5 3473 5.1 Washington West Virginia Wisconsin Wyoming Puerto Ricco 502.0 31.5 399.8 143.4 195.4 1,058 1,302 241 Regression Analysis: SDArea versus NumberSD The regression equation is SDArea 120+0.346 NumberSD PredictorCoef SE CoefT Constant NumberSD 0.34560 0.06158 5.61 0.000 119.9123.0 0.97 0.335 S. 635.187 R-Sq 38.7% R-Sq (adj) 37.4 Analysia of Variance Source Regression Residual Ezzo: 50 20173111 403462 Tocal DF sS MS 1 12710141 12710141 31.50 0.000 51 32883252