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

Quantitative techniques and decision making, Let the national income model ...

Let the national income model be: Y= c+1+G C=20+0.6y I=0.2y G=20 Where y= income, C= consumption, I= investment and G=government expenditure find y, C and I from the model. By quan

Process costing - accounting for scrap.., a company has two processes whose...

a company has two processes whose details are as follows: Materials 3000kg @ k0.30/kg, labour K120 for process 1 and material 2000kg @ k0.40/kg and labour k84 for process 2. actual

Statistical analysis of hedge funds returns, In this problem set we are goi...

In this problem set we are going to analyze returns of indices for three hedge funds strategies (market neutral, risky arbitrage, long/short). The indices are constructed by CSFB/T

10-k report information, Where are Cash Equivalents and Marketable Securiti...

Where are Cash Equivalents and Marketable Securities noted on a 10-K report? What needs to be included as a minimum disclosure?

Accrual basis in accounting , The foundation sales whereby income are ackno...

The foundation sales whereby income are acknowledged when gained and considerable regardless of when collected; and costs are noted on a corresponding basis when suffered. All amaz

Mba: accounting & finance for managers, . From the following cost, product...

. From the following cost, production and sales data of Decors Motor Ltd., prepare comparative income statement for three years under (i) absorption costing method, and (ii) margi

Bill of exchange, Who can issue a bill of exchange for what purpose? Onl...

Who can issue a bill of exchange for what purpose? Only a supplier who has to get the cash from his client for the purchase which was done on credit score platform can increase

Index number, Why index numbers serve as economic barometers?

Why index numbers serve as economic barometers?

Reply plz, order tomatoes in crates of 25 kg and he is able to stock a maxi...

order tomatoes in crates of 25 kg and he is able to stock a maximum of four crates or 100 kg of tomatoes. His experience taught him that the daily demand ranges from 0 to100 kg of

Adjusting entries, The notes receivable were accepted from several customer...

The notes receivable were accepted from several customers. The notes were issued on Sept. 1,2011 and will be settled together with a 20% interest on May 31, 2011.

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