Decision Models term project help! I need help with a project on median incomes in relation to crime rates for a sample of cities across the U.S. Please create an Excel sheet with the table of City Data below including variable lables (dependent vs. independent) and descriptive statistics as mentioned in the additional instructions below. Please use multiple regression analysis methods to test theory that areas with lower median income experience a higher total crime rate. If possible, please also include graphs as appropriate scatterplot, histogram, pie chart, etc.

Median Total

City Population Income Crime Rate

Orlando, FL 262,372 $41,345 481.6

San Diego, CA 1,381,069 $63,456 211.5

Evansville, IN. 83,322 $32,414 423.1

Flint, MI 99,002 $23,131 680.9

Stamford, CT 128,278 $72,706 150.8

Chicago, IL 2,722,389 $47,099 436.5

Phoenix, AZ 1,537,058 $46,601 390.9

Boulder, CO 105,112 $57,428 182.5

Lakewood, WA 59,610 $42,231 419.8

Abilene, TX 120,958 $43,059 385.4

2014 data obtained from:

http://www.city-data.com/

Additional Instructions from Project Guidelines:

Fianal project must include the following areas:

* Introduction What was your project? Why did you choose the topic? What was the main research question? How did completing this project demonstrate Saint Leo Universitys core value of excellence?

* Data What was your data source? What dates did it cover? What was the web site you obtained it from? What variables did you include? Identify all dependent and independent variables. What were their values and what do those values signify?

* Descriptive Statistics for your primary variables, be sure to include Table 1 below (you can cut and paste it into your document if you like).

* Graphs as appropriate scatterplot, histogram, pie chart, etc.

* Testing Conducted what type of test did you conduct? What were the results?

* Conclusion Wrap up your report in a concise manner. Clearly state what you learned from the results and any potential shortcomings of your analysis.

Descriptive Statistics for Project

Add descriptive statistics measures as needed for your project.

Statistic ????? ?????

N ? ?

Mean ? ?

Std. Deviation ? ?

Skewness ? ?

Minimum ? ?

Q1 ? ?

Median ? ?

Q3 ? ?

Maximum ? ?