STAT200 UMD Descriptive Statistics Analysis Marital Status Case Study Statistics, I need this template below complete according to the instructions and dat

STAT200 UMD Descriptive Statistics Analysis Marital Status Case Study 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 STAT200 Introduction to Statistics
Assignment #2: Descriptive Statistics Analysis and Writeup
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.
STAT200: Assignment #2 – Descriptive Statistics Analysis and Writeup – Instructions
Page 1 of 3
Step #3: Write-up findings using the Provided Template
For this part of the assignment, write a short 2-3 page write-up of the process you followed and the
findings from your analysis. You will describe, in words, the statistical analysis used and present the
results in both statistical/text and graphic formats.
Here are the main sections for this assignment:
✓ Identifying Information. Fill in information on name, class, instructor, and date.
✓ Introduction. For this section, use the same scenario you submitted for the first assignment and
modified using your instructor’s feedback, if needed. Include Table 1 (Table 1: Variables
Selected for the Analysis) you used in Assignment #1 to show the variables you selected for the
analysis.
✓ Data Set Description and Method Used for Analysis. Briefly describe the data set, using
information provided in the data set file. Also describe what method(s) (i.e., TI Calculator, free
web applets, Excel) you used to analyze the data.
✓ Results. In this section, you will report the results of your descriptive statistics data analysis. For
each variable, fill in the following sections:
•
Variable (#): (Name). Fill in the name of the variable. Note: Income was included for
variable 1.
•
Numerical Summary. Fill in Table . Descriptive Analysis for Variable with your
computation. Below is the template table; be sure to include the name(s) of the
measures used as well as their values. Since there will be no measure of dispersion for
the qualitative variable, just enter N/A for not applicable. Note: The information for the
required variable, “Income,” has already been partially completed and can be used as a
guide for completing information on the remaining variables.
Variable
n
Measure(s) of Central Tendency
Measure(s) of Dispersion
Variable:
•
Graph and/or Table. Put the graph or table for the variable in this section.
STAT200: Assignment #2 – Descriptive Statistics Analysis and Writeup – Instructions
Page 2 of 3
•
Description of Findings.
–
Briefly describe the descriptive statistics measure(s) that was/were calculated
and explain why was it/they the appropriate one(s) to use.
–
Describe the results of the analysis in everyday language. Please consult your
textbook and information contained in our LEO classroom for examples.
✓ Discussion and Conclusion. Organize the discussion to address findings for which you presented
results. 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.
Assignment Submission: Name the file that contains your completed “Assignment #2: Descriptive
Statistics Analysis Writeup Template” using the following format: “Assignment2-StudentLastName.”
Submit it via the Assignments area in the LEO classroom in the “Assignment #2: Descriptive Statistics
Analysis Writeup” folder.
Grading Rubric for Assignment #2
Introduction
10%
Description of data set and method(s) used for analyzing the data
10%
Results. For each variable (10% for each variable):
50%
● Numerical Summary: Accurate/appropriate results reported in table.
● Graph and/or Table: Accurate/appropriate graph or table.
● Findings:
○ Description of and explanation of measure(s) used.
○ Explanation of the results of the analysis, including information from both the
numerical summary and graph and/or table.
Discussion and Conclusion. Described results and provided answers to questions about
expenditures.
20%
Writes clearly, concisely, and with few errors.
10%
Clearly presents material graphically. Easy to understand.
STAT200: Assignment #2 – Descriptive Statistics Analysis and Writeup – Instructions
Page 3 of 3
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