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

Explain correlation coefficients, 1. What type of correlation coefficient w...

1. What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A.

Sampling Error, Use the concepts of sampling error and z scores to explain ...

Use the concepts of sampling error and z scores to explain the concept of distribution of sample means.

Evaluate the strategic value of the proposed organisation, 1) Working in yo...

1) Working in your groups analyse the organisation of information that the Facebook social networking site potentially uses. 2) Suggest the organisation of information and data

Semi average trend values, Year : 2008 2009 2010 2011 2012 2013 sale : 111 ...

Year : 2008 2009 2010 2011 2012 2013 sale : 111 120 114 123 117 126

Wae optic, can we polarize sunlight by the help of Polaroid disc?

can we polarize sunlight by the help of Polaroid disc?

Statistics, The amount of time it takes the IRS to send a refund to taxpaye...

The amount of time it takes the IRS to send a refund to taxpayers is normally distributed with a mean of 12 weeks and a standard deviation of 3 weeks. What proportion of the taxpay

Distribution of the sample mean, 1. Suppose that a population has mean, µ, ...

1. Suppose that a population has mean, µ, and standard deviation, σ. What does the central limit theorem tell us about the distribution of the sample mean?

Frequency distribution, hey goo day, i wanna know the definition of frequen...

hey goo day, i wanna know the definition of frequency distribution and how to conduct it like in examples?

Analysis and interpretation business report, Case Study. Using the data, pr...

Case Study. Using the data, prepare a report that analyses the profitability, liquidity and solvency of a Accessorize Pty Ltd and help the owner to decided whether to purchase the

Financial instruments, how are financial instruments recognised in financia...

how are financial instruments recognised in financial reports in the past and present?

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