Assignment #2: Descriptive Statistics Analysis and Writeup

# Assignment #2: Descriptive Statistics Analysis and Writeup

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.

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-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 3 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.

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: ○ 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.

50%

Discussion and Conclusion. Described results and provided answers to questions about expenditures.

20%

Writes clearly, concisely, and with few errors.

Clearly presents material graphically. Easy to understand.

10%

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-Food Seventh Column Total Amount of Annual Expenditure on Food Amount in US Dollars USD-Entertainment Eighth Column Total Amount of Annual Expenditure on

Entertainment Amount in US Dollars

USD-Education Ninth Column Total Amount of Annual Expenditure on Education

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 52 years old, has an annual household income of \$95,744, a family size of 4, annual expenditures of \$55,963, and spends \$7,040 on food, \$105 on entertainment, and \$340 on education.

UniqueID# SE-MaritalStatus SE-Income SE-AgeHeadHousehold SE-FamilySize USD-AnnualExpenditures USD-Food USD-Entertainment USD-Education 1 Not Married 95744 52 4 55963 7040 105 340 2 Not Married 95432 51 1 55120 7089 84 274 3 Not Married 96727 39 2 56440 7051 93 222 4 Not Married 96621 54 2 55746 7000 106 322 5 Not Married 96572 59 2 56515 7179 95 349 6 Not Married 98717 40 3 56393 7036 106 213 7 Not Married 96697 49 2 56453 6971 86 186 8 Not Married 96653 51 4 56488 6943 90 212 9 Not Married 97912 49 1 55704 6937 97 277

10 Not Married 96928 43 3 55932 6953 105 273 11 Not Married 96244 56 4 56051 7073 114 261 12 Not Married 97681 53 4 56124 7097 108 263 13 Not Married 96522 43 4 56152 6991 101 237 14 Not Married 95366 48 2 57082 7130 90 305 15 Not Married 94867 60 1 55512 6935 87 272 16 Married 108781 52 5 83231 11795 178 689 17 Married 95706 52 4 71597 8925 121 475 18 Married 106627 56 3 82676 10363 179 794 19 Married 97303 27 4 76134 8634 22 16 20 Married 97663 51 3 72971 9294 108 454 21 Married 100947 35 4 73973 8455 96 2 22 Married 100837 42 5 73849 8633 209 53 23 Married 93901 43 2 74254 9157 132 468 24 Married 100964 28 2 77744 9397 174 11 25 Married 95385 50 4 74110 9101 119 454 26 Married 95994 55 4 73404 9231 150 468 27 Married 103144 29 5 75393 8902 163 36 28 Married 111478 29 5 82699 10740 82 334 29 Married 95865 46 1 74789 9321 133 478 30 Married 114932 44 5 81186 11077 80 111

• Assignment #2_ Instructions for Descriptive Statistics Analysis and Writeup
• dataset