GCU PUB550 Assignments Latest 2021 April (Full)

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

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 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 Topic 2 “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 written comparison to the 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 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 and the Topic 2 “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 to discuss the findings for either the chi-square or correlation findings. For the presentation of your PowerPoint, use Loom to create a voice-over or a video. Refer to the topic resources for additional guidance on recording your presentation with Loom. Include an additional slide for the Loom link at the beginning, and an additional slide for references at the end.

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?

What is the decision rule?

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 and the PowerPoint to the 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 required to submit this assignment to LopesWrite. Refer to the?LopesWrite Technical Support articles?for 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 YRBSS and YRBS. Then use the 2015 “Youth Risk Behavior Surveillance System Dataset” and conduct a two-sample t-test to determine if weight (in kg) differs by sex. Submit the SPSS output for the t-test.

Part 2

Create an 8-10 slide PowerPoint presentation to discuss the findings for the t-test. For the presentation of your PowerPoint, use Loom to create a voice-over or a video. Refer to the topic resources for additional guidance on recording your presentation with Loom. Include an additional slide for the Loom link at the beginning and an additional slide for references at the end.

Include the following:

Identify which of three t-tests was selected and explain why this is the best statistical test and whether the assumptions were met.

What are the null and alternative hypotheses?

What is the decision rule?

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

Submit the SPSS exported output and the PowerPoint to the 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 required to submit this assignment to LopesWrite. Refer to the?LopesWrite Technical Support articles?for 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

Overview

In public health, data are often gathered from separate groups in order to describe health-related behavior for a topic of interest. In practice, a larger sample is often surveyed, and then focus groups or interviews can be conducted with a smaller subset of the sample. The quantitative survey data from a larger group helps to identify health-related trends and patterns within the sample group. The qualitative data collected with the smaller group complements the quantitative survey data and helps 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 purpose of this assignment is to analyze qualitative and quantitative data from two separate groups, propose a research question, and then disseminate your findings in a mixed-methods manuscript. The survey and focus group are both on the topic of nutrition. The quantitative data is adapted from the Youth Risk Behavior Surveillance System (YRBSS), and the qualitative data is from a focus group transcript in which 9th grade girls discussed healthy eating.

For this assignment, you will use:

IBM SPSS Statistics and the “Youth Risk Behavior Surveillance System Dataset” to conduct a basic quantitative statistical analysis.

The “9th Grade Girls Healthy Food Focus Group Transcription” to conduct a qualitative analysis and identify key themes.

Part 1: Analyzing Data

Using the resources indicated above, conduct the following analyses and record the results on the “Results and Outputs” template. Attach this document as an Appendix in your paper.

Qualitative Analysis: Read the “9th Grade Girls Healthy Food Focus Group Transcription.” This transcript is from a focus group of 9th grade girls discussing healthy eating with the moderator. Generate codes and summarize the qualitative data.

Quantitative Analysis:

Review the “Youth Risk Behavior Surveillance System Dataset.” Identify two or three variables of interest and identify a study topic for your paper. Conduct a literature search for three to five peer-reviewed articles from the last 5 years that have studies supporting your topic. Develop a research question for your study based on the selected variables. The research question should demonstrate support for the focus group results and should be supported by existing literature.

Prepare the data to complete the analysis based on your research question.

Using SPSS, conduct descriptive statistics to summarize the sample.

Using SPSS, select an appropriate quantitative inferential statistical test to analyze the data.

Part 2: Reporting Data

Prepare a 1,250-1,500 word manuscript to disseminate the findings of your proposed study. The study should be based on your proposed research question and supported by the findings from the qualitative and quantitative analyses above, as well as by current literature. Include the following:

Abstract

A 150-250 word summary of the manuscript.

Introduction

Summarize the purpose of the research, the problem being addressed, and your proposed research question.

Support your summary using three to five peer-reviewed articles from the last 5 years that are relevant to your topic and that support why the study is being conducted.

Methods

Qualitative Methods (Focus Group)

Describe the focus group sample and data collection process.

Describe the process used to analyze the qualitative data.

Quantitative Methods (YRBSS Survey)

Discuss how the data were collected.

Identify and describe the variables used in the analysis.

Describe the descriptive and inferential statistical tests that were conducted.

Identify the software that was used to conduct the analysis.

Results

Qualitative Results (Focus Group)

Summarize the results of the qualitative analysis from the “9th Grade Girls Healthy Food Focus Group Transcription.”

Quantitative Results (YRBSS Survey)

Summarize the sample using the results of the descriptive statistics.

Describe the main outcomes of the inferential statistical analysis.

Include at least one table or figure to support the results.

Discussion

Interpret the study results in relation to the related literature and study purpose.

Discuss the study limitations.

Based on the interpreted results of the study, provide recommendations for future public health research, policy, or practice.

Appendix

“Results and Outputs” analysis document.

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. Refer to the LopesWrite Technical Support articles for assistance.

Benchmark Information

This benchmark assignment assesses the following programmatic competencies:

Master Public Health

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.