Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

17 As part of the marketing group of a film company, we are asked to find out the age distribution of the audience of the

17 As part of the marketing group of a film company, we are asked to find out the age distribution of the audience of the latest film.
From 500 responses, we find that 50 are younger than 6 years old, 86 are 6 to 9 years,
165 are 10 to 14, 25 are 15 to 21, and 174 are older than 21.
a)Make a frequency table of these categorical data.
Age Frequency
< 6
6 to 9
10 to 14
15 to 21
older than 21
total
b) Make relative frequency table.
c)Make bar chart using counts in the frequency table.
d) Would the distribution of responses in a bar chart of relative frequencies be different from the distribution of responses in a bar chart of frequencies?
e)Make pie chart.
18 Write few sentences describing the distribution across age groups shown by the charts.
19 The audiences interviewed were also asked if they had seen the movie before (Never, Once, More than Once):
Age Group
Under 6 6 to 9
Viewing Frequency Never 42 62
Once 5 20
More Than Once 3 4
a)Compute the marginal frequency distribution by Viewing Frequency in new column labeled "Total".
b)Compute the marginal frequency distribution by Age Group in new row labeled "Total".
c) What percentage of all audience members are over 21?
d) In the Viewing Frequency group "More Than Once", what percentage are Over 21?
20 a)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
Viewing Frequency Never
Once
More Than Once
b)Make stacked bar chart of the relative viewing frequencies by Age Group in 20 a):
Select all the cells within the red-dashed rectangle above, Insert, Insert Column or Bar Chart, and 2D Column and Stacked.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

More Books

Students also viewed these Mathematics questions