Data Analysis Coursework Example | Topics and Well Written Essays - 1750 words

Data Analysis - Coursework Example The APS is intended to be representative of the whole of the population of the UK. The population covered by the survey is all people resident in private households and young people living away from the parental home in student halls of residence or similar institution during term time. The survey covers a target sample of at least 875 economically active persons for each Unitary Authority (UA)/Local Area District (LAD), and at least 450 economically active persons in Greater London Boroughs. The number of jobseekers is derived from the Work and Pensions Longitudinal Study (WPLS), which also contains data on jobseekers allowance claimants. The data was obtained from computer systems used to administer the benefits. Although the data downloaded covers the whole Great Britain, only figures relating to London were extracted for analysis. Both datasets were downloaded from government’s Neighbourhood Statistics website  http://www.neighbourhood.statistics.gov.uk Selection Process The process of selecting the jobseeker’s allowance data is as follows: on the Neighborhood Statistics website, click on Topics, then Economic deprivation, then Jobseekers allowance claimants, choose the year and tick download on the right hand side, choose Microsoft Excel file. The file download is initiated. The process is repeated for all five years. For the unemployment data, click on topics and then proceed to Economic deprivation, Worklessness: economic activity, choose the time period and check download on the right hand side, choose Microsoft Excel file. The file download begins automatically. The process is repeated for all five years. Since the analysis only sampled data from cities in London, the findings may be skewed and hence not applicable to all other cities in the rest of Great Britain. However, one strength of the paper is that it uses data covering duration of five years and therefore takes account of any seasonal or periodic fluctuations. Objective This pa per will investigate the relationship between the number of unemployed persons and the number of persons claiming jobseekers’ allowance in London region. To ensure that eligible persons are included in the survey, data pertaining to persons aged 16-64 years only was used in the analysis. Types of analyses to be conducted Analyses of the data provided will begin with an exploratory analysis followed by in-depth statistical analyses which will act as confirmatory tests to any hypothesized relationships made in the first stage of analysis. Under exploratory analyses, descriptive statistics will be computed, a relationship will also be hypothesized using a scatterplot and bar graphs. In the second phase of analysis, the equation relating the two variables will be modeled. Correlation analysis will also be used to investigate the strength of the relationship observed above. A residual plot will be used to confirm the presence or absence of outliers, the plot will also indicate whe ther there were any particular areas where the model greatly under or over-predicted the relationship between unemployed persons and persons seeking employment1. Detailed analysis and conclusions will also be made using a regression model. Data collected from the five year period has been consolidated in to two variables: unemployed (Unemployed Persons Count) and jobseekers (Jobseekers Allowance Claimants). EXPLORATORY ANALYSIS Descriptives of the data is as shown: A plot for the individual years covered during the study is shown