Does the rate of violent crime acts vary across different regions of the United States? Answer this with the (somewhat old) 1999 data in the file P14_20.xlsx as requested below. a. Estimate an...

Does the rate of violent crime acts vary across different regions of the United States? Answer this with the (somewhat old) 1999 data in the file P14_20.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. Interpret the estimated equation. Rank the four regions from highest to lowest according to their mean violent crime rate. Could you have done this without regression? Explain.

b. How would you 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 and interpret your findings. Rank the nine subdivisions from highest to lowest according to their mean violent crime rate.