In table A while calculating the mean take like for example for the age group 15-19 take the upper limit as 20 and lower as 15 and the midpoint will be 17.5 and same for every age
Table C presents the numbers of midwives by number of hours worked per week for Greater Sydney "on 306/2019 and for the Rest of New South Wales on 30162019. Table C Number of Midwives Hours Worked Per Week Greater Sydney Rest of New South Wales 0 196 145 0 39 40+ 1.492 Using the data in Table Co (D) Assuming that in Greater Sydney the standard full-time hours worked per week by midwives in 40.0, calculate the full-time equivalent (FTE) workforce size for midwives in Greater Sydney on 30/6/2019, giving your answer to the nearest whole person. (m) Assuming that in the Rest of New South Wales the standard full-time hours worked per week by midwives in 40.0, calculate the full-time equivalent (FTE) workforce size for midwives in the Rest of New South Wales on 10/6/2019, giving your answer to the nearest whole person. (n) Discuss the considerations and suggest potential policies for formulating a workforce plan to align the supply of midwives in New South Wales with the need for midwives New South Wales on 3016/2024.Table A shows the headcount numbers and percentage distributions by age of midwives in Greater Sydney and in the Rest of New South Wales by age on 30/6/2019 Table A Greater Sydney Rest of NSW Age Headcount % of Total for Headcount % of Total for Number Greater Sydney Number Rest of NSW 15-19 0 0 0 0 20-24 122 3.95 57 25-29 2.88 369 11.94 195 9.85 30-34 366 1.84 232 35-39 284 11.72 2.19 197 9.95 40-44 329 10.65 45-49 242 11.78 12.23 364 232 11.72 50-54 422 13.66 55-59 251 12.68 449 14.53 332 16.78 60-64 280 9.06 185 65-69 9.35 83 2.69 48 2.43 70-74 22 0.71 4 0.2 75+ 0 0 4 0.2 Using the data in Table A: (a) Calculate the total headcount size of the workforce of midwives for Greater Sydney and the total headcount size of the workforce of midwives for the Rest of New South Wales on 30/6/2019. (b) Assuming the mean age of midwives aged 75+ is 78.0, calculate the mean age of midwives in Greater Sydney on 30/6/2019 and the mean age for midwives in the Rest of New South Wales on 30/6/2019, giving each answer to one decimal place. (c) Plot a graph showing the (column) percentage distributions by age for midwives in Greater Sydney and midwives in the Rest of New South Wales on 30/6/2019 (d) Describe, compare and suggest explanations for the features of the percentage age distributions of midwives in Greater Sydney and in the Rest of New South Wales on 30/6/2019 In 2019 the total number of births in the Greater Sydney was 74,000 and the total number of births in the Rest of New South Wales was 32,100. According to ABS population projections, in 2024 the projected total number of births in Greater Sydney will be 83,300 and the projected total number of births in the Rest of New South Wales will be 33,200. (e) Assuming that for Greater Sydney in 2024 the ratio of the headcount number of midwives to the annual number of births is the same as in 2019, project the headcount number of midwives which will be needed in 2024 in Greater Sydney, giving your answer to the nearest whole person. (f) Assuming that for the Rest of New South Wales in 2024 the ratio of the headcount number of midwives to the annual number of births is the same as in 2019, project the headcount number of midwives which will be needed on 30/6/2024 in the Rest of New South Wales, giving your answer to the nearest whole person.Table B shows the five years exit ratios for midwives by age on 30/6/2019 for Greater Sydney and for the Rest of New South Wales and the annual number numbers of new entrants to the midwife workforce by age at time of entry which it is assumed will apply for 30/6/2024. Greater Sydney and for the Rest of New South Wales over the period from 30/6/2019 to Table B Five Years Exit Ratio Annual Number of New Entrants Age Last by Age at Entry Birthday Greater Sydney Rest of New South Wales Greater Sydney Rest of New South Wales 15-19 NA NA 0 0 20-24 0.25 0.25 60 25 25-29 0.2 0.2 60 30 30-34 0.2 0.25 20 20 35-39 0.2 0.2 15 10 40-44 0.15 0.15 18 12 45-49 0.15 0.15 10 5 50-54 0.2 0.2 10 5 55-59 0.25 0.2 10 8 60-64 0.75 0.7 2 1 65-69 0.95 0.9 70-74 0.95 0 0 75+ 0.95 0 (g) Project the numbers of midwives by age and in total for Greater Sydney on 30/6/2024, assuming between 30/6/2019 and 30/6/2024 the exit ratios by age and sex and the annual numbers of new entrants to the midwives workforce by age and sex are as given for Greater Sydney in Table B, and the exit ratio for new entrants to the midwife workforce by the end of the five years is 0.20 for all age groups, and presenting each of your answers to the nearest whole number. (h) Project the numbers of midwives by age and in total for the Rest of New South Wales on 30/6/2024, assuming between 30/6/2019 and 30/6/2024 the exit ratios by age and sex and the annual numbers of new entrants to the midwives workforce by age and sex are as given the Rest of New South Wales in Table B, and the exit ratio for new entrants to the midwife workforce by the end of the five years is 0.20 for all age groups, and presenting each of your answers to the nearest whole number. (i) Describe, compare and give reasons for the projected changes between 30/6/2019 and 30/6/2024 in the midwife by age and in total for Greater Sydney and the projected changes between 30/6/2019 and 30/6/2024 in the midwife by age and in total for the Rest of New South Wales, as shown by your answers to parts (g) and (h) and the data in Table A. (i) Calculate the average annual number of new entrants to the midwife workforce of Greater Sydney between 30/6/2019 and 30/6/2024 which would be needed to ensure the total size of the workforce matches the number needed on 30/6/2024 (using your answers for parts (e) and (g)), giving your answer to the nearest whole person. [3] (k) Calculate the average annual number of new entrants to the midwife workforce of the Rest of New South Wales between 30/6/2019 and 30/6/2024 which would be needed to ensure the total size of the workforce matches the number needed on 30/6/2024 (using your answers for parts (f) and (h)), giving your answer to the nearest whole person