Descriptive Statistics Analysis on households

Descriptive Statistics Analysis on households

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