Write a report on the UK labour market. You will have to (1) collect, examine and present aggregated data using Excel and (2) set up and test three research questions with SPSS using a Census provided on the module web.
Aggregated data (‘country level data’) from OECD will be used to illustrate any changes in the UK labour market over time and to compare it with other OECD countries. This part is worth 40% of the overall mark. The 2011 Census Microdata file from the Office for National Statistics, which contains information on characteristics of UK residents, such as hours of work, health status, economic activity, etc., will be used. This part is worth 60% of the overall coursework mark. You can get some inspiration for research questions by watching the news, reading newspapers articles, etc.
The report will have the following structure:
• Title page (including Group number and names)
• Table of contents
• Part 1: Data analysis using aggregated data (Excel)
• Part 2: Data analysis using micro data (SPSS)
Information about Submission:
The assignment should be uploaded onto Turnitin on, or before, the deadline specified in the teaching plan (18:00 on Friday 30/03/18), by only ONE member of the group. You will need to produce your work in a single Word document. This means that any data and charts you produce in Excel or SPSS must be imported (copied) into Word. I recommend you to save your word file as pdf document and upload the pdf version of your report onto the Moodle link available in the ‘Assessment’ folder. This will ensure that all graphs and tables in your document are correctly displayed. Note that the Moodle link only accepts pdf or word (.doc/.docx) documents. Any other formats cannot be opened and will receive a mark of 0.
1 Part 1: Data analysis using aggregated data (Excel)
This part is worth 40% of the overall group coursework mark. This part should not be longer than 7 pages including any appendices. You will need to find and import data into Excel from the OECD website. Download the following data for the UK and three other OECD member countries of your choice for the period 2000 to
1. Harmonised unemployment rate. Hint: find the monthly harmonised unemployment rate and select annual data in the frequency selection.
2. Trade Union Density.
3. GDP, volume – annual growth rates in percentage.
4. Average annual wages in 2016 constant prices at 2016 USD PPPs.
Add all the raw data into the appendix of Part 1. Do not forget to present the data in a user-friendly format. (Hint: A precise description of a variable, i.e. what it measures, can be found by clicking on the ‘i’ next to the variable name.) Make sure that this part contains the following sections:
• Main Body
The work should be neat and tidy and easy to read. Also, it is very important to use a consistent referencing style for both in-text citations and the list of references displayed at the end of Part 1. Below, further information is given on what has to be included in the main body of Part 1.
1.1 Calculations (5 Marks)
On your spreadsheet calculate the changes in the unemployment rate for the observation period and copy it into your Word document. Make sure that the data is well presented. The formula for changes is:
∆URt = URt −URt−1 (1)
1.2 Numeric Statistics (15 Marks)
Provide numeric descriptive statistics (Mean, Median, Max, Min, Interquartile Range, Std. Dev. and Skewness) for unemployment rate, trade union density, GDP growth rate and average annual wages for the UK and each of the selected three OECD member countries and describe them briefly. The numeric descriptive statistics have to be presented in a well formatted table.
(Maximum 200 words)
1.3 Graphical Methods (40 marks)
1. Create a line chart that compares unemployment rate of the UK with the unemployment rate of 3 other OECD member countries over the period 2000 – 2012.
2. Create a line chart that compares average wage of the UK with the average wages of 3 other OECD member countries over the period 2000 – 2012.
3. Create a scatter plot that shows the relationship between the GDP growth rate and the change in unemployment rate using data from the UK and 3 other OECD member countries.
4. Create a bar chart to compare the trade union density of the UK and 3 other OECD member countries for the years 2000, 2004, 2008 and 2012.
Charts have to be clearly labelled and presented. Describe briefly what each of your charts show.
(Maximum 300 words)
1.4 Economic interpretation of data (40 marks)
Use numeric and graphical descriptive statistics to illustrate to what extent the UK unemployment rate differs from the unemployment rate of other OECD member countries and use economic theory to explain any of those differences (think like an economist!!!). Note that (if necessary) you may create additional charts using the downloaded data to support your arguments. Extra marks will be awarded for evidence of research having been undertaken. This includes relevant references and quotes where appropriate. Any references should be shown within the text, in the standard manner of an academic paper. Extra Marks will also be awarded for the application of appropriate theory to the data.
(Maximum 600 words)
2 Part 2: Data analysis using micro level data
This part is worth 60% of the overall group coursework mark. This part of the report should not exceed 9 pages including appendices. On Moodle under the section ‘Assessment’ you will find a data file (CW2.sav) from the 2011 Census Microdata file of the Office for National Statistics. See below for details about the survey. You have to use this dataset for your report.
Part 2 should have the following structure:
• Aims of the investigation and hypotheses
• Descriptive statistics
• Hypothesis tests
Complete the following tasks:
2.1 Aims of the investigation and hypotheses (25 marks)
Using the 2011 Census Microdata identify three research questions and highlight their importance. Set up your hypotheses. Show that you can think like an economist!
(Maximum 400 words)
2.2 Descriptive statistics (20 marks)
In line with the aims of the investigation you provided generate descriptive statistics using tables and graphs with SPSS. You have to provide information for the reader about the sample and variables of interests.
(Maximum 300 words)
2.3 Hypothesis tests (45 marks)
Set up and conduct hypotheses tests and interpret the results. This section should contain three hypothesis tests. At least one must be a cross tabulation table and associated χ2-tests and at least one should be a comparison-of-means test. The analysis of your results is very important. Do not just present the statistics with no explanations of what they show! You must discuss the results!!!! Use economic theory to explain your results.
(Maximum 900 words)
2.4 Summary/Conclusion (10 marks)
Summarise your main results and provide conclusions.
(Maximum 300 words)
More Information on the Data
A reduced form of the 2011 Census Micro Dataset is the dataset for this part of the assignment. This Microdata Teaching dataset consists of a random sample of 1% of people in the 2011 Census for England and Wales. This includes people classed as both usual residents and short-term residents. Specifically, the dataset includes:
• Records on 569,741 individuals
• For each individual, information is available on 18 separate characteristics, i.e. variables, with varying degrees of information for each variable.
For your coursework you will need to select variables of your interest. It is up to you which variables you use. The following categorical variables are included in the dataset:
Person ID, Region, Residence type, Family composition, Population base, Sex, Age, Marital status, Student (schoolchild or full-time student), Country of birth, Health (general health), Ethnic group, Religion, Economic activity, Occupation, Industry, Hours worked per week, Approximated social grade.
Additionally, two continuous variables were added by your tutor for the purposes of this assignment: Hours worked per week (continuous) and Age (continuous).
You have to read the Microcensus User Guide and Microcensus Variable List (all available on Moodle under the Group Coursework section) to get a detailed explanation about the dataset and its variables. If you do not read those documents, you will not understand what each categorical variable measures.
It would be reasonable for you, to begin with, to first counsel this short diagram of what an insightful survey is about. Next, you ought to acquaint yourself with a couple of cases of as of late distributed book surveys in scholastic diaries. The Canadian Journal of Communication runs a strong survey segment, as do diaries, for example, Theory, Culture and Society and Cultural Politics (among numerous others). The primary thing we will search for in assessing your task is that you have put some idea into how to create your content as an insightful book audit. What I mean is: this isn't a sentiment piece or an expanded howl audit. It's not an individual reflection. We are not inspired by general impressions like how the book influenced you to feel or in any case. This is to be a work of basic grant. On the off chance that you are not set up to put the time, care, and exertion in that such a bit of composing requires, you would be better off finishing one of the other task alternatives this month. The second and most vital standard we will use to assess your audit is the profundity and advancement of your engagement with Martin's book. Have you perused it intently? Do you comprehend his contention and would you say you are reasonably evaluating it? Is it accurate to say that you are giving careful consideration to such inquiries as those of technique, thoroughness, hypothetical approach, or decision of authentic materials? In short: don't just condense the book. The best audits utilize the content under investigation as a stage for saying something inventive or new. As such: ponder the book as a book, not just as data to be compressed. Arrangement rules: standard 1-inch edges, 12-point text style, twofold separated, including your name and all significant information as found on the "accommodation registration" layout (find on cuLearn). Additionally make certain to incorporate your name in the report record name. For additionally evaluating rules, see the general layout presented on cuLearn. Keep African American History in our Schools! Another development has begun since the mid 2000s, where some political gatherings are endeavoring to expel American history from our youngsters' school educational programs and course readings, particularly slave history. In any case, these gatherings additionally would prefer not to cover isolation or social equality. By evacuating the history that we have quite recently canvassed in these most recent two months, the African American people group would be denied their associations with American History. As of late, African Americans have made developments, for example, "Dark Lives Matter" to balance these different gatherings. Numerous attach slave history to the improvement of isolation and prejudice that has spread all through our nation. A Historical Trauma has influenced ages of African Americans as a result of what their predecessors needed to persevere through just to get by in this nation. This doubt has created towards various gatherings, offices and associations. For the individuals who are not influenced, endeavoring to comprehend being an African American in the United States exhibits the requirement for this history to be instructed in all schools and to each American. Set up a letter to the proofreader of your nearby daily paper that would disclose to all of America why African American History ought to be educated in American schools. Clarify why each American should known this history and propose how knowing particular parts of this history could enable retouch to race relations in the United States. You will be relied upon to utilize particular certainties, occasions and individuals to indicate how knowing this history can clarify the injury that has influenced such a significant number of Americans. These actualities, occasions, and individuals must originate from your required work this term and from look into in the library or from the course list of sources. In your letter, exhibit the expansiveness of information you have picked up from this work. Bear in mind to use in content references since you will utilize different sources. This post must be no less than 500 words. On the off chance that you wish, you can add to the letter some approaches to recuperate our country. What steps would we be able to use to end prejudice and division among groups and societies. You will, of course, react to no less than two understudies. I will review your two best reactions. Any reaction past those two is empowered, yet is "free." I won't review it. Supportive Links: http://www.prindlepost.org/2016/05/evacuating subjugation course books/ https://newsone.com/977835/tenn-casual get-together needs subjugation expelled from-history-course books/ http://www.umsl.edu/administrations/cps/records/ross-presentation.pdf http://atlantablackstar.com/2016/06/05/post-awful slave-disorder and-intergenerational-injury servitude is-like-a-revile going through-the-dna-of-dark individuals/ Worldwide Corporation Law Pick ONE inquiry. Take after OSCOLA STYLE Question 1 On account of Eclairs Group Limited v JKX Oil and Gas Plc  3 All ER 641 at page 659 Lord Sumption expressed: "The decide that the guardian forces of chiefs might be practiced just for the reasons for which they were given is one of the primary means by which value authorizes the best possible lead of executives. It is additionally crucial to the protected refinement between the particular spaces of the board and the investors." What exactly degree is this lead really viable in guaranteeing that organizations are legitimately overseen? If you don't mind examine late cases in England or in different locales in your answer. Question 2 Basically talk about the methods by which parent organizations might be considered lawfully in charge of the demonstrations or oversights of their backups. Incorporate into your answer contemplations of universal law, delicate law and the household law of any state as suitable. Understudies are helped to remember the significance of presenting this evaluation. As far as possible for this evaluation is 3,500 words including commentaries yet barring catalogs. Understudies are likewise reminded about the standards on copyright infringement and scholarly wrongdoing Question 3 What legitimate issues are raised by the current fall of the English organization Carillion plc? Propose changes to the corporate administration which may help with anticipating future crumples of this kind. Question 4 Should the present guidelines of English law securing miserable minority investors be changed? On the off chance that so how? You may talk about administrations in different wards in your answer as proper. Understudies are helped to remember the significance of presenting this appraisal. As far as possible for this appraisal is 3,500 words including references yet barring book indices. Understudies are additionally reminded about the standards on counterfeiting and scholarly offense Sainthood: its history, improvement and current importance • HISTORY: Be certain to incorporate the authentic foundation of your theme • ESSENCE: your point's connection to the ESSENCE of Christianity otherwise known as what is its essentialness to the religion. • PRESENT-FUTURE: ponder likewise how your subject effects Christianity's available and future. • Must incorporate a legitimate presentation and conclusion (that contains proposal articulation, outline and key explanations) • Section headings will be helpful to enhance stream. • Length: 11 Pages barring references, times new roman size 12 textual style, twofold dispersed • Citations: APA style, Include page numbers in references when conceivable. Verifiable Background: • Who and why was the principal holy person sanctified (and why there were others esteemed holy people previously him, before an official canonization) • What is the Process verifiably? How was this decided? Embodiment: • What is the significance of a holy person: obligations, parts, impacts, aftereffects of turning into a holy person • What is the significance of a devour day? Why is it imperative Introduce Future: • What are present devour days that are commended in the standard society, regardless of whether non-religious (otherwise known as St. Patrick's Day, St Valentine), how could they get to this point? • Who was the last holy person to be Canonized? • Has the procedure of canonization changed or created through the span of Christian History? >GET ANSWER