Homework
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 homework 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 homework. Refer to the instructional videos in the topic resources as a guide.
For this homework:
o Use the "Data Analysis ToolPak" add-in and Pivot Tables to complete this homework. 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.
o Read the "Health Behavior Case History and Survey" document to familiarize yourself with the survey and its purpose.
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.