Statistics, I need this template below complete according to the instructions and data sheet attached, Please and thank you.
Description of Dataset:
The data is a random sample from the US Department of Labor’s 2016 Consumer Expenditure Surveys (CE) and provides information about the composition of households and their annual expenditures (https://www.bls.gov/cex/). It contains information from 30 households, where a survey responder provided the requested information; it is all self-reported information. This dataset contains four socioeconomic variables (whose names start with SE) and four expenditure variables (whose names start with USD).
Description of Variables/Data Dictionary:
The following table is a data dictionary that describes the variables and their locations in this dataset (Note: Dataset is on second page of this document):
Variable Name | Location in Dataset | Variable Description | Coding |
UniqueID# | First Column | Unique number used to identify each survey responder | Each responder has a unique number from 1-30 |
SE-MaritalStatus | Second Column | Marital Status of Head of Household | Not Married/Married |
SE-Income | Third Column | Annual Household Income | Amount in US Dollars |
SE-AgeHeadHousehold | Fourth Column | Age of the Head of Household | Age in Years |
SE-FamilySize | Fifth Column | Total Number of People in Family (Both Adults and Children) | Number of People in Family |
USD-AnnualExpenditures | Sixth Column | Total Amount of Annual Expenditures | Amount in US Dollars |
USD-Food | Seventh Column | Total Amount of Annual Expenditure on Food | Amount in US Dollars |
USD-Housing | Eighth Column | Total Amount of Annual Expenditure on Housing | Amount in US Dollars |
USD-Transport | Ninth Column | Total Amount of Annual Expenditure on Transportation | Amount in US Dollars |
How to read the data set: Each row contains information from one household. For instance, the first row of the dataset starting on the next page shows us that for the first household in the sample: the head of household is not married and is 51 years old, has an annual household income is $95,432, has a family size of 1, annual expenditures of $55,120, and spends $7,089 on food, $18,391 on housing, and $115 on transportation.
UniqueID# | SE-MaritalStatus | SE-Income | SE-AgeHeadHousehold | SE-FamilySize | USD-AnnualExpenditures | USD-Food | USD-Housing | USD-Transport |
1 | Not Married | 95432 | 51 | 1 | 55120 | 7089 | 18391 | 115 |
2 | Not Married | 97469 | 35 | 4 | 54929 | 6900 | 18514 | 145 |
3 | Not Married | 96664 | 53 | 3 | 55558 | 7051 | 18502 | 168 |
4 | Not Married | 96653 | 51 | 4 | 56488 | 6943 | 18838 | 124 |
5 | Not Married | 94867 | 60 | 1 | 55512 | 6935 | 18633 | 131 |
6 | Not Married | 97912 | 49 | 1 | 55704 | 6937 | 18619 | 152 |
7 | Not Married | 96886 | 44 | 2 | 55321 | 6982 | 18312 | 153 |
8 | Not Married | 96244 | 56 | 4 | 56051 | 7073 | 18484 | 141 |
9 | Not Married | 95366 | 48 | 2 | 57082 | 7130 | 18576 | 149 |
10 | Not Married | 96727 | 39 | 2 | 56440 | 7051 | 18376 | 120 |
11 | Not Married | 96697 | 49 | 2 | 56453 | 6971 | 18520 | 136 |
12 | Not Married | 95744 | 52 | 4 | 55963 | 7040 | 18435 | 146 |
13 | Not Married | 96572 | 59 | 2 | 56515 | 7179 | 18648 | 123 |
14 | Not Married | 98717 | 40 | 3 | 56393 | 7036 | 18389 | 114 |
15 | Not Married | 94929 | 59 | 2 | 55247 | 6948 | 18483 | 133 |
16 | Married | 95778 | 42 | 4 | 73323 | 9067 | 22880 | 201 |
17 | Married | 109377 | 48 | 4 | 83530 | 10575 | 23407 | 99 |
18 | Married | 95706 | 52 | 4 | 71597 | 8925 | 22376 | 181 |
19 | Married | 95865 | 46 | 1 | 74789 | 9321 | 22621 | 168 |
20 | Married | 109211 | 42 | 4 | 82503 | 11566 | 22219 | 62 |
21 | Married | 95994 | 55 | 4 | 73404 | 9231 | 22852 | 177 |
22 | Married | 114932 | 44 | 5 | 81186 | 11077 | 26411 | 153 |
23 | Married | 112559 | 39 | 3 | 80934 | 11189 | 25531 | 73 |
24 | Married | 95807 | 56 | 4 | 72949 | 9210 | 23139 | 186 |
25 | Married | 99610 | 36 | 2 | 73550 | 9513 | 27164 | 33 |
26 | Married | 95835 | 54 | 3 | 73092 | 9111 | 23252 | 186 |
27 | Married | 102081 | 42 | 4 | 82331 | 11738 | 23374 | 121 |
28 | Married | 104671 | 41 | 4 | 82786 | 10420 | 22245 | 84 |
29 | Married | 107028 | 46 | 4 | 82816 | 10840 | 25671 | 109 |
30 | Married | 114505 | 36 | 5 | 78325 | 11375 | 26006 | 140 |