Data Analysis: Descriptive Statistics (Statistics Project Sample)

Data Analysis Using Excel: Descriptive Statistics 1. Identify two continuous variables in the dataset. Calculate and report the appropriate statistics for all of these variables, as specified in the lecture. Report the statistics following the example below. Continuous variable (income) example: Respondents’ income ranged from $27,000 to $153,000 (M = $62,000, s.d. =$12,062.92). 2. Identify two nominal variables in the output. Calculate and report the appropriate statistics for these variables, as specified in the lecture. Report the statistics following the example below. Nominal Variable Example: Results indicated that 52% (n = 146) of respondents were Republican, 40% (n = 112) were Democrat, and 8% (n = 22) were Independent. 3. Identify two ordinal variables in the output. Report the appropriate statistics for thesevariables, as specified in the lecture. Report the statistics following the example below. Ordinal Variable Example – Results indicated that 34% (n =130) of respondents were very satisfied with their lives, 23% (n = 89) were satisfied, and 98% (n = 26) were neutral, 10% (n =38) were unsatisfied, and just 6% (n =25) were very unsatisfied. 4. Do any of the variables show data entry errors? If so, which one(s)? How do you know there is a data entry error? Data Analysis Using Excel: Descriptive Statistics 5. Based on you interpretation of the data, do respondents think social workers are beneficial? Support your answer with the data. Should this be interpreted with caution? Why or why not? 6. Based on your interpretation of the data, how useful were the resources provided to people who have received services? Support your answer with the data. Should this data be interpreted with caution? Why or why not? 7. Describe the distributions of the continuous variables. Are they normal? Are any of them skewed positively or negatively? If they are skewed, how do you know they are skewed?