2 a This assignment uses a somewhat updated version of the d

2 a. This assignment uses a somewhat updated version of the data set we discussed in class on Nov. 5. The entries below list the 3 seating capacity, the average banking angle (degrees), the track length (miles) as well as the record speed (mph) during a 4 qualifying lap and the record average speed (mph) during a race. You are going to develop separate models for the qualitying Sspeed and the average race speed. Notice that there are two tabs in the workbook. Seats BankAng Trklngth TopQual TopRace Use the correlation matrix (shown in yellow) 9 a ATLANTA MOTOR SPEEDWAY 10 b BRISTOL MOTOR SPEEDWAY 124,000 160,000 154 197 478163.633 053 150 585131.407 2.00 187.432 160.166 1.50 189 414145.138 137 184.145 141.383 2.50 210 364177.602 1.00 164 444132.719 50 181 238142.245 2.50 188.889 155.912 150 197773144.122 1.50 72 563146.530 50 186.034 160.306 0.53 100.20182.223 2.00 206 558173.997 106 140.598117.134 100 142.141 0.75 130 599108.707 266 212.809 188.354 1.50 196 235160577 CCALIFORNIA SPEEDWAY 12 d CHICAGOLAND SPEEDWAY Seats | BankAng ·mtngth, I ToeRace 1.0000 13 DARLINGTON RACEWAY 14 f DAYTONA INTERNATIONAL SPEEDWAY 1.0000 0.1841 15 & DOVER INTERNATIONAL SPEEDWAY SPEEDWAY 65,000 257,325 81,867 17 I INDIANAPOLIS MOTOR SPEEDWAY 18 j KANSAS SPEEDWAY 19 k LAS VEGAS MOTOR SPEEDWAY thru 2009 20 LOWES MOTOR SPEEDWAY 21MARTINSVILLE SPEEDWAY 22 n MICHIGAN INTERNATIONAL SPEEDWAY 23 o NEW HAMPSHIRE INTERNATIONAL SPEEDWAY 91,000 24 p PHOENIX INTERNATIONAL RACEWAY 25 q RICHMOND INTERNATIONAL RACEWAY 26 r TALLADEGA SUPERSPEEDWAY through 2009175,000 27 s TEXAS MOTOR SPEEDWAY 5 76,800 112,029 112.918 191,122 RACE SPEED all this 1\" and

Solution