First, the researcher categorised the data into six location groups and six occupation groups, and calculated the frequencies given below: Using Excel and the data in the frequency tables above, answer the following questions. a) Which graphical technique or chart should be used if the researcher is interested in comparing the number of individuals in each location group? Explain the reason for the selection of this graphical chart. Construct and display the chart, also briefly describe what you can observe about the number of individuals belonging to each location category. b) Which graphical technique or chart should be used if the researcher is interested in comparing the proportion of the number of individuals in each occupation group? Explain the reason for the selection of this graphical chart. Construct and display the chart, also briefly describe what you can observe about the proportion of the number of individuals belonging to each occupation category. Frequency tables Location Occupation Location category Frequency Occupation category Frequency Location group A Occupation group 1 Occupation group 2 Occupation group 3 Occupation group 4 Occupation group 5 Occupation group 6 4 Location group B 7 26 Location group C 12 15 Location group D 25 12 Location group E 10 5 Location group F 6 3
First, the researcher categorised the data into six location groups and six occupation groups, and calculated the frequencies given below: Using Excel and the data in the frequency tables above, answer the following questions. a) Which graphical technique or chart should be used if the researcher is interested in comparing the number of individuals in each location group? Explain the reason for the selection of this graphical chart. Construct and display the chart, also briefly describe what you can observe about the number of individuals belonging to each location category. b) Which graphical technique or chart should be used if the researcher is interested in comparing the proportion of the number of individuals in each occupation group? Explain the reason for the selection of this graphical chart. Construct and display the chart, also briefly describe what you can observe about the proportion of the number of individuals belonging to each occupation category. Frequency tables Location Occupation Location category Frequency Occupation category Frequency Location group A Occupation group 1 Occupation group 2 Occupation group 3 Occupation group 4 Occupation group 5 Occupation group 6 4 Location group B 7 26 Location group C 12 15 Location group D 25 12 Location group E 10 5 Location group F 6 3
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 4BGP
Related questions
Question
Expert Solution
Step 1
Given data is:
Step 2
a) The graphical chart that should be use to compare the number of individuals in each location group is bar graph.
The reason is that bar graph makes its easy to compare the number of individuals (frequency).
The bar graph is given as:
Location Category | Frequency |
Location group A | 5 |
Location group B | 7 |
Location group C | 12 |
Location group D | 25 |
Location group E | 10 |
Location group F | 6 |
From bar graph it can be observed that, the Location Group D have maximum frequency.
Step by step
Solved in 3 steps with 3 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill