Introduction to Statistical Computing - Statistics Assignment Help

Assignment Task :

For Part A, we will use Stata to manage the data. Create and submit a do-file for this section, which contains the commands to answer the questions in part A. Ensure that your do-file is appropriately formatted and annotated. In addition to the do-file, submit a pdf version of the do-file. To create a pdf version of the do-file, go to File->Print and change the name of the printer to ‘Adobe PDF’ (or select “Save as PDF” from the dropdown in the bottom left corner), then select OK, and choose a folder in which to save the pdf.
The contents of the datasets that will be used for part A of this assignment are listed in Tables 1 and 2 below. In brief, the individ_data dataset contains information for each participant in the survey, whereas the birth_data dataset contains information for each participants’ offspring.
1) Importing, formatting and collating the datasets
a) Import the dataset individ_data.xlsx and format the dataset so that it aligns with the information provided in Table 1. Convert string variables to numeric variables (with or without value labels, as appropriate). Ensure that missing values are coded as Stata recognized missing values.
b) Check that the contents of the dataset match what is listed in Table 1. 
c) The individ_data dataset contains data for the individual that responded in a household, whereas the birth_data.dta dataset contains information for each birth. Combine the individ_data dataset (i.e. the dataset from part 
b) with the birth_data.dta dataset. The resulting dataset should not have a _merge variable. Check (using a Stata command or option) that there are no orphan
observations in the birth_data.dta dataset (i.e., that there are no children in the birth_data dataset without a parent in the individ_data dataset). 
d) The file extra_data.dta contains data for an additional 66 observations that were not in the original two datasets, append this dataset to the dataset created in
Q1.c and save this dataset as complete_data.dta.
2)  Data consistency and manipulation Use the dataset complete_data.dta from Q1 to answer questions 2a. to 2e.
a) After we merged in the birth_data.dta dataset we had multiple rows of data for participants that had more than one child. Check that education is consistent for
an individual. 
b) Create a new variable that categorises each household according to their highest level of education (note that the highest level of education in a household is that of the most educated individual in that household). Use this variable to ascertain how many households have achieved each level of education. 
c) Calculate the age of attendance for each participant using the date of interview and date of birth. Check that all observations have a corresponding age. 
d) Create a new variable that categorises the age of attendance into the following age categories:
Check that the age variable is correctly categorised.
e) Use a loop to check that dates of BCG, DPT, polio and measles vaccines are missing if the child did not receive the BCG, DPT, polio and measles vaccines, respectively. 
f) Use the complete_data.dta dataset that you saved in Q1.h. Reshape the dataset so that there is one row per participant. Drop any variables that contain all missing data.

This Statistics Assignment has been solved by our Statistics 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.