Part I: Describe your data and graphical analysis (Total 40 marks)
(a) Define your variables, present a table with the definitions for the selected country (5 marks). Do not copy and paste the same information from the methodological report or website. You can use parts of the definitions. Check the type of responses of all questions. What type of variables contains the survey? What about other variables?
(b) Sketch a histogram for the age of respondents. Provide a short explanation. (10 marks)
(c) Create a contingency table for the gender profile. Sketch a pie chart with the percentages and provide a short explanation about the distribution of respondents in your country or region. (10 marks)
(d) Create new age intervals for the respondents:
<18 18-24 25-34 35-44 45-54 55-64 65+
Create a contingency table conditional on: i) age and gender; ii) gender and education. Sketch a pie/bar chart with the percentages and provide a short explanation about the distribution of respondents in your country or region. (15 marks)
Part II: Numerical Analysis I (Total 30 marks)
a) Calculate the descriptive statistics for all variables using the add-in data analysis in Excel. Summarise your results in one table and explain each measure. (15 marks)
b) Manually calculate the mean and standard deviation of resilience index conditional on the gender of respondents. Provide a short explanation. (15 marks)
Part III: Numerical Analysis II (Total 30 marks)
a) Calculate the correlation coefficient between resilience and age. (5 marks)
b) Calculate the resilience correlation conditional on: i) education and gender; ii) income quintiles and gender. Provide a short explanation of your results for different levels of education and income. (15) marks)
c) Based on your descriptive analysis from Parts I, II and III, do you think resilience differs by gender, educational attainment levels or income? Summarise your findings and provide a brief story for the respective country or region (10 marks)
Remark: For Part I give all charts a title, add the X-axis and Y-axis labels when convenient. Include the data sources in a legend. If key information is missing, no credit will be assigned. This is an individual work, similar responses irrespective of the country or region assigned will have no credit.
Disclaimer: The information provided in this assignment brief (version number: 1) is correct at time of publication. In the unlikely event that any changes are deemed necessary, they will be communicated clearly via e-mail and/or via Brightspace and a new version of this assignment brief will be circulated.
