PUB550 Application and Interpretation of Public Health Data
Week 2 Assignment
Descriptive Statistics in Excel
Surveys are often used to gather public health information or data. The first step in analyzing the survey data is to conduct descriptive statistics. Descriptive statistics help provide basic information about the sample group, such as the average age and average income. This information can then be analyzed to effectively measure and describe a population’s health status, behavior, and associated risk factors in relation to these variables.
The purpose of this assignment is to use Excel to apply descriptive statistics in order to describe the sample who completed a health behavior survey. Use the “Health Behavior Data Set” and the “Descriptive Statistics in Excel Worksheet” to complete this assignment. Refer to the instructional videos in the topic Resources as a guide.
For this assignment:
Use the “Data Analysis ToolPak” add-in and Pivot Tables to complete this assignment. Refer to the “Data Analysis ToolPak” resource, located in the topic Resources. Click on the link and select either Windows or Mac for instructions. The Microsoft Excel add-in will enable you to conduct descriptive statistics in Excel.
Read the “Health Behavior Case History and Survey” document to familiarize yourself with the survey and its purpose. You do not need to complete or submit the survey. It is for informational purposes only.
Open the “Health Behavior Data Set” in the Excel. Analyze the survey data and answer the questions in the “Descriptive Statistics in Excel Worksheet.”
Submit the “Descriptive Statistics in Excel Worksheet” to the assignment dropbox.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
PUB550 Application and Interpretation of Public Health Data
Week 3 Assignment
Introduction to SPSS
SPSS is a software that can conduct basic and complex statistical analyses. In this assignment, you will use SPSS to explore the data and conduct descriptive statistics, create frequency charts, recode variables, and create new variables.?
For this assignment, utilize SPSS Statistics and the “Health Behavior Data Set.”
Refer to the topic Resources for assistance with accessing and using SPSS.
Follow the steps below to complete the assignment.
Part 1
Import the Excel file into SPSS.
Sort by age in SPSS to determine the age-range of participants in the data set.
Use the Descriptive Statistics Feature in SPSS to find the mean and standard deviation for the “Age” and “Annual Income.”
Use the “Frequencies” feature to create frequency tables for the employed, education level and sex variables.
Recode the sex variable where “Male”=1 and “Female”=2. Create a frequency table for the new variable.
Compute a new “BMI” variable based on “Weight” and “Height.” Use the Descriptive Statistics Feature in SPSS to find the mean and standard deviation for the new BMI variable.
Part 2
In 200-250 words, compare Excel and SPSS. Discuss specific SPSS software features that make it preferable to Excel for data management. Provide examples illustrating when electing to use SPSS could be preferable to Excel in regard to analyzing survey data.
General Requirements
?Submit the SPSS exported output and the 200–250-word Excel and SPSS comparison to the assignment dropbox.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
PUB550 Application and Interpretation of Public Health Data
Week 4 Assignment
Application of the Pearson Correlation and Chi-Square Test
The chi-square test of independence is used to determine whether two or more samples of cases differ on a nominal level variable. A Pearson correlation is used to determine the relationship between two continuous variables. Both the chi-square test of independence and correlation are widely used in the analysis of public health data.
The purpose of this assignment is to practice calculating and interpreting the Pearson correlation coefficient and a chi-square test of independence. After analyzing the data, communicate the results of one of the tests in a PowerPoint presentation. Refer to the Using and Interpreting Statistics: A Practical Text for the Behavioral, Social, and Health Sciences textbook and instructional videos for assistance completing this assignment.
Part 1
Use SPSS “Health Behavior Data Set” and complete the following:
Conduct a Pearson correlation to determine the relationship between age and annual income.
Conduct a chi-square test to determine the relationship between sex and smoking status.
Export the SPSS output for the Pearson correlation and chi-square tests.
Part 2
Create an 8-10-slide PowerPoint presentation to discuss the findings for either the chi-square or correlation. Create a voice-over or a video presentation that is 5-7 minutes in length. Your slides should be shown on the screen as you present. Loom may be used (you must use your GCU email address to access all of the features for Loom). Other options are Zoom or the recording feature in PowerPoint. Include an additional slide for the link with your selected method of presentation at the beginning and an additional slide for references at the end.
Include the following.
Include the following:
Explain why the statistical test is most appropriate for analyzing the data and whether the assumptions were met.
What are the null and alternative hypotheses for this specific scenario?
What is the critical value? What is the decision rule?
Per the output, what is the test statistic and p-value?
How do you interpret the results? (What was done? What was found? What does it mean? What suggestions are there for the creation of a health promotion intervention?)
General Requirements
Submit the SPSS exported output (Part 1) and the PowerPoint presentation (Part 2) to the assignment dropbox.
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
PUB550 Application and Interpretation of Public Health Data
Week 5 Assignment
Application of the t-Test
The Youth Risk Behavior Survey (YRBSS) is a national survey monitoring health behavior among youth and young adults. It is administered by the Centers for Disease Control and Prevention (CDC). For this assignment, use the “Youth Risk Behavior Surveillance System Dataset” provided to practice calculating and interpreting the t-test. Refer to the instructional videos in the topic Resources and the Using and Interpreting Statistics: A Practical Text for the Behavioral, Social, and Health Sciences textbook as a guide.
Part 1
Refer to the topic Resources to review the documentation, questionnaires, and general information pertaining to the YRBS. Then use the 2019 “Youth Risk Behavior Surveillance System Dataset” and conduct a two-sample t-test to determine if weight (in kg) differs by sex.
Part 2
Create an 8-10-slide PowerPoint presentation to discuss the findings for either the chi-square or correlation. Create a voice-over or a video presentation that is 5-7 minutes in length. Your slides should be shown on the screen as you present. Loom may be used (You must use your GCU email address to access all the features for Loom). Other options are Zoom or the recording feature in PowerPoint. Include an additional slide for the link with your selected method of presentation at the beginning and an additional slide for references at the end.
Include the following:
Explain why the t-test you chose is most appropriate for analyzing the data and whether the assumptions were met.
What are the null and alternative hypotheses for this scenario?
What is the critical value? What is the decision rule?
Per the output, what is the test statistic and p-value?
Interpretation of the t-test results (What was done? What was found? What does it mean? What suggestions are there for the creation of a health promotion intervention?).
General Requirements
Make sure to unzip your data set before importing to SPSS and completing the analysis. Submit the SPSS exported output (Part 1) and the PowerPoint (Part 2) to the assignment dropbox.
While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
PUB550 Application and Interpretation of Public Health Data
Week 7 Assignment
Coding Qualitative Data
The purpose of this assignment is to practice interpreting qualitative interview transcripts by recognizing patterns. This is called coding and it is an important skillset for public health professionals.
For this assignment, code the “Interview Transcript” document. Use the “Coding Qualitative Data Worksheet” to document your results from the “Interview Transcript” and to provide a summary of your findings.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
PUB550 Application and Interpretation of Public Health Data
Week 8 Assignment
Benchmark – Analyzing and Reporting Data
Complete this assignment according to the directions provided below.
Overview
The use of quantitative and qualitative data in a single study is referred to as a mixed methods approach. The quantitative survey data help to identify health-related trends and patterns within the sample group. Qualitative data complement the quantitative element and help to determine why and how a phenomenon exists. The cumulative findings can then help public health professionals form a conclusion about the health issue and inform future public health research, policy, and practice. The content that you create for this assignment is similar to the steps you would take as a public health professional to create and disseminate a manuscript for publication.
In this assignment, you will conduct a retrospective analysis of the publicly available Titanic Datasets. The purpose of this assignment is to analyze qualitative and quantitative data to answer the following research question: What were the causes/mechanisms that led individuals on the Titanic to survive or perish? Examples of explanatory variables that may lead to higher probability of surviving on the Titanic are class, gender, physical strength, social ties, cabin location, etc.
Please note there is inherent bias in those who provided a testimony, because it only includes those that survived.
Background Information
The Titanic hit an iceberg on April 14, 1912, at 11:40 p.m. and sunk completely about 2 hours and 40 minutes later.
A total of 2207 individuals were on board at the time of the collision and only 710 survived, despite the fact that the lifeboats could have saved 1178, so they had been used at only 60% of their capacity.
The survival rates of individuals differed greatly according sex, classes, and types of crew.
For this assignment, you will use:
The quantitative Titanic dataset.
Qualitative testimonials from either Boat 1, 6, or 16.
Note: You will conduct the analyses for Parts 1 and 2. You will then use this information to write Part 3: Mixed Methods Paper
Part 1: Quantitative Analysis
Review the “Quantitative Titanic Dataset” and the accompanying “Codebook.” Consider what descriptive and inferential statistics you will conduct to help answer the research question.
Prepare the data to complete the analysis.
Using SPSS, conduct descriptive statistics to summarize the sample.
Using SPSS, select appropriate quantitative inferential statistical tests to analyze the data to answer the research question.
Part 2: Qualitative Analysis:
Select testimonials from one boat to review by using the Boat 1, Boat 6, or Boat 16 zip files.
Based on your findings in Part 1 (Quantitative Analysis), read and review testimonials from the boat. Code the transcripts and identify at least three key themes.
Part 3: Mixed Methods Paper
Prepare a 1,250-1,500-word paper to address the following. Headers should be used based on the component structure outlined below:
Introduction
Discuss the relationship between socioeconomic status and health from a general perspective.
Summarize the purpose of this research study and the proposed research question.
Quantitative Analysis
Methods
Describe the variables used in the analysis.
Describe the descriptive and inferential statistical tests that was conducted.
Identify the software that was used to conduct the analysis.
Results
Summarize the sample using the results of the descriptive statistics.
Describe the main outcomes of the inferential statistical analysis. Discuss the statistical significance of the results.
Include at least two tables and two figures to support the results.
Qualitative Analysis
Methods
Describe the process used to analyze the qualitative data.
Results
Summarize the results of the qualitative analysis from the selected boat testimonials. Discuss at least three key themes.
Discuss what methods you would employ to analyze the remaining transcripts from all 20 boats/vessels.
Discussion
Interpret the quantitative and qualitative study results in relation to the related literature and research question.
Explain what implications this has on future public health policy and programs.
Discuss the overall study limitations.
General Requirements
You are required to cite to a minimum of three sources to complete this assignment. Sources must be published within the last 5 years and appropriate for the assignment criteria and public health content.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
Benchmark Information
This benchmark assignment assesses the following programmatic competencies:
MPH
2.2: Select quantitative and qualitative data collection methods appropriate for a given public health context.
2.3: Analyze quantitative and qualitative data using biostatistics, informatics, computer-based programming, and software, as appropriate.
2.4: Interpret results of data analysis for public health research, policy, or practice.
MSN Public Health Nursing
6.3: Interpret results of data analysis for public health research, policy, or practice.
