+1(978)310-4246 credencewriters@gmail.com
  

Description

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-Annual Expenditures
USD-Housing
USD-Electricity
Sixth Column
Seventh Column
Eighth Column
USD-Water
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 59 years old, has an annual household income of $94,929, a family size of 2, annual expenditures of
$55,247, and spends $18,483 on housing, $1,451 on electricity, and $546 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
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
94929
96621
96664
96522
96697
96727
94867
96690
97469
96886
95744
96572
95366
97912
96928
114051
106627
109312
103144
111195
112559
97835
100693
95385
100350
95922
96207
97663
100565
97977
SE-AgeHeadHousehold
SE-FamilySize
59
54
53
43
49
39
60
57
35
44
52
59
48
49
43
42
56
37
29
30
39
30
42
50
31
55
27
51
18
44
2
2
3
4
2
2
1
2
4
2
4
2
2
1
3
5
3
6
5
5
3
5
2
4
5
3
3
3
3
2
USD-AnnualExpenditures
55247
55746
55558
56152
56453
56440
55512
56097
54929
55321
55963
56515
57082
55704
55932
84486
82676
80801
75393
80865
80934
77765
73294
74110
73771
72228
74620
72971
69203
73198
USD-Housing
18483
18149
18502
18483
18520
18376
18633
18334
18514
18312
18435
18648
18576
18619
18701
25728
22414
25392
26322
25018
25531
27949
26102
22847
26853
22996
28491
23150
27950
22990
USD-Electricity
1451
1455
1478
1457
1469
1441
1485
1453
1451
1450
1465
1480
1478
1450
1479
1452
1688
1514
1386
1481
1504
1297
1354
1302
1405
1326
1310
1320
1358
1298
USD-Water
546
540
553
537
545
542
523
535
565
523
555
552
538
553
520
818
709
743
626
796
794
641
597
684
585
674
588
689
626
696
University of Maryland University College
STAT200 – Assignment #2: Descriptive Statistics Analysis and Writeup
Identifying Information
Student (Full Name):
Class:
Instructor:
Date:
Remove all red-text instructions from this template prior to submission. Save the file as a word
document or pdf with the title “Last Name, First Name – Assignment 2” (do not submit a rtf file).
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
Variable 1: “Income”
Description
Annual household income in
USD.
Type of Variable (Qualitative or
Quantitative)
Quantitative
Variable 2:
Variable 3:
Variable 4:
Variable 5:
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:
STAT200: Assignment #2 – Descriptive Statistics Analysis Writeup – Template
Page 1 of 3
Variable 1: Income
Numerical Summary.
Table 2. Descriptive Analysis for Variable 1
Variable
n
Measure(s) of Central Tendency
Variable: Income
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
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
n
Measure(s) of Central Tendency
Measure(s) of Dispersion
Variable:
STAT200: Assignment #2 – Descriptive Statistics Analysis Writeup – Template
Page 2 of 3
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
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
Measure(s) of Central Tendency
Measure(s) of Dispersion
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: Assignment #2 – Descriptive Statistics Analysis Writeup – Template
Page 3 of 3
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.
NOTE: You will use the same data set provided for Written Assignment 1.
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.
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.
STAT200: Assignment #2 – Descriptive Statistics Analysis and Writeup – Instructions
Page 1 of 3
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 as
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 (count)
Measure(s) of Central Tendency
Measure(s) of Dispersion
Variable Name
• Graph and/or Table. Put the graph or table for the variable in this section.
• 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.
STAT200: Assignment #2 – Descriptive Statistics Analysis and Writeup – Instructions
Page 2 of 3
Assignment Submission: Save the file that contains your completed “Assignment #2:
Descriptive Statistics Analysis Writeup Template” as a pdf or docx using the following naming
format: “Last Name, First Name – Assignment2.”
Submit it via the Assignments area in the LEO classroom in the “Assignment #2: Descriptive
Statistics Analysis Writeup” folder.
NOTE: Before submitting your written assignment, remove any instructors that were included
in the template. Your instructor knows the instructions, so he/she does NOT need it included
in your report.
Think of your write-up as a final report you are submitting to your boss at work. Would you
leave extraneous information in a final report at work? Specifically, there should be no “(Place
Histogram here)” statements in your submission.
Grading Rubric for Assignment #2
Your instructor will use this grading rubric when grading your assignment submission:
Introduction
10%
Description of data set and method(s) used for analyzing the data
10%
Results. For each variable (10% for each variable):
● Numerical Summary: Accurate/appropriate results reported in table.
● Graph and/or Table: Accurate/appropriate graph or table.
● Findings:
50%
â—‹ 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.
Writes clearly, concisely, and with few errors.
Clearly presents material graphically. Easy to understand.
20%
10%
STAT200: Assignment #2 – Descriptive Statistics Analysis and Writeup – Instructions
Page 3 of 3

Purchase answer to see full
attachment

  
error: Content is protected !!