Reference no: EM131397044 , Length: 3
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.)
Attachment:- copy_of_week_10_dataset.rar
|
Simple interest rate should she charge him
: Frank borrows $1389 from Samantha for 48 months. If Samantha wants Frank to repay a total of 5% more than what he borrowed, what annual simple interest rate should she charge him?
|
|
Identify common elements found in successful classes
: After the interviews, write a one-page paper summarizing your findings and identify common elements found in successful classes and in unsuccessful classes. Submit this paper to your instructor.
|
|
How much did he invest at each amount
: An actor invests some money at 9 %, and $35000 more than twice the amount at 10%. The total annual interest earned from the investment is $29020. How much did he invest at each amount? Use the six-step method.
|
|
What are some opportunities for internal auditing
: What are some opportunities for internal auditing to use technology to improve the way audits are performed? Find and summarize a relevant article dealing with the importance of soft skills in performing audits.
|
|
What you can conclude from the output of 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 (cros..
|
|
How a company could use a variable costing system
: M3A1 & M3A2- Explain, with the help of an example, how a company could use a variable costing system, as well as an absorption costing system. You have the option of using the company you work for as an example.
|
|
What would be the likely state of the economy
: The past, current and future status of major economic indicators and their relations to the economy in a foreseeable period of time. What would be the likely state of the economy for the next few years?
|
|
Estimate the variance and standard error of the sample mean
: Suppose you randomly sample n = 8 participants and get- 2, 6, 10, 1, 15, 22, 11, 29- Estimate the variance and standard error of the sample mean.
|
|
Discuss the timesaving methods
: Time saving suggestions. Identify and discuss the timesaving methods that have been helpful to you in the past, and discuss the methods you found beneficial. Discuss the timesaving methods you haven’t used but plan to use in the near future. Explain ..
|