23 Compute the relative frequency distribution for each Age Group in order to compare distributions by Age Group. The frequency distributions in #19 cannot be compared directly because the Age Group sizes are unequal. For each Age Group, divide count by column subtotal (not the grand total). If you do this correctly, the first column will have 84%, 10%, and 6%. Age Group Under 6 6 to 9 10 to 14 15 to 21 Over 21 Viewing Frequency Never Once More Than Once 24 Make a stacked bar chart of the relative viewing frequencies by Age Group in 20 a): Select cells C69:H72 above, Insert, Insert Column or Bar Chart, and 2D Column and Stacked. If your stacked bar chart is done correctly, it will match the following picture: Chart Title 120% 100% 80% 60% 40% 20% 0% Under 6 6t09 10 to 14 15 to 21 Over 21 Age Group Viewing Frequency More Than Once Viewing Frequency Once ■Viewing Frequency Never 25 Examine the stacked bar chart of the distribution by Age Groups. If the relative frequency distributions are similar or the same, then Age Group is no more than a label. If the distributions are different, then Age Group matters because it determines distribution. Are Age Groups similar or same, or are they different and Age Group matters?

Holt Mcdougal Larson Pre-algebra: Student Edition 2012
1st Edition
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Chapter11: Data Analysis And Probability
Section11.1: Stem-and-leaf Plots And Histograms
Problem 10E
icon
Related questions
Question

Microsoft Excel include formulas

23 Compute the relative frequency distribution for each Age Group in order to compare distributions by Age Group.
The frequency distributions in #19 cannot be compared directly because the Age Group sizes are unequal.
For each Age Group, divide count by column subtotal (not the grand total). If you do this correctly, the first column will have 84%, 10%, and 6%.
Age Group
Under 6
6 to 9
10 to 14
15 to 21
Over 21
Viewing Frequency
Never
Once
More Than Once
24 Make a stacked bar chart of the relative viewing frequencies by Age Group in 20 a):
Select cells C69:H72 above, Insert, Insert Column or Bar Chart, and 2D Column and Stacked.
If your stacked bar chart is done correctly, it will match the following picture:
Chart Title
120%
100%
80%
60%
40%
20%
0%
Under 6
6t09
10 to 14
15 to 21
Over 21
Age Group
Viewing Frequency More Than Once
Viewing Frequency Once
■Viewing Frequency Never
25 Examine the stacked bar chart of the distribution by Age Groups.
If the relative frequency distributions are similar or the same, then Age Group is no more than a label.
If the distributions are different, then Age Group matters because it determines distribution.
Are Age Groups similar or same, or are they different and Age Group matters?
Transcribed Image Text:23 Compute the relative frequency distribution for each Age Group in order to compare distributions by Age Group. The frequency distributions in #19 cannot be compared directly because the Age Group sizes are unequal. For each Age Group, divide count by column subtotal (not the grand total). If you do this correctly, the first column will have 84%, 10%, and 6%. Age Group Under 6 6 to 9 10 to 14 15 to 21 Over 21 Viewing Frequency Never Once More Than Once 24 Make a stacked bar chart of the relative viewing frequencies by Age Group in 20 a): Select cells C69:H72 above, Insert, Insert Column or Bar Chart, and 2D Column and Stacked. If your stacked bar chart is done correctly, it will match the following picture: Chart Title 120% 100% 80% 60% 40% 20% 0% Under 6 6t09 10 to 14 15 to 21 Over 21 Age Group Viewing Frequency More Than Once Viewing Frequency Once ■Viewing Frequency Never 25 Examine the stacked bar chart of the distribution by Age Groups. If the relative frequency distributions are similar or the same, then Age Group is no more than a label. If the distributions are different, then Age Group matters because it determines distribution. Are Age Groups similar or same, or are they different and Age Group matters?
Expert Solution
steps

Step by step

Solved in 2 steps with 6 images

Blurred answer
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra: Structure And Method, Book 1
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell