Statistics and data management: Component B
You will each be assigned two countries (Italy and Slovenia selected)from within the EU and you will have to construct a dataset for these countries using the statistical annex of the European Union. The data is to be presented in Excel, and this will be the first part of the project. You will then have to provide a descriptive analysis of your data using the tools that you have been taught in the module so far. You should include separate sections dealing with the variables individually and taken together.
Each student will have to collect data on employment, unemployment, gross domestic product at current market prices, Exports of goods and services at current prices, Imports of goods and services at current prices.
Breakdown of marks:
Excel file: 25%. Your file should contain all the data required and should be presented so that it can be opened and readily understood by another student.
Use of diagrammatic tools: plots, ogives, box plots etc 20%
Use of statistical tools: means, variance, covariance, correlation. 20%
Discussion of results: 35%
Marking scheme Component B
Does the report ……?
F E D C B A
Contains the requested data
Well-presented and easy to understand
Contains any calculations that have been made
Table of means, standard deviations
Discussion of findings
Table of partial correlations
Relevant diagrammatic presentation
Discussion of results
What you should include:
Your diagrammatic analysis of the data should examine each series for both countries and you should provide a brief description of what you find, for example;
unemployment in the uk varies between ??? with a minimum value of ?.. in ?. And a maximum value of ?? in ?? The mean of the series is ?? etc.
you should also compare across the countries. Diagrams could compare the GDP of germany with that of malta, two countries that vary in size. To do this you would need to use two axes, one for malta and one for Germany, and to see how this is done you can look at the file, ?comparing the variability of three financial series? in study unit 2. This will also show you how to find out which country has the more variable unemployment etc. which you should also do.
You can produce QQ plots for the data and comment on normality.
You should also look at whether the data is correlated by creating a partial correlation matrix for the data for each country separately.
You do not need to do any regression analysis.
This assignment is due at 2 P.M. on the 18th of March and must be submitted electronically. You will need to submit your excel file with data and calculations and a word document with your analysis and discussion. You should copy relevant diagrams into the word document as well as tables of descriptive statistics.
Word limit :1500 words
Your assignment should comprise two documents, and excel file that contains all of your data with every calculation that you have made clearly labelled. It should also contain each of the graphs that you have created.
The second document will be a word document and this should contain all of the data and graphs that are referred to in the text. You may not refer back to the excel file, copy and paste your results into the word document. This is a suggested structure;
Section 1: introduction:
This section tells me anything that i need to know, eg. Country namesSelected two countries—- Italy and Slovenia, the variables and the dates from which the data is available. E.g. german data is available on all variables from ????-???? whereas Estonian data are available on unemployment from????-???? andetc etc.
Section 2: Country 1
This should contain results relevant to the country. The correlation matrix should be constructed from the full range of data that is available for each variable, eg. If you have data from 1992-2013 for some variables but 1996-2013 for the rest, then all the correlations should be calculated using data from 1996 onwards. Your discussion should highlight any interesting relationships and comment on the strength or otherwise.
Section 3: Country 2
As above. For old EU countries you will have data from 1980ish on, use it.
Section 4 Comparison
This will compare variability in each series. You can do this using a mixture of graphs, box plots and statistics such as the coefficient of variation; you should be able to comment on which country has the more variable unemployment etc,.
Section 5: conclusion
What have you done, what did you find.
Please make sure to review all the relevant materisl, as there is important information in each file.
Also the detai requirements are in the files.
PLACE YOUR ORDER WITH SIMILAR OR RELATED INSTRUCTIONS NOW.