Homework 6 USING EXCEL

# Homework 6 USING EXCEL - HW 6 Page 1 of 2 Homework 6. ANOVA...

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

HW 6 Page 1 of 2 Homework 6. ANOVA Analysis USING EXCEL Conduct data management & analyses 1. Generate pivot tables & pivot charts for the following sets of variables in your dataset: PHYS/MENTHLTH by (1) CHECKUP, (2) MSCODE, (3) SMOKESTAT, & (4) RACE5 To create Pivot Tables & Charts Put cursor in cell A1 Go to “Insert” & click on “PivotTable” Make sure the whole set of data is in range From the Pivot Table field list Check PHYS/MENTHLTH & put in “Values” box Choose the BY variable (e.g., CHECKUP) & put in the “Column Labels” box From the table Right click on first value in the “Total” row & choose “Summarize values by” & “Average” Change the value labels for HLTHPLAN Go to “Options” & click “Pivot Chart” Figure 1. Mean Days of Good Mental Health Related to Time Since Last Checkup Choose “Bar graph” & copy the graph & paste it in a Word document & save Insert a title & labels for the X axis & Y axis o Go to “Chart Tools,” “Layout,” “Chart Title,” & “Axis Title” Change the Y-axis values to 0 to 30 o Go to “Chart Tools,” “Layout,” “Axes,” “Primary Vertical Axis,” “More Primary Vertical Axis Options,” & 2. Separate the data for PHYS/MENTHLTH FOR EACH LEVEL of the following variables to make new variables: (1) CHECKUP, (2) MSCODE, (3) SMOKESTAT, & (4) RACE5 To create new variables : Sort the dataset by the variable of interest (e.g., CHECKUP) from the “Home” page by clicking on “Sort & Filter,”

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.

## 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 6 USING EXCEL - HW 6 Page 1 of 2 Homework 6. ANOVA...

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

View Full Document
Ask a homework question - tutors are online