Your BI consulting company has been approached by the Agency who have asked you to conduct an analysis of the death rates of residents and how this has changed in recent times. In order to facilitate your analysis, you have been provided with a data set from the Singapore Department of Statistics that shows resident death (mortality) rates by a number of different variables.
You have been asked to conduct several specific analyses:
1. How has the infant mortality rate in Singapore changed since 1999, and how does it compare with that of five of Singapore’s near neighbours?
2. How has the mortality rate of residents under the age of 5 in Singapore changed since 1999, and how does it compare with that of five other countries (other than those you compared with in Q1)?
3. What were the most common causes of death in Singapore for residents in the 40-60 year are bracket in 2016?
You have also been asked to provide at least two other insights relevant to the mortality of Singapore residents you develop from your analysis.