Oecd database exercise , Basic Statistics

For this second assignment you will have to use the OECD database to investigate possible changes in the policy preferences of Western welfare states. You have to develop (i) an indicator to measure how much a country spends on unemployment benefits per registered unemployed; (ii) an indicator that measures how much it spends on old age pensions per person of 65 or more. Subsequently you have to relate both indicators in a scatter plot and a line of best fit. As you will learn throughout this block, it is important that the countries in your plot remain identifiable.

(1) As a first step you have to retrieve data from the statistics portal of the OECD to develop your two indicators: expenditure data and data on the number of potential recipients (i.e. the number of unemployed and the number of people aged 65 or more). You have to choose two points in time (and in order to be able to observe a meaningful trend, those points should not be too close to one another. You must be able to obtain data for at least 12 OECD countries, amongst which the Netherlands (you can choose the other countries, but you will see that you will be constrained by the availability of data). Part of the exercise is that you learn to find your way in the maze of links on the website.

(2) Next you must figure out a way to represent graphically the relationship between your indicators so that you can capture both different expenditure patterns between countries, as well as changes within the same country over time. Hint: you can best make three scatter plots plotting (i) your two indicators against one another for year x; (ii) your two indicators for year y; and (iii) changes in your two indicators between year x and year y. For each plot you should add a trendline. You can best draw scatter plots using Excel or if you prefer SPSS. Make sure that the points in your plot are clearly labelled (in case you do not succeed to add labels using the software, do it manually).

Posted Date: 3/20/2013 5:12:00 AM | Location : United States







Related Discussions:- Oecd database exercise , Assignment Help, Ask Question on Oecd database exercise , Get Answer, Expert's Help, Oecd database exercise Discussions

Write discussion on Oecd database exercise
Your posts are moderated
Related Questions
Under this methods the enumerators are appointed and given training. They are provided with schedules containing relevant questions. These enumerators go to respondents with the

The national demand and price for a certain type of energy-efficient exhaust fan are related by p=441-3/7q, where p is the price and q the demand. The price and supply of the exhau

report on comparing information system in organisations

Worksheet 5 Q1: For this question, use the petrol consumption data from Worksheet 4, (included the data for worksheet 4)   8.9   10.4    6.3   8.9   10.8   10.8   8.2

do you give the answers with the way you figured the problem out?..

Introduce the aim of this section of the report including an explanation of the data to be analysed. • Use Excel to produce a box and whisker plot for the two sets of booking data

Ritu acquired a mine on lease from Richa for a period of 8 years at a royalty of ` 60 per tonne of coal produced subject to minimum rent of ` 1,00,000 for the first year, increasin

comprehensive problem 1 chapter4

how can i get a free software to run a kolmogorov test?

What according to you are the biggest challenges of moving to IFRS? Manager 1: Well, there are going to be a lot of changes. IFRS is known to be more principle based than the