Cross Tabulation

Anonymous
timer Asked: May 4th, 2016
account_balance_wallet $15

Question Description

·  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.


Tutor Answer

maazkap
School: Purdue University

flag Report DMCA
Review

Anonymous
Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors