PART A: The information needed is provided in the image of the excel table.

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 = _______ + ______ Region1 + _______ Region2 + _______ Region3

PART B: The information needed is provided in the image of the excel table.

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 = ______ + _____ Subdivision1 + _____ Subdivision2 + _____ Subdivision3 + _____ Subdivision4 + ______ Subdivision5 + _____ Subdivision6 + ______ Subdivision7 + _____ Subdivision8 Interpret your findings

B G I A D E F H J K State Region Subdivision Violent Crime Rate 2 ME 1 112 NH 97 W VT 114 5 MA 551 6 RI 287 7 CT 346 8 NY 589 NJ 412 10 PA 421 ADD WWWWW N NNHAPPY OH 316 375 FZ W N 733 MI 575 WI 246 MN 274 IA 280 18 MO 500 ND 67 20 SD 167 NE 430 383 23 DE 734 24 MD 743 1,628 315 WV 351 D D D D D D D D D D D D D W W W W W W W W W W W W W W W W W N N N N N N N N N N N N B B A P P A P A 542 13 SC 847 GA 534 854 301 TN 595 AL 490 349 D ID ID ID LD 00 00 00 00 00 DO DO DO V V V V G G G G U U U U U U U U U A A A AR 425 733 195 508 TX 560 40 MT 207 GE 245 WY 232 co 341 44 NM 835 45 AZ 551 46 IS 276 47 NV 570 48 WA 377 49 OR 375 50 CA 527 51 AK 532 52 HI 235Does the rate of violent crime acts vary across different regions of the United States? Answer this with the data in the file P10_34.xisx 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 = x Region1 + Region2 + Region3 Interpret the estimated equation.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. Subdivision7 + * Subdivision3 + Subdivision4 + Subdivision5 + Subdivision6 + Violent Crime Rate = Subdivision1 + Subdivision2 + Subdivisions