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, Hispanic
Male, age 39, African American
Female, age 19, European American
Male, age 22, Asian American
Female, age 88, European American
Female, age 37, Hispanic
Female, age 43, Asian American
Male, age 72, Native American
Male, age 45, European American
Female, 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:
- Column name: ID, Rows of data: 1 through 10
- Column name: Gender, Rows of data: Male = 1, Female = 2
- Column name: Age: (just type in the number)
- Column name: Race, Rows of data: Hispanic = 1, African American = 2, European American = 3, Asian American = 4, Native American = 5
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:
- Gender (male = 1, female = 2)
- Age: number in years
- Ethnicity (Hispanic = 1, African American = 2, European American = 3, Asian American = 4, Native American = 5
Need Excel help? Click on the Excel Function Help Workbook under Course Materials.
Due: Sunday, 11:59 p.m. (Pacific time)
Points: 50
Expert Solution Preview
Answer:
To complete this assignment, you need to enter data on ten research participants in an Excel spreadsheet. The first row should consist of variable names, and subsequent rows should contain participants’ data. The data you enter should only be the numbers that represent the information presented above, with the following column heading and rows of data: ID (rows 1-10), Gender (1 for male, 2 for female), Age, and Race (1 for Hispanic, 2 for African American, 3 for European American, 4 for Asian American, and 5 for Native American). Additionally, create a codebook on the second sheet to help others understand what the numeric answers represent. The codebook should include information on gender, age, and ethnicity. Remember to use the Excel Function Help Workbook if you need assistance. This assignment is worth 50 points and is due by Sunday at 11:59 pm Pacific time.
