Pivot Table
File Pivot Tables.pptx (39.288 KB)
File HED 280 Healt.h Attitudes Surveypdf (550.762 KB)
File HED 280 Health Attitudes Survey Responses (Raw Data).xlsx (24.275 KB)
Assignment #10 involves analyzing the survey data collected by the HED 280 Health Attitudes Survey. We will use Google Spreadsheets (Google Sheets) to analyze our data. Specifically, you will analyze the variables identified in your research question and hypothesis and create pivot tables in Google Sheets to display the data related to your research question. Remember, your research question addresses your topic of interest from the Q1 of the Rand Survey. Assume survey participants are all from your neighborhood. The attached PDF document provides overall descriptive statistics (summary of the data) for the survey we administered. This link gives you access to the raw data to be used for creating Pivot tables. This link takes you to a YouTube video that describes how to create Pivot tables. I’ve attached the MS Excel file for those of you would prefer to use Excel over Google Spreadsheets. I’ve also attached a PPT slide with the required steps.
What I want you to do: Analyze the data collected by the HED 280 Health Attitudes Survey. Summarize demographic data, 3-4 survey responses from the PDF, and create at least one Pivot table from the raw data comparing your research topic to a demographic variable.
Why I want you to do it: Data analysis allows us to uncover valuable insights and patterns from raw data. Data analysis leads to informed decisions, effective public health programs, and improved health outcomes. Most occurpations require you to be comfortable with data use and analysis of some kind.
How I want you to do it: Access the raw data and save a copy by clicking on File–>Make A Copy, save the copied Google Sheets under your name or use the attached Excel file of the raw data. Locate the data connected to your research question’s dependent variable and independent (demographic) variable. Using insights from the video and our class discussion, 1) summarize the survey’s deomgraphic data, 2) describe 3-4 question responses from the overall data, and 3) create at least one Pivot table focused on your specific research topic. Use Snipping Tool to create an image of your table that you can paste into a WORD document. Attach your three responses as a WORD or PDF document.
the attitude survey and be access from previous order. but I will send a link in the order message