STAT200: Assignment #2 - Descriptive Statistics Analysis and Writeup - Instructions Page 1 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.

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 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 2 of 3

Step #3: Write-up findings using the Provided Template

For this part of the assignment, write a short 2 to three 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:

University of Maryland University College

STAT200 - Assignment #2: Descriptive Statistics Analysis and Writeup

Identifying Information

Student (Full Name):

Class:

Instructor:

Date:

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:

Variable 3:

Variable 4:

Variable 5:

Data Set Description and Method Used for Analysis:

Results:

Variable 1: Income

Numerical Summary.

Table 2. Descriptive Analysis for Variable 1

Variable

n

Measure(s) of Central Tendency

Measure(s) of Dispersion

Variable: Income

Median=

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:

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.

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 two 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

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-Annual Expenditures

Sixth Column

Total Amount of Annual Expenditures

Amount in US Dollars

USD-Housing

Seventh Column

Total Amount of Annual Expenditure on Housing

Amount in US Dollars

USD-Electricity

Eighth Column

Total Amount of Annual Expenditure on Electricity

Amount in US Dollars

USD-Water

Ninth Column

Total Amount of Annual Expenditure on Water

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#

SE-MaritalStatus

SE-income

SE-AgeHeadHousehold

SE-FamilySize

USD-AnnualExpenditures

USD-Housing

USD-Electricity

USD-Water

1

Not Married

94929

59

2

55247

18483

1451

546

2

Not Married

96621

54

2

55746

18149

1455

540

3

Not Married

96664

53

3

55558

18502

1478

553

4

Not Married

96522

43

4

56152

18483

1457

537

5

Not Married

96697

49

2

56453

18520

1469

545

6

Not Married

96727

39

2

56440

18376

1441

542

7

Not Married

94867

60

1

55512

18633

1485

523

8

Not Married

96690

57

2

56097

18334

1453

535

9

Not Married

97469

35

4

54929

18514

1451

565

10

Not Married

96886

44

2

55321

18312

1450

523

11

Not Married

95744

52

4

55963

18435

1465

555

12

Not Married

96572

59

2

56515

18648

1480

552

13

Not Married

95366

48

2

57082

18576

1478

538

14

Not Married

97912

49

1

55704

18619

1450

553

15

Not Married

96928

43

3

55932

18701

1479

520

16

Married

114051

42

5

84486

25728

1452

818

17

Married

106627

56

3

82676

22414

1688

709

18

Married

109312

37

6

80801

25392

1514

743

19

Married

103144

29

5

75393

26322

1386

626

20

Married

111195

30

5

80865

25018

1481

796

21

Married

112559

39

3

80934

25531

1504

794

22

Married

97835

30

5

77765

27949

1297

641

23

Married

100693

42

2

73294

26102

1354

597

24

Married

95385

50

4

74110

22847

1302

684

25

Married

100350

31

5

73771

26853

1405

585

26

Married

95922

55

3

72228

22996

1326

674

27

Married

96207

27

3

74620

28491

1310

588

28

Married

97663

51

3

72971

23150

1320

689

29

Married

100565

18

3

69203

27950

1358

626

30

Married

97977

44

2

73198

22990

1298

696