1) Frequency distributions can be graphed with bar charts, histograms, or polygons. Choose one variable from the “Health Behavior Data Set” and discuss which type of graph is appropriate and why. Refer to section 2.3 in the Using and Interpreting Statistics: A Practical Text for the Behavioral, Social, and Health Sciences textbook as needed for assistance.
The mean, median, and mode are measures of central tendency. Explain why these measures are crucial to public health data analysis.
3) 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:
A) 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.
B) Read the “Health Behavior Case History and Survey” document to familiarize yourself with the survey and its purpose.
C) pen 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.
Each question should be stand alone with its separate refernces. All stated facts must have in-text citations.