Question

A researcher took a random sample of 64 individuals across the country to investigate the relation between hours worked per week and income earned per year. each individual, the hours worked per week and yearly income (measured in ‘000’s dollars) were recorded. The data are stored in HOURSWORKED64 worksheet. In addition to the variables of hours worked and income earned, the individuals were also asked to respond to survey questions concerning other variables (e.g. location, age, etc).

categorised the data into six location groups and six age groups, and calculated frequencies as presented in the tables below.

                                                       Frequency tables

Location			Age
Location category	Frequency		Age category	Frequency
Location group A	3		Age group 1	6
Location group B	7		Age group 2	26
Location group C	14		Age group 3	13
Location group D	25		Age group 4	11
Location group E	9		Age group 5	6
Location group F	6		Age group 6	2

Using Excel and the data in the frequency tables above, answer t questions.

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

                                                                                                                                                                                                                                                                                                                                                         

2. Which graphical technique or chart should be used if the researcher is interested in comparing the proportion of the number of individuals in each age 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 age category.

Answer 1

1. hich 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.            

The chart will be a bar chart.

The chart is as follows:

  

The data is normally distributed.

1. Which graphical technique or chart should be used if the researcher is interested in comparing the proportion of the number of individuals in each age 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 age category.

The chart will be a bar chart.

The chart is as follows:

The data is skewed right.