UploadUS crimedata and focus on the state ofTexas. Your job is to "cut-&-paste" the data and create 7 columns and label them Murder, Rape, Robbery, Assault, Burglary, Larceny and Car Theft respectively. Next you are to perform a regression where you are to predict the murder count using the remaining 6 variables. Finally, pick the two variables with the bestP-values, this time using these two variables in order to predict the murder.Answer the questions using this new table only:

I) What are the two variables you picked? (10 points)

• a. Rape and Burglary
• b. Rape and Larceny
• c. Larceny and Robbery
• d. Larceny and Burglary
• e. None of the choices

II) After getting the new table, choose the variable with the larger coefficient and describe its interpretation. (10 points)

• a. Rape; For every rape there are 0.29 murders
• b. Rape; For every murder there are 0.29 rapes
• c. Robbery; For every robbery there is an increase of 0.102 murders
• d. Robbery; For every murder there are 0.102 robberies
• e. None of the choices

III) How good is the fit and why? (10 points)

• a. Very good;P-values are extremely small
• b. Very good;R-square is very close to 1
• c. Good; SomeP-values are small and some are not
• d. Poor; SomeP-values are small and some are not

Texas,Violent Crime,Murder and nonnegligent Manslaughter,1960,824 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1961,788 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1962,730 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1963,760 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1964,785 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1965,793 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1966,983 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1967,1073 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1968,1163 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1969,1269 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1970,1299 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1971,1383 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1972,1440 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1973,1506 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1974,1652 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1975,1639 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1976,1519 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1977,1705 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1978,1853 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1979,2235 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1980,2392 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1981,2446 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1982,2466 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1983,2239 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1984,2093 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1985,2132 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1986,2258 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1987,1959 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1988,2022 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1989,2029 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1990,2389 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1991,2652 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1992,2239 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1993,2147 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1994,2022 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1995,1693 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1996,1477 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1997,1327 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1998,1346 Texas,Violent Crime,Murder and nonnegligent Manslaughter,1999,1217 Texas,Violent Crime,Murder and nonnegligent Manslaughter,2000,1238 Texas,Violent Crime,Murder and nonnegligent Manslaughter,2001,1332 Texas,Violent Crime,Murder and nonnegligent Manslaughter,2002,1302 Texas,Violent Crime,Murder and nonnegligent Manslaughter,2003,1422 Texas,Violent Crime,Murder and nonnegligent Manslaughter,2004,1364 Texas,Violent Crime,Murder and nonnegligent Manslaughter,2005,1407 Texas,Violent Crime,Forcible rape,1960,892 Texas,Violent Crime,Forcible rape,1961,932 Texas,Violent Crime,Forcible rape,1962,937 Texas,Violent Crime,Forcible rape,1963,1008 Texas,Violent Crime,Forcible rape,1964,1176 Texas,Violent Crime,Forcible rape,1965,1132 Texas,Violent Crime,Forcible rape,1966,1237 Texas,Violent Crime,Forcible rape,1967,1428 Texas,Violent Crime,Forcible rape,1968,1589 Texas,Violent Crime,Forcible rape,1969,2153 Texas,Violent Crime,Forcible rape,1970,2329 Texas,Violent Crime,Forcible rape,1971,2701 Texas,Violent Crime,Forcible rape,1972,2739 Texas,Violent Crime,Forcible rape,1973,2976 Texas,Violent Crime,Forcible rape,1974,3486 Texas,Violent Crime,Forcible rape,1975,3430 Texas,Violent Crime,Forcible rape,1976,3666 Texas,Violent Crime,Forcible rape,1977,4338 Texas,Violent Crime,Forcible rape,1978,4927 Texas,Violent Crime,Forcible rape,1979,6043 Texas,Violent Crime,Forcible rape,1980,6700 Texas,Violent Crime,Forcible rape,1981,6821 Texas,Violent Crime,Forcible rape,1982,6816 Texas,Violent Crime,Forcible rape,1983,6333 Texas,Violent Crime,Forcible rape,1984,7343 Texas,Violent Crime,Forcible rape,1985,8364 Texas,Violent Crime,Forcible rape,1986,8607 Texas,Violent Crime,Forcible rape,1987,8068 Texas,Violent Crime,Forcible rape,1988,8119 Texas,Violent Crime,Forcible rape,1989,7951 Texas,Violent Crime,Forcible rape,1990,8750 Texas,Violent Crime,Forcible rape,1991,9266 Texas,Violent Crime,Forcible rape,1992,9437 Texas,Violent Crime,Forcible rape,1993,9922 Texas,Violent Crime,Forcible rape,1994,9102 Texas,Violent Crime,Forcible rape,1995,8563 Texas,Violent Crime,Forcible rape,1996,8376 Texas,Violent Crime,Forcible rape,1997,8011 Texas,Violent Crime,Forcible rape,1998,7913 Texas,Violent Crime,Forcible rape,1999,7614 Texas,Violent Crime,Forcible rape,2000,7856 Texas,Violent Crime,Forcible rape,2001,8169 Texas,Violent Crime,Forcible rape,2002,8508 Texas,Violent Crime,Forcible rape,2003,8025 Texas,Violent Crime,Forcible rape,2004,8388 Texas,Violent Crime,Forcible rape,2005,8511 Texas,Violent Crime,Robbery,1960,3031 Texas,Violent Crime,Robbery,1961,3042 Texas,Violent Crime,Robbery,1962,3192 Texas,Violent Crime,Robbery,1963,3700 Texas,Violent Crime,Robbery,1964,4479 Texas,Violent Crime,Robbery,1965,4509 Texas,Violent Crime,Robbery,1966,5987 Texas,Violent Crime,Robbery,1967,7558 Texas,Violent Crime,Robbery,1968,9091 Texas,Violent Crime,Robbery,1969,13045 Texas,Violent Crime,Robbery,1970,15280 Texas,Violent Crime,Robbery,1971,14220 Texas,Violent Crime,Robbery,1972,14013 Texas,Violent Crime,Robbery,1973,17056 Texas,Violent Crime,Robbery,1974,19757 Texas,Violent Crime,Robbery,1975,20076 Texas,Violent Crime,Robbery,1976,17352 Texas,Violent Crime,Robbery,1977,19552 Texas,Violent Crime,Robbery,1978,21395 Texas,Violent Crime,Robbery,1979,25667 Texas,Violent Crime,Robbery,1980,29547 Texas,Violent Crime,Robbery,1981,28528 Texas,Violent Crime,Robbery,1982,33618 Texas,Violent Crime,Robbery,1983,29769 Texas,Violent Crime,Robbery,1984,28540 Texas,Violent Crime,Robbery,1985,31680 Texas,Violent Crime,Robbery,1986,40021 Texas,Violent Crime,Robbery,1987,38053 Texas,Violent Crime,Robbery,1988,39301 Texas,Violent Crime,Robbery,1989,37913 Texas,Violent Crime,Robbery,1990,44297 Texas,Violent Crime,Robbery,1991,49700 Texas,Violent Crime,Robbery,1992,44588 Texas,Violent Crime,Robbery,1993,40469 Texas,Violent Crime,Robbery,1994,37643 Texas,Violent Crime,Robbery,1995,33667 Texas,Violent Crime,Robbery,1996,32804 Texas,Violent Crime,Robbery,1997,30522 Texas,Violent Crime,Robbery,1998,28677 Texas,Violent Crime,Robbery,1999,29405 Texas,Violent Crime,Robbery,2000,30257 Texas,Violent Crime,Robbery,2001,35348 Texas,Violent Crime,Robbery,2002,37580 Texas,Violent Crime,Robbery,2003,37017 Texas,Violent Crime,Robbery,2004,35817 Texas,Violent Crime,Robbery,2005,35790 Texas,Violent Crime,Aggravated assault,1960,10681 Texas,Violent Crime,Aggravated assault,1961,10679 Texas,Violent Crime,Aggravated assault,1962,10657 Texas,Violent Crime,Aggravated assault,1963,12043 Texas,Violent Crime,Aggravated assault,1964,13329 Texas,Violent Crime,Aggravated assault,1965,14595 Texas,Violent Crime,Aggravated assault,1966,16175 Texas,Violent Crime,Aggravated assault,1967,16690 Texas,Violent Crime,Aggravated assault,1968,17803 Texas,Violent Crime,Aggravated assault,1969,20240 Texas,Violent Crime,Aggravated assault,1970,21989 Texas,Violent Crime,Aggravated assault,1971,24785 Texas,Violent Crime,Aggravated assault,1972,23093 Texas,Violent Crime,Aggravated assault,1973,23920 Texas,Violent Crime,Aggravated assault,1974,22113 Texas,Violent Crime,Aggravated assault,1975,22658 Texas,Violent Crime,Aggravated assault,1976,21885 Texas,Violent Crime,Aggravated assault,1977,26714 Texas,Violent Crime,Aggravated assault,1978,28475 Texas,Violent Crime,Aggravated assault,1979,34043 Texas,Violent Crime,Aggravated assault,1980,39339 Texas,Violent Crime,Aggravated assault,1981,40765 Texas,Violent Crime,Aggravated assault,1982,45278 Texas,Violent Crime,Aggravated assault,1983,42205 Texas,Violent Crime,Aggravated assault,1984,42761 Texas,Violent Crime,Aggravated assault,1985,47854 Texas,Violent Crime,Aggravated assault,1986,59039 Texas,Violent Crime,Aggravated assault,1987,57881 Texas,Violent Crime,Aggravated assault,1988,60057 Texas,Violent Crime,Aggravated assault,1989,63996 Texas,Violent Crime,Aggravated assault,1990,73907 Texas,Violent Crime,Aggravated assault,1991,84125 Texas,Violent Crime,Aggravated assault,1992,86105 Texas,Violent Crime,Aggravated assault,1993,84881 Texas,Violent Crime,Aggravated assault,1994,81071 Texas,Violent Crime,Aggravated assault,1995,80380 Texas,Violent Crime,Aggravated assault,1996,80613 Texas,Violent Crime,Aggravated assault,1997,77266 Texas,Violent Crime,Aggravated assault,1998,73630 Texas,Violent Crime,Aggravated assault,1999,74070 Texas,Violent Crime,Aggravated assault,2000,74302 Texas,Violent Crime,Aggravated assault,2001,77306 Texas,Violent Crime,Aggravated assault,2002,78628 Texas,Violent Crime,Aggravated assault,2003,75782 Texas,Violent Crime,Aggravated assault,2004,75985 Texas,Violent Crime,Aggravated assault,2005,75383 Texas,Property Crime,Burglary,1960,57589 Texas,Property Crime,Burglary,1961,56814 Texas,Property Crime,Burglary,1962,58017 Texas,Property Crime,Burglary,1963,62867 Texas,Property Crime,Burglary,1964,68170 Texas,Property Crime,Burglary,1965,71636 Texas,Property Crime,Burglary,1966,82651 Texas,Property Crime,Burglary,1967,89387 Texas,Property Crime,Burglary,1968,103095 Texas,Property Crime,Burglary,1969,122152 Texas,Property Crime,Burglary,1970,129866 Texas,Property Crime,Burglary,1971,135648 Texas,Property Crime,Burglary,1972,141613 Texas,Property Crime,Burglary,1973,150463 Texas,Property Crime,Burglary,1974,185928 Texas,Property Crime,Burglary,1975,203821 Texas,Property Crime,Burglary,1976,193280 Texas,Property Crime,Burglary,1977,205672 Texas,Property Crime,Burglary,1978,209770 Texas,Property Crime,Burglary,1979,239758 Texas,Property Crime,Burglary,1980,262600 Texas,Property Crime,Burglary,1981,275978 Texas,Property Crime,Burglary,1982,285967 Texas,Property Crime,Burglary,1983,262198 Texas,Property Crime,Burglary,1984,266074 Texas,Property Crime,Burglary,1985,289825 Texas,Property Crime,Burglary,1986,341747 Texas,Property Crime,Burglary,1987,355597 Texas,Property Crime,Burglary,1988,361972 Texas,Property Crime,Burglary,1989,342346 Texas,Property Crime,Burglary,1990,314512 Texas,Property Crime,Burglary,1991,312693 Texas,Property Crime,Burglary,1992,268928 Texas,Property Crime,Burglary,1993,233913 Texas,Property Crime,Burglary,1994,214687 Texas,Property Crime,Burglary,1995,202642 Texas,Property Crime,Burglary,1996,204390 Texas,Property Crime,Burglary,1997,201059 Texas,Property Crime,Burglary,1998,194883 Texas,Property Crime,Burglary,1999,190362 Texas,Property Crime,Burglary,2000,188975 Texas,Property Crime,Burglary,2001,204362 Texas,Property Crime,Burglary,2002,212602 Texas,Property Crime,Burglary,2003,219877 Texas,Property Crime,Burglary,2004,220118 Texas,Property Crime,Burglary,2005,219828 Texas,Property Crime,Larceny-theft,1960,123415 Texas,Property Crime,Larceny-theft,1961,120707 Texas,Property Crime,Larceny-theft,1962,126751 Texas,Property Crime,Larceny-theft,1963,133454 Texas,Property Crime,Larceny-theft,1964,151736 Texas,Property Crime,Larceny-theft,1965,159767 Texas,Property Crime,Larceny-theft,1966,176987 Texas,Property Crime,Larceny-theft,1967,195275 Texas,Property Crime,Larceny-theft,1968,214729 Texas,Property Crime,Larceny-theft,1969,241732 Texas,Property Crime,Larceny-theft,1970,251091 Texas,Property Crime,Larceny-theft,1971,247653 Texas,Property Crime,Larceny-theft,1972,233646 Texas,Property Crime,Larceny-theft,1973,248538 Texas,Property Crime,Larceny-theft,1974,297850 Texas,Property Crime,Larceny-theft,1975,362665 Texas,Property Crime,Larceny-theft,1976,400767 Texas,Property Crime,Larceny-theft,1977,383451 Texas,Property Crime,Larceny-theft,1978,398923 Texas,Property Crime,Larceny-theft,1979,412515 Texas,Property Crime,Larceny-theft,1980,450792 Texas,Property Crime,Larceny-theft,1981,454879 Texas,Property Crime,Larceny-theft,1982,501727 Texas,Property Crime,Larceny-theft,1983,503582 Texas,Property Crime,Larceny-theft,1984,529518 Texas,Property Crime,Larceny-theft,1985,595912 Texas,Property Crime,Larceny-theft,1986,665029 Texas,Property Crime,Larceny-theft,1987,711594 Texas,Property Crime,Larceny-theft,1988,739642 Texas,Property Crime,Larceny-theft,1989,741660 Texas,Property Crime,Larceny-theft,1990,731224 Texas,Property Crime,Larceny-theft,1991,734261 Texas,Property Crime,Larceny-theft,1992,689780 Texas,Property Crime,Larceny-theft,1993,664862 Texas,Property Crime,Larceny-theft,1994,623947 Texas,Property Crime,Larceny-theft,1995,632468 Texas,Property Crime,Larceny-theft,1996,659414 Texas,Property Crime,Larceny-theft,1997,645451 Texas,Property Crime,Larceny-theft,1998,606967 Texas,Property Crime,Larceny-theft,1999,613862 Texas,Property Crime,Larceny-theft,2000,637522 Texas,Property Crime,Larceny-theft,2001,669625 Texas,Property Crime,Larceny-theft,2002,688992 Texas,Property Crime,Larceny-theft,2003,698644 Texas,Property Crime,Larceny-theft,2004,696507 Texas,Property Crime,Larceny-theft,2005,677042 Texas,Property Crime,Motor vehicle theft,1960,15975 Texas,Property Crime,Motor vehicle theft,1961,15348 Texas,Property Crime,Motor vehicle theft,1962,16986 Texas,Property Crime,Motor vehicle theft,1963,17744 Texas,Property Crime,Motor vehicle theft,1964,21026 Texas,Property Crime,Motor vehicle theft,1965,20195 Texas,Property Crime,Motor vehicle theft,1966,24834 Texas,Property Crime,Motor vehicle theft,1967,28753 Texas,Property Crime,Motor vehicle theft,1968,34170 Texas,Property Crime,Motor vehicle theft,1969,43251 Texas,Property Crime,Motor vehicle theft,1970,45394 Texas,Property Crime,Motor vehicle theft,1971,43478 Texas,Property Crime,Motor vehicle theft,1972,39441 Texas,Property Crime,Motor vehicle theft,1973,42105 Texas,Property Crime,Motor vehicle theft,1974,46046 Texas,Property Crime,Motor vehicle theft,1975,47386 Texas,Property Crime,Motor vehicle theft,1976,43871 Texas,Property Crime,Motor vehicle theft,1977,51018 Texas,Property Crime,Motor vehicle theft,1978,57821 Texas,Property Crime,Motor vehicle theft,1979,72836 Texas,Property Crime,Motor vehicle theft,1980,79088 Texas,Property Crime,Motor vehicle theft,1981,83306 Texas,Property Crime,Motor vehicle theft,1982,87105 Texas,Property Crime,Motor vehicle theft,1983,82532 Texas,Property Crime,Motor vehicle theft,1984,87799 Texas,Property Crime,Motor vehicle theft,1985,99528 Texas,Property Crime,Motor vehicle theft,1986,119121 Texas,Property Crime,Motor vehicle theft,1987,123367 Texas,Property Crime,Motor vehicle theft,1988,134256 Texas,Property Crime,Motor vehicle theft,1989,150971 Texas,Property Crime,Motor vehicle theft,1990,154415 Texas,Property Crime,Motor vehicle theft,1991,163830 Texas,Property Crime,Motor vehicle theft,1992,145071 Texas,Property Crime,Motor vehicle theft,1993,124837 Texas,Property Crime,Motor vehicle theft,1994,110753 Texas,Property Crime,Motor vehicle theft,1995,104923 Texas,Property Crime,Motor vehicle theft,1996,104928 Texas,Property Crime,Motor vehicle theft,1997,101721 Texas,Property Crime,Motor vehicle theft,1998,96646 Texas,Property Crime,Motor vehicle theft,1999,92037 Texas,Property Crime,Motor vehicle theft,2000,93161 Texas,Property Crime,Motor vehicle theft,2001,102667 Texas,Property Crime,Motor vehicle theft,2002,102680 Texas,Property Crime,Motor vehicle theft,2003,98214 Texas,Property Crime,Motor vehicle theft,2004,94077 Texas,Property Crime,Motor vehicle theft,2005,93423