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

Define the critical value and degrees of freedom, (3) You  generate  a  nul...

(3) You  generate  a  null  hypothesis  that  = 32.   You  draw  a  random  sample  of  size n = 28 from the population. You observe the following sample statistics: Y = 35:5 and a

Give the appropriate choice of the null hypothesis, 1 . Below are the point...

1 . Below are the points scored by the winning team in Week 10 of NFL professional football games this Fall, 2011. 24 17 44 13 21 24 30 20 37 26 17 22 27 37 37 45 a) Use thes

Treatment of cst and vat, Treatment of CST and VAT in Sales Book A suppl...

Treatment of CST and VAT in Sales Book A supplier who expenses the CST for inter declares purchase by him, is responsible to first deposit the gathered CST from bought to Got Co

Sampling, What is the sampling and it importance in daily routain life. Exp...

What is the sampling and it importance in daily routain life. Explain stratify sampling

Managerial accounting homework, Your friend Jose is trying to decide whethe...

Your friend Jose is trying to decide whether to buy or lease his next vehicle. He has gathered information about each option but is not sure how to compare the alternatives. Purcha

How many trucks get washed between smokes, A. Northbound trucks leaving Hel...

A. Northbound trucks leaving Helmand Province with USMC communications equipment must go through a washing process before getting underway, so as to prevent Tajikistan from gett

Marginal costing and break-even analysis, Marginal costing and Break-even a...

Marginal costing and Break-even analysis According to C.I.M.A. Manchester, "Marginal Price means the quantity at any given variety of result by which get worse scenario costs ar

Worksheet assignment help, Worksheet 5 Q1: For this question, use the p...

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

Explain correlation coefficient, Q. Explain Correlation Coefficient? A...

Q. Explain Correlation Coefficient? Ans. The strength of a linear correlation is determined by how precisely the y variable shifts as the x variable increases. The two pi

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