See attached instructions for assignment 3, (review Assignment 2 submission, template for assignment 3 and Data set for assignment.) Below items must be answered and work needs to be shown and written
UNCLASSIFIED
STAT200 Introduction to Statistics
Dataset for Written Assignments
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-Annual Expenditures | Sixth Column | Total Amount of Annual Expenditures | Amount in US Dollars |
USD-Housing | Seventh Column | Total Amount of Annual Expenditure on Housing | Amount in US Dollars |
USD-Electricity | Eighth Column | Total Amount of Annual Expenditure on Electricity | Amount in US Dollars |
USD-Water | Ninth Column | Total Amount of Annual Expenditure on Water | 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: the head of household is not married and is 59 years old, has an annual household income of $94,929, a family size of 2, annual expenditures of $55,247, and spends $18,483 on housing, $1,451 on electricity, and $546 on water.
UniqueID# | SE-MaritalStatus | SE-income | SE-AgeHeadHousehold | SE-FamilySize | USD-AnnualExpenditures | USD-Housing | USD-Electricity | USD-Water |
Not Married | 94929 | 59 | 55247 | 18483 | 1451 | 546 | ||
Not Married | 96621 | 54 | 55746 | 18149 | 1455 | 540 | ||
Not Married | 96664 | 53 | 55558 | 18502 | 1478 | 553 | ||
Not Married | 96522 | 43 | 56152 | 18483 | 1457 | 537 | ||
Not Married | 96697 | 49 | 56453 | 18520 | 1469 | 545 | ||
Not Married | 96727 | 39 | 56440 | 18376 | 1441 | 542 | ||
Not Married | 94867 | 60 | 55512 | 18633 | 1485 | 523 | ||
Not Married | 96690 | 57 | 56097 | 18334 | 1453 | 535 | ||
Not Married | 97469 | 35 | 54929 | 18514 | 1451 | 565 | ||
10 | Not Married | 96886 | 44 | 55321 | 18312 | 1450 | 523 | |
11 | Not Married | 95744 | 52 | 55963 | 18435 | 1465 | 555 | |
12 | Not Married | 96572 | 59 | 56515 | 18648 | 1480 | 552 | |
13 | Not Married | 95366 | 48 | 57082 | 18576 | 1478 | 538 | |
14 | Not Married | 97912 | 49 | 55704 | 18619 | 1450 | 553 | |
15 | Not Married | 96928 | 43 | 55932 | 18701 | 1479 | 520 | |
16 | Married | 114051 | 42 | 84486 | 25728 | 1452 | 818 | |
17 | Married | 106627 | 56 | 82676 | 22414 | 1688 | 709 | |
18 | Married | 109312 | 37 | 80801 | 25392 | 1514 | 743 | |
19 | Married | 103144 | 29 | 75393 | 26322 | 1386 | 626 | |
20 | Married | 111195 | 30 | 80865 | 25018 | 1481 | 796 | |
21 | Married | 112559 | 39 | 80934 | 25531 | 1504 | 794 | |
22 | Married | 97835 | 30 | 77765 | 27949 | 1297 | 641 | |
23 | Married | 100693 | 42 | 73294 | 26102 | 1354 | 597 | |
24 | Married | 95385 | 50 | 74110 | 22847 | 1302 | 684 | |
25 | Married | 100350 | 31 | 73771 | 26853 | 1405 | 585 | |
26 | Married | 95922 | 55 | 72228 | 22996 | 1326 | 674 | |
27 | Married | 96207 | 27 | 74620 | 28491 | 1310 | 588 | |
28 | Married | 97663 | 51 | 72971 | 23150 | 1320 | 689 | |
29 | Married | 100565 | 18 | 69203 | 27950 | 1358 | 626 | |
30 | Married | 97977 | 44 | 73198 | 22990 | 1298 | 696 |
UNCLASSIFIED