can you develop seperate models based on info given and comp

0. This assignment uses a somewhat updsted version of the data set we diacussed in class on Now. S. The entries below list the seating capacity, the average banking angle (degrees), the track lergth (miles) as well as the record speed (mph) during a qualitying lap and the record average speed (mph) during a race. You are going to develop separate models for the qualifyling speed and the average race speed. Notice that there are two tabs in the workbook BankAng | Trkingth Topaual | TopRace Use the correlation matrix (shown in yelow) Seats 54-197 47S: 53150 585 131.40 16,633 ATLANTA MOTOR SPEEDWAY b BRISTOL MOTOR SPEEDWAY 160,000 36 1 c CALIFORNIA SPEEDWAY 2.00 187 432 160.166 1.50 18944 145.138 _ 1.37-184.145 141.383 2.50 220 364177.602 100 164444 132.719 1.50 181 238142.245 2.50 188 889 155.912 S0 197.773 144.122 50 172 563 146530 50 186.034160.306 82.223 18 63,000 168,000 95,500 e DARLINGTON RACEWAY 4 DAYTONA INTERNATIONAL SPEEDWAY 23036417 1.00 164444 E DOVER INTERNATIONAL SPEEDWAY 8589 TopRace 055850.5193 HOMESTEAD-MIAMI SPEEDWAY INDIANAPOLIS MOTOR SPEEDWAY KANSAS SPEEDWAY 65,000 257,325 6 1 9 k LAS VEGAS MOTOR SPEEDWAY thru 2009 O ILOWES MOTOR SPEEDWAY 1 MARTINSWILLE SPEEDWAY 2 n MICHIGAN INTERNATIONAL SPEEDWAY 81,867 142,000 140,000 65,000 137,243 0.53 100.201 RACE SPEED 12 2.00 206.558173.997 1.06 140598L 117,134 112.918 3O NEW HAMPSHIRE INTERNATIONAL SPEEDWAY 91.000 76,B00 112,029 00 142 14 p PHOENOX INTERNATIONAL RACEWAY a RICHMOND INTERNATIONAL RACEWAY 75 130 599108707 33 266 212809 188.354 50 196235160.577 14 26 r TALLADEGA SUPERSPEEDWAY through 2009 175,000 TEXAS MOTOR SPEEDWAY Call this.ki.and 1. First, decide which variable (seats, bank angle, or track le st,decide whi hva abe sets, bar kage etracklength1 has the highest correlation with the speed of speed against x1. You may use the trendäine use the trendline function, the Analysis Too Pak, Minitab, or whatever 31 do a simple regression line of best fit and put the residuals for track length) is most highly correlated with the residuals you x2. As before you may use the trendline, Minitab, cr Call that variable-r and regres s the residuals against x2. As before you may use the just found the space marked Residuals to the right Find the estimated speed using this model and put the residuals equation to the one you found in 3 above. Put the residuais from this imodel in the space marked \"4\" Residuals at the yod expect them to be identical?

Solution

On the basis of information given so many techniques are presents in the statistical analysis.

1. If data set having Regression data type

Based on the information given in the data set , at first we decided the independent variable and dependent variable. Regression coefficient find on the basis of the data and write the model and predict the future observation if corresponding indepent variable known.

2. Using Finite difference of Numerical analysis techniues

Anothe methods also to calculate the missing value using Newton\'s formula in Numerical Analysis. In this method we find the intermidiate as well as exterpolation missing observation find. Simpson\'s 1/3 rd rules also applicable to calculate the missing value in data set.