Preposttest
Preposttest
Preposttest
Date: ___________________________
Project 1 - Pretest/Posttest
You will be given 60 minutes to complete the assessment. You may use paper, pencil, and Microsoft
Excel. No other computer program, including the Internet, may be used.
Total Possible:
Your Score:
Section I
5
Section II
10
Section III
41
Total
56
_______
1. This table can be used to find data on property crime in OH and IN for the year 1980.
_______
2. This table can be used to find data on violent crime in Ohio for the year 1994.
_______
3. This table can be used to find data on violent and property crimes in Ohio for the
years 1994 1997
_______
4. This table can be used to find data about property crimes and violent crimes for the
state of Ohio in 1980.
_______
5. This table can be used to find data about property crimes in OH and IN from 19801985.
Use the following table with data from the UCR for Section II.
Section III. Short Answers (41 points) You have 40 minutes to complete this section.
A. Directions: (6 points) In your own words, define the following terms:
1. (1 point)
median
2. (1 point)
mode
3. (1 point)
mean
4. (1 points)
range
5. (2 points)
standard deviation
Calculate the following problems. Use the data in the above table if appropriate. If
you are using Excel to do the calculation, write the exact Excel command you used.
Show all your work to receive full credit. (15 points)
1.
(2 points) Calculate the median violent crime rate for the state of Ohio.
2.
(2 points) Calculate the mean violent crime rate for the state of Indiana.
3.
(5 points) Compute the Upper and Lower Quartile ranges for the state of Ohio.
4.
C. Direction:
Short Answer. Make sure to use complete sentences and correct punctuation. 5
points each. (20 points)
1.
Describe a situation where you would want to use the median rather than the mean to
report the average in a set of data.
2.
With the data we collect from the UCR, would the median or the mean be a better
representation of the average? Why?
3.
4.
Draw a picture of a graph that has low variation, and explain why.