QUESTION
JAN 11, 2019

# CRJ 511 Applied Data Analysis in Criminal Justice Final Project Use SENTENCING. A codebook with description of the data is on the last page of this…

CRJ 511 Applied Data Analysis in Criminal Justice

Final Project

Use SENTENCING.XLS. A codebook with description of the data is on the last page of this document.

Note:

2.     You are expected to use Excel to conduct appropriate statistical analysis to answer each question in this project.

3.     Please copy and paste your results from Excel into WORD first. Type your summary afterwards. Your summary needs to be articulate to a reader who does not read and understand Excel output. Remember that the instructor expects more than just Excel output.

1.     Produce a frequency table and a pie chart for RACE. Summarize the results.

2.     Produce the mode, median, mean, standard deviation, variance, range, minimum, and maximum for JAILCREDIT and AGEADMIT. Report the results.

3.     Construct a 95% confidence interval around the sample mean of JAILCREDIT and AGEADMIT, respectively. Interpret and summarize your results.

4.     Assume that the average age of offenders at prison admissions in the state of Florida is 30. Use the data to perform a hypothesis test to determine if the average age of offenders at prison admissions in your sample is significantly different from the average age in the offender population in Florida. The variable that measures the average age of offenders at prison admission is AGEADMIT. Use a .05 level of statistical significance. Run the one-sample t-test in Excel. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

5.     Assume that the average length of jail in pretrial in the state of Florida is 90 days. Use the data to perform a hypothesis test to determine if the average length of jail in pretrial in your sample is significantly different from the average length of jail in pretrial in Florida. The variable that measures the average length of jail in pretrial is JAILCREDIT. Use a .05 level of statistical significance. Run the one-sample t-test in Excel. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

6.     Conduct an independent sample t-test (alpha= .05) in Excel to determine whether there is a significant difference in the length of jail in pretrial between White and Black offenders. For this t-test, assume that the variances of the two groups are unequal. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

7.     Conduct an independent sample t-test (alpha= .05) in Excel to determine whether there is a significant difference in the age of offenders at prison admissions between White and Black offenders. For this t-test, assume that the variances of the two groups are equal. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

8.     Conduct a Chi-Square test in Excel to determine if the race of offenders is independent of offense type. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

9.     Conduct an ANOVA test in Excel to determine if there is a significant difference in JAILCREDIT across offense types. In your summary, please discuss the null hypothesis, alternative hypothesis, the result of this hypothesis test, and interpret the result.

10.  Correlate AGEADMIT and JAILCREDIT in Excel. Summarize your results and make sure that you briefly explain what this correlation means to you in terms of the impact of age on the length of jail in pretrial (direction of the correlation, correlation coefficient, and test of significance result).

• Attachment 1
• Attachment 2
• Attachment 3

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.