Descriptive Data Analysis HCS 445

Sigchi4life
Category:
Health & Medical
Price: $20 USD

Question description

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. 

tilize the following Excel data, which contains Body Mass Index (B.M.I.), Fasting Blood Sugar Levels (F.B.S.), gender, and clinic information for a group of children ages 10-14, to complete the first item.

  • 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. number). 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.
Your paper should be formatted according to APA style

And It must be a minimum of one page and include graphs, tables, and outputs that are clearly titled and explained.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Maryland
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1830 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors