·
Application: Cross Tabulation
Variable relationships are very important in quantitative
research. They tell researchers what effect different variables have upon one
another. One of the easiest ways to display relationships between variables is
through a cross-tabulation (cross-tab). A cross-tab is simply a chart that
shows frequency or distribution of one or more variables for every category of
another variable. Stated another way, a cross-tab is a joint frequency
distribution of observations on two or more sets of variables. These statistical
observations can be presented by numeric frequency, percentages, or both,
depending on which is most useful given the specific data context.
For this Application Assignment, perform a cross-tabulation on the data
provided in the handout “Week 10 Dataset” such that property crime is displayed
as a rate per student population. Though Excel is not the only software that
can be used to perform a cross-tabulation, it is used here because it is a
widely available program. The handout entitled, “Cross-Tabulation in Excel”
contains instructions on how to complete the task in Excel using two different
methods.
The assignment (2–3 pages):
·
Using Excel, perform a cross tabulation on the data
provided in the Week 10 dataset.
·
Explain what you can conclude from the output of the
cross tabulation.
·
Include your outputs in your Application Assignment
document. (Copy and paste them from Excel into your Word doc.)
WEEK 10 DATASET
| College | Student Enrollment | Crime Total | Forcible Rape | Aggravated Assault | Arson | Property Crime |
| Abalone University | 10,486 | 35 | 5 | 12 | 1 | 17 |
| Franklinville College | 989 | 4 | 0 | 2 | 0 | 2 |
| Marie Louis College | 2,301 | 14 | 2 | 4 | 0 | 8 |
| Robert Long College | 3,467 | 9 | 0 | 1 | 0 | 8 |
| Simon State | 20,573 | 42 | 3 | 5 | 1 | 33 |
CROSS TABULATION
Here is an excerpt
from a dataset Excel file.
|
A
Q1
|
B
Q2
|
C
Q40
|
D
Q41
|
E
Q42
|
Question numbers
|
|
|
7
7
7
|
1
2
2
|
1
1
7
|
1
1
1
|
1
1
1
|
Answers
Answers
Answers
|
|
|
2
7
7
5
|
2
2
2
2
|
1
1
1
6
|
1
1
1
2
|
1
1
1
1
|
Answers
Answers
Answers
Answers
|
|
| 5 | 2 | 6 | 1 | 1 | Answers | |
| 6 | 2 | 1 | 1 | 1 | Answers | |
| 6 | 1 | 2 | 1 | 1 | Answers |
The question numbers
and answer values are explained below.
Frequencies: How often does each value occur?
EXAMPLE 1.
I want to know how
many females and males there are. That is question Q2. Females = 1 and males =
2
STEP 1.
Since the possible
values are 1 & 2, enter those values below and to the left of Q2, as shown
below. In Excel terminology, this is
called the “bins array.”
STEP 2.
Highlight the cells
next to the bin array as shown below.
[img width=”336″ height=”350″
STEP 3.
Enter the frequency
function:
=FREQUENCY(DATA
ARRAY,BINS ARRAY)
The data array refers
to the answers you want to count.
STEP 4.
Enter:
CONTROL + SHIFT +
ENTER
Entering ENTER only
will not work.
[img width=”336″ height=”355″ src=”file:///C:/Users/VENISE/AppData/Local/Temp/msohtmlclip1/01/clip_image010.gif” v_shapes=”_x0000_s1030″>
STEP 5.
Dress up the results as you see fit. For example:
EXAMPLE 2.
During the past 30 days, on how many days
did youth have at least one drink of alcohol (Q41)?
1 = 0 days 5
= 10 to 19 days
2 = 1 or 2 days 6 = 20 to 29 days
3 = 3 to 5 days 7 = All 30 days
4 = 6 to 9 days
[img width=”336″ height=”490″
With at least three reference….
It is important that you cover all the topics identified in the
assignment. Covering the topic does not mean mentioning the topic BUT
presenting an explanation from the context of ethics and the readings for this
class
To get maximum points you need to follow the requirements listed for
this assignments 1) look at the page limits 2) review and follow APA rules
3) create SUBHEADINGS to identify the key sections you are presenting and
4) Free from typographical and sentence construction errors.
0 comments