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

Probabilities, What is the probability of selecting exactly one red and one...

What is the probability of selecting exactly one red and one blue fish (Total red is .479 and total blue is .521 and total of both is 1.000) I cannot figure out the formula or how

Linear Programming Models), #This is a chance to perhaps incorporate some o...

#This is a chance to perhaps incorporate some of your experience, interests, and career business/management goals and ambitions within the context of an individual project paper.

How will the adoption of ifrs change financial reporting, How will the adop...

How will the adoption of IFRS change financial reporting by companies? Manager 1: The new rules will definitely change the way our organization prepares financial statements.

Normal Approximation to Binomial Probability Distribution, A machine that f...

A machine that fills quart milk cartons is set up to average 32.2 oz per carton, with a standard deviation of 1.2 oz. Assume a normal distribution for all of the cartons filled, wh

Create a spreadsheet model and determine linear regression, 1. MMC's CEO, D...

1. MMC's CEO, Dr. Warren A. Beatty (Not the actor) believes that the demand trend for MMC is essentially linear. Thus, he wishes to determine if linear regression would be an effec

TRENDS , Why do we particularly omit the middle year when using the semi-av...

Why do we particularly omit the middle year when using the semi-average method to fit a trend line

Mean, It is a numerical average, as equal to the sum of terms in a given se...

It is a numerical average, as equal to the sum of terms in a given series divided by the number of terms in that series is the mean which is also called the expected value.

Relevant costs to decision-making , Foster Company makes 20,000 units per y...

Foster Company makes 20,000 units per year of a part it uses in the products it manufactures. The unit product cost of this part is computed as follows: Direct materials $24.70 Dir

Time series, explain tthe two uses of time serie, and the four components o...

explain tthe two uses of time serie, and the four components of time series?

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