1. The Department of Transportation wishes to know if states with a larger percentage of urban population have higher rates of automobile and pickup crash deaths. In addition, it wants to know if either the average speed on rural roads or the percentage of rural roads that are surfaced is related to crash death rates. Data for this study are included in the data fileVehicle Travel State.
a. Prepare graphical plots of crash deaths versus each of the potential predictor variables. Note the relationship and any unusual patterns in the data points.
b. Prepare a simple regression analysis of crash deaths on the potential predictor variables. Determine which, if any, of the regressions indicate a significant relationship.
c. State the results of your analysis and rank the predictor variables in terms of their relationship to crash deaths.
Sheet1 StatePers IncomePercap DispPopulationP UrbanFatalitiesFat RateBAC 08Tot RegistAuto RegistDriversH MilesInter MilesR MilesFuel TaxTax pgalH ExpendDoctorsNursesP NinsurMedicaid Alabama127,479,66824,6284,62755.41,1101.83894,6781,9603,69297,32390575,29962018.001,75210,09442,18012.0765 Alaska23,179,53330,70468165.6841.63068023849514,4381,08112,081318.007101,5565,15018.297 Arizona177,294,69624,6536,35388.21,0661.73364,3722,2204,15460,5931,16837,67571718.002,33513,32134,58018.31,049 Arkansas72,598,26123,0452,83152.56502.01822,0109342,04699,55865687,59246221.501,0365,75821,92016.1622 California1,292,510,49030,48036,37894.43,9741.21,15533,93519,82923,467171,1542,46183,4453,26618.0013,28897,743233,20018.26,607 Colorado169,543,66030,3394,84384.55541.11701,7077753,50388,16395468,93456822.001,60112,57636,85016.4430 Connecticut163,078,96538,3983,49087.72770.91013,0471,9772,84921,2953466,18767725.001,26513,13534,6909.4435 Delaware29,385,63129,70886280.11171.2508514656246,242413,27911723.006762,1638,42011.2153 District of Columbia31,219,39245,560588100.0441.2152181613961,5051302720.003344,7458,1109.5146 Florida594,239,67728,82918,20089.33,2141.689016,4747,07514,139121,5261,47140,2562,23315.308,06945,110148,18020.22,276 Georgia271,138,10524,9549,52371.61,6411.54418,5134,1256,134118,7791,24381,0969347.502,87820,70862,23017.51,271 Hawaii42,602,26229,3421,27791.51381.3459935148634,341552,0418517.003524,0499,6207.5211 Idaho40,441,25823,8321,49666.42521.6701,2825191,02848,41661342,81023325.007582,5269,60013.9187 Illinois447,059,93230,40812,82687.81,2491.24349,7575,7388,190139,1572,17098,2051,33319.005,42435,932104,13013.42,107 Indiana178,862,26625,0326,33670.88981.32304,9562,6704,30995,4691,17273,32088018.003,25113,74554,77011.4882 Iowa88,534,19326,4612,98361.14451.41063,3601,7152,094114,193781102,90544121.001,5645,64729,5509.3363 Kansas86,218,65127,2922,77771.44161.41142,4298712,018140,271874127,61244024.001,4146,18124,07012.7279 Kentucky110,982,57623,2794,23655.88641.82103,5471,9112,93378,58776266,10856321.002,1949,84339,12013.6732 Louisiana130,465,10026,7484,37372.69852.23683,9271,8843,03461,00890544,73164020.001,92311,48739,09018.51,007 Maine38,000,54625,5991,31540.21831.2661,0805631,01022,79236719,80523327.605843,66213,8508.8259 Maryland221,924,94933,6365,61986.16141.11794,5102,6393,73831,30048114,02475523.502,68923,68048,84013.7711 Massachusetts269,334,13635,1586,46891.44170.81465,3673,2554,69936,0085737,96766821.002,81530,33578,2805.41,115 Michigan294,019,17726,07910,05074.71,0881.03058,1924,9227,059121,5931,24285,8371,01019.003,24025,14684,48011.61,547 Minnesota181,049,90930,2355,18270.95040.91584,7562,5393,149137,693914119,31065920.002,16815,19452,6908.3617 Mississippi70,855,49222,1182,92148.88842.03022,0081,1271,92774,62269863,84343118.401,6475,19625,35018.8670 Missouri169,689,72825,5165,87869.49921.43384,9172,6684,162129,1221,181106,41270417.003,95514,46256,29012.6833 Montana27,013,19025,07895754.12772.510694938473673,2031,19270,22019127.756222,1107,16015.683 Nebraska54,700,38827,3991,76969.82561.3771,7398011,33193,39848187,17633227.001,4364,34217,87013.2202 Nevada86,520,35029,6932,55491.53731.71181,4246891,66233,87257126,79452124.001,0634,79614,67017.2189 New Hampshire46,439,63831,4101,31259.31291.0341,1856391,02715,83922611,01715219.606933,60712,73010.5113 New Jersey364,124,23735,9748,65394.47241.01996,2473,7845,78238,7524317,29759010.504,01827,37378,51015.8915 New Mexico51,265,41123,3561,96475.04131.51331,5996871,36568,3391,00060,35128918.889424,78511,40022.5473 New York765,618,16532,76719,42987.51,3331.038411,4958,78511,369113,7401,68865,8742,19824.657,45976,925166,99013.24,147 North Carolina259,242,69025,0619,04260.21,6751.64876,3173,5696,384104,4121,10971,3061,65429.953,38522,98780,09016.41,354 North Dakota19,562,22227,71163855.91111.45371134047186,84257184,94512423.004411,5597,00010.054 Ohio336,238,15425,68711,47877.41,2571.139110,8486,2977,976125,1601,57480,4781,87728.004,41830,615114,92011.71,784 Oklahoma107,321,11426,5133,60865.37541.62193,2251,5922,283112,92293397,28941117.001,2826,26025,70017.8583 Oregon111,574,79325,9113,73678.74551.31503,0881,4332,82759,75872946,97539724.001,73610,25329,70016.8418 Pennsylvania409,493,68128,82812,42077.11,4911.45009,9385,7568,601121,5811,75876,4512,10731.205,99937,924126,3709.51,833 Rhode Island35,650,34529,7381,05390.9690.8257974867446,510721,27014630.004943,95510,60010.8178 South Carolina116,443,69523,4864,40560.51,0662.14633,5211,9293,12766,24884349,82653216.001,47210,12235,04016.4689 South Dakota24,183,18727,66079651.91461.64586536858983,74467980,86612822.004021,7439,67010.1102 Tennessee174,530,12025,7246,14963.61,2101.73905,3402,9964,42691,0581,10569,34585020.001,65716,20654,96014.41,207 Texas751,485,69328,25823,84382.53,3631.41,29218,0728,68115,184305,8553,233221,6613,06520.0013,13651,080157,87025.23,041 Utah67,668,31922,0802,66988.22991.1512,3201,1271,65244,22193632,67236924.501,3355,55316,67012.8208 Vermont19,775,10928,20762138.2660.92256529453414,40032012,9799320.003682,3205,66011.2141 Virginia273,030,75830,4927,69973.01,0271.33326,6143,9235,26072,6621,11950,35092717.503,22821,13257,74014.8754 Washington225,854,71131,1796,45082.05681.01955,7583,1244,88083,43176460,8801,10736.003,05717,41349,91011.3961 West Virginia45,199,49122,5191,81046.14312.11421,4136941,35938,27455532,99531631.501,0574,20116,97014.1311 Wisconsin172,603,49326,9835,59968.37561.33135,0182,6284,066114,70574392,55798630.902,27914,50750,6908.2907 Wyoming20,922,84434,79152365.11501.64965221039828,05291325,41010414.0048496542,05013.661 Sheet2 Sheet3 所有答案必须写在试题册上，可不抄题，但请表明题号 西北工业大学研究生院 学 位 研 究 生 课 程 考 试 试 题 考试科目：Applied Statistics（应用统计学） 课程编号：12B002 说 明：所有答案必须写在答题册上,否则无效。 共 2 页 第 2 页 西北工业大学研究生院 学 位 研 究 生 课 程 考 试 试 题 考试科目：Applied Statistics I 课程编号：12B002 姓 名: 学 号: 说 明：所有答案必须写在答题册上,否则无效。 共 2 页 第 1 页 1. The Department of Transportation wishes to know if states with a larger percentage of urban population have higher rates of automobile and pickup crash deaths. In addition, it wants to know if either the average speed on rural roads or the percentage of rural roads that are surfaced is related to crash death rates. Data for this study are included in the data file Vehicle Travel State. a. Prepare graphical plots of crash deaths versus each of the potential predictor variables. Note the relationship and any unusual patterns in the data points. b. Prepare a simple regression analysis of crash deaths on the potential predictor variables. Determine which, if any, of the regressions indicate a significant relationship. c. State the results of your analysis and rank the predictor variables in terms of their relationship to crash deaths. (SPSS is required, 50 scores) 西北工 业 大 学研 究生院 学 位 研 究 生 课 程 考 试 试 题 考 试 科目： Applied Statistics I 课 程 编号 ： 12B002 姓 名 : 学 号 : 说 明：所有答案必 须写 在答 题册 上 , 否 则 无效。 共 2 页 第 1 Ò³ 1. The Department of Transportation wishes to know if states with a larger percentage of urban population have higher rates of automobile and pickup crash deaths. In addition, it wants to know if either the average speed on rural roads or the percentage of rural roads that are surfaced is related to crash death rates. Data for this study are include d in the data file Vehicle Travel State . a. Prepare graphical plots of crash deaths versus each of the potential predictor variables. Note the relationship and any unusual patterns in the data points. b. Prepare a simple regression analysis of crash deaths on the potential predictor variables. Determine which, if any, of the regressions indicate a significant relationship. c. State the results of your analysis and rank the predictor variables in terms of their relationship to crash deaths. (SPSS is required, 50 scores)