I have to create a Descriptive Statistics Data Analysis Plan and am currently stuck. I have filled out some of it but am stuck on the last two tables that I need to fill out. Variable 1 has already been completed on both graphs but I need help with Variable 2-5 for both tables. The page on the far right of the immage is the accomanying data set, im not sure if it will help but it is included in the picture just in case.

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 31 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 Kaiswell# First Column Unique num ber 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 I am using sample standard deviation for three SE-AgeHeadHousehold Fourth Colum Age of the Head of Household Age in Years easons: SE-FamilySize Fifth Column Total Number of People in Family (Both Adults Number of People in Family 1. The data is a sample from a larger data set. Reason(s) for Selecting the Variables and Expected Outcome(s): USD-AnnualExpenditures Sixth Column Total Amount of Annual Expenditures Amount in US Dollars . It is the most commonly used measure of USD-Food Seventh Column Total Amount of Annual Expenditure on Food Amount in US Dollars 1. Variable 1: "Income" - I chose income because I was interested in comparing my income to dispersion. USD-Housing Eighth Column Total Amount of Annual Expenditure on Housing Amount in US Dollars 3. The variable is quantitative. USD-Transport Ninth Column Total Amount of Annual Expenditure on mount in US Dollars others in the US, especially since I'm young and make a decent amount in my opinion. I expect Transportation my annual income to be slightly above average. 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 Variable 2: "Age" Variable 2: "Age "- Seeing as how I'm fairly young, but successful, I'm interested to see how us that for the first household in the sample: the head of household is not married and is 35 years old, has an annual household income is $97,469, has a family size of 4, annual expenditures of $54,929, and spends $6,900 on food, $18,514 on housing, and $145 on transportation. people of other ages compare. I think I will be an outlier when comparing my age to other Variable 3: "Marital status" households. 3. Variable 3: "Marital Status "- I'm married and am curious to see if marital status plays a role Variable 4: in successfulness when comparing my current expenditures and income to other households "Transportation" in the USA. Variable 5: 4. Variable 4: "Transportation "- Living in New York City, taking the subway is typically cheaper "Housing" and more efficient than driving. I wonder how much money taking the subway saves or costs Graphs and/or Tables me when comparing my transportation costs to others in the USA who may drive instead of Complete Table 3. Type of Graphs and/or Table for Selected Variables and briefly explain why you taking the subway. choose those graphs and/or tables:_ Note: The information for the required variable, "Income," has 5. Variable 5: "Housing "-Housing costs are expensive in NYC, and they are a big part of my already been completed and can be used as a guide for completing information on the remaining UniquelD# SE-MaritalStatus SE-Income SE-AgeHeadHousehold SE-FamilySize USD-AnnualExpenditures USD-Food USD-Housing USD-Transport Not Married 9746 annual expenses. I'm curious to see how much housing costs for families like mine. 35 54929 6900 18514 variables.. Note: Do NOT simply copy this for the remaining quantitative variables.. Make a logical 145 Not Married 97912 5570 6937 18619 152 selection based on the data type. Not Married 96697 5645 6971 18520 136 Proposed Data Analysis: Not Married 96653 5648 6943 8838 124 Measures of Central Tendency and Dispersion Table 3. Type of Graphs and/or Tables for Selected Variables Not Married 96664 53 5555 7051 18502 168 Not Married 95744 52 5596 7040 18435 146 Complete Table 2. Numerical Summaries of the Selected Variables and briefly explain why you choose Variable Graph and/or Rationale for why Appropriate? Not Married 94929 59 5524 6948 18483 NADWNAWIN 133 Name Table Not Married 96928 43 55932 6953 18701 145 those measurements. Note: The information for the required variable, "Income," has already been Not Married 97681 5612 7097 18676 134 completed and can be used as a guide for completing information on the remaining variables. Variable 1: Graph: A histogram is one of the best plots available to visually depict the Not Married 96244 56 56051 7073 18484 141 Histogram distribution of quantitative level data. Not Married 96886 44 5532 6982 18312 153 "Income" Table 2. Numerical Summaries of the Selected Variables 12 Not Married 96727 39 5644 7051 18376 120 13 Not Married 96690 57 56097 6822 18334 135 Rationale for Why Appropriate 14 Not Married 96572 59 56515 7179 18648 123 Variable Name Measures of Central Variable 2: Not Married 98717 56393 7036 18389 114 Tendency and Dispersion 16 Married 106292 82299 10983 23063 132 17 Married 95801 73798 9395 3155 151 Variable 1: Median Iam using median for two reasons: Variable 3: 18 Marrie 95385 74110 9101 22847 211 Sample Standard If there are any outliers or the data is not 19 Married 95865 74789 9321 22621 168 "Income" Variable 4: Deviation normally distributed, the median is the 20 Married 109312 80801 10564 25392 58 21 Married 114051 84486 10820 25728 167 best measure of central tendency. 2. The variable is quantitative. Variable 5: 110651 83766 11226 22899 113 23 Married 107338 83651 11710 21893 47 24 Marrie 101829 82385 10821 22409 121 STAT200: Assignment #1 - Descriptive Statistics Analysis Plan - Template 25 Marrie 102244 74687 27964 STAT200: Assignment #1 - Descriptive Statistics Analysis Plan - Template Page 3 of 4 Page 4 of 4 26 Married 113558 79861 10346 25006 141 LZ Married 100947 AUVINAUFAN 73973 8455 26783 larried 07369 83441 11724 23174 82 Married 10689 81585 11360 22396 162 Marrie 9776 73950 9035 22867 202 Marrie 8885 57795 9653 23400 157