Descriptive Data Analysis
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 the first item of your Final Paper:
- 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.