The study was based on the correlation of unemployment and crime. Needs to utilize an excel document in this analysis.
Submit the results of your regression analysis for the demand function you are estimating for your term project. Include:

The data used to estimate the demand model

The results of the analysis, an analysis of the results

Description of remaining issue that needs to be addressed before the final paper is submitted.
Using your inventory of data collected, you will estimate and perform various analyses which will lead you to an evaluation. At the conclusion of your analysis you will address how this example can inform other realworld decision making in other organizations as well as your own decisionmaking and management skills.
Statistical Analysis and Tests
1. Evaluate Adj R2.
2. Each variable (independent variables have to be tested by using ttest, so as to see whether each of the variables (exogenous or independent) that you have include in the function has an effect on the dependent variable (left hand side).
3. For ttest, the following steps should be followed:
(i) H0: β0 = 0
(Null hypothesis)
HA: β0 ¹ 0
(Alternate hypothesis)
If t calculated > t table value (nk) degrees of freedom
where:
n = # of observations
k = # of parameters, i.e. # of right hand side variables plus the constant
then H0 is rejected, i.e. the variable you are testing has an effect on the dependent variable.
4. Do Ftest, by following these steps:
(i) H0: β0 = β1 = β2 = 0
(Null hypothesis)
HA: At least one β is not equal to zero
(Alternate hypothesis)
(ii) If F calculated > F table value
Then H0 is rejected, i.e. all the righthandside variables are important.