6. Cross tabulations Problem: The following crosstabulation shows household income by educational level of the head of household (Statistical Abstract of the United States: 2008) Household Income ($1000s) Under 25 25.0- 49.9 50.0- 74.9 75.0- 99.9 100 or Educational Level more Total Not H.S. graduate H.S. graduate Some college Bachelor's degree Beyond bach. deg. 4,207 4,917 2,807 3,459 6,850 5,258 2,094 829 1,389 5,027 4,678 2,848 1,274 539 2,637 3,250 2,581 1,241 367 2,668 4,074 5,379 4,188 9,961 22,099 20,067 13,787 7,822 885 290 Total 13,106 18,490 15,216 10,248 16,676 73,736

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Question
6. Cross tabulations Problem:
The following crosstabulation shows household income by educational level of the head of
household
(Statistical Abstract of the United States: 2008)
Household Income ($1000s)
Under
25
25.0-
49.9
50.0-
74.9
75.0-
99.9
100 or
Educational Level
more
Total
Not H.S. graduate
H.S. graduate
Some college
Bachelor's degree
Beyond bach. deg.
4,207
4,917
2,807
885
290
3,459
6,850
5.258
2,094
829
1,389
5,027
4,678
2,848
1,274
539
2,637
3,250
2,581
1.241
367
2,668
4,074
5,379
4.188
9,961
22,099
20,067
13,787
7,822
Total
13,106 18,490 15,216 10,248
16,676
73,736
a. Compute the row percentages for high school graduate and bachelor's degree (see
examples in table below)
b. What percentage of households headed by high school graduates earn $75, 000 or
more?
c. What percentage of households headed by bachelor degree recipients earn less than
$50,000 (49,900 or less)?
2
HW 3 questions and Ch 3 BONUS summer 2021
Under 25
25.0-49.9
Iso.0-74.9
75.0-99.9
total
Educational level
Not HS Graduate
HS Graduate
Some College
Bachelor's degree
Beyond bach deg
Total
100 or more
4207
3459
1389
539
367
9961
4917
6850
5027
2637
2668
22099
2807
5258
4678
3250
4074
20067
13787
885
2094
2848
2581
5379
290
829
1274
1241
4188
7822
13106
18490
15216
10248
16676
73736
ROW PERCENTAGES
ONLY CALCULATE ROW PERCENTAGES FOR HS GRADUATE AND BACHELORS DEGREE AND ANSWER PARTS B & C.
ROW PERCENTAGES.FOLLOW EXAMPLES FOR OTHER ED LEVELS.
Educational level
Not HS Graduate
HS Graduate
Some College
Bachelor's degree
Beyond bach deg
Total
Under 25
=(4207/9961)*100
50.0-74.9
=(3459/9961)*100 (1389/9961)*100 -(539/9961)*100
25.0-49.9
75.0-99.9
100 or more
=(367/9961)*100
total
=(9961/9961)*100
=(2807/20067)*100
(5258/20067)*100 =(4678/20067)*100 (3250/20067)*100 =(4074/20067)*100
=(20067/20067)*100
(290/7822)*100
(13106/73736)*100
L829/7822)*100(1274/7822)*100(1241/7822)*100(4188/7822)*100
=(18490/73736*100 =(15216/73736*100 (10248/73736*100 =(16676/73736*100 (73736/73736*100
(7822/7822)*100
Educational level
Not HS Graduate
HS Graduate
Some College
Bachelor's degree
Beyond bach deg
Total
Under 25
42.23
25.0-49.9
50.0-74.9
13.94
75.0-99.9
5.41
100 or more
Itotal
34.73
3.68
100
13.99
26.20
23.31
16.20
20.30
100
3.71
10.60
16.29
15.87
53.54
100
17.77
25.08
20.64
13.90
22.62
100
Transcribed Image Text:6. Cross tabulations Problem: The following crosstabulation shows household income by educational level of the head of household (Statistical Abstract of the United States: 2008) Household Income ($1000s) Under 25 25.0- 49.9 50.0- 74.9 75.0- 99.9 100 or Educational Level more Total Not H.S. graduate H.S. graduate Some college Bachelor's degree Beyond bach. deg. 4,207 4,917 2,807 885 290 3,459 6,850 5.258 2,094 829 1,389 5,027 4,678 2,848 1,274 539 2,637 3,250 2,581 1.241 367 2,668 4,074 5,379 4.188 9,961 22,099 20,067 13,787 7,822 Total 13,106 18,490 15,216 10,248 16,676 73,736 a. Compute the row percentages for high school graduate and bachelor's degree (see examples in table below) b. What percentage of households headed by high school graduates earn $75, 000 or more? c. What percentage of households headed by bachelor degree recipients earn less than $50,000 (49,900 or less)? 2 HW 3 questions and Ch 3 BONUS summer 2021 Under 25 25.0-49.9 Iso.0-74.9 75.0-99.9 total Educational level Not HS Graduate HS Graduate Some College Bachelor's degree Beyond bach deg Total 100 or more 4207 3459 1389 539 367 9961 4917 6850 5027 2637 2668 22099 2807 5258 4678 3250 4074 20067 13787 885 2094 2848 2581 5379 290 829 1274 1241 4188 7822 13106 18490 15216 10248 16676 73736 ROW PERCENTAGES ONLY CALCULATE ROW PERCENTAGES FOR HS GRADUATE AND BACHELORS DEGREE AND ANSWER PARTS B & C. ROW PERCENTAGES.FOLLOW EXAMPLES FOR OTHER ED LEVELS. Educational level Not HS Graduate HS Graduate Some College Bachelor's degree Beyond bach deg Total Under 25 =(4207/9961)*100 50.0-74.9 =(3459/9961)*100 (1389/9961)*100 -(539/9961)*100 25.0-49.9 75.0-99.9 100 or more =(367/9961)*100 total =(9961/9961)*100 =(2807/20067)*100 (5258/20067)*100 =(4678/20067)*100 (3250/20067)*100 =(4074/20067)*100 =(20067/20067)*100 (290/7822)*100 (13106/73736)*100 L829/7822)*100(1274/7822)*100(1241/7822)*100(4188/7822)*100 =(18490/73736*100 =(15216/73736*100 (10248/73736*100 =(16676/73736*100 (73736/73736*100 (7822/7822)*100 Educational level Not HS Graduate HS Graduate Some College Bachelor's degree Beyond bach deg Total Under 25 42.23 25.0-49.9 50.0-74.9 13.94 75.0-99.9 5.41 100 or more Itotal 34.73 3.68 100 13.99 26.20 23.31 16.20 20.30 100 3.71 10.60 16.29 15.87 53.54 100 17.77 25.08 20.64 13.90 22.62 100
6. Cross tabulations Problem:
The following crosstabulation shows household income by educational level of the head of
household
(Statistical Abstract of the United States: 2008)
Household Income ($1000s)
Under
25
25.0-
49.9
50.0–
74.9
100 or
75.0-
99.9
Educational Level
more
Total
Not H.S. graduate
H.S. graduate
Some college
Bachelor's degree
Beyond bach. deg.
4,207
4,917
2,807
885
3,459
6,850
5,258
2,094
829
1,389
5,027
4,678
2,848
1,274
539
367
2,637
3,250
2,581
1,241
2,668
4,074
5,379
4,188
9,961
22,099
20,067
13,787
7,822
290
Total
13,106
18,490
15,216
10,248
16,676
73,736
a. Compute the row percentages for high school graduate and bachelor's degree (see
examples in table below)
b. What percentage of households headed by high school graduates earn $75, 000 or
more?
c. What percentage of households headed by bachelor degree recipients earn less than
$50,000 (49,900 or less)?
Transcribed Image Text:6. Cross tabulations Problem: The following crosstabulation shows household income by educational level of the head of household (Statistical Abstract of the United States: 2008) Household Income ($1000s) Under 25 25.0- 49.9 50.0– 74.9 100 or 75.0- 99.9 Educational Level more Total Not H.S. graduate H.S. graduate Some college Bachelor's degree Beyond bach. deg. 4,207 4,917 2,807 885 3,459 6,850 5,258 2,094 829 1,389 5,027 4,678 2,848 1,274 539 367 2,637 3,250 2,581 1,241 2,668 4,074 5,379 4,188 9,961 22,099 20,067 13,787 7,822 290 Total 13,106 18,490 15,216 10,248 16,676 73,736 a. Compute the row percentages for high school graduate and bachelor's degree (see examples in table below) b. What percentage of households headed by high school graduates earn $75, 000 or more? c. What percentage of households headed by bachelor degree recipients earn less than $50,000 (49,900 or less)?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman