Public health data: application and interpretation
To begin, you will need to open the “Health Behavior Data Set” in Excel. Data Analysis ToolPak is an add-in that allows you to do descriptive statistics with the data. It will give you basic information on the group such as average income, age and other variables.
Using pivot tables, you can then organize and analyze the data to answer the questions in the “Descriptive Statistics in Excel Worksheet.” This worksheet will likely include questions about the central tendency of the data, such as mean, median, and mode, as well as measures of variability, such as range and standard deviation.
Refer to the videos and other resources in the task to help you with your analysis. As soon as you finish the worksheet, submit it in the designated dropbox.
The purpose of this project is to teach you how to apply descriptive statistics and public health tools such as Excel to data from real surveys.