STAT200 - Assignment #2: Descriptive Statistics Analysis and Writeup
STAT200: Assignment #2 - Descriptive Statistics Analysis Writeup - Template Page 3 of 3 University of Maryland University College STAT200 - Assignment #2: Descriptive Statistics Analysis and Writeup Identifying Information Student (Full Name): Tyrell Cook Class: STAT 200 6381 Instructor: Jose Martinez Castillo Date: 13 Sep 2019 Introduction: I am a 30-year-old, married man with an associate degree and a three-family household. My income is $106,906. The four variables selected are SE-Marital Status, SE- Family size, USD-Food, and USD- Meat. 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: “Marital Status” Marital Status of Head of Household Qualitative Variable 3: “Family Size” Total Number of people in Family (Both Adults and Children) Quantitative Variable 4: “Food” Total Amount of Annual Expenditures on Food Quantitative Variable 5: “Fruit” Total Amount of Annual Expenditures on Fruit Quantitative 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 2 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 Total 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-Food Sixth Column Total Amount of Annual Expenditures on Food Amount in US Dollars USD-Meat Seventh Column Total Amount of Annual Expenditure on Meat Amount in US Dollars USD-Bakery Eighth Column Total Amount of Annual Expenditure on Bakery Amount in US Dollars USD-Fruits Ninth Column Total Amount of Annual Expenditure on Fruit 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 food expenditures of $7,040, and spends $906 on meat, $353 on bakery items, and $753 on fruit. UniqueID# SE-MaritalStatus SE-Income SE-AgeHeadHousehold SE-FamilySize USD-Food USD-Meat USD-Bakery USD-Fruits 1 Not Married 95744 52 4 7040 906 353 753 2 Not Married 94867 60 1 6935 918 351 746 3 Not Married 96244 56 4 7073 918 338 773 4 Not Married 98717 40 3 7036 889 348 768 5 Not Married 96697 49 2 6971 898 357 779 6 Not Married 96886 44 2 6982 917 359 752 7 Not Married 94929 59 2 6948 899 345 771 8 Not Married 96653 51 4 6943 880 352 781 9 Not Married 96928 43 3 6953 887 343 759 10 Not Married 96522 43 4 6991 922 349 758 11 Not Married 96572 59 2 7179 880 353 744 12 Not Married 96621 54 2 7000 911 344 768 13 Not Married 96690 57 2 6822 880 349 764 14 Not Married 96664 53 3 7051 906 346 772 15 Not Married 95366 48 2 7130 904 344 760 16 Married 100947 35 4 8455 910 415 1001 17 Married 114505 36 5 11375 1368 537 1124 18 Married 95865 46 1 9321 1159 447 1006 19 Married 95835 54 3 9111 1098 452 1027 20 Married 100350 31 5 9044 1015 407 1142 21 Married 113558 31 5 10346 1343 515 1122 22 Married 95706 52 4 8925 1207 454 1003 23 Married 106906 51 3 11356 1434 493 1286 24 Married 109377 48 4 10575 1492 517 1096 25 Married 102081 42 4 11738 1348 484 1379 26 Married 103001 34 4 8947 864 427 951 27 Married 110553 23 4 10575 1346 531 1090 28 Married 106977 56 3 10611 1320 546 1120 29 Married 101890 48 2 11089 1481 541 1157 30 Married 100565 18 3 8479 893 370 1068 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 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 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