West Coast University Biostatics Worksheet

This week’s assignment will teach you how to conduct some of the basic statistical analyses that you will need for your signature assignment. Each week builds upon concepts you will need to know.

Make sure you have loaded the Analysis ToolPak. For Excel 2013, 2010, or 2007: for more information, see Load the Analysis ToolPak in Excel.

Open the small Excel database that you created last week and do the following:

Calculate the frequency and percentage for gender and ethnicity.

Calculate the mean, standard deviation, median, and 50th percentile for age.

Create a bar chart for participants’ gender and a bar chart for ethnicity (based on percentages, not counts).

Create a histogram for participants’ age.