Homework 1.
Frequency Tables & Graphs
Generate
Generate pivot tables & pivot charts for the following sets of variables in your dataset:
Set 1:
PHYSHLTH/MENTHLTH as raw data & class intervals
Set 2:
BMI as raw data & class intervals
Set 3:
AGE & AGE6
Set 4:
RACE5 & RACE2
Writeup
For each set of variables of above, write up the similarities & differences of the distributions related to the following
characteristics (as discussed in class) based on the Pivot Tables & Pivot Charts 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 16)
5. Patterns in data & frequency
distributions
section “Patterns in Data”
Turn in
For each set of variables, pivot tables, pivot charts, & write ups of similarities & differences.
How To: Pivot Tables & Pivot Charts
Pivot Tables & Examples
Put cursor in cell A1
o
Go to “Insert”
&
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '09
 STACY
 mental health, Frequency distribution, pivot tables, pivot charts, Alabama Mental Health, Pivot Charts Pivot

Click to edit the document details