Cross Tabulation

· Application: Cross Tabulation

Variable relationships are very important in quantitativeresearch. They tell researchers what effect different variables have upon oneanother. One of the easiest ways to display relationships between variables isthrough a cross-tabulation (cross-tab). A cross-tab is simply a chart thatshows frequency or distribution of one or more variables for every category ofanother variable. Stated another way, a cross-tab is a joint frequencydistribution of observations on two or more sets of variables. These statisticalobservations 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 dataprovided in the handout “Week 10 Dataset” such that property crime is displayedas a rate per student population. Though Excel is not the only software thatcan be used to perform a cross-tabulation, it is used here because it is awidely available program. The handout entitled, “Cross-Tabulation in Excel”contains instructions on how to complete the task in Excel using two differentmethods.

The assignment (2–3 pages):

· Using Excel, perform a cross tabulation on the dataprovided in the Week 10 dataset.

· Explain what you can conclude from the output of thecross tabulation.

· Include your outputs in your Application Assignmentdocument. (Copy and paste them from Excel into your Word doc.)

WEEK 10 DATASET

CollegeStudent EnrollmentCrime TotalForcible RapeAggravated AssaultArsonProperty CrimeAbalone University10,48635512117Franklinville College98940202Marie Louis College2,301142408Robert Long College3,46790108Simon State20,5734235133

CROSS TABULATION

Here is an excerptfrom a dataset Excel file.   

AQ1BQ2C Q40DQ41EQ42

Question numbers

777122117111111AnswersAnswersAnswers27752222111611121111AnswersAnswersAnswersAnswers52611Answers62111Answers61211Answers

The question numbersand answer values are explained below.

Frequencies: How often does each value occur?

EXAMPLE 1.

I want to know howmany females and males there are. That is question Q2. Females = 1 and males =2

STEP 1.

Since the possiblevalues are 1 & 2, enter those values below and to the left of Q2, as shownbelow.  In Excel terminology, this iscalled the “bins array.”

STEP 2.

Highlight the cellsnext to the bin array as shown below.

[img width="336" height="350"

STEP 3.

Enter the frequencyfunction:

=FREQUENCY(DATAARRAY,BINS ARRAY)

The data array refersto the answers you want to count.

STEP 4.

Enter:

CONTROL + SHIFT +ENTER

Entering ENTER onlywill not work.

[img width="336" height="355" src="file:///C:/Users/VENISE/AppData/Local/Temp/msohtmlclip1/01/clip_image010.gif" v:shapes="_x005F_x0000_s1030"> 

STEP 5.

Dress up the results as you see fit. For example:

EXAMPLE 2.

During the past 30 days, on how many daysdid 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 theassignment. Covering the topic does not mean mentioning the topic BUTpresenting an explanation from the context of ethics and the readings for thisclass

To get maximum points you need to follow the requirements listed forthis assignments 1) look at the page limits 2) review and follow APA rules3) create SUBHEADINGS to identify the key sections you are presenting and4) Free from typographical and sentence construction errors.