Enter the above information on the 10 imaginary research participants in Excel. Thefirst rowconsists of variable names (column heading). Subsequent…

Question Enter the above information on the 10 imaginary research participantsin 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 = 5In addition, make codebook on the second sheet of your Excel document, so that other people who view 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 Health Science Science Nursing STAT 720 Share QuestionEmailCopy link Comments (0)