Please use the attached documents to complete the assignment 

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:

1. 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.
2. Read the “Health Behavior Case History and Survey” document to familiarize yourself with the survey and its purpose.
3. 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.

Descriptive Statistics in Excel Worksheet

Use Microsoft Excel to analyze the information in the “Health Behavior Data Set” and answer the questions below.

How many participants are in the sample? ____________________________________________

Descriptive Statistics for Age

Sort by age

a. What is the age range? __________________________________________________

Enable the “Data Analysis ToolPak” in Excel. Use the Data Analysis Feature to find the mean and standard deviation for age.

a. What is the mean age? ________________________________________________

b. What is the standard deviation for age? ______________________________________

c. Copy and Paste the Descriptive Statistics Output for age here:

Descriptive Statistics for Annual Income

Use the Data Analysis Feature to find the mean and standard deviation for the Annual Income.

a. What is the mean income? ________________________________________________

b. What is the standard deviation for income? ___________________________________

c. Copy and Paste the Descriptive Statistics Output for age here:

Frequencies for Smoking Variable

Use the Pivot Table Feature to create frequency tables for the smoker variable.

a. What percent of the sample identify as smokers? _______________________________________

b. Copy and Paste the Pivot Table here:

Frequencies for Sex Variable

Use the Pivot Table Feature to create frequency tables for sex.

a. What percent of the sample identified as male? ________________________________

b. What percent of the sample identified as female? ______________________________

c. Copy and Paste the Pivot Table here:

Descriptive Statistics Summary

Create a summary of the descriptive statistics conducted on the sample that answers the following in

2

50-500 words:

a. Summarize the survey. How many questions were there? How were the data collected?

b. Discuss the sampling strategy used. Did this strategy result in a representative sample?

c. Describe the sample. Based on the calculated descriptive statistics and frequencies, what do we know about the sample.

d. Discuss two additional variables that could have been included in the survey to gain a better understanding of the population.

© 2021. Grand Canyon University. All Rights Reserved.

2

Health Behavior Case History and Survey

Case History

You currently serve as a health promotion specialist for a local community health organization. The organization was interested in learning about general health behaviors in the community, and the relationships between these health behaviors and environmental and social determinants.

You developed a short eight-question survey to gather information and will use the survey results to inform the development of a health promotion intervention. The survey allowed you to collect primary data based on convenient sample of people visiting the local shopping grocery store. Participants were offered $5 in exchange for completing the survey.

The “Health Behavior Dataset”, located in the Excel worksheet, includes 30 observations from this survey. Refer to the data from this survey to complete the assignment.

Survey

ID (to be completed by researcher): _____ _____ _____

Demographics

1. How old are you? __________

2

. What is your sex?

· Male

· Female

3. Are you currently employed?

· Yes

· No

4. What is your highest level of education?

· Less than High school

· Graduated High School

· Graduated College

5. What is your annual income? __________

Height and Weight

6. How much do you weigh in pounds? __________

7. What is your height in inches? __________

Smoking Status

8. Do you smoke?

· Yes
· No

© 2021. Grand Canyon University. All Rights Reserved.

2

2

>Data

01

2

0

No 2

000

No

Female Yes 3

100

Yes

Male No 1

No

Female Yes 1

00

Yes

Female No 2 5000

Yes

Female Yes 3

000

No

Male Yes 1

000

66 Yes

Female Yes 2

0

68 Yes

00

280

No

Female Yes 3

120

No

50 Male Yes 1

00

No

20 Female No 1

63 Yes

Male Yes 3

150

No

61 Male Yes 2 28000

65 No

Male No 1

180

No

36 Female Yes 2

0

64 No

35 Male Yes 3

0

180

Yes

Male No 2

000

100 70 Yes

110 64 No

Female No 2

00

65 Yes

42 Female Yes 3

200 65 No

Male No 2 5000 160

No

Male No 1

72 No

175

No

Male Yes 3

165

Yes

40 Female Yes 3

170 69 Yes

Female No 1 15000

73 No

46 Male Yes 3 64000 175 68 No

42 Male Yes 3

250 70 Yes

Key

Key