STATISTICS ASSIGNMENT
Excel Data.xlsx
BMI of Boys and Girls
| M | F |
| 26 | 20 |
| 29 | 23 |
| 20 | 15 |
| 37 | 32 |
| 28 | 26 |
| 37 | 22 |
| 27 | 21 |
| 16 | 32 |
| 22 | 30 |
| 22 | 23 |
| 21 | 18 |
| 23 | |
| 22 |
All Variables
| ID | M/F | Clinic | BMI | FBS |
| 1 | M | B | 26 | 113 |
| 2 | F | A | 20 | 81 |
| 3 | M | C | 29 | 101 |
| 4 | M | A | 20 | 92 |
| 5 | F | A | 23 | 96 |
| 6 | F | A | 15 | 71 |
| 7 | F | C | 32 | 108 |
| 8 | M | B | 37 | 139 |
| 9 | F | C | 26 | 102 |
| 10 | M | B | 28 | 92 |
| 11 | M | B | 37 | 119 |
| 12 | F | C | 22 | 90 |
| 13 | F | A | 21 | 94 |
| 14 | M | C | 27 | 96 |
| 15 | F | B | 32 | 105 |
| 16 | F | B | 30 | 149 |
| 17 | M | A | 16 | 81 |
| 18 | M | C | 22 | 101 |
| 19 | M | B | 22 | 88 |
| 20 | M | C | 21 | 97 |
| 21 | F | A | 23 | 78 |
| 22 | F | A | 18 | 87 |
| 23 | M | C | 23 | 93 |
| 24 | M | B | 22 | 100 |
FBS by Clinic
| A | B | C |
| 81 | 113 | 101 |
| 92 | 139 | 108 |
| 96 | 92 | 102 |
| 71 | 119 | 90 |
| 94 | 105 | 96 |
| 81 | 149 | 101 |
| 78 | 88 | 97 |
| 87 | 100 | 93 |
Paper.docx
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 attache d 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.
This is the actual assignment the above is the extra info. It is along the lines of the last one.
Review the instructions for your Final Paper in Week Five of your course or the “Components of Course Evaluation” section of the course guide. For this week’s assignment, utilize 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 items two and three of your Final Paper:
· Assess how B.M.I. varies by gender. Use the tab “B.M.I. of Boys and Girls”. 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?
· 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. What statistical analysis is most appropriate? Why? What do the results indicate?
Your paper should be formatted according to APA style as outlined in the Ashford Writing Center. It must be a minimum of two pages and include graphs, tables, and outputs that are clearly titled and explained. This assignment will be used as part of your Final Paper, it is expected that any feedback provided by your instructor regarding this assignment will be incorporated into your Final Paper submission.