Need 3 assignments completed as posted plagiarism free by 04/19/17 5:00 pm est.

TOPIC FOR ALL 3 ASSIGNMENTS:

Security and Criminal Justice

Topic: Criminals

Incarcerated Offenders

Question 1: Compare and contrast the gender, age, and race of incarcerated offenders in the prison system.  What does the information tell you about the typical inmate?

Topic: Criminals

Arrested Citizens

Question 2: Use data (including violent crime, property crime and drug crime) to predict the number of adults to be arrested in 2010 for possession of drugs.

Assignment 1:

The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools, technology, and skills of MTH/219. In the first week, you must develop a question that can be answered with numerical data and that spans over at least ten years. For example, "How has the population of the world changed over the past 50 years, and when will the population be unsustainable?"

In a Microsoft® Word document, write the topic/question you are addressing, where you plan to find your data even if it is one of the below sources, and why you chose this topic. Your paper should be 30 to 45 words long. You can either choose a topic from the Student Topics and Questions List or can create your own. If you chose to create your own, you must get instructor approval.

Here is a list of possible data sources to find your data:

• Healthcare data
• Educational data
• Criminal data
  1. Select the type of table under Law Enforcement or Incarcerations.
  2. Select year
  3. Then select the type of data you are looking for from the dropdown menus and click on the Microsoft® Excel® table, which will automatically download on your computer.
• Mortgage data
• Census data (Population, economy, business, education, employment, health, housing, income, trade)
• UN data (income, trade, religion, health, poverty)
• Health data
• Globalization, health, and agriculture data
• UCR data (crime)

You may choose to find data elsewhere, but you must get it approved by your instructor. It is very important the data you collect meet the following requirements:

1. It has data from a trusted/peer-reviewed source that is numeric per year.
2. You can collect at least ten data points (data over at least ten years old).
3. Your question can be answered with the data.

Assignment 2:

The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools, technology, and skills of MTH/219. In Week 2, you will work with the data you collected to analyze the data to draw conclusions.

Review the instructional video on how to use regression in Microsoft® Excel®.

Input your data into Microsoft® Excel® (data and years).

Create a scatterplot.

Insert a linear trendline. Make sure to show the equation and the R-square value. Also, make sure you label each axis and give a title to your graph. If you need help creating your visual, watch How to create scatterplot with trendline in Excel®.

In the same Microsoft® Excel® worksheet, answer the following questions. Each question should be 90 to 175 words.

1. Does the line fit the data? How can you tell?
2. What does the slope of the line mean in your real-life data? How can you interpret the slope of your line?
3. What does the y-intercept mean in your real-life data? How can you interpret the y-intercept?

Save and upload your Excel® file, including the graphic and your answer to each question.

Assignment 3:

The purpose of the Signature Assignment is to have you work with real-life data to answer a real-life question using the tools, technology, and skills of MTH/219. In Week 3, you will determine the type of polynomial your data is best represented. You will use that polynomial to make a prediction about your data.

Review the instructional video on how to use regression in Microsoft® Excel® (if you have forgotten from Week 2).

Input your data into Microsoft® Excel® (data and years).

Create a scatterplot.

Insert a polynomial trendline with degree of 4. Make sure to show the equation and the R-square value. Also make sure you label each axis and give a title to your graph. Then repeat this process for a 5th degree polynomial.

Answer the following questions in the same Microsoft® Excel® worksheet. Each question should be 175 to 260 words.

1. Which of the polynomials fit the data better? How can you tell?
2. Compare and contrast the polynomial regression with the linear regression from Week 2. What is the best model for your data so far?
3. What happens to your polynomial models over time? In other words, what do you expect to happen to the value if you measure it 50 years from now?

Save your Microsoft® Excel® file, including the graphic and your commentary.