I need help how to calculate using this data My chosen Id is I with not married 51 family size 1 I need to use all that 30 data to calculate what I need below Income Marital status , housing, food, and family size. i am having a hard time doing this assignment
Font Paragraph Styles 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 Each responder has a unique responder 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 Number of People in Family and Children) 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 Amount in US Dollars transportation 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. 1 of 2 311 of 613 wordsCopy AaBbCCDc|AaBbCCD
