BIOSTAT WITH LAB

Lab Assignment Part 2: Household Data Set Review

Part 1. Provide an answer for each question in the matrix listed below using HouseholdData.xls. Upload the completed template using the assignment link.

​​Provide at least one graph, chart, or figure to support your findings. For example, number of bedrooms per household.

​​​

Part 2. Analyze the data and statistics calculated for the community.

1. Construct and submit the table below using a 95% confidence interval for the proportion of households with a history of heart disease, separately for each race.  Would you say the proportion of households with history of heart disease differs by race? Hint. Confidence interval (CI) = p ± z(SE) where standard error (SE).

2. Provide SPSS code used to generate results for the Prevalence of Heart Disease table. Submit the table below with your results.

  https://assets.adobe.com/link/a8cb7f94-8dda-4f44-5265-439bf9af35ef  

Tips on how to handle SPSS syntax

How to copy/paste SPSS syntax

To open a new Syntax Editor window, click  File > New > Syntax or go to the drop down menu Click the Paste > OK/Run.

How to execute syntax commands

Execute (or  run) the commands, highlight the lines of code you want to run, then click  Run > Selection, or press Ctrl + R on your keyboard.

How to save a SPSS syntax files

Your SPSS syntax will save as an *.sps file while the Syntax Editor window is open and active, then click  File > Save or  File > Save As to save the syntax file.

How to open to an SPSS syntax file

To open a syntax file on your computer, click  File > Open > Syntax. You can do this from any open window (including the Data View or Output View). Or, think about using Microsoft Notepad to copy/paste your SPSS syntax.

Instructions

PBHE520: Assignment week #5: Lab Assignment Part 2:  Household Dataset 

For this assignment, students will complete Two Sections: Section One: Quantitative Analysis AND Section Two: Qualitative analysis. 

As a public health personnel, students will conduct a survey and collected economic and health data on households in a township that is known to have a high prevalence of heart disease. Before, you proceed with the data analysis be sure to review the video ( https://assets.adobe.com/link/a8cb7f94-8dda-4f44-5265-439bf9af35ef)   for additional instructions and relevant facts. To complete this lab assignment, students will use  SPSS' latest version describing results about heart disease. The  Household Data file (attached below) contains data for 100 households surveyed including race, household income, family size, home price, number of bedrooms, and family history of heart disease. Analyze the 100 survey (basic statistics) and

address the questions outlined in the video presentation. Hint: Let the questions drive the necessary analysis. You may need to perform a regression, correlation, or proportion analyses. 

Provide an answer for each question in the matrix listed below using HouseholdData.xls. Upload the completed template using the assignment link. You must use the lab template attached to this assignment. Provide at least one graph, chart, or figure to support your findings. For example, number of bedrooms per household 

Section One. Quantitative Analysis: Analyze the data and statistics calculated for the  community. 

1.  Construct and submit the table below using a 95% confidence interval for the proportion of households with a history of heart disease, separately for each race. Would you say the proportion of households with history of heart disease differs by race? Hint. Confidence interval (CI) = p ± z(SE) where standard error (SE). 

2. Provide SPSS code used to generate results for the Prevalence of Heart Disease table. Submit the table below with your results.  You must provide the SPSS code along with your output. 

Section Two: Qualitative Analysis: Using the Excel file column entitled “Patient Symptoms”, complete the following steps: 

1. Create themes based on the organ system affected – for example, chest pain would be related to cardiovascular system, stomach pain would be related to gastrointestinal system, etc. You may look up common symptoms for heart attack as well. 

2. Categorize the symptoms reported by each research participant according to the indicated themes. 

3. Determine the counts and proportions of relevant symptoms according to the various themes and identify the most relevant theme. 

4. Analyze your results to determine the numbers and proportions of subjects with a history of heart disease that had previous symptoms 

5. Summarize and present your results using Tables/bar charts. Comments on your results.

Assignment Instructions:

Please review the  Weekly Assignment Grading Rubric prior to submission (Select  View IRubric in the main Assignment List page).

Assignments are due in the Assignment portion of the classroom by  Sunday, 11:59 p.m. EST each week. Make sure you read and understand the directions and requirements for each Assignment. Please ensure you cite your references in APA format with a minimum of 3 references. Assignment will be graded based on the following areas: Foundation and synthesis of knowledge, application of knowledge critical thinking, writing skills, and organization of ideas and format. Refer to Library Online Resource Center for any research assistance.

Lab Assignment Part 2: Household Data Set Review

Part 1. Provide an answer for each question in the matrix listed below using HouseholdData.xls. Upload the completed template using the assignment link.

​​Provide at least one graph, chart, or figure to support your findings. For example, number of bedrooms per household.

​​​

Part 2. Analyze the data and statistics calculated for the community.

1. Construct and submit the table below using a 95% confidence interval for the proportion of households with a history of heart disease, separately for each race.  Would you say the proportion of households with history of heart disease differs by race? Hint. Confidence interval (CI) = p ± z(SE) where standard error (SE).

2. Provide SPSS code used to generate results for the Prevalence of Heart Disease table. Submit the table below with your results.

  https://assets.adobe.com/link/a8cb7f94-8dda-4f44-5265-439bf9af35ef  

Tips on how to handle SPSS syntax

How to copy/paste SPSS syntax

To open a new Syntax Editor window, click  File > New > Syntax or go to the drop down menu Click the Paste > OK/Run.

How to execute syntax commands

Execute (or  run) the commands, highlight the lines of code you want to run, then click  Run > Selection, or press Ctrl + R on your keyboard.

How to save a SPSS syntax files

Your SPSS syntax will save as an *.sps file while the Syntax Editor window is open and active, then click  File > Save or  File > Save As to save the syntax file.

How to open to an SPSS syntax file

To open a syntax file on your computer, click  File > Open > Syntax. You can do this from any open window (including the Data View or Output View). Or, think about using Microsoft Notepad to copy/paste your SPSS syntax.