MUST HAVE MINITAB!!!MUST HAVE MINITAB SOFTWARE!!!MUST HAVE MINITAB SOFTWARE!!!MUST HAVE MINITAB SOFTWARE!!!In this assignment, you will use Uniform Crime Report (UCR) statistics to analyze interval variables for violent crimes over a 5-year period. The information needed to complete this assignment is conveniently accessed by clicking the links in the Project Resources image below.To get started, click the image below to access the Step-by-Step Instructions for using the data set in the Minitab software.Use the data set provided by clicking the image below for the Uniform Crime Report data. Copy and paste this data into the Minitab software.Use this information to create descriptive statistics to analyze the types of crimes that are committed and the variance between crimes from 2008 and 2012.Create and recode the variables to produce a table and a chart illustrating the variance between crimes from 2008 and 2012.Display your findings by creating appropriate tables and graphs using the data you downloaded to a Minitab spreadsheet.Present the Minitab spreadsheet as a table in a Microsoft Word document; be sure to include the tables and graphs you created to support your analysis of the data and state your conclusions about the variance in the types of violent crimes between 2008 and 2012.
mcj5100_w2_a2_s2_dataset.xlsx
mcj5100_w2_project_dataset.xlsx
mcj5100_w2a2_companion_step_by_step.pdf
Unformatted Attachment Preview
Year
2008
2009
2010
2011
2012
Murder/NonNegligent
Manslaughter
294
287
269
198
217
Forcible Rape
750
823
712
771
665
Robbery
10603
11367
9449
8054
9385
Aggravated Assault
13132
13116
12061
11869
11343
Year
Murder/Non-Negligent Manslaughter
Forcible Rape
Robbery
2008
2009
2010
2011
2012
294
287
269
198
217
750
823
712
771
665
10603
11367
9449
8054
9385
Aggravated Assault
13132
13116
12061
11869
11343
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Week 2 Assignment 2: Working with Minitab Software – Descriptive Statistics
Companion to Assignment 2/Step by Step Instructions Using Minitab Software
Summary of Instructions: For this assignment you will use the data set provided on the assignment
page. You will copy this data set into a spreadsheet in Minitab.
Step 1. Retrieve the Data from the Data Set Spreadsheet
Click the magnifying glass in the image of the assignment page for the Data Set. Select the first row in
the spreadsheet. These are the column headings. Press and hold the ctrl key on your keyboard and press
the letter C. This action copies the selected content to the clipboard of your computer.
Retrieve the Data Set for this
assignment.
Select only the first row in the
spreadsheet. Press ctrl + C to copy.
Ctrl + C
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Step 2. Open Minitab and Copy/Paste Column Headers
Open the Minitab software. Depending on your operating system, you may need to click or double click
to start the Minitab. Click in the grey cell below cell C1. Hold down the ctrl key on the keyboard and
type the letter V. This will paste the column titles from the spreadsheet into Minitab.
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Step 3. Copy Data from Data Set
Next select the remaining data in the data set spreadsheet provided. Hold down the ctrl key or your
keyboard and press the letter C to copy the data.
Step 4. Paste Data into Minitab
Click cell C1 row 2 in the Minitab spreadsheet. Press ctrl + V to paste the data in the Minitab
spreadsheet.
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Step 5. Display Descriptive Statistics
Click Stat on the menu bar, then Basic Statistics, then click on Display Descriptive Statistics.
Step 6. Display Descriptive Statistics
Select one column header and add it to the variables list by clicking the select button. Repeat until all
column headings have been added.
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
After all column headings have been added to the variables list, your screen should look like this:
Step 7. Select the Statistics Button
Select the Statistics button. In this menu you check only the boxes for the data you want shown in your
results output (Session Window). For this exercise check the same selections that are checked in the
graphic below, then select OK for both menus to get your output.
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Step 8. Results are displayed in the Session Window
The Session Window displays the descriptive statistics data output for your analysis
Student Response – Analysis of Data
Write your initial analysis of these violent crimes looking at the data set year by year to draw your
hypothesis. Then use the output from this Minitab exercise to compare each crime using the Mean,
Standard Deviation, Minimum, and Maximum data. Check your reading for the week for more
information on how to apply this data in your analysis.
In addition to your written analysis support your findings by creating and recoded variables to produce a
pie chart illustrating the variances in crimes 2008 and 2012.
Step 9. Producing a Pie Chart
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Step 9 A – Setting Pie Chart Options
Select the Chart values from a table option and click in the field for Categorical variable.
Step 9 B – Click C1 Year and click the Select button. This action adds Year to the Categorical variable.
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
Step 10. Add column headings to the Summary variable field
Click each column heading and click the select button to add each column heading to the Summary
variable field. Click the OK button
Step 11. The Pie Chart results
Select Chart Values from a Table
Experiment with variables in other Graphs
MCJ5100 WEEK 2 ASSIGNMENT 2 STEP-BY-STEP INSTRUCTIONS
January 1,
2015
The Graph menu lists many chart options. Now that you know how to find the list of Graphs, try some
other types of graphs, bar chart, histogram, line plot, etc., using different variables from your table of
data.
…
Purchase answer to see full
attachment
Are you having trouble with the above assignment or one similar?
We offers 100% original papers that are written from scratch.We also have a team of editors who check each paper for plagiarism before it is sent to you.