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		Occupatiocategory	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 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.