**PUB550 Application and Interpretation of Public Health Data**

**Week 1 Discussion**

DQ1

Statistics is an important component of public health. Explain the relevance of statistics in the planning, implementation, and evaluation of a health promotion intervention. How do you envision using statistics in your current or future career?

DQ2

Describe the difference between quantitative and qualitative methods. Explain how each are used in public health.

**PUB550 Application and Interpretation of Public Health Data**

**Week 2 Discussion**

DQ1

List three methods for collecting public health data. For each, provide a brief description and discuss the advantages and disadvantages of the approach.

DQ2

The mean, median, and mode are measures of central tendency. Explain why these measures are crucial to public health data analysis.

**PUB550 Application and Interpretation of Public Health Data**

**Week 3 Discussion**

DQ1

Summarize the six steps of hypothesis testing. Propose a scenario in which hypothesis testing is applied to public health data.

DQ2

Compare descriptive and inferential statistics. Discuss why both descriptive and inferential statistics are used in the analysis of public health data.

**PUB550 Application and Interpretation of Public Health Data**

**Week 4 Discussion**

DQ1

Correlation is a common statistic to measure a general linear relationship between two variables. Explain why correlation does not equal causation.

DQ2

Explain the differences between parametric and nonparametric tests. How do you determine if a parametric or nonparametric test should be used when analyzing data?

**PUB550 Application and Interpretation of Public Health Data**

**Week 5 Discussion**

DQ1

Compare the various types of ANOVA by discussing when each is most appropriate for use. Include specific examples to illustrate the appropriate use of each test and how interaction is assessed using ANOVA.

DQ2

When analyzing public health data, describe the steps you would take to determine what statistical test to conduct. Discuss the impact of data type on test selection.

**PUB550 Application and Interpretation of Public Health Data**

**Week 6 Discussion**

DQ1

Given the limited number of statistical calculations required by some public health positions, explain why it is important for you to know how to utilize appropriate software to analyze public health data. Support your ideas with reasons, facts, and examples.

DQ2

Discuss three strengths of the linear regression. Identify a peer-reviewed study that uses linear regression in its analysis. Explain why linear regression was used and discuss one challenge in interpreting the results. Include the permalink with your citation.

**PUB550 Application and Interpretation of Public Health Data**

**Week 7 Discussion**

DQ1

Describe three methods of qualitative data collection and discuss an example of when each method would be used.

DQ2

Describe the process of coding qualitative data. Identify the distinguishing factors between inductive and deductive coding.

**PUB550 Application and Interpretation of Public Health Data**

**Week 8 Discussion**

DQ1

Refer back to your response to Topic 1 DQ 1: “Statistics is an important component of public health. Explain the relevance of statistics in the planning, implementation, and evaluation of a health promotion intervention. How do you envision using statistics in your current or future career?” After completing the course, how has your vision changed regarding the role statistics will have in your current or future career?

DQ2

What is an IRB? What does Christianity say about ethics? Discuss an ethical challenge you might face collecting and analyzing data from human subjects. How you might approach it from a biblical perspective.

**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.

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.

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.

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.