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