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

Total stockholders equity, To determine the amount at which inventory shoul...

To determine the amount at which inventory should be reported on the December 31 Year 1 balance sheet, Monroe Company compiles the following information for its inventory of Produc

Cost accounting question, LO.1 (Activity analysis) The Raleigh plant manage...

LO.1 (Activity analysis) The Raleigh plant manager of Allentown Corp. has noticed the plant frequently changes the schedule on its production line. He has gathered the following in

Accounting for inflation, Accounting for inflation Inflation sales is a ter...

Accounting for inflation Inflation sales is a term reporting a range of sales systems designed to correct problems that comes from traditional cost sales in the use of inflation. I

How to calculate midrange in statistics?, Midrange The midrange is the ...

Midrange The midrange is the measure of the center that is the value midway between the highest and the lowest values in the original data set. It is found by adding the highes

Define Accrued liabilities , Obligations showing the responsibility to pay ...

Obligations showing the responsibility to pay for solutions or products that have been suffered or obtained but not compensated for by the end of the sales interval.

Find the probability that a cup of drink chosen at random, Question: (i...

Question: (i) A soft drink machine is regulated so that it fills an average of 300 cL per cup. If the amount of drink in each cup is normally distributed with standard deviati

Absorption costing, how do i prepare an income statement for absorption cos...

how do i prepare an income statement for absorption costing?

Frequency polygon, Differentiate between Historigrams and Histogram

Differentiate between Historigrams and Histogram

Feature of accounting transaction, Classification feature of Accounting Tra...

Classification feature of Accounting Transaction. Under the classification accountant posts the entries into their respective ledgers in the Accounts Books. Every Account entry

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