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

Definition of capitalization, Definition of capitalization is termed or sho...

Definition of capitalization is termed or shown as a process of recording & classifying the expenditure on assets in a balance sheet. Can you explain me this term more.

Difference in the loss in man-hours - accidents in firms, An occupational h...

An occupational health inspector was interested in determining whether there is a difference in the loss in man-hours due to accidents  by introducing a new safety programme.  The

What is account code, The three-character alpha/numeric code allocated by t...

The three-character alpha/numeric code allocated by the Workplace of Economical Control (OFM) to recognize each account.

Compute the value for the test statistic-spss, A number of years ago the Am...

A number of years ago the American Academy of Pediatrics recommended that tetracycline drugs not be used for children under the age of 8. Prior to this recommendation, a two-year s

Accounting and finance for managers, From the following information related...

From the following information related to XYZ Ltd.; you are required to find out (a) contribution (b) Break-even point in units (c) Margin of safety, (d) Profit Total Fixed Costs

Find confidence interval, A sample of 40 golfers showed that their average ...

A sample of 40 golfers showed that their average on a particular course was 94 with a standard deviation of 6. a. Find the 95% confidence interval of the mean score for all golf

Adjustments, office supplies on hand at year-end amounted to $100

office supplies on hand at year-end amounted to $100

Quantitative Technic management, How has quantitative analysis changed the ...

How has quantitative analysis changed the current scenario in the management world today?

Calculate the predicted mean temperature, The following are actual data sho...

The following are actual data showing the latitude of a sample of major cities in the northern hemisphere and their mean high annual temperature. latitude(X)    mean high temp(Y

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