BSTAT 3321-006 Final Project Instructions: Files Please find all the necessary and related files in the Modules section of Canvas. Competency In this project, you will demonstrate your mastery of the following competency: Perform regression analysis to address an authentic problem. Scenario Suppose, you are a data analyst for U.S. Department of Justice . Authorities wants you calculate crime rate for several cities requested that you come up with regression models that predict the crime rate based on the metrics that are included in the data set. These regression models will help make key decisions to improve the the security for the city. You will use the Excel data analysis tools to perform the statistical analyses and then prepare a report of your findings to present the crime rates. Since most of the peoples in the department are not data analysts, you will need to interpret your findings and describe their practical implications. Note: This data set has been "cleaned" for the purposes of this assignment. Directions For this project, you will submit the Excel script you used to make your calculations and a summary report explaining your findings. Summary Report: Once you have completed all the steps in your