Homework 2 - Descriptive Statistics& Examples Go to...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework 2. Descriptive Statistics for Quantitative Variables Conduct Conduct descriptive statistics in Excel for the following variables in your dataset: 1. PHYSHLTH/MENTHLTH 2. SLEEP 3. BMI 4. DRINK30 5. EMTSUPRT 6. LSATISFY Write-up For each variable above, write up the following characteristics of the distributions (as discussed in class) based on the Excel descriptive statistics you generated. Center Spread Shape Unusual features To find descriptions of “Center,” “Spread,” “Shape,” & “Unusual Features,” refer to: - Course Documents Section 1. Intro & Descriptive Stats (weeks 1-6) 5. Patterns in data & frequency distributions section “Patterns in Data” Turn in The Excel-generated descriptive statistics & the write-ups. How To: Descriptive Statistics in Excel
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Descriptive Statistics & Examples Go to “Data,” click on “Data Analysis,” & then choose “Descriptive Statistics” Click into the “Input Range” box & then highlight the column for the variable of interest Choose “Labels in first row” & “Summary statistics” Copy & save output to another file & save MENTHLTH Mean 26.30119 Standard Error 0.298532 Median 30 Mode 30 Standard Deviation 8.213691 Sample Variance 67.46472 Kurtosis 4.409188 Skewness -2.37363 Range 30 Minimum 0 Maximum 30 Sum 19910 Count 757 Example Write Up ‘The results for mental health in Alabama (Table 1) indicate that it is unimodal with the peak at 30 days, leptokurtic, asymmetrical, and skewed negatively.’ Descriptive Statistics from Excel...
View Full Document

This note was uploaded on 01/18/2012 for the course SSC 304 taught by Professor Stacy during the Fall '09 term at University of Texas.

Page1 / 2

Homework 2 - Descriptive Statistics& Examples Go to...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online