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
“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
Attachments
20190410195134assignment__2__instructions_for_descriptive_statistics_analysis_and_writeup (148 kB)20190410195141stat200e_dataset_spring_2019__2_.achavies (70 kB)
