# Cross Tabulation

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

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.

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.

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