Module 1 Assignment: Descriptive Statistics. The assignments in this course are designed to assist you in applying the techniques you learned in the module to real-world scenarios. For this assignment, consider the following scenario:
You are part of a community in which there have been several disturbing incidents over the past few months. Some of the incidents involved damage to property, power outages, and animal cruelty. Your community has asked you to be a part of the committee that selects the inaugural Community Observation Patrol (COP) group. You have been asked to look at the files and provide the committee with information that will help select the inaugural COP members.
You will be analyzing the following variables located in the :
- AGE
- CONVICTD*
- ESTVICRT!
- WRKSTAT
Part 1: Statistical Tasks
You will need to complete the following tasks to explore the issues discussed in the scenario.
Descriptive Statistics: Compute the following descriptive statistics for each variable:
- Mean
- Median
- Mode
- Range
- Standard Deviation
Hint: You can use Excels Data Analysis Tool to compute descriptive statistics.
Frequency Distributions: Create frequency distributions for each variable. Be sure to include the proper labels for each variable category (class interval) and to include the percentage distributions.
Hint: Refer to the Infobase resources in this module and the site for examples of how to generate frequencies and compute percentages in Excel.
Charts: Create a pie, bar, line, or histogram chart for each variable. Be sure to include the proper labels for each variable category (class interval).
Hint: When creating charts, remember a variables scale of measurement can impact the type of chart used. In general, pie and bar charts are used for variables at the nominal and ordinal levels of measurement, and line and histogram charts are used for variables at the interval and ratio levels of measurement.
Correlations: Compute the correlation coefficient for each variable in one correlation matrix.
Hint: You can use Excels Data Analysis Tool to compute the correlation coefficients in a correlation matrix.
Part 2: Summarize Your Findings
You need to provide a summary of your findings and an interpretation that helps the reader understand what your findings mean in relation to the issues you explored in the real-world scenario. To do this, include a summary of the descriptive statistics, frequency distributions, and correlations.
When summarizing central tendencies and variability use the following general guidelines:
- Variables at the nominal level of measurement: mode, range
- Variables at the ordinal level of measurement: median, range
- Variables at the interval-ratio level of measurement: mean*, range, standard deviation. (*Remember that when a distribution is skewed, the median is a better measure of central tendency to use.)
Assume that the reader has already seen your work. Thus, do not provide a line-by-line description of each item. Instead provide a general summary (1-3 sentences) of each item. You can refer back to the text for examples of how to explain what the results of each statistical test means. Remember to use your own words. As a rule of thumb, if you are confused about what you wrote, your reader will most likely also be confused about what you wrote.
Part 3: Show Your Work
When you submit your assignment, you must also show your work. To do this, include a copy of your computed descriptive statistics, frequency distributions, charts, and correlation matrix.
You can copy and paste your work into your assignment document or you can submit a copy of the Excel file containing your work.
Assignment Template
Assignment 1
Statistical Tasks
List the names of the statistics and the related statistical values for each statistical task completed.
Summary of Findings
Provide a summary of your findings and the related interpretations.
Work Displayed
Include copies of the work you completed for each assigned task or a note that states: Work submitted as an Excel file.
This activity must be complete before the due date on the .
Grading Standard: 100 points, scored according to the .
course text book:
https://reader2.yuzu.com/reader/books/9781071806241/epubcfi/6/68[%3Bvnd.vst.idref%3Ds9781071806210.i2916]!/4/2[s9781071806210.i2916]/20[s9781071806210.i2931]/36[s9781071806210.i2954]/6/3:58[es%20%2Cof%20]

Leave a Reply
You must be logged in to post a comment.