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. 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. 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. Hours Per Week Yearly Income ('000's) 18 43.8 13 44.5 18 44.8 25.5 46.0 11.5 41.2 18 43.3 16 43.6 27 46.2 27.5 46.8 30.5 48.2 24.5 49.3 32.5 53.8 25 53.9 23.5 54.2 30.5 50.5 27.5 51.2 28 51.5 26 52.6 25.5 52.8 26.5 52.9 33 49.5 15 49.8 27.5 50.3 36 54.3 27 55.1 34.5 55.3 39 61.7 37 62.3 31.5 63.4 37 63.7 24.5 55.5 28 55.6 19 55.7 38.5 58.2 37.5 58.3 18.5 58.4 32 59.2 35 59.3 36 59.4 39 60.5 24.5 56.7 26 57.8 38 63.8 44.5 64.2 34.5 55.8 34.5 56.2 40 64.3 41.5 64.5 34.5 64.7 42.3 66.1 34.5 72.3 28 73.2 38 74.2 31.5 68.5 36 69.7 37.5 71.2 22 66.3 33.5 66.5 37 66.7 43.5 74.8 20 62.0 35 57.3 24 55.3 20 56.1 41 61.5
Sociologists argued that women on average earn less than men as women often choose to work less hours. They further suggest that the choice of hours worked may be driven by various factors such as age, childcare needs, occupation choice and flexibility. To investigate the relation between hours worked and income earned by Australian men and women, a researcher plans to survey a sample of individuals across the country.
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.
- 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.
- 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.
Hours Per Week | Yearly Income ('000's) |
18 | 43.8 |
13 | 44.5 |
18 | 44.8 |
25.5 | 46.0 |
11.5 | 41.2 |
18 | 43.3 |
16 | 43.6 |
27 | 46.2 |
27.5 | 46.8 |
30.5 | 48.2 |
24.5 | 49.3 |
32.5 | 53.8 |
25 | 53.9 |
23.5 | 54.2 |
30.5 | 50.5 |
27.5 | 51.2 |
28 | 51.5 |
26 | 52.6 |
25.5 | 52.8 |
26.5 | 52.9 |
33 | 49.5 |
15 | 49.8 |
27.5 | 50.3 |
36 | 54.3 |
27 | 55.1 |
34.5 | 55.3 |
39 | 61.7 |
37 | 62.3 |
31.5 | 63.4 |
37 | 63.7 |
24.5 | 55.5 |
28 | 55.6 |
19 | 55.7 |
38.5 | 58.2 |
37.5 | 58.3 |
18.5 | 58.4 |
32 | 59.2 |
35 | 59.3 |
36 | 59.4 |
39 | 60.5 |
24.5 | 56.7 |
26 | 57.8 |
38 | 63.8 |
44.5 | 64.2 |
34.5 | 55.8 |
34.5 | 56.2 |
40 | 64.3 |
41.5 | 64.5 |
34.5 | 64.7 |
42.3 | 66.1 |
34.5 | 72.3 |
28 | 73.2 |
38 | 74.2 |
31.5 | 68.5 |
36 | 69.7 |
37.5 | 71.2 |
22 | 66.3 |
33.5 | 66.5 |
37 | 66.7 |
43.5 | 74.8 |
20 | 62.0 |
35 | 57.3 |
24 | 55.3 |
20 | 56.1 |
41 | 61.5 |
Step by step
Solved in 3 steps with 2 images