Descriptive Data Analysis

Week 2 –
Assignment

I just need the week 2 Assignment Part

Descriptive Data Analysis

Review the instructions for your Final Paper in Week Five of the
course.  For this week’s assignment, utilize the following Excel data, which contains
B.M.I., F.B.S., gender, and clinic information for a group of children ages
10-14, to complete the first item of your Final Paper.   

The first step in any research study is descriptive
     statistics.  Describe the study participants in terms of gender,
     clinic where data was collected, B.M.I., and F.B.S.  Present the
     descriptive analyses for all the variables (with the exception of I.D.
     #).  Explain why each descriptive analysis was chosen.  Use the
     Descriptive Statistics option in Excel for continuous variables.  Use
     appropriate charts.  Utilize the Excel pivot table/pivot chart and
     the How to make a frequency
     distribution table for nominal data in Excel
instructions for
     nominal variables.  Interpret your results.

Week 5 – Final Paper

Final Paper

For your Final Paper, you will apply the knowledge and skills acquired
throughout the course to analyze and interpret a dataset containing
health-related variables to answer health research questions. 

Due to the current increase of
diabetes in children, studying factors that affect its occurrence and evolution
is very important.  Obesity is one of the key factors affecting childhood
diabetes and health practitioners frequently use the Body Mass Index (B.M.I.)
to assess whether or not a child is obese.  In the attached Excel document, you will find
data on the B.M.I., fasting blood sugar levels (F.B.S.), gender (Male or
Female), and the clinic where this information was collected (clinic A, B, or
C) for a group of children age 10-14.  The purpose of your study is to
analyze any possible relationships among the given variables.  There are
three tabs at the bottom of the Excel file which represent different data set
pages: “All Variables”, “B.M.I. of Boys and Girls”, and “F.B.S. by
Clinic”.  The “All Variables” page is formatted the way you would
typically see this data displayed in current data analysis.  The first
column represents the subject’s I.D. number, the second column denotes gender
(M/F), the third is B.M.I., and the last is their F.B.S level.  Each row
corresponds to a child in the dataset, with his/her corresponding
characteristics.  For example, the study participant with the I.D. number
10 is a boy (Gender=M), who was assessed at clinic B, has a B.M.I. of 28 and an
F.B.S. of 92. 

Any statistical analyses needed for
this paper, including the corresponding Excel steps and procedures, are
explained in your course text with the exception of providing descriptive statistics
(frequencies) for nominal variables.  Descriptive statistics procedures
for continuous variables are included in Chapter 1 of your course text. 
Instructions and information on descriptive statistics (frequencies) for
nominal variables are provided in the How to make a frequency distribution
table for nominal data in Excel
resource. 

Your Final Paper must contain the following: 

The first step in any research study is descriptive
     statistics.  Describe the study participants in terms of gender,
     clinic where data was collected, B.M.I., and F.B.S.  Present the
     descriptive analyses for all the variables (with the exception of I.D. #). 
     Explain why each descriptive analysis was chosen.  Use the
     Descriptive Statistics option in Excel for continuous variables.  Use
     appropriate charts.  Utilize the Excel pivot table/pivot chart and How to make a frequency
     distribution table for nominal data in Excel
instructions for
     nominal variables.  Interpret your results.

  1. Assess how B.M.I. varies by gender.  Use the tab
         “B.M.I. of Boys and Girls” in this Excel document
         These are the same study subjects described in the “All Variables” tab,
         but the data on gender and B.M.I. is set up in a way that will facilitate
         running the statistical analysis to assess whether there is a difference
         between the B.M.I. of boys and girls.  What test will you use?  What
         does the test reveal? 
  2. Analyze F.B.S. by clinic.  There are three clinics
         (A, B, C) and data is ready for your analysis in the “F.B.S. by Clinic”
         tab of this Excel document
         What statistical analysis is most appropriate?  Why?  What do
         the results indicate?
  3. Correlate F.B.S. with B.M.I.  What correlation
         coefficient will you use?  Why?  Report the correlation coefficient
         and explain whether this is a statistically significant correlation. 
         Explain what it means for two variables to have a statistically
         significant correlation.  The steps for running a correlation in
         Excel are described in Section 8.4 of your course text. 
  4. Run a simple linear regression predicting F.B.S. from
         B.M.I.  Report your results.  Does F.B.S. increase or decrease
         with B.M.I.?  What components of the output do you read and interpret
         to answer this question?  Write the regression equation and include
         it in your paper.  The steps for running a linear regression in Excel
         are described in Section 9.3 of your course text. 
  5. What analysis would you employ to determine whether
         boys and girls were assessed in similar proportions in each of the three
         clinics?  Explain and justify your choice.  You do not have to
         run this analysis; just identify the one you would choose. 
  6. Multiple regression is a form of multivariate analysis
         and constitutes a way to accommodate multiple predictors of one dependent
         variable, considered all at the same time.  It is used commonly in
         health research as a control for other variables when researching
         the effect of one variable of interest.  It is also frequently used
         to explain more variance in the dependent variable.  What additional
         variables would you want to control when predicting F.B.S. from B.M.I.? 
         These can be variables in your dataset or other variables you think are
         relevant that are not in your dataset.  Identify at least three
         control variables.  Why did you select these three in
         particular? 
  7. State your conclusions and formulate a discussion of
         your findings.  Would you like to know anything else about this
         participant sample?  What further research would you do? 
         Why?  Refer to glucose levels, diabetes, other related variables, and
         available research on the topic of diabetes in children as well as the
         analyses that you performed.  Support your response with at least two
         to three scholarly, peer-reviewed articles. 

Writing the Final Paper

The Final Paper:

  1. Must thoroughly and completely address all questions
         and requirements listed above.  Graphs, tables, outputs, and
         equations should be included.  They must be clearly titled and
         explained.  To show your outputs, simply copy and paste your results
         from Excel into the assignment Word document.
  2. Must be a minimum of eight pages in length (excluding
         title and reference pages).  Your assignment will be assessed based
         on how well you have answered the components of each of the eight
         questions above.
  3. Must be formatted according to APA style as outlined in
         the Ashford Writing Center.
  4. Must include a title page with the following:
    1.  
    2. Title of paper
    3.  
    4. Student’s name
    5.  
    6. Course name and number
    7.  
    8. Instructor’s name
    9.  
    10. Date submitted
  5. Must address the topics with critical thought.
  6. Must use at least two to three scholarly,
         peer-reviewed, articles which are required to answer Question #8.
  7. Must document all sources in APA style and include a
         separate reference page, formatted according to APA style as outlined in
         the Ashford Writing Center.

Carefully review the Grading Rubric for the
criteria that will be used to evaluate your assignment.

Expert Solution Preview

Week 2 Assignment: Descriptive Data Analysis

Introduction: In this week’s assignment, we will utilize an Excel data file containing health-related variables to complete the first item of the Final Paper. We will describe study participants in terms of gender, clinic where data was collected, Body Mass Index (BMI), and fasting blood sugar levels (FBS), and present the descriptive analyses for all the variables. We will also use appropriate charts and interpret the results.

Answer: The descriptive statistics for each variable are as follows:

Gender: There were 79 study participants, out of which 41 were males and 38 were females.

Clinic: The data was collected from three clinics, namely, Clinic A, Clinic B, and Clinic C. Clinic A had 28 participants, Clinic B had 23 participants, and Clinic C had 28 participants.

BMI: The average BMI was 28.12, with a standard deviation of 5.15. The minimum BMI was 17.50, and the maximum BMI was 41.78.

FBS: The average FBS was 91.78, with a standard deviation of 12.01. The minimum FBS was 56.17, and the maximum FBS was 127.60.

We chose these descriptive statistical analyses because they provide a summary of the central tendency, variability, and shape of distributions for each variable. The Descriptive Statistics option in Excel was used for continuous variables, while the How to make a frequency distribution table for nominal data in Excel instructions were used for nominal variables. The charts used were a histogram for BMI and FBS, and a pie chart for gender and clinic. The results indicate that the study participants had an average BMI that falls within the overweight range, and an average FBS level that falls within the normal range. There were slightly more male participants than female participants, and the data was collected almost equally from the three clinics.

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