You have gained a short-term internship working as a junior data analyst in your city council’s employment division. Your supervisor has commissioned you a task to assist her in examining the relationship between the number of hours worked per week and income earned per year amongst the profession of casual bookkeepers. A random sample of 200 bookkeepers from different age groups who work in small to medium-sized accounting firms across different suburbs in the city were selected for collecting the data on the two associated variables. These data are stored in the .xls file attached.
Your supervisor has categorised the data into six age group categories and four suburb categories. She further calculated the frequencies for each category and presented the information in the tables below.
Your supervisor has categorized the data into six age group categories and four suburb categories. She further calculated the frequencies for each category and presented the information in the tables below.
Age
Age category
fraimnty
Age group 1
37
Age group 2
60
Age group 3
47
Age group 4
IS
Age group 5
21
Age group h
15
Use the data pnn idl’d in the tables above io answer the following questions.
(a.) Your supervisor is interested in comparing the number of bookkeepers in each ayt category. Which chart would you recommend her to use? Explain the reason in selecting the graphical chart. L nurfc
Use Excel to construci the chart you selected for part (a). Display ihe chart. Then briefly describe what you have observed about the number of bookkeepers in each age category. ] runt
(e) Your supervisor is interested in comparing the |>ru|M>rtion of the number of bookkeepers in each suburb category. Which ehart would you recommend her to use? Explain the reason in selecting the graphical chan. L mart
(dl Use Excel to construct the chan you selected for part fc). Display the chart. Then briefly describe what you have observed about the proportion of the number of bookkeepers in each suburb category. ] mart
Second, your supervisor would like to use an appropriate graphical descriptive technique in presenting summaries of the data on each of the two variables: hours narked /ter meek and income earned /ter year. Refer to the .xls tile attached.
Your supervisor believes that using 9 class intervals would be besi in construciing
a hisiogjam for each of the two variables. Explain how your supervisor concluded 9 as the appropriate number of class intervals. :i mad;
Your supervisor suggests using class intervals listed below: