Homework 6 USING EXCEL

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

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

View Full Document Right Arrow Icon
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,”
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
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 Right Arrow Icon
Ask a homework question - tutors are online