Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored 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