The researcher categorised the data into six location groups and six occupation groups, and calculated the frequencies given below. 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 Occupation category Frequency Occupation group 1 4 Occupation group 2 26 Occupation group 3 15 Occupation group 4 12 Occupation group 5 5 Occupation group 6 3 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.
The researcher categorised the data into six location groups and six occupation groups, and calculated the frequencies given below.
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
Occupation category Frequency
Occupation group 1 4 Occupation group 2 26 Occupation group 3 15 Occupation group 4 12 Occupation group 5 5 Occupation group 6 3
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.
Step by step
Solved in 3 steps with 2 images
