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 writeup 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: Writeup findings using the Provided Template
For this part of the assignment, write a short 23 page writeup 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: “Assignment2StudentLastName.”
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 selfreported 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 130
SEMaritalStatus
SEIncome
SEAgeHeadHousehold
SEFamilySize
Second Column
Third Column
Fourth Column
Fifth Column
Not Married/Married
Amount in US Dollars
Age in Years
Number of People in Family
USDAnnual Expenditures
USDHousing
USDElectricity
Sixth Column
Seventh Column
Eighth Column
USDWater
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 Housing
Total Amount of Annual Expenditure on
Electricity
Total Amount of Annual Expenditure on Water
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: the head of household is not married and is 53 years old, has an annual household income of $97,681, a family size of 4, annual expenditures of
$56,124, and spends $18,676 on housing, $1,468 on electricity, and $551 on water.
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
SEMaritalStatus
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
SEIncome
97681
96727
95432
96928
94929
95744
95366
96697
96572
96653
96664
96621
96886
96244
94867
98351
109312
111478
107511
95835
110553
95706
110651
98491
99610
97663
115766
107235
106627
109523
SEAgeHeadHousehold
SEFamilySize
USDAnnualExpenditures
53
39
51
43
59
52
48
49
59
51
53
54
44
56
60
34
37
29
56
54
23
52
58
22
36
51
41
38
56
37
4
2
1
3
2
4
2
2
2
4
3
2
2
4
1
3
6
5
3
3
4
4
4
3
2
3
4
6
3
5
56124
56440
55120
55932
55247
55963
57082
56453
56515
56488
55558
55746
55321
56051
55512
76558
80801
82699
83347
73092
81419
71597
83766
75996
73550
72971
83448
83471
82676
84002
USDHousing
18676
18376
18391
18701
18483
18435
18576
18520
18648
18838
18502
18149
18312
18484
18633
26513
25392
24949
22915
23252
26991
22376
22899
26283
27164
23150
25679
26074
22414
26771
USDElectricity
1468
1441
1458
1479
1451
1465
1478
1469
1480
1470
1478
1455
1450
1457
1485
1342
1514
1503
1723
1300
1421
1315
1682
1326
1330
1320
1511
1486
1688
1457
USDWater
551
542
548
520
546
555
538
545
552
535
553
540
523
539
523
547
743
814
773
705
719
694
754
620
627
689
767
769
709
768
Purchase answer to see full
attachment