Homework 5 USING EXCEL - HW 5 Page 1 of 2 Homework 5....

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

View Full Document Right Arrow Icon
HW 5 Page 1 of 2 Homework 5. Independent t -Test 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 HLTHPLAN PHYS/MENTHLTH by RACE2 PHYS/MENTHLTH by BINGEDRINK PHYS/MENTHLTH by HEAVYDRINK 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., HLTHPLAN) & 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” 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,” & then change “Minimum” to 0 & “Maximum” to 30 Figure 1. Mean Days of Good Health for Participants with & without Health Plans in Alabama 2. Separate the data for PHYS/MENTHLTH into the following 8 new variables: o Separate HLTHPLAN into “No health plan PHYS/MENTHLTH” & “Yes health plan PHYS/MENTHLTH”
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 at Austin.

Page1 / 2

Homework 5 USING EXCEL - HW 5 Page 1 of 2 Homework 5....

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