Question

First, the researcher categorised the data into six location groups and six occupation groups, and calculated the frequencies given below. Frequency tables Location Occupation Location category Frequency Occupation category Frequency Location group A 5 Occupation group 1 4 Location group B 7 Occupation group 2 26 Location group C 12 Occupation group 3 15 Location group D 25 Occupation group 4 12 Location group E 10 Occupation group 5 5 Location group F 6 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 Page 4 of 6 HI6007 STATISTICS FOR BUSINESS DECISIONS 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.

Answer 1

(a)

Thus, a bar chart is useful for comparing the number of individuals in each location group.

This chart clearly displays the number of individuals.

(b)

Thus, a pie chart is useful for comparing the number of individuals in each occupation group.

This chart clearly displays the occupation of individuals.