EXCEL: https://1drv.ms/u/s!AuK98V5u7-1KnFU3YRiVt7Wzu8Tr?e=0gm6c3

For this question, consider the "Data.csv" file which provides information on the log of total deaths per million for Covid-19 cases and the human development index for a random sample of 90 countries. All your workings for the corresponding parts should be shown clearly with the use of Microsoft Equation Editor for formulae editing.

(a) Draw an appropriate diagram to represent the information given in the data and interpret the same. (Use Excel for the diagram) [3]

(b) Compute the Pearson's product moment correlation coefficient and interpret it. [4]

(c) Find the least squares regression equation and interpret it. [5]

(d) Estimate the following:

(i) log of total deaths per million for COVID-19 cases for the case of Mauritius where the human development index for Mauritius is 0.79. [1]

(ii) log of total deaths per million for COVID-19 cases for a country where the human development index is 0.3 [1]

(e) Comment on the reliability of your estimates for part (d). [3]

(f) Justify the application of the statistical methods above. [2]

(g) State any limitation(s) or point of caution(s) with regards to the analyses you carried out above. [3]