Question
A crosstabulation displays the frequency of data as it occurs in particular categories. The types of data displayed can be either categorical or quantitative. If
A crosstabulation displays the frequency of data as it occurs in particular categories. The types of data displayed can be either categorical or quantitative. If the data is quantitative, ranges will often be used instead of each numerical value from the given data. Be careful when determining the ranges for use within a crosstabulation. If the ranges are too large or too small, then this display will not be meaningful.Here we are given quantitative data for variables x and y. We are also given specific classes to use. The crosstabulation format is given below. The rows correspond to x values in the specified classes 10-29, 30-49, etc., and the columns correspond to y values in the specified classes 20-39, 40-59, etc. The Grand Total column will be the sums of the previous columns, and the Grand Total Row will be the sums of the above rows.
y | Grand Total | |||||
---|---|---|---|---|---|---|
20-39 | 40-59 | 60-79 | 80-99 | |||
x | 10-29 | |||||
30-49 | ||||||
50-69 | ||||||
70-90 | ||||||
Grand Total |
Here are the data.
Observation | x | y |
---|---|---|
1 | 13 | 87 |
2 | 47 | 63 |
3 | 82 | 21 |
4 | 78 | 34 |
5 | 23 | 82 |
6 | 35 | 65 |
7 | 21 | 89 |
8 | 37 | 71 |
9 | 17 | 96 |
10 | 51 | 44 |
Observation | x | y |
---|---|---|
11 | 71 | 34 |
12 | 20 | 75 |
13 | 87 | 22 |
14 | 54 | 41 |
15 | 61 | 54 |
16 | 76 | 24 |
17 | 72 | 23 |
18 | 63 | 38 |
19 | 37 | 62 |
20 | 39 | 32 |
To fill in the table, first determine how many observations are in each x class. Place this value in the corresponding row of the Grand Total column. Of these, determine how many are in the corresponding classes for y.Observations 1, 5, 7, 9, and 12 have x values between 10 and 29, so a 5 will be placed in the first row of the Grand Total column. Of these 5 observations, there are none with y values between 20 and 39, or 40 and 59. There is 1 observation with y-values between 60 and 79. There are 4 observations with y-values between 80 and 99. Therefore 1 and 4 will be placed in the first row of the 60-79 and 80-99 columns, respectively.
y | Grand Total | |||||
---|---|---|---|---|---|---|
20-39 | 40-59 | 60-79 | 80-99 | |||
x | 10-29 | |||||
30-49 | ||||||
50-69 | ||||||
70-90 | ||||||
Grand Total |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started