Oecd database exercise , Basic Statistics

Assignment Help:

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).


Related Discussions:- Oecd database exercise

Wave optics, how does wave act as in interfrence?

how does wave act as in interfrence?

Estimate the expected monetary value, 3DP, a Luxembourg-based company plans...

3DP, a Luxembourg-based company plans to develop and sell highly specialized 3D printers. The cost of product development is estimated at EUR 50,000.-, irrespective of whether or n

Determine the local luminance, 1. Consider a room 3 m x 3m x 3m with one fa...

1. Consider a room 3 m x 3m x 3m with one façade made of glazing with diffuse transmittance 0.6 and reflectance 0.2. The interior surfaces have a reflectance of 0.5. Consider incid

Accounting standards in europe, Accounting Standards in  Europe  countr...

Accounting Standards in  Europe  countries:   Europe has seen the maximum progress in having developed its accounting standards. In 2000, a document was published by the Europe

How to stretch or shrink a graph, Q. How to stretch or shrink a graph? ...

Q. How to stretch or shrink a graph? Ans. If you have the equation of a graph, you can stretch or shrink the graph, in either the x or the y direction, just by multiplying

Frequcency, how can we construct a bivariate frequency distribution

how can we construct a bivariate frequency distribution

What is b2b, Definition of B2B? This is known as the abbreviation of Busin...

Definition of B2B? This is known as the abbreviation of Business to Business. Abbreviation Of Business To Business

FIFO, how to figure out cost of good available for sale, cost of sales, end...

how to figure out cost of good available for sale, cost of sales, ending inventory

Amplification, Amplification is the process by which the magnitudes of the ...

Amplification is the process by which the magnitudes of the variable quantity is increasing, especially the magnitude of voltage, current or power, without changing any other quant

Determine the cutoff score to indicate a score, What would be the cutoff sc...

What would be the cutoff score to indicate a score that is in the top 15% of the scores on a test with a mean of 100 and a standard deviation of 15?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd