I need the solution as per the instructions
DEM 127: ELEMENTS OF DEMOGRAPHY BUS828: POPULATION AND WORKFORCE PLANNING: ASSIGNMENT PART A To be submitted in via the Turnitin facility on iLearn on or before 10.55am on 30th August 2019. The assignment will be administered in three parts (A, B and C). The maximum credit for the assignment is 35% of the maximum total credit for the unit. The maximum credit for Part A is 10% of the maximum total credit for the unit. You must do all parts of the assignment independently (i.e. without extensive help from other people). Penalties for cheating or plagiarism or excessive collusion will be severe. Late submission will be penalised according to the schedule of penalties described in the unit guide on iLearn. No extension requests will be granted, unless an application for special consideration with documented evidence of unavoidable disruption is submitted and approved. Please do not include the instructions or the questions in your submitted answer. The numbers of females in the population (in thousands) by age last birthday and female labour force participation rates by age last birthday for India and New Zealand in 2015 are presented in the following Table A: Table A Age Last Birthday (x) Number of Females Aged x in Population (000s) Female Labour Force Participation Rate (%) India New Zealand India New Zealand 0-4 56,618 150 0.0 0.0 5-9 60,179 153 0.2 0.0 10-14 59,761 145 0.4 0.0 15-19 58,206 154 4.9 46.0 20-24 55,949 163 17.0 71.8 25-29 53,820 158 23.8 73.5 30-34 49,976 149 27.0 76.2 35-39 44,166 143 30.5 78.3 40-44 39,372 164 30.8 82.5 45-49 34,661 164 30.2 82.4 50-54 30,469 165 28.0 82.4 55-59 25,936 148 23.0 79.8 60-64 21,335 128 14.0 66.8 65+ 38,482 362 6.3 16.6 [14] a) Calculate the (column) percentage distributions of the female populations of India in 2015 and New Zealand in 2015, giving each percentage to one place of decimals. [12] b) Calculate the mean age of the female population of India in 2015 and the mean age of the female population of New Zealand in 2015, assuming for India the mean age of females aged 65+ is 73.0 years and for New Zealand the mean age of females aged 65+ is 75.0 years, and giving both your answers to one place of decimals. [12] c) Calculate the median age of the female population of India in 2015 and the median age of the female population of New Zealand in 2015, giving both your answers to one place of decimals. [20] d) Describe, compare, and suggest explanations for the differing features of the percentage distributions of the female populations by age for India in 2015 and New Zealand in 2015 (your answers to part a). [20] e) Describe, compare, and suggest explanations for the differing features the variation in female labour force participation rates by age for India in 2015 and New Zealand in 2015 (given in Table A). [4] f) Calculate the total number of females in the labour force for India in 2015 and the total number of females in the labour force for New Zealand in 2015, giving both your answers to the nearest whole number. [6] g) Calculate the percentage distribution of the total number of females in the labour force by age for India in 2015 and the percentage distribution of the total number of females in the labour force by age for New Zealand in 2015, giving each percentage to one place of decimals. [12] h) Compare the percentage distributions of the total numbers of females in the labour force by age for India in 2015 and New Zealand in 2015 (i.e. the answers for part f)), and explain how the differences are related to the female population and to labour force participation rates (provided in Table A). For parts d) and h) please note the numbers of females aged 65+ are not strictly comparable to the numbers in other age ranges in the table, due to the much wider range of years spanned by the 65+ age range. Assessment Criteria Marks for each question are given in square brackets. The total mark will be scaled to reflect the 10% of the unit grade weighting attached to this part of the assignment. Parts a), b), c), f) and g). For the parts of the answer which involve calculations, the answers should include key steps in the working (i.e. the formulae used and the key data inputs into the formulae). The award of full marks requires both correct answers and working out to be clearly presented. Penalties will apply if the instruction on decimal places is not followed. For each of part d), part e) and part h) the maximum length of answer is 600 words. Penalties (1 mark 50 words over limit (or part thereof) per section) will apply for exceeding the specified word limit. You are encouraged to incorporate relevant statistics (including, but not restricted to, those sought as answers to parts a)-c), f) and g) into your answers for d), e) and h) if doing so would help your reader (details of the calculations do not need to be presented). For each of these parts you may also provide up to two graphs or tables, if doing so would help your reader (the material in the graphs and tables does not count to the word limit). For parts d) or e) you are encouraged to use literature or internet sources to inform your answers. However if you do so please ensure you provide a full list of the references at the end of the relevant part of your assignment (in alphabetical order) and acknowledge your sources at appropriate places in the text of your answers using the (author, date) format. If you use such sources please ensure you express the information or ideas used in your own words (do NOT copy word-for-word). The reference list does not count towards the word limit. There is no need to reference lecture materials. For part h) it is expected your explanations of the differences in the female labour forces will refer both to the patterns of female labour force participation rates and to the distributions of the female populations. However, there is no need to duplicate explanation of the underlying causes of population difference or labour force participation rate difference (since these are already tested in parts d) and e)). Since your answer will be based purely on the data provided in the question and on calculations you perform, references are not expected for part h). Parts d) and e) the marking will be based 85% on Content, 5% on Use of Research and Referencing, and 10% on Quality of Written Expression. Marking for Part h) will be based 90% on Content and 10% on the Quality of Written Expression. Content (85% of maximum) Level F (Fail) Level 1 (Unsatisfactory) Level 2 (Below Expectation) Level 3 (Meets Expectation) Level 4 (Exceeds Expectation) Mark = 0-20% Mark = 20-45% Mark = 45- 55% Mark = 55- 70% Mark = 70- 85% The answer is missing or severely lacking in information and ideas or irrelevant or suffers from extensive expression which prevents understanding of meaning or plagiarism or academic misconduct is evident. Presents a small amount of acceptable content. Acceptable content includes accurate description, accurate comparison and plausible explanation using theory (e.g. how fertility, mortality and migration and explain age structure) which is relevant to the question and expressed clearly enough to be understood. Presents a moderate amount of acceptable content. The award of a mark in this range is contingent on the answer including some comparison between the countries and/or plausible explanations of patterns rather than being entirely descriptive. Inaccurate or irrelevant content will have a minor detrimental effect on the mark awarded. Includes a significant amount of acceptable content. The award of a mark in this range is contingent on the answer includes a significant amount of comparison and significant application of theory presented in lectures to explain patterns. Inaccurate or irrelevant content will be detrimental to the mark awarded. Extensive amount of acceptable and relevant content. For the award of a mark in this range highly detailed and integrated description and comparison, with appropriate and well developed application of theoretical explanation is expected. Well- developed explanation goes beyond the routine application of theory from the lectures. The development of explanation may be supported by deeper statistical analysis and/or by reliable research using literature or data from sources other than the assignment question. No irrelevant content. Research and Referencing (5%) Mark = 0% Mark = 1% Mark = 2% Mark = 3-4% Mark = 5% Answer missing or extremely brief or suffers from extensive expression which prevents understanding of meaning or plagiarism or academic misconduct is evident. No citation/use of sources/references is evident. Some citation/use of sources/ references is evident, but an accepted citation method (i.e. Harvard or APA) is not utilized. Some source material is used, and an accepted citation method (i.e. Harvard or APA) is utilized. An extensive range of source material is cited, and an accepted citation method (i.e. Harvard or APA) is utilized. Written Expression (10%) Mark = 0% Mark = 1-3% Mark = 4-5% Mark = 6-8% Mark = 9-10% The answer is missing or extremely brief or