Does the rate of violent crime acts vary across different regions of the United States? Answer this with the data in the file P10_34.xlsx as requested below. a. Estimate an appropriate regression model to explain the variation in violent crime rate across the four given regions of the United States. Use Region 4 as the baseline for the regression model. Round your answers to two decimal places, if necessary. If your answer is negative number, enter "minus" sign. Violent Crime Rate = 325.44 36.72 Region1 + 298.61 Region2 + 97.86 Region3 Interpret the estimated equation. The estimated model indicates that the predicted rate of violent crime is greatest in Region 3 and lowest in Region 1 : Rank the four regions from highest to lowest according to their mean violent crime rate.b. Modify the regression model in part a to account for possible differences in the violent crime rate across the various subdivisions of the given regions. Estimate your revised regression equation. Use Subdivision 9 as the baseline for the regression model. Round your answers to two decimal places, if necessary. If your answer is negative number, enter "minus" sign. Violent Crime Rate = 325.44 Subdivision1 + Subdivision2 + Subdivision3 + Subdivision4 + Subdivision5 + Subdivision6 + Subdivision7 + Subdivision8 Interpret your findings. The estimated model indicates that the predicted rate of violent crime is greatest in Subdivision 5. and lowest in Subdivision 1 :A B C D State Region Subdivision Violent Crime Rate 2 ME 1 112 NH 97 VT 1 114 5 MA 551 6 RI 1 287 7 CT 346 NY 1 589 9 NJ 412 10 PA 421 11 OH WWWW N NN 316 12 IN 375 13 IL 733 14 MI 575 15 WI 246 16 MN 274 17 IA 280 18 MO 500 19 ND 67 20 SD 167 21 NE 430 22 KS WWW WWW WWWWWWUN N NNNNNNNNNN UP 383 23 DE 734 24 MD 743 25 DC 1,628 26 VA 315 27 WV 351 28 NC 542 29 SC 847 30 GA 534 31 FL 854 32 KY 301 33 TN 695 34 AL 490 35 MS 6 349