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 Excel, you will create a summary report to present your findings. Use the provided template to create your report. You must complete each of the section mentioned in the template.
What to Submit?
To complete this project, you must submit the following:
Excel Script: Your Excel script contains all the statistical analyses you completed for this project. Review the file to make sure that every step and all your outputs are included.
Summary Report: Use the provided template to create your summary report. The template contains guiding questions to help you complete each section. Be sure to remove these questions before submitting your report. Your summary report should be submitted as a 3- to 5-page Microsoft Word document or pdf. It should include an APA-style cover page and APA citations for any sources used. Use double spacing, 12-point Calibri or Times New Roman font, and one-inch margins.
