For the assignment, you must hand in your Excel spreadsheet. In Excel, after finishing your analysis use the
save as command from Excel to save your spreadsheet as HMWK1.xlsx.
Part 1 of the assigment: (on excel)
Use Excel, Standard Mortality Tables.xlsx, to calculate the following for 2015.
• The mean age at death for Canadian males;
• The variance of age at death for Canadian males;
• The standard deviation of age at death for Canadian males;
• The most likely age at which a Canadian male will die (the mode); and
• The median age at which a Canadian male will die.
Do this for males at birth (that is, after a live birth).
Include your answers to the application questions in the material you email me with your answers to the above
text problems. Also attach your Excel file, as explained above.
Part 2:
Also do this, i have attached the document with all the question, And the answers, this is part of the
assignment but this not done on excel. Also, i just want u to have a look and write the answers and steps in ur
way but i have provided u with the answers already. Thanks
Section 4.3
- Question 4.19, parts c, d, and e.
Section 4.4 (For this, you are encouraged to use Tables 2 and 3, from your text.) - Question 4.32
- Question 4.47
Section 4.7 - Question 4.73
- Question 4.77