West Coast University Biostatics Questions

This assignment, like subsequent assignments each week, will help you make progress toward your final project.

The first step is to understand how to use Microsoft Excel to enter data that you collected on individuals. You will use the information below for this assignment.Male, age 50, HispanicMale, age 39, African AmericanFemale, age 19, European AmericanMale, age 22, Asian AmericanFemale, age 88, European AmericanFemale, age 37, HispanicFemale, age 43, Asian AmericanMale, age 72, Native American Male, age 45, European AmericanFemale, age 30, African American

Enter the above information on the 10 imaginary research participants in Excel. Here are a few rules to keep in mind when creating a data set in Excel: The first row consists of variable names (column heading). Subsequent rows contain participants’ data. For this data set, the data you enter should only be the numbers that represent the information presented above, with the following column heading and rows of data:

In addition, create a codebook on the second sheet of your Excel document, so that other people who view your data set can understand what the numeric answer for different variables represent. It will look as simple as this:

Need Excel help? Click on the Excel Function Help Workbook under Course Materials.

Due: Sunday, 11:59 p.m. (Pacific time)Points: 50