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.

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 University’s 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                 ?         ?