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 1 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 2 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. Grading Rubric for Assignment #2 Introduction 10% Description of data set and method(s) used for analyzing the data 10% Results. For each variable (10% for each variable): 50% ● 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. Discussion and Conclusion. Described results and provided answers to questions about expenditures. 20% Writes clearly, concisely, and with few errors. 10% Clearly presents material graphically. Easy to understand. STAT200: Assignment #2 - Descriptive Statistics Analysis and Writeup - Instructions Page 3 of 3 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 53 years old, has an annual household income of $97,681, a family size of 4, annual expenditures of $56,124, and spends $18,676 on housing, $1,468 on electricity, and $551 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 97681 96727 95432 96928 94929 95744 95366 96697 96572 96653 96664 96621 96886 96244 94867 98351 109312 111478 107511 95835 110553 95706 110651 98491 99610 97663 115766 107235 106627 109523 SE-AgeHeadHousehold SE-FamilySize USD-AnnualExpenditures 53 39 51 43 59 52 48 49 59 51 53 54 44 56 60 34 37 29 56 54 23 52 58 22 36 51 41 38 56 37 4 2 1 3 2 4 2 2 2 4 3 2 2 4 1 3 6 5 3 3 4 4 4 3 2 3 4 6 3 5 56124 56440 55120 55932 55247 55963 57082 56453 56515 56488 55558 55746 55321 56051 55512 76558 80801 82699 83347 73092 81419 71597 83766 75996 73550 72971 83448 83471 82676 84002 USD-Housing 18676 18376 18391 18701 18483 18435 18576 18520 18648 18838 18502 18149 18312 18484 18633 26513 25392 24949 22915 23252 26991 22376 22899 26283 27164 23150 25679 26074 22414 26771 USD-Electricity 1468 1441 1458 1479 1451 1465 1478 1469 1480 1470 1478 1455 1450 1457 1485 1342 1514 1503 1723 1300 1421 1315 1682 1326 1330 1320 1511 1486 1688 1457 USD-Water 551 542 548 520 546 555 538 545 552 535 553 540 523 539 523 547 743 814 773 705 719 694 754 620 627 689 767 769 709 768
Purchase answer to see full attachment