Current Population Survey Case Study - Sociology Assignment Help

Assignment Task :

CASE STUDY:

The Current Population Survey (CPS) is used to supplement census information between census years. The data file contains 534 observations on 6 variables sampled from the Current Population Survey of 2017 with information on wages and other characteristics of the workers. Detail of variables included in this sample are given as below:

• Wages
• Education
• Work experience
• Sector
• Occupation
• Age

Part A: 

1. Identify the type of each variable and indicate whether it is qualitative or quantitative. If it is quantitative data, indicate whether it is discrete orcontinuous. Otherwise, state the level of measurement.
2. Identify whether the analysis you were considering in this survey is a population or sample. Provide a relevant reason. 
3. Refer to variable Occupational Category. Construct a frequency distribution for the variable and draw an appropriate graph for this variable. Explain by given 2 relevant points. 
4. By using Excel, organize the Age into group frequency distribution.
5. By using Excel, construct a descriptive statistics table for Wages and Number of years of Experience which include the FIRST & THIRD QUARTILES and IQR. 
6. Based on your output in Q(5), explain the following analysis for both variable.

• Measure of location
• Measure of dispersion
• Shape of distribution
•  Justify who’s spread more 

Part B: 

1. You will to use the for Wages and Number of years of Experience to do the following analysis:

• Identify the independent and dependent variable for the analysis.
• By using Excel, draw a scatterplot. Your graph must include the coefficient of determination value, the regression line and its equation. Explain your graph.
• Use Excel to generate a summary output for regression analysis. From the output, determine the regression equation. 

• Interpret the result from (c) by explaining the following; the value of y-intercept the slope the coefficient of correlation value
• the coefficient of determination value 

2. You will to use the for Wages and Number of years of Education to do the following analysis:

• By using Excel, draw a scatterplot. Your graph must include the coefficient of determination value, the regression line and its equation. Explain your graph. 
• Use Excel to generate a summary output for regression analysis. From the output, determine the regression equation. 
• Interpret the result from (c) by explaining the following; the value of y-intercept

Part C: 

1. Develop a contingency table using these variables: Occupational category and Sector of the workers. 
2. What is the probability that a randomly selected worker occupation is sales or in manufacturing sector? 
3. Suppose that worker is in construction sectors, what is the probability that the worker is professional? 
4. What is the probability that a randomly selected worker occupation is management and in other sector?
5. Suppose that 4 worker were selected at random. What is the probability that all four workers were professional and they in other sector?

This Sociology Assignment has been solved by our Sociology Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.