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, 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:

  1. Column name: ID, Rows of data: 1 through 10
  2. Column name: Gender, Rows of data: Male = 1, Female = 2
  3. Column name: Age: (just type in the number)
  4. 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:

  1. Gender (male = 1, female = 2)
  2. Age: number in years
  3. 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

EHHA 501 Patient Journey Flow Chart

Develop an existing patient journey that crosses the three sectors of care in your organization (the organization is military hospital) Hwo could this be improved ? As a chart flow  You are a medical professor in charge of creating college assignments and answers for medical college students. You design and

MDC Gabapentin in the Context of Bipolar Disorder

A new patient presents to your office for treatment of bipolar disorder. In his medical history, he reports that he takes gabapentin prescribed by his primary care provider, but he is not sure what he takes it for. He states he is almost out of his gabapentin and is asking

KEMUL Health & Medical Using Technology to Prevent Patient

Using Technology To Prevent Patient Falls Review the concepts of technology application as presented in the Resources. Reflect on how emerging technologies such as artificial intelligence may help fortify nursing informatics as a specialty by leading to increased impact on patient outcomes or patient care efficiencies. In a project proposal

KEMUL Organizational Conflict and Effectiveness

1. Conflict  2.Relationship Between Organizational Conflict and Effectiveness  3.Common Sources of Organizational Conflict 4.Managerial Response to Conflict 5.Categories of Conflict 6.Stages of Conflict 7.Conflict Resolution Outcomes 8.Common Conflict Resolution Strategies. 9.Compromising 10.Competing 11.Cooperating/Accommodating 12.Common Causes of Organizational Conflict 13.Helpful Tips in Conflict Resolution. 14.Negotiation 15.Types of Alternative Dispute Resolution (ADR)

HSA 405 SU?Healthcare Quality Case Study

Overview In order to complete this case study, refer to this week’s readings for policy information required to analyze and make recommendations on this case. As a healthcare quality fraud analyst, you are responsible for identification of root causes and providing recommendations in an action plan to ensure compliance with

Needs to be 3 paragraphs You are the sole psychologist on

Needs to be 3 paragraphs  You are the sole psychologist on what is considered a small-sized base, with a population of approximately 6,000 people, including civilians, dependents, reservists, and active duty personnel. You have an appointment scheduled today with a patient whom you know works within the MTF (Military Treatment

Homework Content ScenarioThe administrator’s presentation,

Homework Content Scenario The administrator’s presentation, based on your briefing, was so well received by the board members that they asked to see a proposal for a hospital-based outpatient facility. In fact, the board suggested that the administrator ask you to take the lead in the project. Your administrator is

The CEO of a health care system has asked you, the system’s

The CEO of a health care system has asked you, the system’s strategic planner, to explain the factors they must consider when deciding the resources that should be devoted to a new facility project. List and describe the factors that determine the location, physical size, projected staffing, and effective décor

AMU HIMA 410 Hospital Data Modeling and Entity Relationship

A data model provides a view of how the data is structured throughout an organization. You’ve been provided with a set of data points from a local hospital. Instructions: Using the data points provided, create a model. Your data model should structure the data to support the business practices of

HIMA 360 AMU Encoder Selection for HIM Director Report

Case Scenario: Part 1: You are the HIM Director at Community General Hospital. As the director, you are in charge of purchasing an encoder for your 20 coders. You have identified the criteria that you will use to make the determination and put it in the grid below. Vendor 1

NUR 3846 BCC Deep Vein Thrombosis Questions

Using the video from Episode 2 on Samantha, answer the following prompts: Prompt 1: Explain in detail the pathogenesis of a DVT (Deep Vein Thrombosis) and how it can lead to a PE (Pulmonary Embolism). Prompt 2: Research and list all the possible treatment options for a DVT. Please correlate

MDC Key Elements of Psychiatric Assessment Discussion Reply

response to post: Discuss the Key elements of Psychiatric assessment and Interviewing of children. Assessing children and adolescents is challenging.  A psychiatric assessment can determine if a child is experiencing a disorder or if there are other factors that may be causing their difficulties. Establishing rapport is the first and

MDC Conducting Psychiatric Assessments Discussion Reply

Respond to Ste: Discuss the Key Elements of Psychiatric Assessment and Interviewing of Children When conducting psychiatric assessments and interviewing of children, there are several important elements to consider. According to Sharma et al. (2019), creating a rapport is crucial to building a relationship of trust with children while encouraging

MDC Assessing Childrens Mental Health Discussion Reply

post response Mari: Assessing children and adolescents is challenging. Generally, the child/adolescent in question would not have initiated the consultation or may not be in agreement with the need for a consultation. The consultation may or may not even be sought for the most impairing problem at hand. While children

MU African American Counselors in Training Project

Task summary: You are to do Exploring clinical supervision with African American counselors in Training editing Full description: please write Exploring clinical supervision with African American counselors in Training   You are a medical professor in charge of creating college assignments and answers for medical college students. You design and

Few people have not heard about the Food and Drug

Few people have not heard about the Food and Drug Administration (FDA). The COVID pandemic has placed a renewed focus on its role in assuring safety of drug approval. It is not nearly as well known that the FDA is tasked with regulating multiple categories of products. One cannot work in healthcare

MHA 543 UP Health & Medical Generational Work Trait

Work traits vary considerably between various generations. Each individual has a unique manner for interacting with others and solving problems or addressing issues that arise. In this assignment, you will address work trait differences and how these differences might impact the organizational culture and succession planning.  Part I: Individual Work

Health & Medical Health Screening Tests Issues and Concerns

Describe what you already know about the module’s topics (if anything) With your limited understanding, how you would answer the module’s guiding question: “Do you think most people undergoing a screening test understand how to assess the benefits and risks of the test?” What other questions does the guiding question