STAT 200E University of Maryland Baltimor Descriptive Statistics Analysis & Excel Sheet Assignment #2: Descriptive Statistics Analysis and Writeup In the

STAT 200E University of Maryland Baltimor Descriptive Statistics Analysis & Excel Sheet Assignment #2: Descriptive Statistics Analysis and Writeup

In the first assignment (Assignment #1: Descriptive Statistics Analysis Data Plan), you developed a scenario about annual household expenditures and a plan for analyzing the data using descriptive statistic methods. The purpose of this assignment is to carry out the descriptive statistics analysis plan and write up the results. The expected outcome of this assignment is a two to three page write-up of the findings from your analysis as well as a recommendation.

Assignment Steps:

Step #1: Review Feedback from Your Instructor

Before performing any analysis, please make sure to review your instructor’s feedback on Assignment #1: Descriptive Statistics Data Analysis Plan. Based on the feedback, modify variables, tables, and selected statistics, graphs, and tables, if needed.

Step #2: Perform Descriptive Statistic Analysis

 Task 1: Look at the dataset. • (Re)Familiarize yourself with the variables. Review Table 1: Variables Selected for the Analysis you generated for the first assignment as well as your instructor’s feedback. In addition, look at the data dictionary contained in the data set for information about the variables.

• Select the variables you need for the analysis.

 Task 2: Complete your data analysis, as outlined in your first assignment, with any needed modifications, based on your instructor’s feedback.

• Calculate Measures of Central Tendency and Variability. Use the information from Assignment #1 – Table 2. Numerical Summaries of the Selected Variables. Here again, be sure to see your instructor’s feedback and incorporate into the analysis.

• Prepare Graphs and/or Tables. Use the information from Assignment #1 – Table 3. Type of Graphs and/or Tables for Selected Variables. Here again, be sure to see your instructor’s feedback and incorporate into the analysis. University of Maryland University College
STAT200 – Assignment #2: Descriptive Statistics Analysis and Writeup
Identifying Information
Student (Full Name):Andrew Nolley
Class:Stat200
Instructor:Fred Kaiser
Date:07/25/2020
Introduction:
Use the same scenario you submitted for the first assignment with modifications using your
instructor’s feedback, if needed. Include Table 1: Variables Selected for the Analysis you used in
Assignment #1 to show the variables you selected for analysis.
Table 1. Variables Selected for the Analysis
Variable Name in data set
Description
Type of Variable
(Qualitative or
Quantitative)
Variable 1: “Income”
Annual household income in
USD.
Quantitative
Variable 2:Housing
Total Amount of Annual
Expenditure on Housing
Quantitative
Variable 3:Transport
Total Amount of Annual
Expenditure on
Transportation
Quantitative
Variable 4:Marital Status
Marital Status of Head of
Household
Qualitative
Variable 5:Family Size
Total Number of People in
Family (Both Adults and
Children)
Quantitative
Data Set Description and Method Used for Analysis:
Results:
Variable 1: Income
Numerical Summary.
Table 2. Descriptive Analysis for Variable 1
Variable
n
Variable: Income
Measure(s) of
Central Tendency
Median=
Measure(s) of
Dispersion
SD =
Graph and/or Table: Histogram of Income
(Place Histogram here)
Description of Findings.
Variable 2: (Fill in name of variable)
Numerical Summary.
Table 3. Descriptive Analysis for Variable 2
Variable
n
Measure(s) of
Central Tendency
Measure(s) of
Dispersion
Measure(s) of
Central Tendency
Measure(s) of
Dispersion
Variable:
Graph and/or Table.
(Place Graph or Table Here)
Description of Findings.
Variable 3: (Fill in name of variable)
Numerical Summary.
Table 4. Descriptive Analysis for Variable 3
Variable
Variable:
n
Graph and/or Table.
(Place Graph or Table Here)
Description of Findings.
Variable 4: (Fill in name of variable)
Numerical Summary.
Table 5. Descriptive Analysis for Variable 4
Variable
N
Mean/Median
St. Dev.
Measure(s) of
Central Tendency
Measure(s) of
Dispersion
Variable 4:
Graph and/or Table.
(Place Graph or Table Here)
Description of Findings.
Variable 5: (Fill in name of variable)
Numerical Summary.
Table 6. Descriptive Analysis for Variable 5
Variable
n
Variable:
Graph and/or Table.
(Place Graph or Table Here)
Description of Findings.
Discussion and Conclusion.
Briefly discuss each variable in the same sequence as presented in the results. What has the
highest expenditure? What variable has the lowest expenditure? If you were to recommend a
place to save money, which expenditure would it be and why? Note: The section should be no
more than 2 paragraphs.
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
SE-Income
SE-AgeHeadHousehold
SE-FamilySize
Second Column
Third Column
Fourth Column
Fifth Column
Not Married/Married
Amount in US Dollars
Age in Years
Number of People in Family
USD-AnnualExpenditures
USD-Food
USD-Housing
USD-Transport
Sixth Column
Seventh Column
Eighth Column
Ninth Column
Marital Status of Head of Household
Annual Household Income
Age of the Head of Household
Total Number of People in Family (Both Adults
and Children)
Total Amount of Annual Expenditures
Total Amount of Annual Expenditure on Food
Total Amount of Annual Expenditure on Housing
Total Amount of Annual Expenditure on
Transportation
Amount in US Dollars
Amount in US Dollars
Amount in US Dollars
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#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
SE-MaritalStatus
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Not Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
Married
SE-Income
95432
97469
96664
96653
94867
97912
96886
96244
95366
96727
96697
95744
96572
98717
94929
95778
109377
95706
95865
109211
95994
114932
112559
95807
99610
95835
102081
104671
107028
114505
SE-AgeHeadHousehold
51
35
53
51
60
49
44
56
48
39
49
52
59
40
59
42
48
52
46
42
55
44
39
56
36
54
42
41
46
36
SE-FamilySize
USD-AnnualExpenditures
1
4
3
4
1
1
2
4
2
2
2
4
2
3
2
4
4
4
1
4
4
5
3
4
2
3
4
4
4
5
55120
54929
55558
56488
55512
55704
55321
56051
57082
56440
56453
55963
56515
56393
55247
73323
83530
71597
74789
82503
73404
81186
80934
72949
73550
73092
82331
82786
82816
78325
USD-Food
7089
6900
7051
6943
6935
6937
6982
7073
7130
7051
6971
7040
7179
7036
6948
9067
10575
8925
9321
11566
9231
11077
11189
9210
9513
9111
11738
10420
10840
11375
USD-Housing
18391
18514
18502
18838
18633
18619
18312
18484
18576
18376
18520
18435
18648
18389
18483
22880
23407
22376
22621
22219
22852
26411
25531
23139
27164
23252
23374
22245
25671
26006
USD-Transport
115
145
168
124
131
152
153
141
149
120
136
146
123
114
133
201
99
181
168
62
177
153
73
186
33
186
121
84
109
140

Purchase answer to see full
attachment