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

Data Analysis - Coursework ExampleThe APS is intended to be translator of the whole of the population of the UK. The population cover by the survey is all people resident in private households and young people living extraneous from the parental home in student halls of residence or similar institution during term time. The survey covers a target sample of at least(prenominal) 875 economically fiddleive persons for each Unitary Authority (UA)/Local Area District (LAD), and at least 450 economically active persons in slap-uper capital of the United Kingdom Boroughs. The number of jobseekers is derived from the Work and Pensions Longitudinal Study (WPLS), which also contains selective information 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, lone(prenominal) figures relating to London were extracted for analysis. Both datasets were downloaded from governme nts Neighbourhood Statistics websitehttp//www.neighbourhood.statistics.gov.uk Selection Process The process of selecting the jobseekers allowance data is as follows on the neighborhood Statistics website, click on Topics, then Economic deprivation, then Jobseekers allowance claimants, choose the family and tick download on the right hand side, choose Microsoft jump 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 stop consonant 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 efficiency 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 paper go forth investigate the relationship surrounded by 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 give begin with an exploratory analysis followed by in-depth statistical analyses which willing 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 whether 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