Question 2 With reference to the dataset <Development indicators_country_GBA.xlsx> given, answer the below questions: (a) Examine the data and identify the data type (nominal, ordinal, interval and ratio) for each variable. Calculate the number of observations and provide useful summary statistics (ie., mean, median, mode) for each variable. Tabulate your answer as per the format given below (use Microsoft Excel): Variable Data type Number observations of Summary statistics XX XX XX XX XX XX Mean Median Mode Mean Median Mode (8 marks) (b) Identify the data quality issues and use an appropriate treatment method for each issue identified. Prepare the data for visualisation using Microsoft Excel. Provide a screenshot highlighting each data quality issue and a screenshot of the treated data after the corresponding data treatment. (Maximum word count: 250 words) (16 marks)

Fig: 1