Download the State Crime Excel sheet; row 2 gives detailed descriptions of each variable, while row 4 gives short versions that should be used in your regressions. Estimate the following multiple regression models (remember that all of your independent variables will have to be in adjacent columns in Excel). Look at each set of results critically and consider how you would interpret the strengths and weaknesses of each model. Save your results from each model for use when completing the end-of-module assessment. Use Robbery as your dependent variable in each model. The notation f(X, Y, Z) means a function of X, Y, Z; i.e., X, Y, and Z are your independent variables. Even though it isnt listed, each model will include an intercept. NOTE: when Excel reports a value like 2.4E-06, this is scientific notation for 2.4 * (10^-6), or 0.0000024.
Model A: Robbery = f(Murder, Population, %Metro)
Model B: Robbery = f(%Bachelors, %Metro, %SameHouse, %young)
Model C: Robbery = f(%Bachelors, %Metro, %SameHouse, %youngmale)
Model D: Robbery = f(%Bachelors, %Metro, %SameHouse, %youngfemale)
Model E: Robbery = f(MedianAge, %Poverty, %Unemploy, Rain)
Model F: Robbery = f(MedianAge, %Poverty, %Unemploy, Temp)
Model G: Robbery = f(MedianAge, %Poverty, %Unemploy, Sun)
The state of North Utah currently has a median age of 37.4, a 12.7% poverty rate, a 6.1% unemployment rate, and 41.9 inches of annual rainfall on average. Recent economic changes have led to the unemployment rate falling to 5.8%. This change will likely be associated with the Robbery rate changing from about 77.6 robberies (per 100,000 inhabitants) to about ___ robberies.
A T U W X z AA AB AC J K L M N O P Q R R Non-crime variables; units are as specificd in row 2 descriptors C D E F GH- 1 Table 5, Crime in the United States by State, Rate per 100,000 inhabitants Murder Aggravat Motor Violent and Robbe cd Property Larceny vehicle 2 State crime nonneglige ry assault crime Burglary theft theft State ALABAMA ARIZONA ARKANSAS CALIFORNIA e COLORADO - CONNECTICUT 1 DELAWARE 2 FLORIDA 3 3 GEORGIA 4 4 IDAHO 5 ILLINOIS 5 INDIANA 7 IOWA & KANSAS 9 KENTUCKY 0 LOUISIANA 1 MAINE 2 MARYLAND 3 MASSACHUSETTS 4 MICHIGAN 5 MINNESOTA 6 MISSISSIPPI 7 MISSOURI 8 MONTANA 9 NEBRASKA 0 NEVADA 1 NEW HAMPSHIRE 2 2 NEW JERSEY 3 NEW MEXICO 4 NEW YORK 5 5 NORTH CAROLINA 6 NORTH DAKOTA 7 OHIO & OKLAHOMA 9 OREGON 0 PENNSYLVANIA 1 RHODE ISLAND 2 SOUTH CAROLINA 3 SOUTH DAKOTA 4 TENNESSEE 5 TEXAS 6 UTAH 7 VERMONT 8 VIRGINIA 9 WASHINGTON 0 WEST VIRGINIA 1 WISCONSIN 2 WYOMING Violant 430.8 416.5 460.3 402.1 308.0 262.5 491.4 470.4 365.7 217.0 380.2 357.4 271.4 339.9 209.8 518.5 129.3 473.8 413.4 449.9 234.4 274.6 433.4 252.9 262.1 603.0 215.3 288.5 613.0 393.7 342.2 270.1 286.2 441.2 254.0 335.4 257.2 508.5 316.5 590.6 408.3 224.0 121.1 196.2 289.1 300.3 277.9 205.1 Murder Robbe Assault Prop Crim. Burglary Larceny CarThe 7.2 96.2 285.2 3,351.3 877.8 2.254.8 218.7 5.4 101.1 263.9 3,399.1 732.4 2.403.5 263.2 5.4 76.3 330.5 3,602.6 1,030.1 2,380.6 191.9 4.6 139.9 232.3 2,658.1 605.4 1621.5 4312 59.8 189.1 2.650,5 476.1 1.944.5 1,944.5 237.9 2.4 98.2 135.4 1,974.1 358,5 1,442.6 173.0 4.2 132.4 313.7 3,065.5 662.3 2,259.4 143.9 5.0 118.7 312.3 3,105.3 710.5 2,216.3 178.6 5.6 125.0 209.3 3,346.6 823.2 2,254.3 268.5 1.7 13.6 161.0 1,864.3 411.9 1,357.1 95.3 5.5 137,6 204.0 2,274.3 452.1 1.659.8 162.5 5.4 108.2 211.3 2,854.0 653.0 1,984.9 216.2 1.4 30.4 204.6 2,193.9 513.5 1,543.0 137.4 46.6 248.1 2,946.8 600.4 2,117.0 2,117.0 228.5 73.9 35.5 2,362.9 596.4 1629.3 137.2 10.8 119.9 352.8 3,582.0 890.4 2,493.6 198.0 1.8 25.2 68.7 2,292.3 488.1 1,735.3 68.8 6.4 169.5 272.0 2,663.5 538.9 1,898.3 226.3 2.0 100.2 270.5 2,051.8 459.2 1,455.7 136.3 6.4 102.1 274.8 2,327.6 569.4 1,510.0 248.3 2.1 67.8 127.5 2,420.4 419.0 1,854.4 147.0 6.5 80.5 156.5 2,724.7 835,6 1,742.3 146.7 6.1 90.7 298.7 3,137.0 643.0 2,223.9 2701 2.2 20.1 190.2 2,556.5 400.3 1,974.0 182.2 3.1 55.7 160.5 2,623.4 476.3 1,308.2 238.9 5.8 185.8 360.6 2,837.7 826.0 1,653.4 358.3 1.7 49.0 112.7 2,194.3 373.0 1,750.3 71.0 4.5 135.8 135.6 1,882.8 403.1 1,325.2 154.5 6.0 86.8 449.9 3,704.8 1,029.9 2,391.8 283.2 3.3 138,6 234.7 1,824.8 287.2 1,458.6 78.8 4.8 94.9 218.4 3,128.0 9210 2,058.7 148.3 2.2 22.4 199.9 2,094.0 405.6 1,492.7 195.7 124.2 123.2 2.327.5 790.2 1,968.5 168.8 5.1 78.7 300.8 3,273.7 866.1 2,116.4 291.2 2.0 61.0 142.7 3,173.9 528.5 2,394.5 250.9 115.6 185.7 2,060.8 407.3 1,545.6 107.8 2.9 65.0 147.4 2,442.0 533.2 1,696.4 212.4 6.2 83.2 373.6 3,624.2 857.8 2,502.9 263.5 2.4 18.8 236.2 1.914.7 399.1 1,404.6 111.0 5.0 112.5 436.9 3.180.3 785.1 2,213.7 182.1 4.3 120.2 246.9 3,258.2 721.8 2,287.8 248.6 1.7 42.8 130.4 2.350.4 459.6 2,233.4 257.3 1.6 11.6 87.1 2.214.2 528.7 1632.2 53.3 55.3 109.7 2,065.9 322.5 1,640.1 103.3 2.3 83.5 166.4 3,710.3 837.0 2.465.3 407,4 3.3 35.1 226.7 2,103.9 521.7 1.478.3 103.3 2.8 84.2 161.6 2,188.7 424.0 1,636.0 128.6 2.9 12.9 157.2 2,198.4 335.5 1,763.6 99.2 Total state population Per capil unemployn aver: avers # o belo 18-24/18 % male 18-24 % female 1 Median age Median age, Median as 25 ye X of statep: living in same house one year ago Population PerCapl XUnemplo Rain Temp Sun XPova Zyoung Xyoungmale Zyoungti Medianage Medage Male MedageF Bache Metro *SamcHouse 4,833,722 32448 7.2 58 63 99 16.2 16.2% 16.7% 15.8% 38.4 36.9 39.8 23.5% 76.0% 85.5 6,626,624 32997 7.7 14 60 # 16.1 16.7% 17.3% 16.1% 36.8 35.5 38.1 27.4% 94.0% 81.7 2,959,373 32509 7.2 51 60 # 16 16.2% 16.6% % 15.8% 37.7 36.3 39 20.6% 61.1% 84.2 38,332,521 41932 8.9 22 59 # 13.9 16.4% 16.9% 16.0% 35.8 34.6 37 31.0% 97.8% 85.7 5,268,367 41137 6.9 16 45 # 8.5 15.0% 15.5% 14.6% 36.5 35.5 37.5 37.8% 87.0% 81.1 3,596,080 53842 7.8 50 49 82 9.8 15.3% 16.02 14.6% 40.6 42.1 37.2% 94.8% 87.8 925,749 38891 6.7 46 55 97 11.6 16.0% 16.5% 15.6% 39.5 37.9 41 29.8% 100.0% 86.7 13,552.860 36601 7.255 71 101 13 15.0% 15.6% 14.5% 41.5 40 42.9 27.2% 96.4% 83.9 9,992,167 33111 8.2 51 64 112 15.4 16.0% 16.7% 15.4% 36 34.7 37.3 28.3% 82.3% 84 1,612,136 32348 6.1 19 44 # 11.1 16.3% 16.6% 16.0% 35.4 34.6 36.2 26.2% 66.2% 82.5 12,882,135 40584 9 39 52 95 12.1 15.5% 15.9% 15.0% 37.2 35.9 38.6 32.1% 86.7 6,570,302 35171 7.6 42 52 88 118 16.5% 16.9% 16.1% 37.3 36 38.6 23.8% 77.6% 84.9 3,090,416 38702 4.7 34 48 # 9.8 17.0% % 17.4% 16.7% 36.6 39.4 26.4% 58.3% 84.6. 2,893,957 41139 5.3 29 54 # 11.2 17.0% 17.6% 16.4% 36.1 34.8 37.4 31.1% 67.1% 83.5 4,395,295 31960 8 49 56 93 15.2 15.7% 16.1% 15.2% 37 39.8 22.6% 58.2% 84.5 4,625,470 36241 6.7 60 66 101 20.2 16.3% % 16.7% 16.0% 36.1 37.4 22.5% 83.4% 86.5 1,328,302 35617 6.7 42 41 101 12.7 13.8% 14.3% 13.3% 42.6 45 28.2% 58.8% 86.3 5,928,814 45652 6.6 45 54 # 7.1 14.9% 15.6% 14.2% 38.3 36.6 39.8 37.4% 97.4% 86.5 6,692,024 48472 6.7 48 48 98 9.6 16.1% 16.5% 15.8% 39.3 37.8 40.8 40.3% 98.53 87.1 3,895,622 34853 8.8 33 44 71 11.1 16.5% 16.9% 16.0% 39.5 38.1 40.9 26.9% 81.8% 85.3 5,420,380 40324 5 27 41 95 8.7 15.02 15.27 36.6 38.7 33.5% 77.2% % 85.5 2,991,207 30608 8.5 59 63 111 21.1 17.1% 17.7% 16.6% 36.5 35 37.9 20.4% 45.5% 86.1 6,044,171 35625 6.7 42 55 115 13 16.0% 16.4% 15.5% 38.2 36.7 39.6 27.0% 74.3% 84 1,015,165 35379 5.4 15 43 82 11.7 15.9% 16.5% 15.3% 39.9 38.7 41.1 29.0% 35.43 83.5 1,868,516 41135 3.8 24 49 117 9.6 16.5% 16.8% 16.2% 36.2 35.1 37.4 29.4% 64.2% 2,790,136 34855 9.6 9.5 50 # 10.1 14.5% 14.6% 14.3% 37.3 36.7 37.9 22.5% 90.32 79.7 1,323,459 46653 5.1 43 44 30 6.4 15.12 15.4% 14.8% 42.4 41.4 43.3 34.6% 62.5% 85.9 8,899,339 47693 8.2 47 53 34 9.4 14.3% 14.92 13.6% 39.4 37.8 41 36.6% 100.0% 90.1 2,085,287 31574 6.9 15 53 # 17.8 16.5% 17.1% 15.9% 36.9 35.5 38.4 26.4% 66.7% 85.9 19,651,127 45620 7 7 42 45 63 11.9 15.8% 16.3% 15.3% 38.2 36.6 39.8 34.13 92.9% 89.3 9,848,060 33682 8 50 59 # 13.6 15.9% 16.8% % 15.12 38.1 36.6 39.5 28.4% 77.6% 84.7 723,393 49385 2.9 18 40 93 11.1 19.8% 20.3% 19.3% 35.3 34.2 36.7 27.1% 49.23 82.3 11,570,808 36175 7.4 39 51 72 13.7 15.6% 16.0% 15.2% 39.2 37.7 40.7 26.1% 79.5% 85.1 3,850,568 36648 5.3 37 60 # 14.6 16.7% 17.1% 16.2% 36.2 34.9 37.5 23.8% 66.7% 82.7 3,930,065 34606 7.9 27 48 68 11.8 14.8% 15.1% 14.5% 38.9 37.9 40.1 30.7% 83.4% 81.9 12,773,801 40849 7.3 43 49 87 11.1 15.8% 16.1% 15.4% 40.6 38.9 42.1 28.7% 87.8 1,051,511 41149 9.3 48 50 98 11.4 17.5% % 17.8% 17.3% 39.9 38.1 41.6 32.4% 100.0% 86.5 4,774,833 31843 7.6 50 62 115 14.1 16.4% 17.2% 15.6% % 38.6 37 40.1 26.1% 84.22 84.9 844,877 40864 3.8 20 45 # 14.5 16.6% 16.9% 16.3% 36.7 35.6 37.9 26.6% 47.3% 83.3 6,495,978 35630 7.7 54 58 # 14.3 15.5% 16.0% 15.1% 38.5 37.1 39.8 24.8% 77.1% 84.9 26,448,193 39023 6.3 29 65 # 13.8 16.5% 17.0% 15.9% 33.1 35 27.5% 88.6% 83.5 2,900,872 32206 4.6 12 49 # 8.6 19.4% 19.4% 19.3% 30.1 29.6 30.6 31.3% 89.3% 82.9 626,630 41062 4.4 43 43 58 9.6 16.7% 16.13 42.4 41.1 43.5 35.7% 34.3% 86.4 8,260,405 42480 5.7 44 55 # 11.4 15.5% 16.1% 15.0% 37.7 36.4 39 36.1% 87.2% 84.3 6,971,406 43003 7 38 48 58 11 15.0% 15.5% 14.6% 37.6 36.5 38.6 32.7% 89.8% 82.5 1,854,304 31320 6.8 45 52 60 18 15.0% 15.4% 14.63 41.8 40.5 43 18.9% 61.4% 88.2 5,742,713 37876 6.7 33 43 89 10.7 15.7% 15.9% 15.5% 38.3 37.8 40.1 27.7% 73.8% % 85.6 582.658 46876 4.7 13 42 114 10.9 16.0% 16.4% 15.7% 36.8 36.1 37.6 26.6% 30.4% 81.6 A T U W X z AA AB AC J K L M N O P Q R R Non-crime variables; units are as specificd in row 2 descriptors C D E F GH- 1 Table 5, Crime in the United States by State, Rate per 100,000 inhabitants Murder Aggravat Motor Violent and Robbe cd Property Larceny vehicle 2 State crime nonneglige ry assault crime Burglary theft theft State ALABAMA ARIZONA ARKANSAS CALIFORNIA e COLORADO - CONNECTICUT 1 DELAWARE 2 FLORIDA 3 3 GEORGIA 4 4 IDAHO 5 ILLINOIS 5 INDIANA 7 IOWA & KANSAS 9 KENTUCKY 0 LOUISIANA 1 MAINE 2 MARYLAND 3 MASSACHUSETTS 4 MICHIGAN 5 MINNESOTA 6 MISSISSIPPI 7 MISSOURI 8 MONTANA 9 NEBRASKA 0 NEVADA 1 NEW HAMPSHIRE 2 2 NEW JERSEY 3 NEW MEXICO 4 NEW YORK 5 5 NORTH CAROLINA 6 NORTH DAKOTA 7 OHIO & OKLAHOMA 9 OREGON 0 PENNSYLVANIA 1 RHODE ISLAND 2 SOUTH CAROLINA 3 SOUTH DAKOTA 4 TENNESSEE 5 TEXAS 6 UTAH 7 VERMONT 8 VIRGINIA 9 WASHINGTON 0 WEST VIRGINIA 1 WISCONSIN 2 WYOMING Violant 430.8 416.5 460.3 402.1 308.0 262.5 491.4 470.4 365.7 217.0 380.2 357.4 271.4 339.9 209.8 518.5 129.3 473.8 413.4 449.9 234.4 274.6 433.4 252.9 262.1 603.0 215.3 288.5 613.0 393.7 342.2 270.1 286.2 441.2 254.0 335.4 257.2 508.5 316.5 590.6 408.3 224.0 121.1 196.2 289.1 300.3 277.9 205.1 Murder Robbe Assault Prop Crim. Burglary Larceny CarThe 7.2 96.2 285.2 3,351.3 877.8 2.254.8 218.7 5.4 101.1 263.9 3,399.1 732.4 2.403.5 263.2 5.4 76.3 330.5 3,602.6 1,030.1 2,380.6 191.9 4.6 139.9 232.3 2,658.1 605.4 1621.5 4312 59.8 189.1 2.650,5 476.1 1.944.5 1,944.5 237.9 2.4 98.2 135.4 1,974.1 358,5 1,442.6 173.0 4.2 132.4 313.7 3,065.5 662.3 2,259.4 143.9 5.0 118.7 312.3 3,105.3 710.5 2,216.3 178.6 5.6 125.0 209.3 3,346.6 823.2 2,254.3 268.5 1.7 13.6 161.0 1,864.3 411.9 1,357.1 95.3 5.5 137,6 204.0 2,274.3 452.1 1.659.8 162.5 5.4 108.2 211.3 2,854.0 653.0 1,984.9 216.2 1.4 30.4 204.6 2,193.9 513.5 1,543.0 137.4 46.6 248.1 2,946.8 600.4 2,117.0 2,117.0 228.5 73.9 35.5 2,362.9 596.4 1629.3 137.2 10.8 119.9 352.8 3,582.0 890.4 2,493.6 198.0 1.8 25.2 68.7 2,292.3 488.1 1,735.3 68.8 6.4 169.5 272.0 2,663.5 538.9 1,898.3 226.3 2.0 100.2 270.5 2,051.8 459.2 1,455.7 136.3 6.4 102.1 274.8 2,327.6 569.4 1,510.0 248.3 2.1 67.8 127.5 2,420.4 419.0 1,854.4 147.0 6.5 80.5 156.5 2,724.7 835,6 1,742.3 146.7 6.1 90.7 298.7 3,137.0 643.0 2,223.9 2701 2.2 20.1 190.2 2,556.5 400.3 1,974.0 182.2 3.1 55.7 160.5 2,623.4 476.3 1,308.2 238.9 5.8 185.8 360.6 2,837.7 826.0 1,653.4 358.3 1.7 49.0 112.7 2,194.3 373.0 1,750.3 71.0 4.5 135.8 135.6 1,882.8 403.1 1,325.2 154.5 6.0 86.8 449.9 3,704.8 1,029.9 2,391.8 283.2 3.3 138,6 234.7 1,824.8 287.2 1,458.6 78.8 4.8 94.9 218.4 3,128.0 9210 2,058.7 148.3 2.2 22.4 199.9 2,094.0 405.6 1,492.7 195.7 124.2 123.2 2.327.5 790.2 1,968.5 168.8 5.1 78.7 300.8 3,273.7 866.1 2,116.4 291.2 2.0 61.0 142.7 3,173.9 528.5 2,394.5 250.9 115.6 185.7 2,060.8 407.3 1,545.6 107.8 2.9 65.0 147.4 2,442.0 533.2 1,696.4 212.4 6.2 83.2 373.6 3,624.2 857.8 2,502.9 263.5 2.4 18.8 236.2 1.914.7 399.1 1,404.6 111.0 5.0 112.5 436.9 3.180.3 785.1 2,213.7 182.1 4.3 120.2 246.9 3,258.2 721.8 2,287.8 248.6 1.7 42.8 130.4 2.350.4 459.6 2,233.4 257.3 1.6 11.6 87.1 2.214.2 528.7 1632.2 53.3 55.3 109.7 2,065.9 322.5 1,640.1 103.3 2.3 83.5 166.4 3,710.3 837.0 2.465.3 407,4 3.3 35.1 226.7 2,103.9 521.7 1.478.3 103.3 2.8 84.2 161.6 2,188.7 424.0 1,636.0 128.6 2.9 12.9 157.2 2,198.4 335.5 1,763.6 99.2 Total state population Per capil unemployn aver: avers # o belo 18-24/18 % male 18-24 % female 1 Median age Median age, Median as 25 ye X of statep: living in same house one year ago Population PerCapl XUnemplo Rain Temp Sun XPova Zyoung Xyoungmale Zyoungti Medianage Medage Male MedageF Bache Metro *SamcHouse 4,833,722 32448 7.2 58 63 99 16.2 16.2% 16.7% 15.8% 38.4 36.9 39.8 23.5% 76.0% 85.5 6,626,624 32997 7.7 14 60 # 16.1 16.7% 17.3% 16.1% 36.8 35.5 38.1 27.4% 94.0% 81.7 2,959,373 32509 7.2 51 60 # 16 16.2% 16.6% % 15.8% 37.7 36.3 39 20.6% 61.1% 84.2 38,332,521 41932 8.9 22 59 # 13.9 16.4% 16.9% 16.0% 35.8 34.6 37 31.0% 97.8% 85.7 5,268,367 41137 6.9 16 45 # 8.5 15.0% 15.5% 14.6% 36.5 35.5 37.5 37.8% 87.0% 81.1 3,596,080 53842 7.8 50 49 82 9.8 15.3% 16.02 14.6% 40.6 42.1 37.2% 94.8% 87.8 925,749 38891 6.7 46 55 97 11.6 16.0% 16.5% 15.6% 39.5 37.9 41 29.8% 100.0% 86.7 13,552.860 36601 7.255 71 101 13 15.0% 15.6% 14.5% 41.5 40 42.9 27.2% 96.4% 83.9 9,992,167 33111 8.2 51 64 112 15.4 16.0% 16.7% 15.4% 36 34.7 37.3 28.3% 82.3% 84 1,612,136 32348 6.1 19 44 # 11.1 16.3% 16.6% 16.0% 35.4 34.6 36.2 26.2% 66.2% 82.5 12,882,135 40584 9 39 52 95 12.1 15.5% 15.9% 15.0% 37.2 35.9 38.6 32.1% 86.7 6,570,302 35171 7.6 42 52 88 118 16.5% 16.9% 16.1% 37.3 36 38.6 23.8% 77.6% 84.9 3,090,416 38702 4.7 34 48 # 9.8 17.0% % 17.4% 16.7% 36.6 39.4 26.4% 58.3% 84.6. 2,893,957 41139 5.3 29 54 # 11.2 17.0% 17.6% 16.4% 36.1 34.8 37.4 31.1% 67.1% 83.5 4,395,295 31960 8 49 56 93 15.2 15.7% 16.1% 15.2% 37 39.8 22.6% 58.2% 84.5 4,625,470 36241 6.7 60 66 101 20.2 16.3% % 16.7% 16.0% 36.1 37.4 22.5% 83.4% 86.5 1,328,302 35617 6.7 42 41 101 12.7 13.8% 14.3% 13.3% 42.6 45 28.2% 58.8% 86.3 5,928,814 45652 6.6 45 54 # 7.1 14.9% 15.6% 14.2% 38.3 36.6 39.8 37.4% 97.4% 86.5 6,692,024 48472 6.7 48 48 98 9.6 16.1% 16.5% 15.8% 39.3 37.8 40.8 40.3% 98.53 87.1 3,895,622 34853 8.8 33 44 71 11.1 16.5% 16.9% 16.0% 39.5 38.1 40.9 26.9% 81.8% 85.3 5,420,380 40324 5 27 41 95 8.7 15.02 15.27 36.6 38.7 33.5% 77.2% % 85.5 2,991,207 30608 8.5 59 63 111 21.1 17.1% 17.7% 16.6% 36.5 35 37.9 20.4% 45.5% 86.1 6,044,171 35625 6.7 42 55 115 13 16.0% 16.4% 15.5% 38.2 36.7 39.6 27.0% 74.3% 84 1,015,165 35379 5.4 15 43 82 11.7 15.9% 16.5% 15.3% 39.9 38.7 41.1 29.0% 35.43 83.5 1,868,516 41135 3.8 24 49 117 9.6 16.5% 16.8% 16.2% 36.2 35.1 37.4 29.4% 64.2% 2,790,136 34855 9.6 9.5 50 # 10.1 14.5% 14.6% 14.3% 37.3 36.7 37.9 22.5% 90.32 79.7 1,323,459 46653 5.1 43 44 30 6.4 15.12 15.4% 14.8% 42.4 41.4 43.3 34.6% 62.5% 85.9 8,899,339 47693 8.2 47 53 34 9.4 14.3% 14.92 13.6% 39.4 37.8 41 36.6% 100.0% 90.1 2,085,287 31574 6.9 15 53 # 17.8 16.5% 17.1% 15.9% 36.9 35.5 38.4 26.4% 66.7% 85.9 19,651,127 45620 7 7 42 45 63 11.9 15.8% 16.3% 15.3% 38.2 36.6 39.8 34.13 92.9% 89.3 9,848,060 33682 8 50 59 # 13.6 15.9% 16.8% % 15.12 38.1 36.6 39.5 28.4% 77.6% 84.7 723,393 49385 2.9 18 40 93 11.1 19.8% 20.3% 19.3% 35.3 34.2 36.7 27.1% 49.23 82.3 11,570,808 36175 7.4 39 51 72 13.7 15.6% 16.0% 15.2% 39.2 37.7 40.7 26.1% 79.5% 85.1 3,850,568 36648 5.3 37 60 # 14.6 16.7% 17.1% 16.2% 36.2 34.9 37.5 23.8% 66.7% 82.7 3,930,065 34606 7.9 27 48 68 11.8 14.8% 15.1% 14.5% 38.9 37.9 40.1 30.7% 83.4% 81.9 12,773,801 40849 7.3 43 49 87 11.1 15.8% 16.1% 15.4% 40.6 38.9 42.1 28.7% 87.8 1,051,511 41149 9.3 48 50 98 11.4 17.5% % 17.8% 17.3% 39.9 38.1 41.6 32.4% 100.0% 86.5 4,774,833 31843 7.6 50 62 115 14.1 16.4% 17.2% 15.6% % 38.6 37 40.1 26.1% 84.22 84.9 844,877 40864 3.8 20 45 # 14.5 16.6% 16.9% 16.3% 36.7 35.6 37.9 26.6% 47.3% 83.3 6,495,978 35630 7.7 54 58 # 14.3 15.5% 16.0% 15.1% 38.5 37.1 39.8 24.8% 77.1% 84.9 26,448,193 39023 6.3 29 65 # 13.8 16.5% 17.0% 15.9% 33.1 35 27.5% 88.6% 83.5 2,900,872 32206 4.6 12 49 # 8.6 19.4% 19.4% 19.3% 30.1 29.6 30.6 31.3% 89.3% 82.9 626,630 41062 4.4 43 43 58 9.6 16.7% 16.13 42.4 41.1 43.5 35.7% 34.3% 86.4 8,260,405 42480 5.7 44 55 # 11.4 15.5% 16.1% 15.0% 37.7 36.4 39 36.1% 87.2% 84.3 6,971,406 43003 7 38 48 58 11 15.0% 15.5% 14.6% 37.6 36.5 38.6 32.7% 89.8% 82.5 1,854,304 31320 6.8 45 52 60 18 15.0% 15.4% 14.63 41.8 40.5 43 18.9% 61.4% 88.2 5,742,713 37876 6.7 33 43 89 10.7 15.7% 15.9% 15.5% 38.3 37.8 40.1 27.7% 73.8% % 85.6 582.658 46876 4.7 13 42 114 10.9 16.0% 16.4% 15.7% 36.8 36.1 37.6 26.6% 30.4% 81.6
